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 components: reports, datasets, and dashboards
- Exploring available data connectivity options
Connecting and Preparing Data
- Importing data from Excel, CSV files, and cloud services
- Basic data transformation using the Power Query Editor
- Cleaning and shaping data for effective visual analysis
Designing Effective Visuals
- Selecting appropriate chart types for your specific data
- Creating tables, cards, and KPIs
- Leveraging slicers and filters to enhance interactivity
Building Interactive Dashboards
- Assembling visuals into cohesive, functional dashboards
- Applying themes, layouts, and design best practices
- Incorporating drill-through and cross-filter interactions
Publishing and Sharing Reports
- Saving and publishing reports to the Power BI Service
- Configuring workspaces and managing access permissions
- Sharing dashboards and embedding reports into other platforms
Practical Workshop
- Developing a complete dashboard from a sample dataset
- Customising visual interactions and filter settings
- Presenting and sharing results with key stakeholders
Summary and Next Steps
Requirements
- Familiarity with data handling via spreadsheets
- Experience using Microsoft Excel or comparable tools
- Fundamental knowledge of business reporting or analytics
Audience
- Business analysts
- Operations and administrative staff
- Professionals aiming to create impactful 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.
