Course Overview
- ›What is Business Analytics?
- ›Role of Business Analyst
- ›Types of Analytics
- ›KPIs and Metrics
- ›Problem Solving Framework
- ›Industry Use Cases
- ›SWOT Analysis
- ›PESTLE Analysis
- ›Porter’s 5 Forces
- ›Business Model Canvas
- ›Value Chain Analysis
- ›Competitive Benchmarking
- ›Excel Interface
- ›Worksheets
- ›Cell Referencing
- ›Sorting & Filtering
- ›Data Cleaning
- ›Tables
- ›SUM, AVERAGE, COUNT
- ›IF, Nested IF
- ›VLOOKUP, HLOOKUP
- ›INDEX-MATCH
- ›Text Functions
- ›Date Functions
- ›IFERROR
- ›Pivot Tables
- ›Pivot Charts
- ›Goal Seek
- ›What-If Analysis
- ›Scenario Manager
- ›Solver Tool
- ›KPI Cards
- ›Interactive Filters
- ›Slicers
- ›Dynamic Charts
- ›Dashboard Design
- ›Data Sources
- ›Transformations
- ›Splitting Columns
- ›Missing Values
- ›Removing Duplicates
- ›Merging Tables
- ›Database Basics
- ›DDL, DML, DCL
- ›Tables
- ›Constraints
- ›CRUD
- ›Basic Queries
- ›Joins
- ›Subqueries
- ›CTEs
- ›Window Functions
- ›Aggregations
- ›Views
- ›ER Diagrams
- ›Normalization
- ›Star Schema
- ›Snowflake Schema
- ›Data Warehousing
- ›Power BI Architecture
- ›Data Import
- ›Power Query
- ›Relationships
- ›Visualizations
What we'll cover in this course:
- Introduction to Business Analytics
- Business Strategy & Frameworks
- Excel Fundamentals
- Excel Formulas & Functions
- Advanced Excel Analytics
- Excel Dashboard Building
- Power Query & Data Cleaning
- SQL Essentials
- Advanced SQL for Analytics
- Database Design & Data Modeling
- Power BI Fundamentals
- Advanced Power BI
- Tableau for Business Intelligence
- Business Statistics Essentials
- Business Forecasting
- Financial Analytics
- A/B Testing & Experimentation
- Product & Marketing Analytics
- Prompt Engineering for Analysts
- ChatGPT for Business Analysis
- Gemini & Claude for Visualization
- Co-Pilot for Excel
- Gamma for Business Presentations
- AI Case Study – Amazon
- AI Case Study – Netflix
- AI Case Study – Uber & Airbnb
- Business Documentation & BRD
- Agile & Scrum for Analysts
- Pitch Deck Creation using AI Tools
- Financial Modeling for Startups
- Project
- Final Mastery & Career Launch
Technologies & Tools
