AI & Data · ADDA

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.

Duration4 months
Training hours150 hrs
Who it's forDiploma holders and any graduate
PrerequisitesNo prior coding experience needed

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.

Find a branch

Related courses

WhatsApp us