Business Analytics – SQL, Dashboard, Excel

মডিউল – ১ : Business Analytics Fundamentals

• Business Analytics কী
• Business Analytics এর ধরণ (Descriptive, Diagnostic, Predictive, Prescriptive)
• ডেটা, ইনফরমেশন ও ইনসাইট
• Data Life Cycle
• BI বনাম BA বনাম Data Science
• Data-Driven Decision Making
• Analyst এর Job Role ও প্রয়োজনীয় স্কিল

SQL for Business Analytics

মডিউল – ২ : SQL Basics for Business Analytics

• SQL পরিচিতি
• Data Types (Text, Number, Date)
• SELECT Statement
• WHERE Clause
• Comparison Operators
• Logical Operators
• ORDER BY
• LIMIT / TOP

মডিউল – ৩ : SQL Data Aggregation

• Aggregate Functions (COUNT, SUM, AVG, MAX, MIN)
• GROUP BY
• HAVING
• Summary Reports তৈরির কৌশল
• Practical Business KPIs
  • Revenue
  • Cost
  • Profit
  • Customer Count
  • Daily/Monthly Trends

মডিউল – ৪ : SQL JOIN & Relationship Analysis

• Primary Key / Foreign Key
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL JOIN
• Multi-Table JOIN
• Customer → Order → Product Analysis
• Churned/Cross-sell behavior analysis

মডিউল – ৫ : SQL Date & Time Analytics

• DATE, TIME, TIMESTAMP
• Date Functions
  • EXTRACT
  • DATE_TRUNC
  • AGE
• Time-Based Analysis
  • MTD
  • YTD
  • YOY
  • Week-over-Week
• Cohort & Retention Analysis

মডিউল – ৬ : SQL Window Functions

• OVER()
• PARTITION BY
• ROW_NUMBER()
• RANK()
• DENSE_RANK()
• RUNNING TOTAL
• MOVING AVERAGE
• Customer Ranking
• Sales Trend Analytics

মডিউল – ৭ : Real-World SQL Business Problems

• Top 10 customers
• Daily revenue
• Customer purchase frequency
• Most profitable products
• Churned customer list
• Discount impact analysis
• Inventory aging
• Business campaign performance analysis

Excel for Business Analytics

মডিউল – ৮ : Excel Essentials for Analysts

• Excel Interface
• Cell, Sheet, Table
• Data Entry Best Practice
• Formatting & Data Cleaning
• Sorting & Filtering

মডিউল – ৯ : Excel Formulas & Functions

• Text Functions
• Logical Functions
• Date Functions
• Lookup Functions (VLOOKUP / XLOOKUP)
• Financial Functions
• Array Formula Basics

মডিউল – ১০ : Excel Data Cleaning & Transformation

• Remove Duplicates
• Text-to-Columns
• Flash Fill
• Find & Replace
• Data Validation
• What-If Analysis
• Scenario Manager

মডিউল – ১১ : Excel Pivot Table Mastery

• PivotTable
• PivotChart
• Slicer
• KPI summarization
• Dynamic Reports
• Monthly dashboard building

Dashboard & Visualization

মডিউল – ১২ : Data Visualization Fundamentals

• Visualization Basics
• Best Chart Selection
• Avoiding Wrong Visuals
• KPI Design & Terminology
• Business Storytelling

মডিউল – ১৩ : Dashboard Design (Excel / Power BI / Google Data Studio)

• Dashboard Layout
• Creating Data Model
• Designing KPI Cards
• Slicer, Filters
• Trend Chart
• Category Comparison Chart
• Customer Funnel
• Sales Performance Dashboard

মডিউল – ১৪ : Complete Business Dashboard Project

• Business Requirements Collection
• Data Cleaning
• SQL Query for Data Extraction
• Excel Model Preparation
• Dashboard Build
• Business Insights
• Executive Summary Presentation

Advanced Business Analytics

মডিউল – ১৫ : Business Metrics & KPIs

• CAC, LTV
• Retention
• Churn
• ARPU
• Sales Funnel
• Lead Scoring
• Marketing Attribution

মডিউল – ১৬ : Business Case Studies

• E-commerce Sales Analysis
• Banking Customer Segmentation
• Telecom Churn Analysis
• Retail Inventory & Pricing Analysis
• Service Industry Performance Dashboard

মডিউল – ১৭ : Final Project & Presentation

• Real Dataset
• Problem Definition
• SQL + Excel + Dashboard
• Insights & Recommendations
• Final Presentation