Join our collaborative edu-course with Alcheringa, IIT Guwahati, and partner companies to become a Master of Business Analytics. This program focuses on delving into organizational data, emphasizing statistical analysis for informed decision-making. Gain expertise in Business Analytics and problem-solving through hands-on projects such as Airlines Project, Sales Analysis across various products and segments, and Market Intelligence Dashboard & Story.
What Will I Learn ?
Introduction to Business Analytics
✓ Definition and Importance of Business Analytics
✓ Types of Business Analytics (Descriptive, Predictive, Prescriptive)
✓ Key Applications in Various Industries
Analysis vs Analytics
✓ Differences Between Data Analysis and Data Analytics
✓ Use Cases and Tools for Each
✓ The Role of Data Analysts vs Data Scientists
Traditional Data vs Big Data
✓ Characteristics of Traditional Data
✓ Big Data and the 4 V’s (Volume, Variety, Velocity, Veracity)
✓ Comparison and Implications for Business Analytics
Business Intelligence
✓ Overview of Business Intelligence (BI) Systems
✓ BI Tools and Platforms (Power BI, Tableau)
✓ Role of BI in Decision Making
Data Warehousing vs Data Mining
✓ Concepts and Functions of Data Warehousing
✓ Data Mining Techniques and Algorithms
✓ Key Differences and Use Cases
Career Path of Business Analyst
✓ Role of a Business Analyst in Organizations
✓ Skills Required for Business Analysts
✓ Career Growth and Opportunities in Business Analytics
Skills and Tools, Roles and Responsibilities for Business Analyst
✓ Core Skills (Problem-solving, Communication, Critical Thinking)
✓ Common Tools (Excel, SQL, Tableau, Python)
✓ Typical Responsibilities of a Business Analyst
Introduction to Business Analytics With Excel
✓ Role of Excel in Business Analytics
✓ Basics of Data Management in Excel
✓ Common Analytical Techniques in Excel
Business Problem
✓ Defining Business Problems in Analytics
✓ Approach to Solving Business Problems Using Data
Formatting
✓ Applying and Customizing Formatting in Excel
✓ Best Practices for Formatting Data for Analysis
Filtering
✓ Using Filters to Narrow Down Data
✓ Advanced Filtering Techniques
Sorting
✓ Sorting Data in Ascending/Descending Order
✓ Sorting by Multiple Columns
Conditional Formatting
✓ Highlighting Data with Conditional Formatting
✓ Use Cases for Conditional Formatting in Analytics
Formulas
✓ Common Formulas in Business Analytics
✓ Basic Arithmetic, Date, and Text Functions
Cell References
✓ Understanding Relative, Absolute, and Mixed References
✓ Importance in Formulas and Data Analysis
Advanced Functions – VLOOKUP
✓ Syntax and Use of VLOOKUP
✓ Use Cases for Searching Data
Advanced Functions – COUNTIF
✓ Counting Based on Specific Criteria
✓ Applications in Data Analysis
Pivot Tables
✓ Creating and Customizing Pivot Tables
✓ Analyzing Large Datasets Efficiently
Pivot Charts
✓ Visualizing Data with Pivot Charts
✓ Use Cases for Business Analysis
Data Dashboarding
✓ Building Interactive Dashboards in Excel
✓ Key Metrics to Include in Business Dashboards
Macros in Analytics
✓ Automating Tasks Using Macros
✓ Benefits of Using Macros for Data Analysis
Business Analytics With Tableau
✓ Overview of Tableau for Business Analytics
✓ Differences Between Excel and Tableau for Data Visualization
Business Problem – Basic Definition and Terminologies, Getting Started with Tableau
✓ Defining Business Problems for Tableau Analysis
✓ Introduction to Tableau Interface and Terminologies
Data Loading, Data Connection, Tableau Workspace
✓ Importing Data into Tableau
✓ Connecting to Different Data Sources
✓ Navigating the Tableau Workspace
Calculated Fields, Chart 1 – Profitability across Regions
✓ Creating Calculated Fields in Tableau
✓ Visualizing Profitability Across Geographic Regions
Marks in Tableau
✓ Understanding and Using Marks in Visualizations
✓ Customizing Marks for Better Insights
Filters in Tableau
✓ Applying Filters to Focus on Specific Data Points
✓ Types of Filters in Tableau
Parameters in Tableau, Chart 2 – Sales/Profit across Segment/Categories
✓ Using Parameters for Interactive Analysis
✓ Creating Visualizations for Sales and Profit by Segment
Chart 3 – Customer Analysis
✓ Customer Segmentation and Analysis
✓ Visualizing Customer Data for Better Insights
Sorting
✓ Sorting Data in Tableau for Clearer Visuals
✓ Best Practices for Sorting in Dashboards
Chart 4 – Sales Performance across Targets, Data Blending
✓ Analyzing Sales Performance Against Targets
✓ Introduction to Data Blending in Tableau
Advance Internship Projects
1. Deep Diving into Financial Analytics
✓ Financial Metrics and KPIs (Profitability, Liquidity, Efficiency)
✓ Building Financial Models in Excel/Tableau
✓ Analyzing Financial Statements
2. Building and Structuring of P&L Data
✓ Understanding the Profit and Loss Statement
✓ Structuring P&L Data for Analysis
✓ Key Insights from P&L Analysis
3. Building a FMCG Model
✓ Key Metrics in FMCG (Fast-Moving Consumer Goods)
✓ Building Forecast Models for Demand and Sales
✓ Visualizing FMCG Data in Tableau or Excel
Careers Opportunity:
✓ Market research analyst
✓ Business/Analytics translator
✓ Data analyst
✓ Application Architect
