Course Overview
- ›What is Business Analytics?
- ›Role of Business Analyst in Industry
- ›Types of Analytics: Descriptive, Diagnostic, Predictive
- ›Understanding KPIs and Business Metrics
- ›Business Problem Solving Framework
- ›Industry Use Cases (Retail, Finance, Marketing, HR)
- ›Excel Interface and Navigation
- ›Understanding Worksheets and Workbooks
- ›Cell Referencing (Relative, Absolute, Mixed)
- ›Sorting and Filtering Data
- ›Basic Data Cleaning Techniques
- ›Working with Tables
- ›Basic Data Formatting
- ›Basic Formulas (SUM, AVERAGE, COUNT)
- ›Logical Functions (IF, Nested IF, IFS)
- ›Lookup Functions (VLOOKUP, HLOOKUP)
- ›INDEX-MATCH Combination
- ›Text Functions (LEFT, RIGHT, MID, CONCAT)
- ›Date and Time Functions
- ›Error Handling Functions (IFERROR)
- ›Basic Charts (Bar, Line, Pie)
- ›Column and Area Charts
- ›Conditional Formatting with Charts
- ›Pivot Tables
- ›Pivot Charts
- ›Building Interactive Dashboards in Excel
- ›Introduction to Microsoft Copilot
- ›Generating Formulas using AI
- ›Automated Data Insights
- ›Creating Summaries from Large Datasets
- ›AI-Based Chart Suggestions
- ›Enabling Power Query in Excel
- ›Connecting to Data Sources
- ›Importing Data from Excel, CSV and Other Sources
- ›Transforming Data
- ›Filtering Rows
- ›Changing Data Types
- ›Renaming Columns
- ›Splitting Columns
- ›Merging Tables
- ›Combining Data (Append Queries)
- ›Removing Duplicates and Handling Errors
- ›Loading Data into Excel
- ›Introduction to Databases
- ›Installing MySQL
- ›Database Languages : DDL, DML , DCL, TCL
- ›Creating a Database
- ›Creating Tables
- ›Modifying Tables
- ›Deep Dive into Constraints
- ›Primary Keys and Foreign Keys
- ›Inserting Data into Tables
- ›Selecting Data from Tables
- ›Updating Data in Tables
- ›Deleting Data from Tables
- ›Functions in MySQL
- ›Subqueries in MySQL
- ›Views in MySQL
- ›Power BI Products Overview
- ›Components of Power BI (Desktop, Service, Mobile)
- ›Power BI Desktop Installation
- ›Power BI Architecture
- ›Connecting to Various Data Sources (Excel, CSV)
- ›Importing Data from Excel Formatted Reports
- ›Loading and Transforming Data
- ›Using Power Query to Clean and Transform Data
- ›Data Modeling and Schema Concepts
- ›Creating Table Relationships
- ›Building a Data Model from Multiple Data Sources
- ›Creating Measures and Calculated Columns
- ›Visualizations: Bar/Column, Pie and Donut Charts
- ›Creating, Formatting and Styling Reports
- ›Filters: Visual Level, Page Level and Report Level
- ›Include and Exclude Filters
- ›Power BI Service and Power BI Server
- ›Collaboration and Sharing in Power BI Service
- ›Mean, Median, Mode
- ›Variance and Standard Deviation
- ›Correlation for Business Decisions
- ›Trend Analysis
- ›Basic Forecasting Concepts
- ›Introduction to Prompt Engineering
- ›Understanding How AI Models Interpret Prompts
- ›Structuring Clear and Effective Prompts
- ›Role-Based Prompting (Act as Business Analyst / Data Analyst)
- ›Introduction to ChatGPT in Business Analytics
- ›Generating SQL Queries using Prompts
- ›Creating Excel Formulas with AI Assistance
- ›Data Cleaning and Insight Generation
- ›Automating Business Reports using ChatGPT
What we'll cover in this course:
- Introduction to Business Analytics
- Excel Basics
- Excel Formulas
- Advanced Excel Charts
- Co-Pilot for Excel
- Power Query (Data Cleaning & Preprocessing)
- SQL Essentials
- Power BI for Business Intelligence
- Business Statistics Essentials
- Prompt Engineering Essentials
- ChatGPT for Data Analysis
- Gemini for Data Visualization
- Gamma for Business Presentations
- Claude for Interactive Dashboards
- Project
Technologies & Tools
