Diploma in Data Analytics
Diploma in Data Analytics
In today’s data-driven world, every business relies on numbers, not guesswork. Companies make decisions based on dashboards, analytics, trends, and reports. The individuals who know how to read, analyze, visualize, and present data are the ones who advance the fastest in their careers.
However, many students and professionals face challenges because
- They know Excel, but not analytics.
- They can store data, but struggle to extract insights from it.
- They create reports, but do not produce dashboards that decision-makers understand.
- They learn tools, but do not figure out how to use them in real projects.
- They lack hands-on experience that employers seek during hiring.
What This Program Offers
- 4 Months of Practical Skills Training
- 2 Months of Real Internship Experience
- Training + Internship Certificates
- Job Assistance (Resume + Interviews + Portfolio)
Why You Should Learn Data Analytics Now
- Data Analyst is one of the fastest-growing careers globally
- Salaries are high because demand is strong and talent is scarce.
- Every company collects data, but very few know how to use it.
- With the right skills, you become valuable in any industry.
- You can work in IT, Banking, Finance, Healthcare, Marketing, HR, and more.
You will be able to apply for roles such as:
- Data Analyst
- MIS Executive
- Business Analyst
- Reporting Analyst
- Power BI Dashboard Analyst
- Excel + SQL Analyst
This Course is for You If You Want To
- Start a career in the IT or corporate world.
- Switch to a high-growth, high-income field.
- Build dashboards and professional reports.
- Work with real business datasets.
- Gain experience, not just theory.
Module 1: Excel & Advanced Excel
Customizing Excel
- Customizing Ribbon
- AutoCorrect customization
- Changing Excel Default Options
Using Basic Functions
- SUM, AVERAGE, MAX, MIN
- COUNT, COUNTA
- Absolute, Mixed & Relative References
Formatting & Proofing
- Number, Font, Alignment, Borders
- Basic Conditional Formatting
Mathematical Functions
- SUMIF / SUMIFS
- COUNTIF / COUNTIFS
- AVERAGEIF / AVERAGEIFS
Protection
- File Protection
- Workbook & Worksheet Protection
Text Functions
- UPPER / LOWER / PROPER
- LEFT, RIGHT, MID
- TRIM, LEN, EXACT
- CONCATENATE
- FIND / SUBSTITUTE
Date & Time Functions
- TODAY, NOW
- DAY, MONTH, YEAR
- DATE, DATEDIF, DATEADD
- EOMONTH, WEEKDAY
Advanced Paste Special
- Paste Formats / Formulas
- Paste Validations
- Transpose Tables
Excel 2013/16/365 New Features
- Tree Map, Waterfall
- Sunburst, Box & Whisker
- Combo Charts + Secondary Axis
- Slicers in Pivot Table
- Power Map & Power View
- Forecast Sheet
- Sparklines
- 3D Map
- New Pivot Controls (Fields/Items/Sets)
- Timelines in Pivot
- Autocomplete list + Data Range
- Quick Analysis Tool
- Smart Lookup
Sorting & Filtering
- Filter by Text/Number/Color
- Sorting Options
- Advanced Filter (15–20 Criteria)
Printing & Workbook Output
- Set Print Area
- Headers/Footers
- Layout & Template Structure
Print Titles (Repeat Rows/Columns)
Module 2: Advanced Excel & Analytics
What-If Analysis
- Goal Seek
- Scenario Analysis
- Data Tables (PMT)
Logical Functions
- IF Function
- IFERROR
- Nested IF
- Logical AND / OR
Data Validation
- Numeric / Date / Text Validation
- Lists & Dropdowns
- Custom formula validations
- Dependent dropdowns
Lookup Functions
- VLOOKUP / HLOOKUP
- INDEX + MATCH
- Nested Lookups
- Reverse Lookup (CHOOSE)
- INDIRECT to link sheets
- Helper Column Lookups
Pivot Tables
- Basic & Advanced Pivot Setup
- Value Field Settings
- Classic Layout
- Grouping (Date & Number)
- Calculated Fields & Items
Array Formulas
- Concept of Arrays
- CSE Entry (Ctrl+Shift+Enter)
- LEN/MID/IF Array Examples
- Lookup Arrays
Advanced Array Logic
Charts & Slicers
- Bar / Pie / Line / Comparison Charts
- Slicers for filtering
- Primary + Secondary Axis
Dashboard Development
- Dashboard Planning
- Chart + Table Integration
Dynamic Content Dashboard
Module 3: VBA Macros
VBA Basics
- What is VBA?
- Automation Scope
- Recording Macros
- Procedures & Functions
Variables
- Declared vs Undeclared
- Data Types
- Constants
MessageBox / InputBox
- Customized MsgBox & InputBox
- Reading cell values to messages
- Button groups
Conditional Control
- IF / ELSEIF
- SELECT CASE
Looping
- Do Loop / For Loop
- Exit Loop
- Advanced Loop Techniques
Mail Automation
- Outlook Namespace
- Automated Email Sending
- MAPI Configuration
Functions
- Custom Functions
- Calling Functions
- Parameters + Optional Parameters
Sheets & Workbooks
- Sheet types
- Insert/Delete/Copy/Move
Hide/Unhide
Referencing Workbooks
Save/Open/Create
Filtering & Reporting
- AutoFilters
- Advanced Filters
- Pivot Table via VBA
- Chart Creation Using VBA
Form Controls
- UserForm elements
- Combo Box / Radio / Checkbox
- Calendar + Spin Control
- Read/Write Data Through Forms
Workbook Automation
- Merge Sheets
- Merge Multiple Excel Files
- Split Worksheets
Automated Copying
Module 4: SQL Server & PL/SQL
SQL Server Basics
- RDBMS Overview
• SQL Studio Introduction
• Databases & Tables
Basic SQL Queries
- SELECT Queries
• DISTINCT & Aliases
• CASE Expressions
• ORDER BY / GROUP BY
Sorting & Filtering
- WHERE Filters
• TOP / OFFSET-FETCH
• NULL Handling
Aggregation
- SUM / MIN / MAX / AVG
• GROUP BY
• HAVING
Table Management
- CREATE / ALTER / INSERT
• Modify Columns & Datatypes
Constraints
- NOT NULL
• DEFAULT
• UNIQUE
• PRIMARY KEY / FOREIGN KEY
• INDEXES
SQL Joins
- INNER/OUTER
• LEFT/RIGHT
• CROSS & SELF JOIN
Views
- Create Views
• Views vs Tables
• Views from JOINs
String Functions
- LEFT / RIGHT
• UCASE / LCASE
• LENGTH / FORMAT / CONCAT
Date Functions
- DATE_ADD, NOW, CURRENT_DATE
• DATEDIFF, DATE_FORMAT
• EXTRACT, LAST_DAY
T-SQL Programming
- Variables, Batches
• IF/ELSE / WHILE
• Flow Control
Stored Procedures
- Simple Stored Procedure
• Parameterized SP
• Query using SP
Transactions
- ACID Concepts
• Transaction Control
• Real-time Use Cases
Module 5: Power BI (Business Analytics)
Power BI Essentials
- Power Query / Power Pivot / Power View
• Report Server, Mobile, Desktop Flow
Power Query (ETL)
- Clean, Shape, Transform Data
• Remove Duplicate/Errors
• Split/Merge/Pivot/Unpivot
• Keep/Remove Rows
• Group By
• Custom Column Logic
M Language
- IF/ELSE
• Split/Merge Columns
• Replace Value
• GROUP BY / SORT
• Pivot via M Functions
Data Modeling
- Relationships
• One-to-One / One-to-Many / Many-to-Many
• Create & Modify Relationships
DAX Formulas
- Calculated Column vs Measure
• Operators / Expressions
• Date Functions (YEAR/MONTH/WEEKNUM etc.)
• Text Functions (LEN/LEFT/UPPER etc.)
• Logical IF, OR, AND, TRUE/FALSE
• Math Functions POWER, SQRT, ROUND
• Statistical Functions SUMX, MINX, MAXX
• Filter Functions CALCULATE, ALL, RELATED
Reports & Visualization
- Charts (Bar, Pie, Line, Area, Combo)
• Table & Matrix
• Scatter / Funnel / Ribbon / Waterfall
• Dashboard Creation + Pin Visuals
• Sharing Dashboards
Diploma in Data Analytics
- Strong Foundation in Data Analytics Tools
- Data Cleaning, Preparation & Exploration
- Statistical Analysis & Business Insights
- Visualization & Interactive Dashboards
- Real-World Projects & Job-Ready Skills
4.7 (65 reviews)
Find Other Courses
- Advanced Excel and Data Reporting Course
- PHP & Advanced PHP Training
- Web Designing & Full Stack Development Program
- ChatGPT & AI Tools Professional Certification Program
- Advanced Digital Marketing Program
Diploma in Data Analytics
Please Fill the Form
Diploma in Data Analytics – FAQs
What is the Diploma in Data Analytics course about?
This course teaches you how to collect, analyze, visualize, and interpret data using tools like Excel, SQL, Power BI, Python, and real-time datasets.
Who can enroll in this Data Analytics Diploma program?
Students, working professionals, beginners, and anyone interested in data-driven careers can join. No prior technical background is required.
What skills will I learn in this diploma course?
You will learn Excel for data cleaning, SQL for database queries, Power BI/Tableau for visualization, Python for analytics, statistics, dashboards, and real-world project handling.
How is the course structured?
The course includes instructor-led classes, hands-on practice, assignments, case studies, and multiple live projects to build strong practical skills.
Will I get job support after completing the diploma?
Yes, you will receive interview preparation, resume building, and placement assistance for roles like Data Analyst, Business Analyst, and Reporting Analyst.