Power BI for Tableau users
Offered By: Microsoft via Microsoft Learn
Course Description
Overview
- 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:
Syllabus
- Module 1: Introduction to Power BI for Tableau users
- Introduction
- Introduction to the Power BI Desktop
- Differences in terminology
- Relationships
- CALCULATE function
- Build a visual
- Apply conditional formatting
- Performance Analyzer
- Check your knowledge
- Summary
- Module 2: Connect data to Power BI for Tableau users
- Introduction
- Data transformation
- Relationships
- Data transformation lab
- Check your knowledge
- Summary
- Module 3: Create Power BI calculations for Tableau users
- Introduction
- Understanding calculated columns and measures
- Understand iterator functions
- Learn the CALCULATE function
- Table DAX expressions
- Lab for understanding Power BI calculations
- Check your knowledge
- Summary
- Module 4: Organize and simplify Power BI fields for Tableau users
- Introduction
- Learn the importance of field properties
- Organize and simplify calculations
- Lab for organizing and simplifying fields
- Check your knowledge
- Summary
- Module 5: Create Power BI visuals for Tableau users
- Introduction
- Build a visualization
- Format a visualization
- Show more with tooltips
- Apply conditional formatting
- Create a custom visual
- Apply a filter
- Create a bookmark
- Lab - Creating visualizations
- Check your knowledge
- Summary
- Module 6: Perform analytics in Power BI for Tableau users
- Introduction
- Gain insights with AI visuals
- Add reference lines from the Analytics pane
- Create parameters with the what-if analysis
- Use R and Python
- Lab - Perform analytics
- Check your knowledge
- Summary
- Module 7: Optimize Power BI performance for Tableau users
- Introduction
- Improve a model refresh and function
- Improve a model calculation
- Improve a visual
- Check your knowledge
- Summary
Tags
Related Courses
Statistics OnePrinceton University via Coursera Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera Curso Práctico de Bioestadística con R
Universidad San Pablo CEU via Miríadax Análisis Estadístico de datos con R
Universidad Católica de Murcia via Miríadax Data Analysis with R
Facebook via Udacity