Intro to Data Analytics

• Analytics Overview

• The different Roles of Analyst

• KPIs

  •  What is a KPI

  •  Common KPIs

  •  Marketing/Product Analytics KPIs

  •  General Business and Data Analytics KPIs

SQL

Basic SQL Baseline

• Getting to know your Data

• Basic Select

•  Where Statement

•  Order By

•  Scalar Function

  •  Math functions

  •  Text functions

  •  Date & Time functions

  •  Conversion Functions

• Isnull & Coalesce

• Case Statement

  •   Simple Case

  •   Advanced Case

• Group Functions

• Having

• Join

  •   Inner Join

  •  Outer Joins

• Union

• Excpt

• Intersect

• Sub Query

• Derived Tables

• DML

Advanced SQL

• Window Functions

• Ranking  Functions

  •   Row Number

  •   Rank

  •   Danse Rank

  •   Ntile

• Aggregative Window Functions

• Offset Functions

  •   Lead

  •   Lag

• Window Functions: Controlling the Window

  •   Rows Between

• Views

• CTE: Common Table Expression

SQL Mastery & AI Analytics

• Intro to LLM

• Prompt Engineering

• Optimization & Learning Techniques:

  •   One-Shot Learning

  •   Few-Shot Learning

  •    Zero-Shot Learning

  •    Zero-Shot CoT (Chain of Thoughts)

• Translating Business Questions into SQL Queries

  •    Writing Queries with AI & Copilot

  •    Optimizing, Debugging and Troubleshooting Queries using AI

• Case Studies: Real Business Analysis using SQL & AI

  •   Cohort Analysis

  •   Segmentation

  •   Data Scaffolding

  •   Automation with tool like n8n

Tableau

• Connecting to Data

  •    Setting Up Connections and Data Sources

  •   Organizing Your Data

  •   Relationship Data Modeling

• Desktop Basics

• Creating a Report

  •   Displaying your data

  •   Understanding Fields

  •   Chart types

  •   Filtering & Sorting

  •   Organizing Data: Groups, Sets and Bins

  •   Parameters – Dynamic and Statics

• Advanced Reporting

  •   Creating and Editing Calculated Fields

  •   Aggregations, String Functions, Date Calculations

  •   Table Calculations

  •   Level of Detail

  •   Data Blending

  •   Advanced Charts

  •   Analytics and Forecasting

  •   Mapping Data Geographically

• Advanced Formatting

• Dashboards

  •   Combining views into a dashboard

  •   Sizing, Layout and Formatting

  •   Interactivity: Filters and Actions

• Final Project

Data Visualization

• What is data visualization and why it is essential

• Types of visualizations in the business world

• How to tell the story behind the numbers

• Different types of charts, maps, and tables

• Cognitive biases in data presentation + Gestalt principles

• The use of colours and their meanings

• How to use text and typography effectively

• Interactivity and its advantages in data presentation

Building User-Centered Dashboards

• The proper workflow for creating a dashboard

• Understanding user needs and requirements

• Types of dashboards

Python Programming

Basic Python

• Fundamentals

  •   Intro

  •   Python essentials

  •   The working environment

• Data types

  •    Numbers

  •    Strings

  •    Booleans

  •    None

• Collections

  •    Lists

  •    Tuples

  •    Dictionaries

  •    Sets

• Control flow

  •    if…else

  •    for…in

  •    list comprehension

  •    while

• Textual interface

  •    input

  •    format

Intermediate Python

• Functions:

  •    Built-in Functions

  •    lambda Functions

  •    User-defined Functions using AI & Copilot (text-to-code)

• Working with Text files & JSON

  •    Standard library essentials

• Connecting Python and SQL

  •    Manual coding

  •    Generated DB connections for SQL Queries using AI

Data Analysis - The NumPy library and Co Pilot AI

• The NumPy Library

  •    Arrays

  •    Broadcasting

  •    Vectorized operations

  •    Auto-generating Arrays using AI

• The pandas Library

  •    Series and Index

  •    DataFrame

  •    GroupBy

  •    Transformations

  •    Visualisation

  •    Auto-transforming JSON / YAML files into a DataFrame using AI

  •    Auto-generating DataFrame and Series from text using AI

• Advanced Visualisations

  •     Matplotlib

  •     Seaborn

  •     Plotly

  •     AI-Enhanced Visualization

  •     Asking Copilot for best chart recommendations

  •     Auto generating code for plots using AI

• · Final Project

Statistics for Data Analysts

• Descriptive Statistics

  •     Measures of central tendency (mean, median, mode)

  •     Dispersion (variance, standard deviation, range, percentiles)

• Random Variables

  •     Discrete Variables

  •     Continuous Variables

• Probability Basics:

  •     Concepts of events

  •     Sample space

  •     Combinations

  •     Conditional probability and Bayes’ theorem

• Distributions for Analysts

  •    Normal

  •    Binomial

• A/B testing

Big Data & Machine Learning

Big Data

• Big Data Technologies Introduction

• Hadoop Data ingestion technologies

• Hive and Impala

• NoSQL

• Technologies and trends in the world of Big Data

Machine Learning

• Programming fundamentals

• ML lifecycle

• Data preparation

• Machine learning algorithms

• Regression

• Classification

• Clustering

Final Project