INTERMEDIATE LEVEL DATA ANALYTICS WORKSHOP

Live-Online Training: N175,000
Classroom Training: N 215,000
3 - 4 participants: 5% discount
5 or more participants: 10% discount

(Available also for Customised Training by Duration, Venue & Fee)

(PARTICIPANTS MUST BE WITH THEIR COMPUTERS)

Course Contents

DAY ONE

Data Analytics with Excel

Basic Facts on Data Analytics

The main purpose of Data Analytics

What you learn in Data Analytics

Functions of Data Analysts

Using Power BI with Excel.

 DAY TWO

Pivot table and PowerPivot Tables

Relationship between Tables

Introduction to the DAX formulas

The calculation functions

Quick measures.

 DAY THREE

Querying your Data

Understanding PowerQuery

Understanding Power Map

Plotting your data on a live map

 DAY FOUR

Data Visualization

Adding visualization to reports

Design a report layout

Conditional Analysis

Slicing and filtering reports

Dashboards

Cell(s) level security.

 DAY FIVE

Predictions – defining success metrics

Prescriptions – best course of action

Data Analytic Sensitivity

Univariate and multivariate scenarios

Charting Data in Analytics

Analytics and statistical summary