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
- Key concepts: distinguishing between reports, datasets, and dashboards
- Reviewing available data connectivity methods
Data Connection and Preparation
- Importing data from Excel, CSV files, and cloud platforms
- Foundational data manipulation using Power Query Editor
- Refining and structuring data for visual analysis
Creating Effective Visuals
- Selecting appropriate chart types for specific data sets
- Building tables, information cards, and KPI displays
- Implementing slicers and filters to enhance interactivity
Developing Interactive Dashboards
- Assembling visuals into unified, cohesive dashboards
- Applying themes, layouts, and industry design standards
- Integrating drill-through and cross-filtering interactions
Publishing and Distributing Reports
- Storing and publishing reports within the Power BI Service
- Setting up workspaces and managing user access rights
- Sharing dashboards and embedding reports into other applications
Practical Workshop
- Constructing a full dashboard using a provided sample dataset
- Adjusting visual interactions and filter settings
- Presenting outcomes to key stakeholders
Conclusion and Further Learning
Requirements
- Familiarity with data management via spreadsheets
- Hands-on experience with Microsoft Excel or comparable platforms
- Fundamental understanding of business reporting or analytics
Target Audience
- Business analysts
- Operations and administrative personnel
- Professionals aiming to produce high-impact dashboards and reports
Testimonials (2)
The most valuable takeaway was learning how to apply the concepts in real-world scenarios and understanding the tools and processes.
Marcel Tansae - DB Technology
Course - Microsoft Power Automate
How to use relationships in Power BIand the differences between columns and measurements
