CERTIFICATE In DATA ANALYTICS COURSE(M-DAC-7151)

Last updated Dec, 2025
Certified Course

₹18,000 ₹20,000

Duration6 Months
Enrolled0
Lectures150
Videos0
Notes0
CertificateYes

What you'll learn

The Data Analytics Course teaches essential skills for analyzing, visualizing, and interpreting data using Excel, SQL, Power BI, and Python fundamentals. Students learn data cleaning, dashboards, queries, reports, and real business projects. With hands-on practice, this course prepares learners for roles like Data Analyst, MIS Executive, Business Analyst, and Reporting Specialist in modern data-driven workplaces.

Who This Course Is For

Students wanting to start a career in data analytics
Job seekers preparing for MIS/Data Analyst roles
Working professionals needing reporting skills
Commerce, IT, Engineering, and Management students
Beginners with no coding or analytics background
Anyone wanting to learn dashboards, SQL, and business reporting

Why Choose This Course

Covers Excel, SQL, Power BI, Looker Studio & Python basics
Real datasets and business case studies
Learn dashboards, reports, KPIs, and data cleaning
SQL queries for data extraction and analysis
Power BI visualizations & interactive dashboards
In-demand skills for high-growth data roles
Hands-on projects + mock tests + certification

Course Syllabus

Module 1: Excel for Data Analysis

Day 1: Introduction to Data Analytics and Job Roles
Day 2: Understanding Data Types and Business Use Cases
Day 3: Excel Interface and Navigation
Day 4: Cell Formatting, Data Entry, Fill Series
Day 5: Basic Functions – SUM, AVERAGE, MIN, MAX
Day 6: Text Functions – LEN, TRIM, CONCAT, LEFT, RIGHT
Day 7: Logical Functions – IF, AND, OR, NOT
Day 8: Lookup Functions – VLOOKUP, HLOOKUP
Day 9: Nested IF & IFS with Range Lookups
Day 10: COUNTIF, SUMIF, AVERAGEIF
Day 11: Data Validation and Dropdown Menus
Day 12: Conditional Formatting Techniques
Day 13: Sorting and Filtering Complex Data
Day 14: PivotTables – Grouping & Summarization
Day 15: Pivot Charts and Interactive Filters
Day 16: Data Cleaning – TRIM, CLEAN, Remove Duplicates
Day 17: Date & Time Functions – DATEDIF, EOMONTH, TODAY
Day 18: Excel Dashboard Design Principles
Day 19: Mini Project – Sales Dashboard
Day 20: Practice and Evaluation
Day 21–25: Case Studies – Marketing, HR, Inventory
Day 26–30: Internal Test + Dashboard Submission

Module 2: SQL for Data Queries

Day 31: Introduction to Databases and SQL
Day 32: SELECT Statement and Filtering with WHERE
Day 33: Logical Operators – IN, LIKE, BETWEEN
Day 34: Sorting and Limiting Results
Day 35: Aggregate Functions – COUNT, SUM, AVG
Day 36: GROUP BY and HAVING Clause
Day 37: JOINS – INNER, LEFT, RIGHT
Day 38: Combining Tables using JOINS
Day 39: Subqueries and Nested SELECT
Day 40: CASE Statements and Conditional Logic
Day 41: Working with Dates and Aliases
Day 42: Creating and Modifying Tables
Day 43: Inserting, Updating, Deleting Data
Day 44: Project – E-commerce Order Analysis
Day 45: Mini Assignment – HR Data Reporting
Day 46–50: Practice on Live Datasets
Day 51–60: Internal Test + Project Presentation

Module 3: Python for Data Analysis - Module 4: Power BI & Looker Studio - Module 5: Capstone + Placement Prep

Want to learn more or join this course with our latest offers? Click here to chat with us on WhatsApp for instant support.

Course Fees

₹20000/-

Discounted Fees

₹ 18000/-

Course Duration

6 Months

Review

0.0

Course Rating (0 reviews)

Featured review

No reviews yet. Be the first to review this course!