Advanced Diploma in Data Analytics
To equip learners with skills to efficiently analyze and visualize data for effective decision-making.
LANGUAGE SKILLS
Basic syntax - Control flow - Functions and modules - File handling - Exception handling - List comprehensions - OOP concepts.
DATA MANAGEMENT
Introduction – Formatting Worksheet – Conditional for- matting - Pivot tables and charts - Formulas and functions (VLOOKUP, INDEX-MATCH, SUMIF, etc.) -Data cleaning and transformation -Data validation and sorting – Macros - Excel VBA and User Forms – Connect with External Data – Creating an Automation Project
Creating tables - Data manipulation - Queries (SELECT, JOIN, GROUP BY) - NoSQL basics - CRUD operations - Unstructured Data.
DATA WRANGLING
Arrays operations - Indexing - Linear algebra - Series and DataFrame - Data cleaning - Merging and joining - Time series data.
DATA VISUALIZATION
Basic plotting (line, scatter, bar) - Customizing plots - Subplots - Histograms and box plots - 3D plotting.
Connecting to data sources- Data transformation and clean- ing - Building visualizations charts, tables, maps- Creating dashboards - Applying fi lters and slicers - Implementing ad- vanced analytics in Power BI.
Setting up repository - Version Control - Branching & Merging - Collaboration.