Data Analyst

Excel

---

Excel Basics

Data Analysis using Excel

SQL

---

Introduction

SQL Datatypes

Keys & Constraints

SQL Commands

SQL Queries

SQL Joins

SQL Functions

Window Functions & CTE

Views

Indexes

Stored Procedures

Exception Handling

Case Studies

Python

---

Python Basics

Control flow statements

Functions

Data Structures

Loops

File Handling

Exception Handling

Modules & Packages

Numpy

Pandas

Matplotlib & Seaborn

Statistics

---

Basic Statistics

Power BI

---

Power BI introduction

Installation & Overview

Power Query

Data Modeling

Data Warehousing Concepts

DAX

Data Visualization

Interactive Reports

Power BI Service

Real-Time Projects