Develop dynamic reports with Microsoft Power BI

Overview

University: Microsoft Learn

Categories: Data Analysis Courses, Data Visualization Courses, Data Cleaning Courses, Microsoft Power BI Courses, DAX (Data Analysis Expressions) Courses

Module 1: Learn how to retrieve data from various data sources, including Microsoft Excel, relational databases, and NoSQL data stores, and improve performance while retrieving data.

• Identify and connect to a data source
• Get data from a relational database like Microsoft SQL Server
• Get data from a file like Microsoft Excel
• Get data from applications
• Get data from Azure Analysis Services
• Select a storage mode
• Fix performance issues
• Resolve data import errors

Module 2: Utilize Power Query to clean and prepare your data for analysis, simplify models, change data types, rename objects, and pivot data.

• Resolve inconsistencies, unexpected or null values, and data quality issues
• Apply user-friendly value replacements
• Profile data to learn more about specific columns before using them
• Evaluate and transform column data types
• Apply data shape transformations to table structures
• Combine queries
• Apply user-friendly naming conventions to columns and queries
• Edit M code in the Advanced Editor

Module 3: Create sophisticated semantic models by simplifying the structure and implementing star schemas; understand the importance of data granularity for performance and usability.

• Create common date tables
• Configure many-to-many relationships
• Resolve circular relationships
• Design star schemas

Module 4: Master the use of implicit and explicit measures; create simple and compound measures and understand the similarities and differences between calculated columns and measures.

• Determine when to use implicit and explicit measures
• Create simple measures
• Create compound measures
• Create quick measures
• Describe similarities and differences between calculated columns and measures

Module 5: Add calculated tables and columns to your semantic model, understand row context, and determine the best use of calculated columns versus Power Query custom columns.

• Create calculated tables
• Create calculated columns
• Identify row context
• Determine when to use a calculated column instead of a Power Query custom column
• Add a date table to your model using DAX calculations

Module 6: Learn to select the appropriate Power BI visuals to meet your design and report layout requirements.

• Understand the structure of a Power BI report
• Learn about report objects
• Select the appropriate visual type

Module 7: Explore various techniques available for filtering a Power BI report to design reports that meet specific requirements and expectations.

• Design reports for filtering
• Design reports with slicers
• Design reports using advanced filtering techniques
• Apply consumption-time filtering
• Select appropriate report filtering techniques

Module 8: Navigate the Power BI service, manage workspaces, distribute reports, and configure data protection.

• Create and manage Power BI workspaces and items
• Distribute a report or dashboard
• Monitor usage and performance
• Recommend a development lifecycle strategy
• Troubleshoot data by viewing its lineage
• Configure data protection

Module 9: Utilize a single semantic model to build multiple reports

Syllabus

Taught by

Tags

united states