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
- Exploring essential components: reports, datasets, and dashboards
- Investigating available data connectivity options
Data Connection and Preparation
- Importing data from Excel, CSV files, and cloud platforms
- Performing basic data transformation using the Power Query Editor
- Refining and structuring data for visual analysis
Creating Effective Visuals
- Selecting appropriate chart types for specific data
- Generating tables, cards, and key performance indicators (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-filtering interactions
Publishing and Distributing Reports
- Storing and publishing reports to the Power BI Service
- Setting up workspaces and managing access permissions
- Sharing dashboards and integrating reports
Practical Workshop
- Developing a complete dashboard using a sample dataset
- Tailoring visual interactions and filters
- Presenting and sharing outcomes with key stakeholders
Conclusion and Future Directions
Requirements
- Familiarity with managing data in spreadsheets
- Hands-on experience with Microsoft Excel or comparable software
- Fundamental understanding of business reporting or analytics
Target Audience
- Business analysts
- Operations and administrative team members
- 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
engagement with the attendees
