Microsoft Data & Power BI
Microsoft Power BI Data Analysis Professional
A three-day professional course in Power BI analysis.
3 daysIntermediate11 modules
About this course
A three-day professional course in Power BI analysis. You will connect to data, profile and shape it, build advanced models and DAX calculations, create compelling visuals and publish and share reports.
What you'll learn
- Analyze data and create reports with Power BI.
- Connect to data.
- Perform data cleaning, profiling, and shaping.
- Visualize data with Power BI.
- Enhance data analysis by adding and customizing visual elements.
- Model data with calculations.
- Customize and filter visualizations.
- Use advanced analysis techniques.
- Share reports and create dashboards in the Power BI Service.
- Manage and collaborate in the Power BI Service.
- Enhance reports and dashboards.
Curriculum
11 modules
- Data Analysis and Visualization for Business Intelligence
- Interact with Reports in Power BI
- Create Data Source Connections
- Configure and Manage Relationships
- Save Files in Power BI
- Secure and Troubleshoot Connections
- Load, Clean, and Shape Data with the Query Editor
- Profile Data with the Query Editor
- Shape Data with the Query Editor
- Transform Data with the Query Editor
- Create Visualizations with Power BI
- Select Visualization Types with Power BI
- Customize Visuals and Pages
- Incorporate Tooltips in Visualizations
- Create Calculated Columns with DAX
- Create Calculated Measures and Conditional Columns
- Create Data Hierarchies
- Filter Reports
- Discover Time-Intelligence Insights
- Configure Slicers for Interactive Filtering
- Create Calculated Tables, Variables, and Parameters
- Perform Statistical Analysis
- Analyze Data with Advanced Power BI Features
- Publish and Explore Reports in the Power BI Service
- Create Dashboards
- Add Q&A to Dashboards
- Manage Workspaces and Share Content
- Collaborate with the Power BI Service
- Optimize Usability and Performance
- Create Mobile Reports for Power BI
Who it's for
Analysts who want deep Power BI skills.
Before you start
- To ensure your success, you should have experience managing data with a spreadsheet program such as Microsoft Excel. Optionally, having experience with other data analytics tools, such as Google Analyticsâ„¢, as well as a knowledge of database design concepts and basic programming constructs such as looping and branching, will help you get even more out of this course.
Related courses
More in Microsoft Data & Power BI →Foundation
Microsoft Power BI - Beginner
Microsoft Data & Power BI
View course →Intermediate
Microsoft Power BI - Data Analysis Practitioner
Microsoft Data & Power BI
View course →IntermediatePL-300
PL-300T00 Design and Manage Analytics Solutions Using Power BI (PL-300 Exam Prep)
Microsoft Data & Power BI
View course →Intermediate
55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →Foundation
55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.