Data Analytics Course

Course Content

Data Analytics Course includes Excel, Advance Excel, SQL, Power BI, Python and Generative AI.

MS Excel

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

Advance Excel

1. Advanced Formulas and Functions
2. Working with Large Datasets
3. Working with Charts
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. Power BI Service
7. Power BI Advanced Features
8. 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

Generative AI

1. What is Artificial Intelligence?
2. What is Generative Artificial Intelligence?
3. Difference between Traditional A.I and Generative A.I
4. How to use Chatgpt, Perplexity and Gemini?
5. How to use AI in Canva to create images and videos?
6. How to use notebooklm to generate audio?
7. Prompt Engineering (How to write professional prompt)
8. How to write SQL Queries using Gen A.I
9. Convert MS SQL Queries to MySQL using Gen A.I
10. How to generate practice data (Like excel sheets) using Gen A.I
11. How to rectify code (Python Scripts, SQL Queries) using Gen A.I

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: 6 Month
• Slot: Weekends Offline

Training Features

• Upto 20 Students in a batch
• Special Focus on Practical
• Study Material with Lab Facility
• Trainer having 15+ years Industrial Experience.
• 100+ Task Sheets
• 2-3 Project Included
• 100% Placement Support

Why Tech Altum

• MSME Registered Company
• ISO Certified Training Institute
• Run by Ex IIT Alumni
• Microsoft Registered Training Partner
• 100% Job Assistance
• Fully AC Classrooms with Projector
• Lab Facility with Free WiFi