Next Level Power BI for Experienced Users is a two day course that provides attendees already experienced with Microsoft Power BI basics with a hands-on exploration of intermediate and beyond level features. This course is geared for attendees ready to learn the advanced techniques that you, your business analysts, and your stakeholders need to create complex information from projects, program, and portfolio reporting to utilizing time-phased data and, potentially, data from your enterprise’s other line-of-business tools.
1. Get Project Online Data
· Select and mine relevant tables with ODATA
· Advanced ODATA data mining
· Importing other data formats
· Advanced Editing of data queries
2. Advanced Data Transformations
· Managing table relationships
· Creating & using data hierarchies
· Creating custom columns and measures and metrics for filtering and reporting
3. Creating Power BI Reports
· Using advanced visualizations
· Configuring drill-down
· Modifying visual interactions
· Importing and creating custom visuals
4. Configure Power BI Security
· Creating Dashboard and row-level security
· Utilizing Filtering using row-level security
5. Publishing Reports and Dashboards
· Building Mobile Reporting
· Creating and deploying content packs
· Configuring natural language query
This hands-on course explores essential PowerBI data handling functions and reporting skills, coupling the most current, effective techniques with the soundest practices. Attendees of this course will gain practical examples from the experienced instructor who has deployed and configured Power BI reporting in a wide variety of businesses.
Working in a hands-on learning environment led by our expert facilitator, students will learn how to:
· Create Advanced Power BI Reports
· Advanced understanding of the data schemas and extracting data
· Perform advanced transformations of data or any data schema
· Utilize time-phased data in the creation of complex analyses
· Create new measures using DAX
· Filter data using row-level security
· Create and deploy content packs
· Use Power BI to integrate with line-of-business applications