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
Transitioning from Excel to Power BI
- Understanding Power BI and its relationship with Excel.
- Importing data from Excel into Power BI.
- Transforming Excel data for use in Power BI.
- Best practices for integrating Excel and Power BI.
Power BI Fundamentals
- Overview of Power BI components.
- Connecting to data sources.
- Basics of data modeling.
- Creating simple visualizations.
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.
- Utilizing themes and templates.
- Considerations for mobile dashboard design.
- User experience and accessibility.
Advanced Power BI
- Fundamentals of DAX (Data Analysis Expressions).
- Advanced data transformations.
- Complex data modeling.
- In-depth analysis techniques.
- Security and administration in Power BI.
Summary and Next Steps
Requirements
- A solid understanding of fundamental data concepts and structures.
- Experience with Microsoft Excel and data manipulation.
- Familiarity with basic statistical concepts.
Target 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.