Analyzing and Visualizing Data with Power BI

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
Dates | Delivery format | Price |
June 15- 24, 2019 | 9:30 AM - 12:30 PM EST | Live Online | $499 |
July 15 - 24, 2019 | 9:30 AM - 12:30 PM EST | Live Online | $499 |
August 15- 24, 2019 | 9:30 AM - 12:30 PM EST | Live Online | $499 |
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
- Consuming and Transforming Data 1
- Consuming and Transforming Data 2
- Modeling and Visualizing Data 1
- Modeling and Visualizing Data 2
- Modeling and Visualizing Data 3
- Modeling and Visualizing Data 4
- Configure Dashboards, Reports and Apps in the Power BI Service 1
- 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
-
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
- Select a visualization type
- Configure page layout and formatting
- Configure interactions between visuals
- Configure duplicate pages
- Handle categories that have no data
- Configure default summarization and data category of columns
- Position, align, and support visuals
- Enable and integrate R visuals
- Format measures
- Use bookmarks and themes for reports
-
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
0.00 average based on 0 ratings