Building Analytical Dashboards with Power BI

16 hours

Learn how to effectively get data from various sources, optimally model your data, creatively visualize your data, and share your data the smart way with Power BI Desktop and the Power BI Service.

What Will I Learn?

By the end of this course, you will have practiced how to Get Data from various sources, Model your data, Visualize your data, and Share your data with Power BI Desktop and the Power BI Service.

The training objective of the course is to provide students with the necessary knowledge for data integration and advanced analysis using Power BI. Practical use cases are incorporated into the sessions allowing application into real-world situations.

  • Import data from heterogeneous sources including Excel, Access, ERP systems, websites, online services, social media, and more.
  • Design, refine and optimize data models
  • Create analytical calculations using Data Analysis eXpressions (DAX)
  • Create interactive reports and dashboards
  • Share insights within the organization using content packs and app workspaces
  • Leverage content on various mobile platforms

Course Benefits

Does our organization need insights to make decisions at every level, in real time?
With Power BI you can gather and analyze data from hundreds of data sources: on-premises data sources, big data, streaming data, cloud services…

Are you already using Power BI but you need to get the most out of it?
In this course you will learn how to create and share powerful data visualizations with your team, using practical examples that you can implement from day 1.

Are you leveraging implementing Power BI in your organization?
Microsoft Power BI is the best data visualization tool out there, and we will show you all the necessary ingredients for a successful implementation.

Audience

This course is intended for experienced business and data analysts with prior experience data visualization tools like Tableau, QlikView and Excel with PowerPivot & Power View and desire to apply similar approaches to Power BI.

Course Outline

Module 01: Introduction to Business Intelligence

Module 02: Introduction to Power BI Ecosystem

Module 03: Introduction to Power BI Desktop

Module 04: Get Data – Gathering & Cleansing

Module 05: Modeling – Dimensional Modeling

Module 06: Modeling – Improving the Data Model

Module 07: Visualize – Introduction to Visuals & Chart Interactions

Module 08: Introduction to Power BI Service

Module 09: Get Data – Advanced Transformations

Module 10: Modeling – Introduction to DAX

Module 11: Modeling – Advanced Modeling Techniques

Module 12: Visualize – Advanced Visualizations

Module 13: Visualize – Advanced Features

Module 14: Share – Publishing and Sharing using Power BI Service

Module 15: Power BI Mobile

Module 16: Modeling – Security

Module 17: Administration

Training Request Letter

Do you need some help convincing your manager that this training would be beneficial for you and your organization? We have written a template letter for you to give to your manager, giving them an idea as to what will be covered in the training

Download the letter

Upcoming classes

Andreas Schindler

Mentor

Tom Huguelet

Technical Architect, Trainer

Riccardo Perico, Lucient Trainer profile picture

Riccardo Perico

BI & Power BI Engineer, Trainer