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 (5 days)
Course Outline
Introduction
Excel to Power BI
- Introduction to Power BI and its relationship with Excel.
- Importing data from Excel into Power BI.
- Transforming Excel data for Power BI.
- Best practices for integrating Excel and Power BI.
Power BI Fundamentals
- Overview of Power BI components.
- Connecting to data sources.
- Data modelling basics.
- Creating simple visualisations.
Power BI Dashboards
- Design principles for dashboards.
- Interactive dashboard features.
- Sharing and publishing dashboards.
- Dashboard navigation and actions.
Power BI Dashboard Design
- Advanced design techniques.
- Utilising themes and templates.
- Mobile dashboard design considerations.
- User experience and accessibility.
Advanced Power BI
- DAX (Data Analysis Expressions) fundamentals.
- Advanced data transformations.
- Complex data modelling.
- In-depth analysis techniques.
- Security and administration in Power BI.
Summary and Next Steps
Requirements
- A basic understanding of data concepts and structures.
- Experience with Microsoft Excel and data manipulation.
- Familiarity with fundamental statistical concepts.
Audience
- Data analysts.
- Business intelligence specialists.
Testimonials (3)
Method of training.
Ineshia Bilankulu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
The facilitator took time to ensure no one gets left behind.
Athenkosi Ngqandu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
The manner in which the presenter addressed questions. The method of delivering the course was very beneficial to the students. A very good teacher indeed.