EIEIOTECHNOVATION
← Training programmes

EIEIO / DATA SCIENCE

AGENDA DA-100 Analyzing Data with Microsoft Power BI (Non-Technical)

Course outline

2 days

Duration

2 Days

THE DETAILED PROGRAM

DAY 1:

Session

From

To

Item

8.30 am

9.00 am

Module 1: Get Started with Microsoft Data Analytics

Data Analytics and Microsoft

Getting Started with Power BI

10.30 am

10:45 am

Morning Break

10.45 am

11.00 pm

Module 2: Prepare Data in Power BI

Get data from various data sources

Resolve data errors

11:00 pm

12:00pm

Module 3: Clean, Transform, and Load Data in Power BI

Data shaping

1:00 pm

2:00pm

  • Lunch

2:00pm

3:00pm

Enhance the data structure

3:00 pm

3:30 pm

Dimensions and Hierarchies

Data Profiling

3:30 pm

3:45 pm

  • Afternoon Break

3:45 pm

4:00 pm

Module 4: Design a Data Model in Power BI

Introduction to data modeling

4:00pm

5:00pm

Working with tables

END

DAY 2:

Session

From

To

Item

8.30 am

9.00 am

Module 5: Create Measures using DAX in Power BI

10.30 am

10:45 am

Morning Break

10.45 am

11.00 pm

Introduction to DAX

11:00 pm

12:00pm

DAX context

1:00 pm

2:00pm

  • Lunch

2:00pm

3:00pm

Module 6: Create Reports

Design a report

3:00 pm

3:30 pm

Enhance the report

3:30 pm

3:45 pm

  • Afternoon Break

3:45 pm

4:00 pm

Module 7: Create Dashboards

Create a Dashboard

4:00pm

5:00pm

Real-time Dashboards

Enhance a Dashboard

END

Programme scope, delivery arrangements and suitability are confirmed during enquiry.