Introduction to Data, Data Analysis & its Process

Basics of Microsoft Excel

Exploring Data with Excel Functions

Common Functions

String Functions

Logical Functions

Numerical Functions

Date & Time Functions

Utilizing Excel Templates

Mastering VLOOKUP & HLOOKUP

Conditional Selection and Logical Operators

What-If Analysis Techniques

Solving Linear Optimization with Excel Solver

Data Validation Techniques

Pivot Table Analysis

Power Query Data Exploration

Merging & Appending Data Sets

Working with Power Pivot

Data Modeling in Excel

Data Visualization with Excel

Rank and Percentile Calculation

Histogram and Pareto Chart Procedures

Exponential Smoothing & Moving Averages

Macros in Visual Basic for Applications

Introduction to Microsoft Power BI Desktop

Data Connection in Power BI Desktop

Power Query Editing and M Functions

Merging & Appending Queries

Basic Charts and Visuals in Power BI

Custom Visualizations in Power BI

Different Types of Filtering

Preparing Summary Reports

Grouping & Aggregation Techniques

Groupings and Binnings

Drill Down and Drill Through Filters

Creating Table Relationships in Power BI

Data Modeling Techniques

Creating Interactive Dashboards

Data Analysis Expressions (DAX Functions)

Power BI Q&A Visuals

Key Influencer Visuals

Time Series Analysis and Forecasting Models

Introduction to Databases and Installation

Basic SQL Queries

Aggregate and Scalar Functions

Data Filtering Techniques

Logical Operators

Comparison Operators

Handling Null Values

Different Types of Joins

Group By and Having Clauses

Querying and Aggregating Data

Window Functions in SQL

Conditional Statements and Nullif

SQL Views

SQL Subqueries

Creating a Database

Database Operations

Database Design and Software Development Life Cycle

Primary Key and Foreign Key Concepts

SQL Best Practices

Introduction to Python Programming

Python Programming Marketplace

Anaconda Environment Setup

Getting Started with Jupyter Notebook

Python Syntax Essentials

Variables in Python

Data Types in Python

Operators in Python

Conditional Statements in Python

Loops in Python

For Loops

While Loops

Overview of Inbuilt Functions

User-Defined Functions

Object-Oriented Programming in Python

Defining Classes & Objects

File Handling in Python

Error Handling in Python

Decorators & Generators

NumPy for Data Handling

Pandas for Data Analysis

Data Visualization with Matplotlib

Data Visualization with Seaborn

Building GUI Applications with Tkinter

Introduction to Tableau

Understanding Tableau Concepts

Connecting and Preparing Data

Exploring & Analyzing Data

Sharing Insights

Introduction to Advanced Tableau

Advanced Table Calculations

Advanced Data Preparation & Analytics in Tableau

Level of Detail Calculations

Advanced Dashboard Techniques