DATES TO BE ANNOUNCED
Power BI transforms your organization’s data into rich visuals for you to collect and organize so you can focus on what matters to you. In this course, you learn how to connect to data, then clean and transform it. You also create a data model and report on KPIs. Lastly, you produce visualizations on the data and publish them to share. The course includes an introduction to DAX language and best practices.
The course involves lecture, demonstration, hands-on practice and instructor coaching. No previous knowledge of Power BI is required.
This course can be applied to the following certificates:
Business Analysis Certificate
Data Analysis Certificate
Benefits and Learning Outcomes
- Understand capabilities and uses of Power BI
- Understand the four phases of handling data in Power BI: load, model, visualize and report
- Apply understanding of the four phases to analyze real-world examples
- Extract, Transform and Load sample data
- Model sample data into tables with accurate relationships
- Create visualizations from sample data
- Explore options for sharing and reporting data visualizations
Course Outline/Topics
The course teaches all skills needed to build a rich report and covers the following:
Extract, transform and load data
- Learn how to combine data sources, perform complex transformations, and then load to the model
- Understand the Power Query window
Model data and create Key Performance Indicators (KPIs)
- Model data best practices and create relationships between tables
- Learn an intro to the DAX language
- Make DAX measures and columns for KPIs
- Measure time intelligence
- Use best practices for data optimization
Visualize the data
- Learn how to create rich visualizations
- Add a layout to make stunning reports
- Use advanced features such as tooltips and bookmarks for advanced analysis
- Use the correct graph and best practices for visual layout design
Share the reports
- Deploy your reports to share with the correct people in your organization
- Use best practices for sharing and maintaining reports
Who Should Attend
Individuals charged with identifying data insights and sharing them with others.