Data Analytics and Business Intelligence with Microsoft Excel
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