Who is this training for?
Power BI report designer that share and collaborate on reports in Power BI
Training objectives
- Optimize your use of Power BI Desktop and Power BI Report Builder report editors from the desktop
- Identify the reporting process for application production
- Learn the basics of simple DAX/Power FX functions to perform the calculations your visualizations need
- Make effective use of available visualizations by following simple data storytelling rules and recommendations
Summary
BI professionals and experts who want to dig deeper into Power BI to connect different data sources, transform data, design data models, create and publish reports and reports within their organization.
Course outline
Chapter 1 - Understanding the structure of Power BI
- Examining the licensing models offered
- Discovering the particularities of Premium plans
- Working with Power BI Reporting server
- Learning how to consume data gateways
- Discovering how applications work
Chapter 2 - Importing data
- Understanding data security issues
- Consuming and updating the data catalog
- Querying data from Microsoft SQL Server
- Querying data from Microsoft Dataverse
- Query data from Cosmos DB
- Query data from Synapse Analytics Services
- Troubleshoot performance issues
- Troubleshoot data import errors
Chapter 3 - Transform and load data
- Understand data transformation options
- Learn how to normalize data
- Learn how to change column types
- Learn how to combine multiple sources
- Understand how to visualize the profile of Data
Chapter 4 - Designing a Data Model
- Understanding How to Work with Tables
- Learning How to Create a Custom Date Table
- Setting Up and Working with Dimensions
- Understanding How to Set Data Granularity
- Learning How to Set Up Relationships and Filtering Directions
Chapter 5 - Securing Data
- Understanding How to Define and Set Up Roles
- Learn How to Set Up the Static Method
- Learn How Configure the dynamic method
- Learn how to use sensitivity labels
Chapter 6 - Adapt the data model with DAX
- Discover simple functions
- Learn how to create calculated columns
- Understand measures and aggregations
- Understand the notion of context
- Understand how to change context with the CALCULATE function
- Create a time frame table
- Learn how to work with time functions
Chapter 7 - Optimize the performance of the Data Model
- Review the Performance of Your Data Model
- Understand How to Work with Variables
- Learn How to Reduce Cardinality
- Learn How to Optimize Direct Query Models
- Learn How to Create and Manage Aggregations
Chapter 8 - Use with the Right Visualizations
- Learn How to Use the Q&A Visual
- Learn How to Import Custom Visuals
- Understand How to Set Goals
Chapter 9 - Create Reports
- Understand the simple rules of data storytelling
- Design or reuse report layouts
- Learn how to personalize interactions
- Learn how to design a user experience
- Learn how to set up conditional formatting
- Set up slicing, filtering, and sorting
- Learn how to define mobile reports
Chapter 10 - Creating Effective Dashboards
- Learn how to create real-time tiles
- Learn how to set the mobile view
- Learn how to set and set goals
Chapter 11 - Create paginated reports
- Learn how to get the data
- Learn how to create a paginated report
- Understand how to work with charts
- Learn how to publish the report
Chapter 12 - Manage datasets in Power BI
- Learn how to use a data gateway
- Learn how to set up a scheduled refresh
- Learn how to set up incremental refresh
- Learn how to manage and promote datasets
- Learn how to troubleshoot refresh issues
- Improve performance with query caching
Approach and methodology
- Lectures
- Demonstrations
- Guided and individual exercises
Prerequisites
- Have access to the Power BI service (Pro License) or equivalent content.
- Power BI app installed on the desktop or equivalent content.
Recommendations
Know how to navigate the Power BI interface. Recognize and differentiate Power BI content. Understand the Power BI dataset. Understand Power BI apps. .
