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.
Course Outline
Introduction to Power BI
- Overview of Power BI components and architecture.
- Understanding Power BI Desktop versus Power BI Service.
- Navigating the Power BI interface.
Data Modelling and Transformation
- Connecting to data sources and importing data.
- Transforming data using the Power Query Editor.
- Establishing relationships between data tables.
Basic Functions and DAX Measures
- Introduction to DAX (Data Analysis Expressions).
- Creating calculated columns and measures.
- Applying basic functions for calculations and aggregations.
Designing Data Visualizations
- Selecting appropriate visualizations for data.
- Customising charts, graphs, and tables.
- Enhancing interactivity with slicers and filters.
Building and Publishing Dashboards
- Combining visuals to create dashboards.
- Configuring real-time data updates.
- Publishing dashboards to Power BI Service.
Exporting and Sharing Reports
- Exporting reports in various formats (e.g., PDF, PowerPoint).
- Sharing reports securely within the organisation.
- Embedding Power BI reports in other platforms (e.g., Microsoft Teams, SharePoint).
Practical Dashboard Development
- Developing a business-focused dashboard from scratch.
- Incorporating user feedback into design.
- Ensuring dashboards align with business objectives.
Summary and Next Steps
Requirements
- Fundamental knowledge of data concepts and spreadsheet tools (e.g., Microsoft Excel).
Audience
- Business analysts.
- Data professionals.
- Managers and decision-makers aiming to improve reporting capabilities.
35 Hours
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.
