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 elements: reports, datasets, and dashboards
- Data connectivity possibilities
Data Integration and Preparation
- Retrieving data from Excel, CSV files, and cloud platforms
- Foundational data modification via Power Query Editor
- Refining and structuring data for visual analysis
Crafting Impactful Visuals
- Selecting appropriate chart styles for specific data types
- Developing tables, cards, and KPI indicators
- Incorporating slicers and filters to enhance interactivity
Constructing Interactive Dashboards
- Assembling visuals into unified dashboards
- Implementing themes, layouts, and design standards
- Integrating drill-through features and cross-filtering
Report Distribution and Collaboration
- Storing and publishing reports to Power BI Service
- Setting up workspaces and managing access rights
- Distributing dashboards and integrating reports
Practical Workshop
- Building an end-to-end dashboard from sample data
- Adjusting visual interactions and filtering options
- Presenting outcomes and sharing insights with key stakeholders
Recap and Future Directions
Requirements
- Familiarity with managing data via spreadsheets
- Proficiency with Microsoft Excel or equivalent software
- Foundational understanding 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
The basic structure of Power BI, its main functions, as well as some advanced functions
