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
- Comprehending the Power BI ecosystem
- Navigating the Power BI Desktop interface
- Connecting to standard data sources
Data Preparation and Transformation
- Employing Power Query for data cleansing
- Structuring and transforming data
- Managing and merging queries
Fundamentals of Data Modeling
- Establishing relationships between tables
- Working with data types and hierarchical structures
- Constructing star schemas
Creating Visualizations
- Choosing appropriate visuals for specific data sets
- Customizing charts and graphical elements
- Effectively utilizing slicers and filters
Essentials of DAX
- Understanding calculated columns and measures
- Applying common DAX functions
- Implementing time intelligence concepts
Advanced Analytics and Reporting
- Creating drill-through pages and tooltip interactions
- Enhancing dashboards with sophisticated visuals
- Applying conditional formatting techniques
Publishing and Sharing Insights
- Publishing reports to the Power BI Service
- Managing workspaces and user access permissions
- Sharing dashboards across different teams
Optimizing Performance and Governance
- Enhancing the performance of data models
- Adhering to governance and compliance best practices
- Implementing strategies for dataset refreshes
Summary and Future Steps
Requirements
- A foundational understanding of data concepts
- Previous experience working with spreadsheets or tabular data
- Familiarity with fundamental reporting tasks
Target Audience
- Business analysts
- Corporate professionals dealing with data analysis
- Individuals responsible for creating dashboards and reports
14 Hours
Testimonials (2)
Method of training.
Ineshia Bilankulu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
- Building dashboards - Learning the counts and SUMs and SWITCH -