• Understanding the concept of AI, Data Science, Business Intelligence
• Significance and relevance of business analytics in decision-making
• Diverse categories of analytics: Descriptive, Predictive, and Prescriptive
• The role of data visualization in business analytics
• Basic Data Types and Structures
• Understand data warehousing, data lakes, and data marts. 
• Understanding business matrices & KPIs
• Business Analytics with AI, ChatGPT & Prompt Engineering
• Overview of Tools (Excel, SQL, Power BI, KNIME, GitHub)
• Setting up a GitHub account for Building a Portfolio
• GitHub Terminology: Understanding repositories, merge requests, pull requests, and push requests
•  

• Introduction to Excel and Google Sheets
• Learn to collect, manage, and store company data effectively
• Basic Functions: SUM, COUNT, AVERAGE, MIN, MAX
• Using IF, AND, OR Functions
• Activity: Basic calculation exercises using Excel

• Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
• Text Functions: LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN
• Working with Delimiters and Text-to-Columns (Split, STUFF, etc.)
• Activity: Exercises on text manipulation and lookups

• Scenario Analysis with What-If Analysis Tools
• Creating Professional Dashboards in Excel
• Using Solver and Goal Seek for Business Optimization
• Data Analysis Techniques for Logistic Regression using Excel
• Activity: Build an optimization model with Goal Seek

• What is Data Visualization? Overview of Industry Tools (e.g. Tableau, Power BI)
• Understanding the role of Power BI in data visualization
• How to create a Scope Document to plan Dashboards and define KPIs
• Data Transformations: Introduction to Data Cleaning, Aggregation, and Calculated Columns

Activity: Plan and create a scope document for a sample dashboard project

• Understanding Primary/Foreign Keys and Relationships
• Introduction to STAR Schema: Importance in BI and How to Design a STAR Schema
• Data Transformation and Modelling

Case Study: Import Excel Retail Data to create a STAR Schema, Transform Data, and Build a Dashboard

• Introduction to DAX (Data Analysis Expressions)
• Creating Measures and Calculated Columns using DAX
• Understanding DAX Functions for Data Transformation

Activity: Hands-on creation of DAX measures and calculated columns in Power BI

• Introduction to Data Hierarchies in Power BI
• Structuring and organizing data for hierarchical analysis
• Creating a drill-down feature in Power BI
  • Forecast future trends and patterns using Power BI
• Creating interactive dashboards and reports 

Activity: Hands-on creation of a hierarchy in Power BI and use of drill-down functionality in a dashboard

– Introduction to Databases and ERD (Entity Relationship Diagram)

– Basic concepts: Tables, Records, and Keys

– Introduction to Database Normalization

 Activity: Create a simple ERD for a business scenario

– Basic SQL Queries: SELECT, FROM, WHERE, GROUP BY, ORDER BY

– Using LIMIT, CASE WHEN, and NULL in SQL

– Basic Mathematical Operations in SQL

 Activity: Hands-on exercises with basic SQL queries in VS Code

– Understanding and Working with Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

 Activity: Hands-on exercises with different types of joins and their applications

– Introduction to Subqueries

– Subqueries in SELECT, WHERE, and FROM clauses

 Activity: Hands-on exercises with subqueries in different contexts

Introduction to No Code Data Analytics tool KNIME or Orange
-Introduction to Predictive Analytics

– Overview of Machine Learning Algorithms: Decision Trees, Random Forests

– Basics of KMeans and Clustering

– Data Mining using KNIME

– Working with Data in KNIME: Importing, Cleaning, and Visualizing

– Building ML Models with Decision Trees and Random Forests in KNIME

 Activity: Hands-on building of a decision tree model

– Clustering with K-Mean and Visualization in KNIME

 Activity: Hands-on clustering exercise with real-world data and evaluation of the results

– Students present their final dashboard projects, demonstrating the full use of Power BI, Excel, SQL, and predictive analytics

– Feedback and discussion on the projects

 Activity: Projects presentation with peer feedback and instructor evaluation

• Career Prospects of Analytics in business, Sales, marketing, Supply Chain, Finance, HR and much more
• Special mentoring sessions from global Industry leaders from Amazon, Microsoft, Nike, Jazz and more.
• LinkedIn Profile Building and Cracking job interviews with skills & tricks
• How to build career as a freelance business analyst