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
Getting Started with Power BI
- Exploring the Power BI ecosystem
- Interacting with the Power BI Desktop interface
- Establishing connections to various data sources
Preparing and Transforming Data
- Leveraging Power Query for data cleanup
- Reshaping and processing data
- Administering and merging queries
Core Data Modeling
- Defining relationships between tables
- Handling data types and hierarchical structures
- Constructing star schemas
Creating Visualizations
- Choosing appropriate visuals for specific data
- Tailoring charts and graphical elements
- Utilizing slicers and filters strategically
Fundamentals of DAX
- Distinguishing calculated columns from measures
- Applying standard DAX functions
- Incorporating time intelligence principles
Advanced Analysis and Reporting
- Developing drill-through and tooltip features
- Enhancing dashboards with complex visuals
- Applying conditional formatting rules
Disseminating Insights
- Deploying reports to the Power BI Service
- Overseeing workspaces and user permissions
- Distributing dashboards among team members
Performance Optimization and Governance
- Enhancing data model efficiency
- Adhering to governance and compliance standards
- Setting up dataset refresh protocols
Conclusion and Future Learning
Requirements
- A foundational grasp of data concepts
- Proficiency with spreadsheets or tabular data structures
- Basic experience with reporting tasks
Intended Audience
- Business analysts
- Corporate professionals engaged with data workflows
- Individuals responsible for generating 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.
