Course Details

This course is designed for Business Analysts, Financial Analysts, Statisticians and Business Intelligence professionals. It builds on the Introduction to Microsoft Power BI course by going in depth in analyzing and visualizing data with Power BI. It covers all the methods for connecting and importing data, cleaning and modeling data, creating visually appealing reports and dashboards, and publishing and sharing your work. This course will prepare participants for the Microsoft 70-778 exam by covering all the required skills. There are quizzes at the end of each module that mirror the format of the 70-778 exam questions.

The course is broken down into 8 live data labs. Please take a look at the schedule below.

SCHEDULE

WHAT YOU WILL LEARN

• How to connect to data sources
• Perform transformations
• Cleanse data
• Create and Optimize Data Models
• Create calculated columns, calculated tables, and measures
• Measuring performance by using KPIs, gauges, and cards
• Create hierarchies
• Create and format interactive visualizations
• Manage custom reporting solutions
• Access on-premises data
• Configure a Dashboard
• Publish and embed reports
• Configure security for dashboards, reports, and apps
• Configure apps and apps workspaces

LIVE ONLINE LABS

1. Consuming and Transforming Data 1
2. Consuming and Transforming Data 2
3. Modeling and Visualizing Data 1
4. Modeling and Visualizing Data 2
5. Modeling and Visualizing Data 3
6. Modeling and Visualizing Data 4
7. Configure Dashboards, Reports and Apps in the Power BI Service 1
8. Configure Dashboards, Reports and Apps in the Power BI Service 2

WHO SHOULD ATTEND

• Business Analysts
• Financial Analysts
• Statisticians
• Business Intelligence professionals

PREREQUISITES

• Introductory knowledge of Power BI
• Experience with Microsoft Excel
• Some knowledge of relational databases and reporting
• An awareness of key business functions such as revenue, profitability, and accounting is desirable