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
- An overview of Power BI Desktop and the Power BI Service
- Understanding key elements: reports, datasets, and dashboards
- Exploring 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
- Refining and structuring data for visual analysis
Creating Effective Visuals
- Selecting appropriate chart types based on your data
- Developing tables, cards, and KPI indicators
- Utilizing slicers and filters to enhance interactivity
Constructing Interactive Dashboards
- Integrating visuals into a unified dashboard layout
- Implementing themes, layouts, and design best practices
- Incorporating drill-through and cross-filtering features
Publishing and Distributing Reports
- Storing and publishing reports to the Power BI Service
- Setting up workspaces and managing access controls
- Distributing dashboards and embedding reports
Practical Workshop
- Developing a full dashboard from a sample dataset
- Adjusting visual interactions and filter settings
- Presenting and sharing outcomes with key stakeholders
Wrap-Up and Future Steps
Requirements
- Familiarity with data management via spreadsheets
- Proficiency with Microsoft Excel or equivalent tools
- Foundational understanding of business reporting or analytics
Intended 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.
