Spotify Dashboard

  • Added new measures that utilise the current data in the dataset and produce new insights such as average streams per year
  • Understanding basic tools in Power BI such as slicers, drop down bars, etc, to promote user-friendly interface
    • Skills Applied:
    Power BI

Employee's Dashboard

  • Data cleaning with Python; utilised Pandas library to clean and transform data
  • Utilised SQL to do feature engineering; frequency of employee coming into different timeslot, how many days are the employees working per week, etc.
  • Utilised DAX to add leading zeros to the employee ID.
    • Skills Applied:
    SQL Python Power BI

Netflix Dashboard

  • Visualise demographics and psychographics such as "Age", "Ratings", "Genre", and "Country".
  • Understanding basic tools such as "Packed-bubbles", "Horinzontal Bar Chart", "Area Chart", and "Geographic Map".
    • Skills Applied:
    Tableau

Coffee Sales Dashboard

  • Data preparation and cleaning in Excel to ensure consistency and accuracy
  • Utilised pivot tables for visualisation of data, allowing dynamic updates as filters changes
  • Adding slicers for easy filtering and data segmentation, and using timeline to filter specific date ranges.
  • Familiarised with Excel functions such as XLOOPUP, INDEX, MATCH, IFERROR, etc.
    • Skills Applied:
    Excel