Data Analyst

1) Advanced Excel for Data Analysis

2) SQL & Database

3) Power BI

4) Python for Data Analysis

5) Statistics for Data Analytics

6) Real-World Projects

7) Career Preparation

Excel Basics

Basics Worksheet Basics, Data Formats, Data Handling Basics

Essential Formulas

Basic Formula Operations, Mathematical Functions 1, Mathematical Functions 2, Textual Functions Part 1, Textual Functions 2, Logical Functions Date-Time Functions, Lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH)

XLOOKUP for Excel and Office 365

XLOOKUP as a replacement of VLOOKUP Handling NA and approximate match in XLookup Wildcard matching in XLOOKUP Search modes

Data Tools

Sorting, Filtering and Data Validation, Text-to-columns and remove duplicates, Advanced Filter option, Formatting Data and Tables

Excel Charts

Importance of Data Visualization, Elements of Charts, The Easy way of Creating Charts, Bar and Column Charts, Formatting Charts Part 1, Formatting Charts Part 2, Line Charts, Area Charts, Pie and Doughnut Charts, Scatter plot or XY Chart, Waterfall Charts, Sparklines, Pivot Tables

Pivot Tables and Pivot Charts

Pivot Tables, Pivot Charts

Maps Chart for Excel

Maps Chart

Using ChatGPT with Excel

Use ChatGPT For Excel Problems

Macros

Macros

Importing Data from Websites

Importing Data from Websites Excel 2019 and 365

Basic SQL

SQL Basics, Installing SQL Server, SSMS in your system Tables, DBMS, Views and Indexes

Types of SQL Commands

CreateTables, keys, Restore and Backup, Creating tables using CSV files, Selection and Filtering Commands, Ordering, Commands, Aggregate Commands, Group By, Conditional Statements, Joins, Subqueries

Functions

String Functions, Mathematical Functions, Date Time Functions, Pattern Matching, Window Functions, Data type Conversion Functions

Modules,packages and Liberaries

Modules, Packages, Ways to Import, Built -in Modules, Python Libraries

Python and Numpy

Numpy Introduction, Numpy Datatypes and Attributes, Creating Numpy Arrays, Numpy Random Seed, Viewing Arrays and Matrices, Manipulation of Arrays ( Arithmetic ), Manipulating Arrays ( Aggregate ), Variance and Standard Deviation, Reshaping and Transpose, Dot product, Comparison Operator and Sorting, Image to Numpy Array

Data Analysis using PANDAS

Pandas Overview, Series, Data Frames and CSV, Describing Data with Pandas, Selecting and Viewing Data, Asking the right questions, Manipulating Data using Pandas, Manipulating Data with Pandas 2, Apply Function

Matplotlib Introduction, Using Matplotlib, Matplotlib Workflow (Explicit Method), Scatter and Bar plot, Histograms and Subplots, Subplots Alternate Method, Plotting from Pandas Series, Plotting from Pandas DataFrame, Plotting from Pandas DataFrame 2, Plotting from Pandas DataFrame 3, Plotting from Pandas DataFrame 4, Plotting from Pandas DataFrame 4, Plotting from Pandas DataFrame 6, Customizing our Plots, Customizing our Plots 2, Seaborn Introduction, Seaborn Univariate Analysis, Seaborn Bivariate Analysis, Seaborn Plotting Relationships, Plotly Express

Power BI

Introduction to Power BI, Data Transformation + Data Types, Replace Text + Extract + Split, Trim + Clean, Assignment, Data Modelling, Visualization, ETL, Column Chart, Pie Chart, Line Chart, Table, Slicers, Filters, Tree Visualization, Logical DAXText DAX, DateTime DAX, Bookmarks, RLS, Field Parameters, AI Visuals + Quick Measures, Folder Problem, SQL+PowerBI

Interview Preparation

How to build a Resume, Customizing the Resume as per specific Job, Interview Preparation Guidelines, Short Mock Interview Flow, How to Apply for Jobs, Profile Enhancement and Upskilling

100% Practical