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 the differences between Power BI Desktop and Power BI Service.
- Navigating the Power BI interface.
Data Modeling 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 the data.
- Customizing charts, graphs, and tables.
- Enhancing interactivity with slicers and filters.
Building and Publishing Dashboards
- Combining visuals to create dashboards.
- Setting up real-time data updates.
- Publishing dashboards to the Power BI Service.
Exporting and Sharing Reports
- Exporting reports in various formats (e.g., PDF, PowerPoint).
- Sharing reports securely within the organization.
- Embedding Power BI reports into other platforms (e.g., Microsoft Teams, SharePoint).
Practical Dashboard Development
- Developing a business-focused dashboard from scratch.
- Incorporating user feedback into the design.
- Ensuring dashboards align with business goals.
Summary and Next Steps
Requirements
- Basic understanding of data concepts and spreadsheet tools (e.g., Microsoft Excel).
Audience
- Business analysts.
- Data professionals.
- Managers and decision-makers looking to enhance 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.