Courses

BI Designing and Reporting

By February 26, 2025 No Comments

Course Objectives

This course covers the Business Intelligence design and reporting concepts and applications using spreadsheets.

 

Contents

  1. Business Intelligence Concepts

1.1 Introduction

1.2 BI system features

  1. BI Database Design

2.1 Normalization vs de normalization

2.2 Star schema design

  1. Extraction

3.1 Data Sources

3.2 Database – CSV Files – Folders

  1. Transformation

4.1 Apply Steps

4.2 Limiting Columns-Rows

4.3 Merge-Split Columns

4.4 Replace-Change Values

  1. Combining Data

5.1 Merge vs Append

5.2 Multiple Queries

  1. Loading

6.1 Power Pivot Tables Concepts

6.1 Excel Model

  1. Data Aggregation

7.1 DAX Functions

7.2 Column vs Measure

  1. Reporting

8.1 Pivot Tables

8.2 Pivot Charts

  1. Power BI

9.1 Power BI Concepts

 

 

Entry Requirements

Basic IT and Database concepts understanding preferably with hands-on background is required from the participants.

 Target Group

Technical personnel involved in performing Business Intelligence using spreadsheets

 Mode of Delivery: Live, instructor lead learning in a physical or virtual classroom

 Duration: The duration of this course is 3 full training days

Language: English

Participants: The maximum number of participants for this course is 12 persons

 

Time schedule

The time required always depends on the knowledge of the attending participants and the schedule stated below can be used as estimate.

   
Course Structure Hours Days
Business Intelligence Concepts Introduction 1 Day 1
BI system features 1
BI Database Design Normalization vs de normalization 1
Star schema design
Extraction Data Sources 1
Database – CSV Files – Folders
Transformation Apply Steps 2
Limiting Columns-Rows
Merge-Split Columns
Replace-Change Values
Combining Data Merge vs Append 2 Day 2
Multiple Queries 1
Loading Power Pivot Tables Concepts 1
Excel Model 2
Data Aggregation DAX Functions 2 Day 3
Column vs Measure 1
Reporting Pivot Tables 1
Pivot Charts 1
Power BI Power BI Concepts 1