Data Analytics Bootcamp (Live Instructor-Led Class)

About Course

Our 8-week data analytics certificate course is a hands-on learning experience, designed by industry experts to help you accelerate your career in data analytics. This program is a virtual live-instructor training which provides you with full support on building a robust project portfolio that you can include in your resume and showcase during interviews.

Classes will commence on January 11, 2025, and it with be held live via Zoom Meeting.

Tools like Microsoft Excel, SQL, Power BI, Tableau, Databricks
Introduction to Data Analytics
Data Collection and Preparation
Exploratory Data Analysis
Predictive Analytics
Data Visualization
A/B Testing
Introduction to Cloud Computing with Databricks
Building your Project Portfolio on GitHub
Interview Preparation
Resume Review and LinkedIn Optimization

Course Content

Introduction to Data Analytics

What is Data Analysis?
Data analytics variants and the role of data analysts.
What is data and what are the different types of data?
What are variables and constants?
Basic Statistical Concepts

Microsoft Excel

Open and Understand Spreadsheets
Create Borders, Merge& Center
Importing Data
Formulas, Functions and Formatting
Charts & Graphs
Macros
Cell Referencing (Absolute and Relative)
Filter/Sort
IF Statements and Conditional Formatting
Pivot tables
Building Dashboards

00:00
Linear regression and Correlation Analysis
Hypothesis Testing
A/B Testing

SQL

What is a Relational Database?
Downloading and installing pgAdmin4
Loading Data into pgAdmin4
Terminologies
SQL Data Types
DDL and DML Statements
Creating Tables
The SELECT Statement
SQL Functions
Using SQL Joins (Inner Join, Left Join, Right Join, Outer Join, Cross Join)
Combining two or more Tables using UNION, UNION ALL, Intersect & MINUS
Subqueries

00:00
Common Table Expression (CTE)

00:00
Aggregating and Ordering using Group by and Order by
The Having Clause
CASE Statement
Window Functions

00:00

Power BI

Cloud Computing with Databricks

Git Hub

Conclusion

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Introduction to Data Analytics

What is Data Analysis?

Data analytics variants and the role of data analysts.

What is data and what are the different types of data?

What are variables and constants?

Basic Statistical Concepts

Microsoft Excel

Open and Understand Spreadsheets

Create Borders, Merge& Center

Importing Data

Formulas, Functions and Formatting

Charts & Graphs

Macros

Cell Referencing (Absolute and Relative)

Filter/Sort

IF Statements and Conditional Formatting

Pivot tables

Building Dashboards

Linear regression and Correlation Analysis

Hypothesis Testing

A/B Testing

SQL

What is a Relational Database?

Downloading and installing pgAdmin4

Loading Data into pgAdmin4

Terminologies

SQL Data Types

DDL and DML Statements

Creating Tables

The SELECT Statement

SQL Functions

Using SQL Joins (Inner Join, Left Join, Right Join, Outer Join, Cross Join)

Combining two or more Tables using UNION, UNION ALL, Intersect & MINUS

Subqueries

Common Table Expression (CTE)

Aggregating and Ordering using Group by and Order by

The Having Clause

CASE Statement

Window Functions

Power BI

Installing POWER BI

Connecting to Multiple Data Sources including SQL Server, Excel, CSV, Web, etc

Data Cleaning and Transformation

Data Manipulation and Application of Conditions

Creating Visualizations, Dashboards and Reports

Publishing Dashboard/Reports to Power BI Online

Cloud Computing with Databricks

Introduction to Datalake

Creating Clusters

Importing Data to the Datalake

Running Spark SQL Queries on Databricks Clusters

SQL Analytics

Git Hub

Introduction to Git Hub

Creating Repositories

Uploading and Customizing Data Analysis Projects

Sharing your Git Hub Projects

Conclusion

Final Project Walk-through with Instructor

Resume and LinkedIn Optimization Workshop

Student Ratings & Reviews

Quick Links

Resources

Account & Support