Outlines

Course Objectives

The objectives of Analyzing data with Power BI course is to provide learners skills and knowledge to use Power BI to create data models, visualizations, and reports that facilitate analysis and decision-making. The course typically covers topics such as:

• Connecting to data sources and importing data into Power BI.

• Building data models using relationships, calculated columns, and measures.

• Get and transform your data

• Create powerful, automatically updated interactive visuals

• Collaborate on reports and share across your organisation

• Deliver dashboards with automated alerts to drive action

• Creating and formatting visualizations, such as charts, tables, and maps.

• Building interactive reports and dashboards, such as using drill-downs, slicers

• Enhancing reports and dashboards with custom visuals and themes.

• Sharing and collaborating on reports and dashboards

• Using advanced features, such as integrating with external data sources, using DAX formulas,

By the end of the course, participants should be able to use Power BI to create data models, visualizations, and reports that facilitate analysis and decision-making. 

.

Course Outline

Module 1: Introduction to Self-Service BI Solutions 

• Introduction to business intelligence

• Introduction to data analysis

• Introduction to data visualization

• Microsoft tools for self-service BI

Module 2: Introducing Power BI

• Power BI

• The Power BI service

Module 3: Power BI Data

• Excel files, CSV & Text files as a Power BI data source

• Using databases as a Power BI data source

Module 4: Shaping & Combining Data

• Power BI desktop queries

• Shaping data

• Combining data

Module 5: Modelling Data

• Relationships

• DAX queries

• Calculations and measures

Module 6: Interactive Data Visualizations

• Creating Power BI reports

• Managing a Power BI solution