DATA ANALYST BOOTCAMP WITH AI

MATH AND STATS FOUNDATION

Learning Objectives:

• Master Descriptive Statistics and Probability Theory
• Learn different probability distributions such as Normal, Binomial, Poisson, and many more
• Learn Inferential Statistics to draw better inferences from the data

Topics:

• Probability
• Statistics
• Linear Algebra
• Calculus

DATA ANALYSIS WITH EXCEL

Learning Objectives:

• Data Analysis using Excel
• Learn about Excel Basics and Formulas
• Perform Statistical Analysis using Excel
• Learn to use Pivot Tables

Topics:

• Data Cleaning and Preparing
• PivotTable and Grouping for Data Analysis
• Scenario and Sensitivity Analysis
• Lookup Functions and Merging Techniques
• Charts and Visualization Techniques
• Data Analysis ToolPak for Statistics

DATA ANALYSIS USING SQL 

Learning Objectives:

• Understanding essential SQL database Commands
• Filtering data and operators in SQL
• Aggregation and Summary functions
• Combining tables
• Advanced Data Analysis using SQL

Topics:

• What is SQL and Why is it Important?
• SQL Database Admin Commands
• The Basics of SQL
• Filtering Data Using WHERE Clause in SQL
• Aggregation and Summary Functions in SQL
• Miscellaneous Analysis in SQL
• Table to Table Relationship in SQL
• Combining Tables
• Advanced SQL Data Analysis
• Making Efficient Analysis

PYTHON FOR DATA ANALYTICS

Learning Objectives:

• Starts with the basics of Python programming
• Learn how to use the existing functions and also to create the user defined functions
• Working on different Python packages such as Pandas and NumPy
• Visualizations using Python

Topics:

• Introduction to Python
• Code and Data
• Building Blocks
• Strings
• Data Structures
• Flow Control
• Functions
• Modules
• Files
• NumPy
• Pandas
• Regular Expression
• Visualization

ADVANCED ANALYSIS WITH PYTHON

Learning Objectives:

• Efficient use of Pandas and NumPy for Data Analysis
• Learn to perform the analysis on Structured and Unstructured data
• Learn to work with APIs in Python
• Learn how Parallel computing works
• Visualisations using Seaborn, Plotly and Bokeh packages

Topics:

• Exploratory Data Analysis in Python
• Confirmatory Data Analysis in Python
• Intermediate pandas
• Unstructured Data in Python
• Working with APIs in Python
• Parallel Computing with Dask
• Intermediate Seaborn
• Interactive Visualizations with Plotly and Bokeh

DATA VISUALIZATION USING TABLEAU

Learning Objectives:

• Start with introduction to visualizations and Tableau
• Participants will learn how to connect to different data sources
• Learn how to do Slicing and Dicing data
• Learn Basic and Advanced calculations in Tableau
• Dashboard designing, Publishing and Sharing
• Basics of Excel and formulas in Excel

Topics:

• Introduction to Data Visualization and Tableau
• Understanding Tableau Building Blocks
• Managing Data connections
• Prepare Data for use
• Basic Data Visualization
• Advanced Data Visualization
• Slicing and Dicing Data
• Tableau Basic Calculations
• Tableau Advanced Calculations
• Formatting
• Dashboard Designing
• Publishing and Sharing

MICROSOFT POWER BI - THE COMPLETE MASTERCLASS

Learning Objectives:

• Master data transformation using Query Editor.
• Design and optimize efficient data models.
• Create compelling and insightful data visualizations.
• Understand and apply DAX expressions for advanced calculations.
• Utilize Power BI Cloud Service for publishing, sharing, and implementing row-level security.

Topics:

• Introduction

• Preparing Our Project
• Data Transformation - The Query Editor
• Data Transformation - Advanced
• Creating a Data Model
• Data Visualization
• Power BI and Python
• DAX - The Essentials
• DAX - The CALCULATE Function
• Tell a Story with Your Data - Learn to Visualize Effectively
• Power BI Service - Power BI Cloud
• Row-Level Security
• More Data Sources
• Next Steps to Improve and Stay Up-to-Date