Analyzing Data with Power BI

Master data analysis and visualization using Power BI to enhance your reporting skills and transform complex data into actionable insights for SQL Server report creators and business professionals.

Course Thumbnail

Essential Skills Gained

Checkmark

Design efficient data transformations and model optimizations in Power BI.

Checkmark

Implement comprehensive Power BI visualizations and dashboards.

Checkmark

Connect and analyze diverse data sources including Excel and SQL Azure.

Checkmark

Utilize the Power BI service and mobile app for improved data collaboration.

Format

  • Instructor-led
  • 3 days with lectures and hands-on labs.

Audience

  • SQL Server report creators
  • Business analysts
  • Data analysts
  • BI professionals

Description

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes extracting/transforming from various data sources, tabular data modelling, DAX, creating visualizations, the Power BI Service, and the Power BI Mobile App.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Module 1: Power BI Desktop Data Transformations

  1. What is Power BI?

  2. Power BI data

  3. Transformations

  4. Import data to Power BI desktop

  5. Import data from CSV files

  6. Import data from a less structured file

Module 2: Power BI Desktop Modeling

  1. Optimizing data models

  2. Calculations

  3. Hierarchies

  4. Manage table relationships

  5. Last year comparison

  6. Year to date

  7. Market share

  8. Optimize the data model

Module 3: Power BI Desktop Visualization

  1. Visualizing your data

  2. Working with multiple visualizations

  3. Cross-tabular reports

  4. Part-to-Whole reports

  5. Relationship reports

  6. Trend reports

  7. Rank reports

Module 4: Power BI Service

  1. Working with the Power BI service

  2. Configuring a dashboard

  3. Viewing a Power BI Dashboard

  4. Upload a Power BI report

  5. Share a Power BI dashboard

  6. Configure data refresh

Module 5: Working with Excel

  1. Importing data from excel

  2. Analyzing data in Excel

  3. Uploading an Excel file with an Excel table

  4. Uploading an Excel file with a data model

Module 6: Organization Content Packs, Security, and groups

  1. Collaboration

  2. Content packs

  3. Create a content pack

  4. Edit a content pack

  5. Share a content pack

Module 7: Direct Connectivity

  1. Cloud data

  2. Connecting to analysis services

  3. Direct connectivity from Power BI desktop

  4. Direct connectivity from the Power BI service

Module 8: Developer API

  1. The developer API

  2. Custom visuals

  3. Using custom visuals

Module 9: Power BI mobile app

  1. The Power BI mobile app

  2. Using the Power BI mobile app

  3. Power BI embedded

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.