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 35 hours
Course Outline
Introduction to Power BI
- Overview of Power BI components and architectural design
- Distinguishing between Power BI Desktop and Power BI Service
- Getting familiar with the Power BI interface
Data Modeling and Transformation
- Connecting to various data sources and importing records
- Processing and reshaping data via the Power Query Editor
- Defining relationships between distinct data tables
Basic Functions and DAX Measurements
- Fundamentals of DAX (Data Analysis Expressions)
- Constructing calculated columns and measures
- Using basic functions for calculations and data aggregation
Designing Data Visualizations
- Selecting appropriate visualizations for specific data sets
- Tailoring the appearance of charts, graphs, and tables
- Boosting interactivity through slicers and filters
Building and Publishing Dashboards
- Assembling multiple visuals into a cohesive dashboard
- Configuring real-time data refresh capabilities
- Deploying dashboards to the Power BI Service
Exporting and Sharing Reports
- Exporting reports in diverse formats (including PDF and PowerPoint)
- Securely distributing reports within the organization
- Integrating Power BI reports into other platforms (such as Microsoft Teams and SharePoint)
Practical Dashboard Development
- Building a business-focused dashboard from the ground up
- Incorporating user feedback to refine design
- Aligning dashboard features with broader business objectives
Summary and Next Steps
Requirements
- Familiarity with core data concepts and spreadsheet tools (such as Microsoft Excel)
Target Audience
- Business analysts
- Data specialists
- Managers and decision-makers seeking to strengthen reporting abilities
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.