🏫 Programming & Software Development

Data Analytics & BI

Data Analytics Course - Master Google Sheets, SQL, Power Query & Business Intelligence

Duration

12 Weeks

Weekly Hours

4 Hours

Course Incharge

Muzammil Bilwani

📋 Prerequisites

✓ Basic computer literacy and familiarity with spreadsheets

📖 Course Description

Build a strong foundation in data analytics using Google Sheets, SQL, Power Query, and VBA. Learn how to explore, clean, visualize, and extract value from data with hands-on tools and real-world examples.

What You Will Learn

Perform exploratory data analysis in Google Sheets

Clean and format data using formulas and tools

Query and manage databases using SQL

Build dashboards and apply statistical models

Automate and visualize data with Power Query and VBA

Course Outline

Introduction to Data Analytics

→Understanding the role of data analytics in decision-making
→Introduction to data-driven insights
→Overview of tools: Sheets, SQL, VBA, Power Query
→Exploring industry case studies
→Hands-on: Analyze a sample business problem

Data Exploration and Visualization in Google Sheets

→Sorting, filtering, and summarizing data
→Using pivot tables to uncover patterns
→Creating charts and applying conditional formatting
→Hands-on: Analyze a dataset to uncover trends

Introduction to Data and Databases (SQL)

→Understanding relational databases and SQL basics
→Basic SQL commands: SELECT, WHERE, ORDER BY
→Hands-on practice with SQLite or MySQL
→Hands-on: Query sample student or sales database

Data Cleaning and Preprocessing

→Handling missing/inconsistent data
→Removing duplicates and standardizing formats
→Using formulas to transform data
→Hands-on: Clean a messy dataset for analysis

Exploratory Data Analysis (EDA)

→Calculating descriptive statistics
→Analyzing relationships and distributions
→Visualizing insights using Sheets
→Hands-on: EDA on customer or academic dataset

Statistical Fundamentals for Data Analysis

→Intro to probability and hypothesis testing
→Correlation and regression basics
→Applying stats to real-world decisions
→Hands-on: Apply formulas to analyze scenarios

Mail Merge for Student ID Cards

→Preparing Excel with student info
→Designing ID templates in Word
→Linking data with Word mail merge
→Hands-on: Generate and export ID cards as PDF

VBA Programming Basics in Excel

→Declaring variables and writing functions
→Loops, conditionals, and message boxes
→UserForms for input and automation
→Hands-on: Create a mini Excel automation tool

Predictive Analytics with Google Sheets

→Linear regression for forecasting
→Evaluating model performance (R, RMSE)
→Hands-on: Forecast sales or grades using Sheets

Time Series Analysis in Google Sheets

→Moving averages and smoothing techniques
→Trend and seasonality detection
→Hands-on: Analyze website or financial data

Power Query for Data Automation

→Importing and cleaning data
→Filtering, splitting, merging, and pivoting
→Hands-on: Automate a complete ETL process

Case Studies and Capstone Project

→Integrating SQL with Sheets
→Analyzing industry-specific case studies
→Capstone: Build an analytics report from raw data
→Present findings and get feedback

📊 Grading Criteria

Component	Percentage
Quizzes	20%
Class Participation / Attendance	15%
Projects	25%
Final Projects	40%
Total	100%

Ready to Register in This Course?

Join thousands of students who have transformed their careers. Start your journey today!