Data Analyst Full Course Summary Subjects
1. Advance Excel
Excel basic and forma ng
Introduc on to excel
Forma ng cell and workbook
Page setup
Data handling and manipula on
Sor ng and filtering data
Text to column
Condi onal forma ng
Number forma ng
Advance formula and func on
Mathema cal formulas
Date & me func on
Logical func on
Text func on
Lookup func on
2. Power query
Introduc on of power query in excel
Installa on of power query
Data connec on
Data cleaning
Data transforma on- append merge
Add columns (custom and condi onal)
Loading data
3. Excel VBA
Understanding VBA And macro
Variable and data type in VBA
Logical Statement (if, elsleif ,else, switch)
Operators
Loops in VBA
Error handling
Message and input box in VBA
Working with worksheet in VBA
4. Goggle sheet
Introduc on to goggle sheet
Import and export data with goggle sheet
Shor ng and filtering data
Create and filter view clean data in goggle sheet
Lookup, vlookup, xlookup, filter.
Summariza on func on like sum, count, , sumif, coun f.
If and ifs func on
Advance func on- (split, import html, import range, goggle translate)
Spark lines
Smart chips
5. Office 365
Improved produc vity
Improved data analysis
XLookup in office365
Xmatch in office 365
Making a searchable drop downlist in office 365
Dynamic condi onal forma ng
Excel sequence and random array formula in office 365
Data visualiza on
6. Goggle locker studio
Connec ng with data source
Goggle data studio interface
Create table visualiza on
Custom visualiza on in goggle data studio
Crea ng and sharing dashboard
Blended data in goggle data studio
7. Power BI
Introduc on to power BI
Data connec vity & transforma on
Data modeling & dax(data analysis expression)
Data visualiza on & interac ve report
Report and dashboard development
Business intelligence & data analy cs
Sharing
8. Python
Introduc on to python
Python language fundamentals
Python variable
Operators
Input and output func ons
Datatypes and structure in python
String
List
Tuple
Set
Dictonary
Control statement
Logical statement(if,elif,else)
Flow control statement(for, while)
Transfer control statement (pass, con nue, break)
Func onl programing
User defined
Built in
9. SQL
Introduc on to sql
Clauses in sql
Select
From
Where
Dis nct
Group by
Having
Order by
SQL statement
DDL(create, alter, drop,truncate)
DQL(Select, clauses)
DML(insert update delete)
DCl intro (Grant, revoke)
TCL intro (commit rollback)
SQL Advance
Sql func on
Joins
Subqueries
Window
10. Stasia cs & probability
Measure of central tendency(mean , median , mode)
Measure of Dispersion (range variance, standard deva on)
Skewness and kurtosis
Percen les and quar les
Basic probability concepts(sample space, Event, Condi onal probability)
Probability distribu on(normal, Binomial, poisson, Etc)
Central limit therorm
Sampling method ( random, stra fied, cluster, Systema c)
Confidence intervals
Correla on coefficient (Pearson, spearman)
