Data Analytics Bootcamp

Job-Ready Program

Module 01: Introduction to Data Analytics

Class 00: Orientation on Data Analytics Bootcamp

❑ Overview of Data Analytics
▪ What is Data Analytics?
▪ Importance and Applications of Data Analytics in various
industries (Finance, Healthcare, Marketing, etc.)
▪ Different Types of Data Analytics (Descriptive, Diagnostic,
Predictive, Prescriptive)

❑ Job Roles in Data Analytics

▪ Data Analyst vs. Data Scientist vs. Data Engineer
▪ Typical Responsibilities and Expectations in these Roles
▪ Career Paths and Growth Opportunities in Data Analytics
 ❑ Our Course Curriculum
▪ Sharing our course module
▪ Capstone project
▪ Career module
▪ Course completion benefits

❑ Instructors Speech
▪ Get to know the instructors
▪ Instructors thought

❑ Students Introduction
▪ Your introduction
▪ Interaction with one another

❑ QNAs
▪ Question and answer session

Class 01: Introduction to Statistics and Data Analytics

❑ Data Analytics Workflow
▪ Data Collection, Cleaning, and Preprocessing
▪ Exploratory Data Analysis (EDA)
▪ Data Visualization
 ▪ Data Interpretation and Reporting

❑ Introduction to Statistics
▪ Definition and Types of Data
▪ Importance of Data in Decision-Making

❑ Introduction to Data Types and Sources

▪ Structured vs. Unstructured Data
▪ Data Sources: Databases, APIs, Web Scraping, etc.

❑ Introduction to Descriptive Statistics

▪ Importance of Descriptive Statistics in Data Analysis
▪ Key Statistical Terms: Population, Sample, Variables
(Categorical vs. Numerical)

❑ Measures of Central Tendency and Dispersion

▪ Mean, Median, Mode
▪ Range, Variance, Standard Deviation
▪ Interquartile Range (IQR)

❑ Key Tools and Technologies in Data Analytics

▪ Spreadsheets (Excel, Google Sheets)
▪ Business Intelligence Tools (Power BI, Looker)
 ▪ Programming Languages (Python, SQL)

Module 02: Spreadsheet Tools

Class 02: Introduction to Excel

❑ Overview of Excel
▪ Definition and key features

❑ Navigating the Excel interface

▪ Ribbon, Toolbar, Worksheet

❑ Basic Operations of Excel

▪ Creating and saving workbooks
▪ Entering and editing data

❑ Basic formatting in Excel

▪ Font and alignment
▪ Number formats

❑ Introduction to Data Visualization in Excel

▪ How Visualization Enhances Data Understanding
 ▪ Overview of Basic Charts

❑ Real World Example

▪ Interactive Analytical Dashboard

Class 03: Formulas and Functions in Excel

❑ Basic Formulas and Functions
▪ Understanding and Creating Formulas
▪ Common Functions
▪ Using the AutoSum Feature

❑ Text Functions
▪ String Manipulation
▪ Text Formatting
▪ Search and Replace

❑ Date and Time Functions

▪ Current Date and Time
▪ Date and Time Components
▪ Date Calculations

❑ Logical Functions
▪ Logical Operations

❑ Excel Productivity Features

▪ AutoFill and Flash Fill
 ▪ Working with Lists and Series
▪ Importing Data

Class 04: Data Manipulation and Management in Excel

❑ Basic Error Checking and Troubleshooting
▪ Identify and resolve common formula errors.

❑ Data Manipulation
▪ Inserting (Column & Row)
▪ Naming (Column & Row)
▪ Changing data types
▪ Grouping
▪ Pivoting
▪ Transposing
▪ Sorting
▪ Filtering

Class 05: Data Integrity and Management

❑ Data Validation
▪ Data Validation Rules
▪ Drop-Down Lists
▪ Handling Errors
 ❑ Working with Tables
▪ Excel Tables
▪ Formatting Tables
▪ Managing Table Data
▪ Structured References

Class 06: Advanced Excel Techniques

❑ Conditional Formatting
▪ Applying Basic Conditional Formatting Rules
▪ Using Color Scales, Data Bars, and Icon Sets
▪ Creating Custom Conditional Formatting Rules

❑ PivotTables
▪ Creating and Customizing PivotTables
▪ Grouping Data in PivotTables
▪ Using Calculated Fields and Items

❑ Analysis
▪ Using Goal Seek
▪ Setting Up and Using Data Tables
▪ Introduction to Scenario Manager
Class 07: Data Visualization and Dashboard Design
❑ Creating Charts
▪ Types of Charts
▪ Creating and Customizing Charts
▪ Adding Data Labels, Titles, and Legends

❑ Advanced Charting Techniques

▪ Creating Combo Charts
▪ Using Sparklines for Mini-Charts
▪ Creating Dynamic Charts with Named Ranges

❑ Dashboard Design
▪ Principles of Effective Dashboard Design
▪ Creating Interactive Dashboards Using Slicers and Timelines
▪ Linking Charts and Tables for Dynamic Updates

Class 08: Google Sheets

❑ Introduction to Google Sheets
▪ Overview of Google Sheets Interface
▪ Differences between Google Sheets and Excel
▪ Collaboration and Sharing Features
▪ Cloud Integration and Real-Time Editing
❑ Basic Operations
▪ Creating and Organizing Sheets
▪ Entering and Formatting Data
▪ Copying, Pasting, and Using Fill Handle
▪ Managing Rows, Columns, and Sheets

❑ Essential Functions and Formulas

▪ Basic Arithmetic Functions (SUM, AVERAGE, COUNT,
MIN, MAX)
▪ Text Functions (CONCATENATE, LEFT, RIGHT, MID)
▪ Logical Functions (IF, AND, OR)
▪ Date and Time Functions (TODAY, NOW, DATE)

❑ Data Manipulation and Analysis

▪ Sorting and Filtering Data
▪ Using Conditional Formatting
▪ Data Validation and Drop-Down Lists
▪ Importing and Exporting Data

❑ Intermediate Functions and Tools

▪ VLOOKUP and HLOOKUP
▪ Pivot Tables
▪ Array Formulas
 ▪ Using Scripts and Add-ons for Advanced Functionality

❑ Basic Charts and Graphs

▪ Creating Bar, Line, and Pie Charts
▪ Customizing Chart Appearance
▪ Interpreting Data through Visualization

Class 09: Practical Interactive Dashboard Projects

❑ Project-01: Practical Hands-on Interactive Dashboard Project
on Excel
❑ Project-02: Practical Project by Students

Module 03: Business Intelligence Tools

Class 10: Introduction to Data Analytics with Power BI

❑ Overview of Data Analytics
▪ Definition and importance of data analytics
▪ Key concepts: data types, data sources, and data lifecycle
▪ Applications in various industries

❑ Introduction to Power BI
▪ What is Power BI? Overview and components
 ▪ Installing and setting up Power BI Desktop
▪ Overview of the Power BI interface and navigation

❑ Data Sources and Collection Methods

▪ Identifying relevant data sources
▪ Methods of data collection

❑ Importing Data into Power BI

▪ Connecting to various data sources
▪ Overview of connectors and integration
▪ Initial data load and basic transformations

Class 11: Data Preprocessing and Transformation

❑ Data Quality and Preparation
▪ Importance of data cleaning
▪ Common data quality issues

❑ Data Cleaning Techniques

▪ Using Power Query Editor for data cleaning
▪ Handling missing data, removing duplicates, and correcting
errors
▪ Transforming data types and formatting

❑ Advanced Data Transformations

▪ Splitting and merging columns
▪ Pivoting and unpivoting data
▪ Grouping and summarizing data
 ❑ Data Shaping for Analysis
▪ Creating calculated columns
▪ Using conditional columns and custom functions
▪ Managing and reordering applied steps

Class 12: Data Modeling and Relationships

❑ Building a Data Model
▪ Importance of data modeling
▪ Star schema vs. snowflake schema

❑ Creating Relationships
▪ Establishing relationships between tables
▪ Managing relationship properties

❑ Advanced Modeling Concepts

▪ Creating and using calculated tables
▪ Implementing role-playing dimensions

❑ DAX Basics
▪ Understanding DAX syntax and basic functions
▪ Creating simple measures and calculated columns

Class 13: DAX (Data Analysis Expressions)

❑ Charts and Intermediate DAX
▪ Types of charts in Power BI
▪ Charts customization
▪ Intermediate DAX in charts
 ❑ Common DAX Functions
▪ Aggregation functions
▪ Logical functions
▪ Date and time functions

❑ Advanced DAX Techniques

▪ Understanding context
▪ Using CALCULATE and FILTER functions
▪ Creating time intelligence measures

Class 14: Data Visualization Techniques

❑ Creating Visuals in Power BI
▪ Overview of visual types
▪ Creating and customizing visuals
▪ Best practices for effective data visualization

❑ Advanced Visualizations
▪ Using slicers and filters for interactive reports
▪ Setting up visual interactions and drill-through
▪ Creating advanced visuals

Class 15: Power BI Reporting, Sharing, and Collaboration

❑ Creating Reports and Dashboards
▪ Difference between Reports and Dashboards
▪ Assembling multiple visuals into a cohesive report
▪ Creating interactive and dynamic dashboards
❑ Power BI Service
▪ Overview of Power BI Service (cloud-based platform)
▪ Publishing reports from Power BI Desktop to the Service
▪ Setting up data refresh schedules for live reports

❑ Collaboration and Sharing

▪ Sharing reports and dashboards with colleagues
▪ Setting permissions and access levels
▪ Collaborating on reports in real-time

❑ Power BI Mobile
▪ Creating mobile-optimized reports
▪ Viewing and interacting with reports on mobile devices

❑ Embedding and Integrating Reports

▪ Embedding Power BI reports in external applications (e.g.,
SharePoint, Teams, websites)
▪ Power BI API for custom integrations

❑ Best Practices for Reporting and Collaboration

▪ Organizing workspaces
▪ Managing versions of reports
▪ Setting up alerts and notifications for data changes
Class 16: Looker Studio - A Comprehensive Overview
❑ Introduction to Looker Studio
▪ What is Looker Studio, and why use it after mastering Power
BI?
▪ Key differences and similarities between Looker Studio and
Power BI
▪ When to choose Looker Studio for your reporting and
visualization needs

❑ Looker Studio Interface and Navigation

▪ Overview of the interface: menus, panels, and layout
▪ Understanding the report workspace
▪ Quick tour of the data sources, charts, and fields options

❑ Connecting to Data Sources

▪ Supported data connectors (Google Sheets, Google
Analytics, BigQuery, etc.)
▪ Step-by-step guide to adding and managing data sources
▪ Data blending: Combining data from multiple sources
▪ Handling live data vs. static data imports

❑ Creating Reports
▪ Building interactive reports from scratch
▪ Utilizing Looker Studio’s drag-and-drop functionality
 ▪ Creating and managing pages in a multi-page report

❑ Data Visualization Techniques

▪ Customizing visuals: colors, fonts, and layout
▪ Adding calculated fields for advanced reporting
▪ Using filters and date range controls for dynamic data
exploration

❑ Advanced Features
▪ Using calculated fields for custom metrics
▪ Incorporating dynamic controls (e.g., filters, drop-down
menus)
▪ Data aggregation and summarization techniques

❑ Sharing and Collaboration

▪ Sharing reports with team members or external stakeholders
▪ Managing permissions for editing and viewing reports
▪ Embedding reports into websites, Google Slides, and other
platforms

Class 17: Projects on Power BI

❑ Project-03: Practical hands-on interactive project on Power BI
 ❑ Project-04: Practical project by students on Power BI

Class 18: Projects on Looker Studio/ Power BI

❑ Project-05: Practical hands-on interactive project on Google
Looker Studio

❑ Project-06: Practical project by students on Google Looker

Studio

Module 04: Structured Query Language

Class 19: Introduction to SQL and Database

❑ Overview of Databases
▪ Definition and importance of databases
▪ Types of databases
▪ Components of a relational database

❑ Introduction to SQL
▪ What is SQL? Overview and history
▪ SQL standards and dialects
▪ Setting up a database environment

❑ Basic SQL Commands

▪ Connecting to a database
▪ Basic structure of SQL statements
 ▪ Introduction to SQL syntax

❑ Retrieving Data
▪ Selecting specific columns
▪ Using aliases for columns and tables
▪ Performing calculations in SELECT statements

❑ Filtering Data
▪ Basic comparison operators
▪ Logical operators
▪ Using BETWEEN, IN, and LIKE for advanced filtering

❑ Sorting and Limiting Results

▪ Sorting data
▪ Sorting by multiple columns
▪ Limiting results with LIMIT and OFFSET

Class 20: Data Manipulation and Aggregation

❑ Inserting Data
▪ Basic INSERT statement
▪ Inserting multiple rows
▪ Inserting data from another table

❑ Updating and Deleting Data

▪ Basic UPDATE statement
▪ Updating multiple rows
▪ Basic DELETE statement
▪ Deleting multiple rows
 ❑ Window Functions
▪ Ranking Functions
▪ Aggregate Functions
▪ Values Functions

❑ Aggregating Data
▪ Introduction to aggregate functions
▪ Grouping data
▪ Filtering groups

Class 21: Joining Tables and Subqueries

❑ Understanding Joins
▪ Overview of joins and their importance
▪ Inner join
▪ Left join, right join, and full outer join
▪ Cross join and self join

❑ Advanced Join Techniques

▪ Joining multiple tables
▪ Using table aliases in joins
▪ Combining joins with aggregation

❑ Subqueries
▪ Introduction to subqueries
▪ Subqueries in SELECT, FROM, WHERE, and HAVING
clauses
▪ Correlated vs. non-correlated subqueries
Class 22: Advanced SQL Techniques
❑ Advanced SQL Functions
▪ String functions
▪ Date and time functions
▪ Conditional expressions

❑ Views and Indexes

▪ Creating and using views
▪ Advantages and limitations of views
▪ Creating and using indexes
▪ Understanding the impact of indexes on performance

❑ Transactions and Data Integrity

▪ Understanding transactions
▪ Implementing data integrity with constraints
▪ Ensuring ACID properties

Class 23: Practical Projects on SQL

❑ Project-07: Practical hands-on project on SQL

❑ Project-08: Practical hands-on project by Students

 Module 05: Python for Data Analysis

Class 24: Introduction to Python Programming

❑ Overview of Python
▪ History and features of Python
▪ Applications of Python in various fields
▪ Setting up Python

❑ Basic Syntax and Operations

▪ Writing and executing Python scripts
▪ Understanding the Python syntax
▪ Basic data types
▪ Variables and assignment
▪ Basic arithmetic operations and operators

Class 25: Control Structures and Functions

❑ Conditional Statements
▪ if, elif, else statements
▪ Comparison operators and logical operators
▪ Nested conditions

❑ Loops
▪ for loops
▪ while loops
▪ loop statements (continue, break, pass)
 ❑ Functions
▪ Defining and calling functions
▪ Function arguments and return values
▪ Scope of variables
▪ Lambda functions
▪ User defined function

Class 26: Data Structures

❑ Lists
▪ Creating and accessing lists
▪ List methods
▪ List comprehensions

❑ Tuples
▪ Creating and accessing tuples
▪ Tuple operations
▪ Tuple methods

❑ Dictionaries
▪ Creating and accessing dictionaries
▪ Dictionary methods
▪ Dictionary comprehensions

❑ Sets
▪ Creating and accessing sets
▪ Set operations
▪ Set methods
Class 27: File Handling and Exception Management
❑ File Handling
▪ Opening and closing files
▪ Reading and writing to files
▪ Using with statement for file operations

❑ Exception Handling
▪ Understanding exceptions and errors
▪ try, except, else, finally blocks
▪ Raising exceptions
▪ Creating custom exceptions

❑ Modules
▪ Importing modules
▪ Creating and using custom modules
▪ Understanding the module search path

Module 06: Python Libraries for Data

Analysis

Class 28: NumPy and Pandas for Data Analysis

❑ Introduction to NumPy and Pandas
▪ Importance of NumPy and Pandas in data analysis
▪ Differences between NumPy (numerical data) and Pandas
(tabular data)
❑ Working with NumPy
▪ Introduction to NumPy arrays (ndarrays)
▪ Creating NumPy arrays from lists, tuples, and using arange,
zeros, and ones
▪ Basic array operations (element-wise operations, reshaping,
and slicing arrays)
▪ Common NumPy functions (mean, median, sum, standard
deviation, etc.)

❑ Introduction to Pandas
▪ Overview of Pandas data structures: Series and DataFrame
▪ Importing data into Pandas (CSV, Excel, JSON, etc.)
▪ Accessing and selecting data using loc and iloc
▪ Filtering and conditional selection

❑ Data Manipulation with Pandas

▪ Handling missing data: fillna(), dropna(), and isna()
▪ Adding, modifying, and deleting columns
▪ Grouping and aggregating data using groupby
▪ Merging and joining DataFrames (merge(), concat(), join())
 ❑ Basic Data Analysis with NumPy and Pandas
▪ Descriptive statistics using Pandas (describe(),
value_counts())
▪ Handling categorical data and encoding
▪ Data sorting, ranking, and reordering

❑ Integration and Workflow

▪ Combining NumPy and Pandas for efficient data
manipulation
▪ Using NumPy functions on Pandas DataFrames

Class 29: Data Visualization with Matplotlib and Seaborn

❑ Introduction to Data Visualization
▪ Importance of data visualization in data analysis
▪ Overview of Matplotlib and Seaborn libraries
▪ Differences and use cases for Matplotlib (customization) and
Seaborn (statistical plotting)

❑ Getting Started with Matplotlib

▪ Creating basic plots: Line plots, scatter plots, bar charts
▪ Customizing plots: Titles, labels, legends, and grid
▪ Working with figure and axes objects (subplots)
▪ Customizing plot styles, colors, and markers
❑ Advanced Plotting with Matplotlib
▪ Adding annotations and text to plots
▪ Working with histograms, box plots, and pie charts
▪ Exporting plots to different formats (PNG, PDF, etc.)

❑ Introduction to Seaborn
▪ Overview of Seaborn’s features and functionality
▪ Creating simple plots: Scatter plots, line plots, bar plots, and
box plots
▪ Customizing Seaborn styles and themes (darkgrid, whitegrid,
etc.)

❑ Statistical Plots with Seaborn

▪ Visualizing distributions: distplot(), histplot(), kdeplot()
▪ Plotting categorical data: countplot(), boxplot(), violinplot()
▪ Creating regression plots and visualizing relationships
(lmplot(), regplot())

❑ Combining Matplotlib and Seaborn

▪ Using Matplotlib functions to customize Seaborn plots
▪ Creating complex visualizations by combining both libraries
Class 30: Practical Projects on Python
❑ Project 09: Practical hands-on project on python

❑ Project 10: Practical hands-on project by Students

Module 07: Course Final Projects

Class 31: Course Final Full Hands-on Project

❑ Project Overview
▪ Project Selection
▪ Data Collection

❑ Data Analysis and Modeling

▪ Exploratory Data Analysis (EDA)
▪ Data Modeling
▪ Optimization and Refinement

❑ Visualization and Reporting

▪ Creating Visual Dashboards
▪ Report Writing

Class 32: Capstone Project Presentation

❑ Presentation of Capstone Project
▪ Structuring Your Presentation
 ▪ Visual Aids and Tools
▪ Engaging Your Audience

❑ Feedback on Your Capstone Project

▪ Receiving Feedback
▪ Evaluating Feedback

❑ How Can You Improve

▪ Reflecting on Your Work
▪ Incorporating Feedback
▪ Next Steps

Thank You!