ADDA (ADVANCED DIPLOMA IN DATA ANALYTICS) 

ADDA (ADVANCED DIPLOMA IN DATA ANALYTICS) 

COURSE COVERAGE 

DATA MANAGEMENT 

EXCEL 

Introduction – Formatting worksheet – Conditional formatting – Pivot tables and charts – Formulas and functions (VLOOKUP, INDEX, MATCH, SUMIF, etc.) – Data cleaning and transformation – Data validation and sorting – Macros – Excel VBA User Forms – Connect with External Data – Creating an Automation project. 

MySQL 

Creating and modifying tables – Data manipulation (INSERT, UPDATE, DELETE) – Querying databases (SELECT, JOIN, GROUP BY) – Aggregation functions (SUM, AVG, COUNT) – Join and Subqueries. 

MongoDB 

Introduction to NoSQL databases – CRUD operations – Data Indexing & Aggregation – Working with Unstructured Data. 

DATA VISUALIZATION 

MATPLOTLIB 

Basic plotting (line plots, scatter plots, area plots) – Customizing plots (tables, titles, legends) – Multiple subplots – Histograms and box plots – 3D plotting. 

POWER BI 

Connecting to data sources – Data transformation and cleaning – Building visualizations (charts, tables, maps) – Creating dashboards – Applying filters and slicers – Implementing advanced analytics in Power BI. 

LANGUAGE SKILLS 

PYTHON 

Basic syntax and data types – Control flow – Functions and modules – File handling – Exception handling – List comprehensions and lambda functions – Object-oriented programming (OOP) concepts. 

DATA WRANGLING 

NUMPY 

Arrays and array operations – Indexing and slicing – Mathematical functions – Linear algebra operations – Random module – Broadcasting. 

PANDAS 

Series and DataFrame – Indexing and selecting data – Data cleaning and manipulation – Merging and joining data – Grouping and aggregating data – Handling missing data – Time series data. 

CODE MANAGEMENT 

GIT 

Setting up a GIT repository – Version Control – Branching & Merging – Collaboration.