Job - Linked in Business Analytics Course Subjects/Syllabus

Business Problem Solving

• Research the domain
• Interview the internal & external clients
• Documentation
• Different frameworks such as SPIN, 5Ws
• Business Model Canvas
• Issue Tree Framework
• Specialized Frameworks
• 5C Framework
• 4Ps Framework
• Live Session - Requirement gathering and Documentation

Analyzing Patterns and Storytelling

• Five Patterns of Insights
• Analysis Approach
• Pyramid Principle
• Logical Flows and Usage of Words
• Insights Demonstration
• Visualization of Qualitative Variables
• Visualization of Quantitative Data
• Visual Design Principles and Storyboarding

Visualization with Tableau

• Getting Started with Tableau/Power BI
• Hierarchies
• Charts
• Plots
• Grouping and Tree-Maps
• Functions
• Storytelling
• Dashboards creation
• LOD Expressions

Visualization with Power BI (Optional)

• Power BI Overview
• Data Preparation
• Using DAX
• Dashboards Creation
• Reports
• Best Practices
• Data Modelling
• Power BI Service

Introduction to Data Analysis

• Slicing and Dicing Data
• Cell Referencing and Text Functions
• Complex Functions
• Creating and Formatting Charts
• Creating a Pivot Table
• Analysing Data in a Pivot Table
• What-If Analysis
• VLOOKUP - Linking Data from multiple files and tables

Basics of Python

• Data Types and Operations
• Control Structures and Functions
• Data Structures
• OOP
• NumPy
• Pandas
• Matplotlib

Introduction to SQL

• Database Design and Data Warehouse
• SQL Querying
• Data Modeling
• Joins and sets operations
• Business Problem-solving using Data modeling

Exploratory Data Analysis and Statistics

• Inferential Statistics
• Hypothesis testing
• Data Cleaning
• Data Sourcing
• Univariate Analysis
• Bivariate Analysis
• Derived Metrics

Predictive Analysis

• Linear Regression
• Clustering
• Classification
• Decision Trees
• Logistic Regression
• Time-Series Forecasting (Optional)
• Market Basket Analysis (Optional)

Mentor-led Internship

• Choose your project from any of these companies under the guidance of Industry Mentors:

            1. Cars24

            2. Jupiter Money

            3. Practo

            4. The Thickshake Factory

Financial Analytics

• Financial Statements
• Financial Ratios
• Payback Period
• Financial Risks
• Capital Structure
• Time Value of Money
• Stock Analysis & Portfolio Management Case Study

ChatGPT and Generative AI

• Using ChatGPT to Improve Efficiency
• Using ChatGPT for Excel
• SQL Querying Using ChatGPT
• No Code Analytics
• Prompt Engineering
• Overview of Generative AI Tools
• Basics Applications of Generative AI