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 components of the Power BI ecosystem.
- Mastering the navigation of the Power BI Desktop interface.
- Establishing connections to various common data sources.
Data Preparation and Transformation
- Utilizing Power Query for efficient data cleaning.
- Shaping and refining data for analysis.
- Managing and integrating multiple queries.
Data Modeling Fundamentals
- Defining relationships between different tables.
- Handling data types and establishing hierarchies.
- Constructing star schema models.
Building Visualizations
- Choosing the most appropriate visuals for specific data types.
- Customizing charts and graphical elements for better clarity.
- Effectively utilizing slicers and filters.
DAX Essentials
- Distinguishing between calculated columns and measures.
- Applying frequently used DAX functions.
- Incorporating time intelligence concepts.
Advanced Analytics and Reporting
- Developing drill-through and tooltip pages.
- Enhancing dashboards with advanced visual components.
- Applying conditional formatting rules.
Publishing and Sharing Insights
- Deploying reports to the Power BI Service.
- Administering workspaces and access permissions.
- Distributing dashboards across teams for collaboration.
Optimizing Performance and Governance
- Enhancing the efficiency of data models.
- Adhering to governance and compliance standards.
- Setting up effective dataset refresh strategies.
Summary and Next Steps
Requirements
- A solid grasp of fundamental data concepts.
- Practical experience with spreadsheets or tabular data structures.
- Basic proficiency in reporting tasks.
Target Audience
- Business analysts seeking to enhance reporting capabilities.
- Corporate professionals engaged in data-driven work.
- Users responsible for generating dashboards and analytical 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.
