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 7 hours
Course Outline
Introduction to Power BI
- Overview of Power BI Desktop and the Power BI Service
- Key elements: reports, datasets, and dashboards
- Reviewing data connectivity possibilities
Data Connection and Preparation
- Bringing in data from Excel, CSV files, and cloud platforms
- Introduction to data transformation via the Power Query Editor
- Refining and structuring data for visual analysis
Crafting Impactful Visuals
- Selecting optimal chart types for your specific data
- Building tables, cards, and KPI indicators
- Implementing slicers and filters to enhance interactivity
Assembling Interactive Dashboards
- Integrating visuals into unified dashboards
- Applying themes, layouts, and design principles
- Introducing drill-through and cross-filtering capabilities
Distributing and Sharing Reports
- Storing and publishing reports to the Power BI Service
- Managing workspaces and user access permissions
- Distributing dashboards and embedding reports
Practical Workshop
- Developing a full dashboard from a sample dataset
- Adjusting visual interactions and filter settings
- Presenting and sharing outcomes with key stakeholders
Wrap-up and Future Directions
Requirements
- Familiarity with data management via spreadsheets
- Practical experience with Microsoft Excel or comparable tools
- Foundational knowledge of business reporting or analytics
Target Audience
- Business analysts
- Operations and administrative teams
- Professionals aiming to produce compelling 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.
