Data Analytics Course in Noida

Course Content

Data Analytics Course includes Excel, SQL, Advance Excel, Power BI with or without Python.

Excel Basics

1. Introduction to Excel
2. Working with Data
3. Formulas and Functions I
4. Formulas and Functions II
5. Pivot Tables and Slicers I
6. Pivot Tables and Slicers II

Advance Excel

1. Advanced Formulas and Functions I
2. Advanced Formulas and Functions II
3. Working with Large Datasets
4. Power Query
5. Power Pivot and Data Modeling

SQL

1. Introduction to SQL
2. Working with Multiple Tables
3. Aggregating Data
4. Subqueries and Nested Queries
5. Data Manipulation
6. SQL Functions and String Operations

Power BI

1. Introduction to Power BI
2. Data Modeling in Power BI
3. DAX Basics
4. DAX Advanced Concepts
5. Data Visualization in Power BI
6. Data Visualization in Power BI II
7. Power BI Service
8. Power BI Advanced Features
9. Power BI Project

Python

1. Introduction to Python for Data Analysis
2. Data Handling with Pandas
3. Numerical Operations with NumPy
4. Data Visualization
5. Data Aggregation and Group Operations
6. Working with Dates and Times
7. Combining and Merging Datasets
8. Data Input and Output
9. Practical Data Analysis Projects

Project

1. Hands-on Data Analysis Projects using real datasets
2. Analyzing sales data
3. Cleaning and analyzing survey data
4. Visualizing demographic data

This syllabus covers the essentials of data analysis using Python and provides a strong foundation to build on for more advanced topics later.

• Duration: 4 Month
• Duration: 25 hours
• Slot: Weekdays or Weekends

Data Analytics Training Features

• 8 to 12 Students in a batch
• Special Focus on Practical
• Study Material.
• Trainer having 7+ years Industrial Experience.
• Special batches
• Project Included

Why Tech Altum

• MSME Registered Training Institute in Noida
• ISO certified Training Institute
• Run by Ex IIT Alumni
• Microsoft Registered Training Partner
• 100% Job Assistance
• Fully AC Classrooms with Projector
• Lab Facility with Genuine Softwares.