Certificate IN DATA ANALYST ( S-SICT-DATA ANALYST )

Module I

v Excel

o   Topics

§  Basic formulas: SUM, AVERAGE, MEAN, MEDIAN, SUMPRODUCT, CONCATENATE

§  Advance formulas: VLOOKUP, INDEX, MATCH, IF, COUNTIF, SUMIF

§  Remove duplicates and conditional formatting

§  Charts, filters, sort and slicers

§  Pivot tables and pivot charts

v Math and Statistics

o   Topics

§  Basic Math: Arithmetic, Weighted average, Cumulative sum, Percentile

§  Basic Statistics: Mean, Median, Mode, Standard deviation, Normal distribution

Module II

v SQL

o   Topics

§  Basic Queries: SELECT, WHERE, DISTINCT, LIKE, BETWEEN, ORDER BY, LIMIT, GROUP BY,    HAVING CLAUSE, INSERT, UPDATE, ALTER, IMPORT, Data types

§  Advance Queries: Date time function, Window function, Sub query, Case statement, CTE, query optimization

§  JOINS: Inner, Outer, Left, Right

Module III

v BI Tools :-   Power BI

·         Introduction To Power BI

·         Power BI Desktop & Power Query

·         Modeling With Power BI

·         Data Analysis Expressions (DAX)

·         Data Visualization

·         Introduction to Power BI Dashboard, Q&A and Data Insights

·         Power BI Service

·         Power BI Direct Connectivity

·         Case Study/Project

Tableau

·         Introduction to Tableau

·         Tableau Shelf and Card

·         Connecting to and Preparing Data

·         Data Types in Tableau

·         Organizing and Simplify Data

·         Learn Tableau Built-In and Custom Chart

·         Analytics

·         Tableau Dashboard

·         Performance improvement of Dashboard

Module IV

v Programming- Python

Note: If you are a beginner, my personal suggestion will be to learn Python instead of R- as its high in demand and beginner friendly. Also, it will help to solve Machine Learning problems

o   Topics in Python:

§  Variables, Data types, Lists, Tuples, Dictionaries, Sets, Conditional expressions, Modules, Functions, Operators, if statements, Loops, classes and objects

§  Python libraries: Pandas and Matplotlib

§  Pandas: read/write csv, excel and JSON files, work with dataframe, data manipulation and analysis- Group by, Concatenate, Merge

§  Matplotlib: creating static, animated, and interactive visualizations in Python