The session focused on introducing PowerBI as a tool for business intelligence, specifically for building interactive dashboards. The following key themes and activities were covered:

• Portfolio Building: The instructor emphasized the importance of creating a data science portfolio, recommending datascienceportfolio.io as a user-friendly platform to showcase projects and improve job prospects.
• PowerBI Overview:
  • Workflow: PowerBI follows an ETL process—extraction, transformation, and loading. This includes connecting to data sources, cleaning data in the Power Query Editor, modeling data, and visualizing it.
  • DAX: The use of Data Analysis Expressions (DAX) for creating measures and calculated columns was introduced as essential for complex reporting.
  • Comparison to Other Tools: The instructor noted that while similar to Tableau, PowerBI integrates its own powerful data cleaning (Power Query) and DAX capabilities, whereas Tableau is primarily a visualization tool.
• Practical Application:
  • The class walked through the process of connecting to a “shopping trends” dataset (CSV format) using the “Get Data” function.
  • Students practiced cleaning data types (e.g., changing values to fixed decimals for currency) and utilizing “Close and Apply” to load the data into the environment.
• Dashboard Construction: The session concluded with hands-on practice in the Report View, where students created a dashboard title using a text box and utilized “Card” visuals to display key performance indicators (KPIs) such as total purchase amount and unique customer counts. The instructor also demonstrated design best practices, including maintaining consistent formatting and adding visual effects like shadows and rounded borders.