Course Content

Day 1
Introduction & Stages of Business Analytics
7 Topics
Introduction to Business Analytics
Part 1 : Requirement Gathering
Part 2 : Factor Analysis
Part 3 : Data Gathering
Part 4 : Data Analysis
Part 5 : Designing Solutions
Part 6 : Implementation & Measurement
Day 2
Data Procurement and Preparation
4 Topics
Part 1: Introduction
Part 2: SQL Statements and Clauses
Part 3: SQL – Interview Questions
Part 4: Excel – Introduction to Pivots
Day 3
Data visualization and storyboarding
4 Topics
Part 1: Charts and Best Practices
Part 2: Visualization in Excel
Part 3: Project Plan for visualization Project
Part 4: Storyboarding
Day 4
Business Case Study
4 Topics
Part 2: Write the SQL queries, Perform Data modeling in Excel
Part 3: Designing a sample dashboard in Excel