Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
Introduction to Power BI
- Exploring the Power BI ecosystem
- Familiarizing with the Power BI Desktop interface
- Establishing connections to common data sources
Data Preparation and Transformation
- Utilizing Power Query for data cleansing
- Shaping and restructuring data
- Overseeing and merging queries
Data Modeling Fundamentals
- Establishing relationships between tables
- Handling data types and hierarchies
- Constructing star schemas
Creating Visualizations
- Choosing appropriate visuals for specific data
- Tailoring charts and visual elements
- Effective use of slicers and filters
Essentials of DAX
- Distinguishing between calculated columns and measures
- Applying standard DAX functions
- Incorporating time intelligence concepts
Advanced Analytics and Reporting
- Developing drill-through and tooltip pages
- Enhancing dashboards with sophisticated visuals
- Implementing conditional formatting
Distributing and Sharing Insights
- Publishing reports to the Power BI Service
- Administering workspaces and access rights
- Distributing dashboards across teams
Performance Optimization and Governance
- Boosting data model efficiency
- Adhering to governance and compliance standards
- Setting up dataset refresh strategies
Summary and Future Path
Requirements
- A foundational grasp of data concepts
- Practical experience with spreadsheets or tabular data
- Basic familiarity with reporting tasks
Target Audience
- Business analysts
- Corporate professionals engaged in data work
- Individuals responsible for creating dashboards and reports
Testimonials (2)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
Method of training.
