Scribd
Upload
38 views7 pages

Syllabus Data Analyst

Syllabus

Uploaded by

Shiv Bajpai
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
38 views7 pages

Syllabus Data Analyst

Syllabus

Uploaded by

Shiv Bajpai
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 7

DATA ANALYST SYLLABUS

Introduction to Excel
Module 1: Excel Fundamentals & Core Functions

 Introduction to the Excel Interface (Ribbon, Formula Bar, Cells)


 Data Entry and Formatting Techniques
 Absolute vs. Relative Cell References
 Mathematical Functions(SUM, AVERAGE, COUNT, MIN, MAX)
 Logical Functions (IF, AND, OR, NOT, IFS (for multiple conditions))
 Text Functions

 CONCATENATE (&)
 LEFT, RIGHT, MID
 TRIM (to remove extra spaces)
 LEN (to count characters)
 FIND, SEARCH

 Lookup & Reference Functions

 VLOOKUP
 HLOOKUP
 INDEX & MATCH
 XLOOKUP (Modern and more powerful)

 Statistical Functions

 SUMIF, COUNTIF, AVERAGEIF


 SUMIFS, COUNTIFS, AVERAGEIFS

 Date & Time Functions

 TODAY, NOW
 DATEDIF, YEAR, MONTH, DAY
 EOMONTH

Module 2: Data Cleaning & Analysis Tools

 Sorting Data (Single and multi-level)


 Filtering Data (Using AutoFilter and Advanced Filter)
Data Cleaning Tools

 Text to Columns
 Remove Duplicates
 Flash Fill

Data Validation

 Creating dropdown lists


 Setting criteria for data entry

Conditional Formatting

 Highlighting cells based on values


 Using data bars, color scales, and icon sets

PivotTables

 Creating and designing PivotTables


 Grouping data (by dates, numbers)
 Using Slicers and Timelines for interactive filtering
 Creating Calculated Fields and Items

Advanced Analysis like Power Query, power Pivot, basic Charts

Introduction to Python
Module 1: Operations & functions

 Introduction
 Installation
 Basic Operator
 Brief of Jupyter Notebook
 Data Type, Variables and Number
 String
 List
 Tuple
 Dictionary
 Set
 Conditional Statement
 While
 LOOPING
 FUNCTION
 Inbuilt functions
 Exceptional handling
 File handling
 OBJECT ORIENTED CONCEPTS
 Module – random

Module 2: Arrays

 Intro on Numpy
 Creating Arrays
 Indexing Arrays
 Array Transposition
 Shape Manipulation
 Universal Functions
 Array Operations
 Broadcasting
 How to handle Nan

Module 3: Datasets & data frames

 Intro on pandas
 Creating a final data set
 How to read Data Files from pandas
 How to write Data using Pandas
 Inspecting data frame
 Indexing rows & columns of data frame
 Filters & operations using data frame
 Handling missing values using Pandas
 Drop rows and columns in pandas
 Aggregate data in Pandas
 Merge operation on data frames
 Data Wrangling
 Data modelling
 Useful functions of pandas
 EDA(Exploratory Data Analysis) of some useful data

Module 4: Plots & charts


 Intro on Matplotlib
 Basis of Matplotlib
 Figure
 Creating plot
 Plots
 Adding texts to plots
 Adding legend
 Adding Grids
 Subplots
o Scatter Plot
o Bar Chart
o Pie Chart
o Histogram
o Heat map
o Plotting curves
 Brief on Visualization python Libraries

Power BI
Module 1: Setup & Dashboards

 Introduction to Power BI
 Connecting to data sources & creating basic charts & visuals
 Cleansing data with Query Editor
 Creating Report by combining all visuals
 Report Formatting with Filter
 Managing Relationships between Tables in Power BI
 Creating Tables or new columns using Power Query
 Transforming Columns in Query Editor

Module 2: Modelling & Optimisation

 Modelling & Optimisation


 Customisation
 Interactions
 Measures
 Calculated columns
 Columns
 Intro to DAX
 DAX Important functions
 Business intelligence
 Some business logics

Intro to SQL(Structured Query Language) for Data


analyst
refer for querying and manipulating data in RDBMS
Module 1Basic SQL Commands

 SELECT
 INSERT INTO
 UPDATE
 DELETE

Module 2 Filtering Data

 INSERT
 UPDATE
 DELETE

Module 3 Sorting and Limiting Data

 ORDER BY
 LIMIT
 DISTINCT

Module 4 Aggregating Data

 COUNT()
 SUM()
 AVG()
 MIN()
 MAX()
 GROUP BY
 HAVING

Module 5 Joins
 INNER JOIN
 LEFT JOIN
 RIGHT JOIN
 FULL JOIN
 CROSS JOIN
 SELF JOIN

Module 6 Subqueries

 Subqueries in SELECT
 Subqueries in WHERE
 Subqueries in FROM

Module 7 Set Operations

 UNION
 UNION ALL
 INTERSECT
 EXCEPT

Module 8 Data Modification

 WHERE
 AND, OR, NOT
 IN
 BETWEEN
 LIKE
 IS NULL, IS NOT NULL
 EXISTS

Module 9 Views

 CREATE VIEW
 DROP VIEW
 ALTER VIEW

Module 10 Common Table Expressions

 WITH CTE AS
 RECURSIVE CTE
 WITH TEMPORARY CTE

Module 11 Window Functions


 ROW_NUMBER()
 RANK()
 DENSE-RANK()
 NTILE()
 LEAD()
 SUM() OVER()
 AVG() OVER()
 PARTITION BY
 ORDER BY

Module 12 Date and Time Functions

 GETDATE()
 CURRENT_TIMESTAMP
 DATEADD()
 DATEDIFF()
 DATEPART()
 DATE_FORMAT()
 NOW()
 EXTRACT()
 TIMESTAMPDIFF()

Module 14 Conditional Logic

 CASE WHEN
 IFNULL()
 COALESCE()

PROJECTS ON REAL CASES

SQL

POWER bi

You might also like