- Module 1: This module explores how Microsoft Power BI and Tableau connect to data and help you build visualizations.
- Describe the Power BI Desktop interface.
- Connect to your data in Power BI Desktop by using the DirectQuery and Import methods.
- Describe the importance of relationships in your Power BI data models.
- Build a visualization in Power BI Desktop.
- Apply conditional formatting to help analysts detect critical issues and identify patterns in data.
- Discover differences and similarities between Tableau and Power BI concepts.
- Module 2: This module provides the foundational information needed to connect to your data confidently with the new platform.
- Identify basic concepts and terminology on Power BI data connections.
- Connect to your data in Power BI by using live and import methods.
- Perform data transformations by using Power Query editor.
- Share your data transformation steps by using Advanced Query editor.
- Set up relationships in the data modeling view.
- Identify differences and similarities between Tableau and Power BI concepts.
- Module 3: This module provides guidance on Power BI calculation concepts, and how to create and edit calculations.
- Create and apply calculated columns, measures, and calculated tables in Power BI using Data Analysis Expressions (DAX).
- Understand the importance of context in Power BI calculations.
- Identify differences and similarities between Tableau and Power BI calculation concepts.
- Module 4: This module provides guidance on how to organize and simplify your calculations.
- Identify basic organization concepts in Microsoft Power BI.
- Prepare simplified and ready-to-go datasets for future developers and analysts.
- Organize your fields with groups and bins.
- Edit the default properties of your fields.
- Identify differences and similarities between Tableau and Power BI concepts.
- Module 5: This module goes through the basics of creating visuals in Power BI.
- Learn the basics of creating visualizations.
- Identify basic tips and tricks on making pages more interactive and user-friendly.
- Create basic and customized pages that deliver insights.
- Identify how visualization processes and actions differ between Tableau and Power BI.
- Module 6: This module provides guidance on how to apply analytics to data to gain greater insight.
- Build out-of-the-box functions that will be performed by analysts to gain deeper insight into their data.
- Perform thoughtful analytics on top of your data.
- Identify ways that Power BI can be integrated with other languages, such as R and Python.
- Identify differences and similarities between Tableau and Power BI concepts.
- Module 7: This module demonstrates how performance can determine a visual's usefulness.
- Improve a model refresh and function.
- Learn about the importance of removing redundant and unnecessary fields.
- Identify the steps to improve a visual.
- Improve model calculations.
After completing this module, you will be able to:
In this module, you'll:
In this module, you will:
In this module, you will:
In this module, you will:
In this module, you will:
In this module, you will: