Data Analytics With Power BI


Duration: 1 day (8 hours)
Workshop Date: 1 October 2020
Time: 9 am to 5 pm

Fees: $214 (inclusive of GST)
Venue: Informatics Academy

Learning Objective

This dashboard in a day- Power BI course provides students with the knowledge and skills to work with and analyse data using Power BI. This workshop will allow participants to use Power BI Desktop to connect to various data sources, shape that data, and use that model to create reports. Through this Power BI workshop, students can learn that Power BI Desktop centralizes, simplifi es, and streamlines what can otherwise be a scattered, disconnected, and arduous process of designing and creating business intelligence repositories and reports.

At the end of the workshop, participants will better understand how to:

  • Connect to, import, and transform data from a variety of sources
  • Define business rules and KPIs
  • Explore data with powerful visualization tools
  • Build stunning reports
  • Share dashboards with team and/or the world

Workshop Content

Module 1: Introduction to BI Solutions

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI

Module 2: Introduction to Power BI

  • What is Power BI?
  • The Power BI service

Module 3: Power BI Data

  • Using Excel as a Power BI data source
  • Using databases as a Power BI data source
  • Labs

Module 4: Shaping and Combining Data

  • Power BI desktop queries
  • Shaping data
  • Combining data
  • Labs

Module 5: Modelling Data

  • Relationships
  • DAX queries
  • Calculations and measures
  • Labs

Module 6: Interactive Data Visualizations

  • Creating Power BI reports
  • Labs

Quick Enquiry