NIKAOCONSULTING

COURSE OBJECTIVES

​

1. Understand what is a data-driven organization and the need

    for it

2. What is Data Analysis and Business Intelligence

3. Key Principles for Data Analysis and Storytelling

4. Using Excel Functions and Charts for Data Analysis

5. Applying Business Intelligence to Data Analytics

6. Assignments - Analyzing Big Data

7. Assignments - Analyzing your Company Data

8. Assignments - Developing Dashboards and presentations

​

COURSE DETAILS – DAY 1

​

INTRODUCTION TO DATA ANALYTICS, BUSINESS INTELLIGENCE

​

• Welcome to the Course and Ice-breaker

• Data-driven Decision Making for Data-centric Organizations

• What's Big Data? How does it relate to Data Science

• Case Studies

• The Manager's Role in Big Data and Business Intelligence

​

MODULE 1. USING EXCEL FOR DATA ANALYTICS

• Example BI Report

• Excel essential – basic functions

• Pivot Tables

• Excel Charts

• Exercise: Using Excel for Data Analytics

​

MODULE 2. BUSINESS INTELLIGENCE – KEY FUNDAMENTALS FOR ANALYTICS

• Trends

• Correlations and Relationships

• Highs and Lows and Medians

• Pareto Relationships

• Strengths-Weakness

• Opportunities-Threats

• ERRC: Eliminate-Reduce-Raise-Create

​

EXERCISE 1. ANALYSIS ASSIGNMENT: INTERNATIONAL BIKE RETAILER

• Analyze the Dataset using Excel Functions

• Data Insights

​

EXERCISE 2. ASSIGNMENT DEBRIEF

• Sharing the outcomes

• Discussions and Debrief

​

COURSE DETAILS – DAY 2

​

MODULE 3. LEARN MICROSOFT POWER BI

​

• Microsoft Power BI and Installation

• The Power BI Process

• Loading Datasets

• Creating Relationships

• DAX (Data Analysis Expressions)

• Key Visuals of Power BI

• PowerBI.com – publishing and sharing dashboards

​

EXERCISE 3. ANALYSIS ASSIGNMENT: YOUR COMPANY BIG DATA

​

• Analyze the Dataset using Power BI

• Data Insights

​

MODULE 4. STRATEGIC BIG DATA FUNDAMENTALS AND STORYTELLING

​

• The SMART Model of Big Data

• The 5 Key Aspects of Business Intelligence

• Key aspects of a good Dashboards

• Major Storytelling Principles with Data

​

EXERCISE 4. STORYTELLING, DASHBOARDS AND KPIs

​

• Breaking down your Analysis to Storytelling

• What are your KPI’s

​

EXERCISE 5. ASSIGNMENT DEBRIEF

​

• Sharing the outcomes

• Discussions and Debrief

​

WRAP UP AND ACTION PLANNING

​

• Action Planning

• Be aware of Management Bias

• Implementing your Data Analytics and Big Data Strategy

• Sharing and Wrap Up

​

COURSE DURATION :

Two day training program.

​

CERTIFICATION :     

Nikao Consulting internal certification

​

TARGET GROUP :   

Change Leaders, Senior Managers and Managers

 

METHODOLOGIES :   

Active Lecturing

Videos

Excel hands-on Exercises, Activities

Power BI hands-on Exercises, Activities

Brainstorming and team discussion

Problem solving practices

Action planning

 

PRE-REQUISITE:   

Basic experience with Microsoft Excel

Can download MS Excel and Power BI to Laptop