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.
- Exploring core concepts: reports, datasets, and dashboards.
- Discovering various data connectivity options.
Data Connection and Preparation
- Importing data from Excel, CSV files, and cloud platforms.
- Performing basic data transformations using Power Query Editor.
- Cleaning and structuring data for effective visual analysis.
Creating Effective Visuals
- Selecting appropriate chart types to suit your data.
- Building tables, cards, and Key Performance Indicators (KPIs).
- Implementing slicers and filters to enhance interactivity.
Assembling Interactive Dashboards
- Integrating individual visuals into a unified dashboard.
- Applying themes, layouts, and design best practices.
- Enabling drill-through and cross-filtering interactions.
Publishing and Distributing Reports
- Saving and publishing reports to the Power BI Service.
- Setting up workspaces and managing access rights.
- Sharing dashboards and embedding reports in external applications.
Practical Workshop
- Building a comprehensive dashboard from a sample dataset.
- Refining visual interactions and filter behaviors.
- Presenting and sharing final results with stakeholders.
Wrap-up and Future Pathways
Requirements
- Familiarity with data management in spreadsheet applications.
- 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 create 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.
