Microsoft Power BI – Advanced Level
Data Analytics
Course Overview
The Advanced Power BI course is designed for professionals who want to take their Power BI skills to the next level. This course focuses on advanced functionalities, in-depth data modeling, DAX (Data Analysis Expressions), and report optimization techniques. Participants will learn to build complex dashboards, integrate Power BI with other tools, and apply best practices for data storytelling and analytics. By the end of the course, participants will confidently build and manage advanced Power BI solutions, optimize reporting workflows, and provide actionable insights for business decision-making.
Duration: 2 days / 16 hours
Delivery Method: Classroom-based, Virtual Instructor Led Training
PREREQUISITES
Microsoft Office Excel, Knowledge on Basic Database Management, Basic Power BI
TARGET AUDIENCE
Data Analyst, Sales, Human Resource, Admin Executives
OBJECTIVES
At the end of this course, the student must be capable on the following skillsets
- Mastering DAX Functions
- Advanced Visualization Techniques
- Create and Manage Workspace in Power BI Service
- Security and Governance
COURSE OUTLINE
MODULE 1: CONNECTING TO EXTERNAL DATA SOURCES
· Getting Data from SharePoint
· Getting Data from Database
· Getting Data from the Web
· Dynamic Source with Parameters
· Clean Up Data with Power Query Editor
· Review of Data Modeling
MODULE 2: ADVANCED DATA ANALYSIS EXPRESSIONS
· Using Variables in DAX
· Error Handling
· Advanced Calculate Function
· Keep Filters
· Remove Filters
· AverageX
· RankX
· Advanced Time Intelligence Function
MODULE 3: POWER BI REPORTING TOOLS
· Setting up Report Interaction
· Adding Conditional Formatting
· Creating Page Tooltips
· Cards and KPI’s
· Adding Drill-through Filter
· Adding Field and Number Parameter
· Bookmarks and Navigation Button
· AI and Custom Visuals
· Clustering
· Grouping and Binning
MODULE 4: PUBLISHING AND SHARING
· Publish from Power BI Desktop
· Publish Reports to Web
· Printing, PDFs and Exporting to PowerPoint
· Data Driven Alerts
· Report Subscriptions
· Data Lineage View
· Data Lineage Tools
MODULE 5: CREATE AND APPLY DASHBOARD SETTINGS
· Understand real-time dashboards.
· Enhance the dashboard usability.
· Create a dashboard.
· Generate Quick Insights
· Publish Apps in Workspace
MODULE 6: CREATE AND MANAGE WORKSPACES
· Create and manage a workspace.
· Understand workspace collaboration.
· Monitor usage and performance.
MODULE 7: REFRESHING DATASETS
· Understanding Data Refresh
· Personal Gateway
· Replacing a Dataset
· Troubleshoot gateway connectivity.
MODULE 8: ROW-LEVEL SECURITY
· Understand aspects of Power BI security
· Configure static and dynamic row-level in Power BI Desktop
· Configure static and dynamic row-level in Power BI Service
MODULE 9: UNDERSTANDING DATA FLOWS
· Quick tour at Dataflows Interface
· Creating New Dataflows for Local file
· Connecting to Dataflow to Power BI Desktop
· Scheduled Refresh Dataflows
REGISTER NOW
