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
Introducing Power BI
- Overview of Power BI Desktop and the Power BI Service
- Key components explained: reports, datasets, and dashboards
- Review of available data connection options
Data Connection and Preparation
- Importing data from Excel, CSV files, and cloud platforms
- Introductory data transformation using the Power Query Editor
- Preparing and structuring data for visual analysis
Creating Effective Visualisations
- Selecting appropriate chart types for specific data sets
- Building tables, cards, and KPI indicators
- Implementing slicers and filters to enhance interactivity
Constructing Interactive Dashboards
- Assembling visuals into a unified dashboard layout
- Applying themes, layouts, and design best practices
- Incorporating drill-through and cross-filtering interactions
Publishing and Distributing Reports
- Saving and uploading reports to the Power BI Service
- Setting up workspaces and managing access permissions
- Sharing dashboards and embedding reports for broader access
Practical Workshop
- Building a complete dashboard from a sample dataset
- Tailoring visual interactions and filter settings
- Presenting findings and sharing outcomes with stakeholders
Wrap-up and Future Learning Paths
Requirements
- Familiarity with managing data in spreadsheets
- Working experience with Microsoft Excel or comparable tools
- Foundational knowledge of business reporting or analytics
Intended Audience
- Business analysts
- Operations and administrative personnel
- Professionals looking 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.
