Best Seller Icon Bestseller

CERTIFICATE IN DATA ANALYST Complete Data Analyst(S-CDA-5197)

  • Last updated Mar, 2026
  • Certified Course
₹9,500 ₹14,500

Course Includes

  • Duration4 Months
  • Enrolled0
  • Lectures40
  • Videos0
  • Notes0
  • CertificateYes

What you'll learn


The Complete Data Analyst Course is designed to help students build strong skills in data analysis using industry-standard tools. In this course, students will learn Advanced Excel, SQL, Python for Data Analysis, and Power BI to analyze data and create professional dashboards and reports.


The training includes practical exercises, real-world datasets, and projects such as Sales Analysis, HR Analytics, Student Performance Reports, and E-commerce Data Analysis. Students will learn how to clean data, perform analysis, visualize insights, and create interactive dashboards for decision making.


By the end of the course, students will have the practical knowledge and hands-on experience required to start their career as an Entry-Level Data Analyst.




Show More

Course Syllabus


Module 1: Advanced Excel


  • Excel Interface & Shortcuts
  • Basic Formulas (SUM, IF, VLOOKUP, XLOOKUP)
  • Pivot Table & Pivot Chart
  • Conditional Formatting
  • Data Cleaning Techniques
  • Dashboard in Excel
  • MIS Report Creation



Module 2: SQL (Microsoft SQL Server)


  • Database & Table Creation
  • SELECT, WHERE, GROUP BY, ORDER BY
  • JOIN (Inner, Left)
  • Aggregate Functions
  • Subquery Basics
  • Sales Database Practice



Module 3: Python for Data Analysis


  • Python Basics
  • Data Types & Variables
  • Lists & Dictionary
  • Pandas Introduction
  • Data Cleaning using Pandas
  • GroupBy & Filtering
  • Basic Visualization (Matplotlib)
  • CSV & Excel File Handling



Module 4: Power BI


  • Data Import (Excel, SQL)
  • Power Query (Data Cleaning)
  • Data Modeling
  • DAX Basics
  • Measures & Calculated Columns
  • Charts & Visuals
  • Slicers & Filters
  • Interactive Dashboard
  • Report Publishing



Module 5: Integration & Projects


  • Sales Analysis Dashboard
  • Student Performance Report
  • HR Analytics Report
  • E-commerce Analysis


Course Fees

Course Fees
:
₹14500/-
Discounted Fees
:
₹ 9500/-
Course Duration
:
4 Months

Review

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



Call
Text Message
Review
Email
CHAT