Course Description

This course covers the extraction, transformation and loading of very large datasets in Spreadsheet along with the various spreadsheet reporting capabilities.

Contents

1. Very Large Data Introduction

1.1 VLDB Concepts

1.2 Spreadsheet limitations

2. Extraction

2.1 Power Query Introduction

2.2 Data Sources

2.3 Big Data

3. Transformation

3.1 Apply Steps

3.2 Limiting Columns-Rows

3.3 Merge-Split Columns

3.4 Replace-Change Values

4. Combining Data

4.1 Merge vs Append

4.2 Multiple Queries

5. Loading

5.1 Power Pivot Tables Concepts

5.2 Spreadsheet Model

6. Data Aggregation

6.1 DAX Functions

6.2 Column vs Measure

7. Reporting

7.1 Pivot Tables

7.2 Pivot Charts

 

Entry Requirements

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

 Target Group

Technical personnel in a Mobile Network Operator involved in retrieving and examining very large datasets using spreadsheets.

 Mode of Delivery:  Instructor-led learning onsite or in a 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
Very Large Data Introduction		VLDB Concepts		1	Day 1
		Spreadsheet limitations
Extraction		Power Query Introduction		2
		Data Sources
		Big Data
Transformation		Apply Steps		3
		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
		Spreadsheet Model		2
Data Aggregation		DAX Functions		2	Day 3
		Column vs Measure		1
Reporting		Pivot Tables		2
		Pivot Charts		1