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 Power BI Service
- Key concepts: reports, datasets, and dashboards
- Review of data connectivity options
Data Connection and Preparation
- Fetching data from Excel, CSV, and cloud platforms
- Introductory data transformation using Power Query Editor
- Preprocessing and shaping data for visual analysis
Creating Impactful Visuals
- Selecting appropriate chart types for specific data
- Building tables, cards, and KPIs
- Implementing slicers and filters to enhance interactivity
Constructing Interactive Dashboards
- Assembling visuals into unified dashboards
- Applying themes, layouts, and design best practices
- Incorporating drill-through and cross-filter interactions
Report Publication and Distribution
- Storing and publishing reports to Power BI Service
- Setting up workspaces and managing access permissions
- Distributing dashboards and embedding reports
Practical Workshop
- Developing a full dashboard from a sample dataset
- Adjusting visual interactions and filters
- Presenting and sharing outcomes with stakeholders
Recap and Future Pathways
Requirements
- Familiarity with data management via spreadsheets
- Proficiency with Microsoft Excel or comparable tools
- Foundational knowledge of business reporting or analytics
Target Audience
- Business analysts
- Operations and administrative personnel
- Professionals aiming to develop 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.
