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.