AI Analyst with Power BI

AI Analyst with Power BI

A 3 months practical course at Educator Computer Institute and College (ECIC). Build foundational knowledge, practise through structured activities and complete a portfolio project.

What you will learn

• Analytical Thinking and Business Questions: Write a business analysis brief with five questions, metric definitions and a sample sales dataset.
• Data Preparation with Power Query: Clean a sales dataset, document transformation steps and compare row counts and totals before and after cleaning.
• Data Modelling and Relationships: Create a star schema using sales, product, customer and date tables and validate relationship keys.
• DAX Measures and KPI Analysis: Build revenue, cost, profit and margin measures, then test them using a small dataset and slicers.
• Dashboard Design and AI-Assisted Insights: Create a two-page sales dashboard and revise an AI-assisted insight narrative against the actual data.
• Reporting Delivery and Portfolio: Submit a Power BI project, data dictionary, validation checklist and presentation with three supported recommendations.

Course materials

Included in the course: written concept notes, guided practice instructions, assignment briefs, assessment rubrics and module knowledge checks. Learners retain their editable project files and reflective notes.

Course structure

Six modules, twelve text lessons including six practical assignment briefs, and six quizzes with eighteen questions. Practical assignment submission is arranged with the instructor.

Fee and duration

This course is a fully government-funded program and is completely free for everyone. Duration: 3 months.

Frequently Asked Questions

How long is this course?

3 months

Do I need prior experience?

The course starts with foundational concepts. Learners should be able to read basic English and participate in practical activities.

What equipment or materials do I need?

A computer with internet access and suitable practice software.

How will I practise and be assessed?

Each module includes a concepts lesson, a practical assignment brief and a three-question quiz. Keep practical work for instructor review.

What is the course fee?

This course is a fully government-funded program and is completely free for everyone.

Are modules locked?

All modules are currently available. Completion-based drip settings will be configured later.