Advanced Diploma in Data Analytics
Excel, SQL, Python and Power BI to analyse data and build dashboards.
ADDA teaches you to turn raw data into clear answers. In four months you learn Excel, SQL, Python and Power BI, and build reports and dashboards that managers can use. No coding experience is needed, and the course is open to diploma holders and graduates from any stream.
What you will learn
Excel for analytics
Pivot tables, lookup and index-match, data cleaning, validation, macros, VBA and automation.
MySQL
Tables, queries, joins, subqueries, views, constraints, functions and advanced query processing.
MongoDB
NoSQL basics, CRUD operations, indexing, aggregation and unstructured data.
Power BI
Data connections, transformation, charts, maps, dashboards, filters and slicers.
Python
Syntax, control flow, strings, lists, tuples, dictionaries, functions, modules, file handling, exceptions and OOP.
NumPy
Arrays, indexing and slicing, mathematical and linear algebra operations.
Pandas
DataFrames, cleaning, merging, grouping, missing data and time series.
Matplotlib
Line, scatter and bar plots, subplots, histograms and 3D plots.
Git
Repositories, version control, branching, merging and collaboration.
Interested in ADDA?
Find the branch nearest to you and ask about batch timings, fees and scholarships.
