Best Seller Icon Bestseller

DIPLOMA In DATA ANALYTICS(M-DDA-8285)

  • Last updated Sep, 2026
  • Certified Course
₹30,000 ₹47,750

Course Includes

  • Duration6 Months
  • Enrolled0
  • Lectures64
  • Videos0
  • Notes0
  • CertificateYes

What you'll learn

The Professional Diploma in Data Analytics at ET&T Computer Education & Training is a practical, industry-oriented program designed to develop professional skills in data analysis, business intelligence, data visualization and AI-assisted analytics.

The course takes learners from the fundamentals of data handling to advanced analytical techniques using industry-relevant tools including Microsoft Excel 365, SQL, Power BI and Python. Students learn how to collect, clean, transform, analyze and visualize data and convert complex datasets into meaningful business insights.

Special emphasis is given to Advanced Excel, Power Query, Power Pivot, DAX, SQL queries, Python-based data analysis, Power BI dashboards and Generative AI tools. The program also includes practical assignments, business case studies and capstone projects based on real-world applications.

Key Learning Areas

• Advanced Excel 365 for Data Analytics

• Mathematics & Statistics for Data Analysis

• SQL & Database Analytics

• Power Query & Data Transformation

• Power BI & Business Intelligence

• DAX & Data Modeling

• Python for Data Analytics

• Data Cleaning & Exploratory Data Analysis

• Data Visualization & Dashboard Development

• Generative AI for Data Analytics

• Business & MIS Reporting

• Real-World Case Studies & Capstone Projects

Career Objective

The program prepares students for entry-level and professional roles such as Data Analyst, Business Analyst, MIS Executive, Reporting Analyst, Junior BI Analyst and Power BI Analyst.

ET&T Training Approach

Practical Training | Industry-Oriented Curriculum | AI-Enabled Learning | Live Assignments | Portfolio Projects | Dashboard Development | Career & Job Assistance

Show More

Course Syllabus

Level: Beginner to Advanced

1. Excel 365 for Data Analytics

  • Excel Fundamentals & Data Management
  • Advanced Excel Formulas & Functions
  • XLOOKUP, INDEX-MATCH, XMATCH
  • IF, SUMIFS, COUNTIFS, AVERAGEIFS
  • Dynamic Array Functions: FILTER, SORT, UNIQUE
  • Text & Date Functions
  • Conditional Formatting
  • Data Validation
  • PivotTable & PivotChart
  • Advanced Charts & Business Reports
  • What-If Analysis & Forecasting
  • Advanced Excel Dashboard
  • Power Query in Excel
  • Power Pivot & Data Model
  • Introduction to DAX
  • AI in Excel / Copilot for Data Analysis

2. Statistics & Mathematics for Data Analytics

  • Basic Mathematics for Analytics
  • Percentage, Ratio & Proportion
  • Mean, Median & Mode
  • Range, Variance & Standard Deviation
  • Probability Basics
  • Correlation
  • Regression Fundamentals
  • Data Distribution
  • Statistical Interpretation
  • Business Statistics

3. SQL for Data Analytics

  • Database Fundamentals
  • Tables, Records & Relationships
  • SELECT, WHERE, ORDER BY
  • DISTINCT, LIMIT/TOP
  • GROUP BY & HAVING
  • Aggregate Functions
  • INNER, LEFT, RIGHT & FULL JOIN
  • Subqueries
  • CASE Statements
  • CTEs
  • Window Functions
  • Views
  • Data Cleaning with SQL
  • Business Query Analysis
  • Practical SQL Projects

4. Power BI – Business Intelligence

  • Power BI Desktop Interface
  • Importing Data from Multiple Sources
  • Power Query
  • Data Cleaning & Transformation
  • Data Model & Relationships
  • Star Schema
  • DAX Fundamentals
  • Calculated Columns & Measures
  • CALCULATE & Time Intelligence
  • KPIs & Business Metrics
  • Interactive Reports
  • Slicers & Filters
  • Advanced Charts
  • Drill-through & Tooltips
  • Professional Power BI Dashboards
  • Dashboard Publishing & Sharing

5. Python for Data Analytics

  • Python Fundamentals
  • Variables, Data Types & Operators
  • Conditions & Loops
  • Functions
  • Lists, Tuples, Sets & Dictionaries
  • File Handling
  • NumPy
  • Pandas
  • DataFrames & Series
  • Data Cleaning
  • Data Transformation
  • Missing Data Handling
  • Matplotlib
  • Data Visualization
  • Exploratory Data Analysis (EDA)

6. AI for Data Analytics

  • Introduction to Generative AI
  • ChatGPT for Data Analysis
  • Microsoft Copilot
  • AI-assisted Excel Analysis
  • AI-assisted SQL Query Generation
  • AI-assisted Python Coding
  • AI-based Data Cleaning
  • AI-generated Insights
  • Prompt Engineering for Analysts
  • Automated Report Summarization
  • AI-assisted Dashboard Development

7. Data Visualization & Business Reporting

  • Principles of Data Visualization
  • Choosing the Right Chart
  • KPI Design
  • Trend & Variance Analysis
  • Sales & Revenue Analysis
  • Customer Analysis
  • Financial Analysis
  • HR Analytics
  • Inventory Analytics
  • Management MIS Reporting

8. Capstone Projects

Students complete real-world portfolio projects, such as:

  1. Sales Performance Dashboard
  2. HR Analytics Dashboard
  3. Financial Performance Analysis
  4. Customer Data Analysis
  5. Inventory & Supply Chain Analysis
  6. E-Commerce Data Analysis
  7. Power BI Business Intelligence Project
  8. Python Data Analytics Project


Eligibility

Who can apply for this course

Minimum Qualification: 10+2 / Higher Secondary or equivalent from a recognized Board/Institution.

Preferred Qualification: Graduate / Diploma Holder / Undergraduate students / Working Professionals.

Computer Knowledge: Basic knowledge of computers and MS Office is preferred.

Stream: Candidates from Arts, Commerce, Science, Management, Engineering, Computer Applications and other disciplines can enroll.

No prior programming or data analytics experience is required.

Course Fees

Course Fees
:
₹47750/-
Discounted Fees
:
₹ 30000/-
Course Duration
:
6 Months

Review

0.0
Course Rating (0 reviews)
0%
0%
0%
0%
0%



Call
Text Message
Review
Brochure
Email
CHAT