SKILLS ENHANCEMENT PROGRAMS
Power BI - Beginner to Intermediate
Turn Data into Decisions – Learn Power BI from the Ground Up
Course Overview
The Power BI – Beginner to Intermediate course provides a practical foundation in using Microsoft Power BI for data analysis, visualization, and reporting. Learners will explore the full data journey—from connecting to sources and cleaning data to building models, creating reports, and sharing insights. Ideal for aspiring analysts, business professionals, and managers seeking to harness data for better decision-making.
Entry Requirements
- No prior experience with Power BI required
- Basic computer literacy
- Familiarity with Excel or general data concepts is beneficial, but not mandatory
Qualification Structure
To complete the Power BI – Beginner to Intermediate course, learners must complete 5 core modules, totaling 15 hours:
| Module | Topics Covered | Duration |
|---|---|---|
1. Get Started with Power BI | Overview of Power BI interface, building blocks, data flow process | 3 Hours |
2. Get and Transform Data | Connecting to data (Excel, Text/CSV, Folders), using Power Query, basic transformations (Text, Numeric, Date/Time) | 3 Hours |
3. Model Data with Power BI | Semantic model design, star vs snowflake schema, relationships, DAX calculations (columns, measures, iterators), Quick Measures, building a date table | 5 Hours |
4. Build Visuals and Reports | Choosing visuals, tables, matrices, charts (bar, column, line, pie), maps, slicers/filters, formatting, interactivity | 3 Hours |
5. Share Reports | Intro to Power BI cloud service, workspaces, reports, semantic models, sharing with others | 1 Hour |
Key Outcomes
By the end of this course, learners will be able to:
- Understand Power BI’s ecosystem and how to navigate it effectively
- Connect to and transform data from various sources using Power Query
- Design efficient and scalable data models
- Use DAX to perform calculations and build insights
- Create interactive dashboards and reports
- Share and publish reports securely using Power BI services
Duration and Delivery
Total Duration: 15 hours
Mode: Online or in-person
Delivery: Instructor-led training, with hands-on exercises
Assessment and Verification
- Practical project: Build a fully functional Power BI report using provided datasets
- Quizzes at the end of each module
- Instructor feedback and guidance throughout
- Certificate of Completion issued upon successfully completing the course project
Career & Progression Opportunities
This course provides practical skills relevant to roles such as:
- Business/Data Analyst
- Operations Analyst
- Financial Analyst
- Reporting Specialist
- Junior BI Developer
Graduates may progress to:
- Power BI Advanced
- Data Analytics with Python
- SQL for Business Intelligence