• Courses
  • Placement
  • Data Science
    IBM
  • GATE
  • Practice
Switch to Dark Mode

Complete Data Analytics Program

Offline Course
4.6/5 ratings
sale ribbon
interested count43k+ interested Geeks

Unlock the power of data! Elevate your expertise with our Mastering Data Analytics Course. Gain proficiency in Python, SQL, Excel, and Power BI for data analysis, visualization, and reporting. Explore hands-on real-world projects and much more.

levelBeginner to Advancecourse duration12 Weeksseats-left2 Seats Left
Certification Exam by:
warning

Limited Seats Batch | Enroll Now to secure your spot
Use Coupon: "390LASTCHANCE" |  Get an instant 30% discount!! 
For further queries reach us via Call/WhatsApp on : +91-
8076609209

Complete Data Analytics Program

three90Course Brochure

Offline Locations

Course Overview

Why You Should Choose This Course:

  • 12-week offline course
  • Doubt Buster Sessions: Weekdays
  • Project Training/Internship Certificate
  • 50+ hours of recorded content and online resources
  • Assignments & contests to track progress
  • 24x7 Doubt Support in addition to in-class support
  • Bonus Certification Questions to see whats on certification exams.
  • 1:1 Career guidance and resume-building tips

Comprehensive Course:

  • Grow from beginner to advanced-level analyst
  • Essential tools and skills:
  • Jupyter Notebook
  • Numpy
  • Pandas
  • Excel
  • SQL
  • Power BI

Key Highlights:

  • 30+ hours of Beginner to Advanced Self-Paced Content
  • Real-Life Projects for practical implementation
  • Industry-Recognized Certificate & Supplementary Articles
  • Learn Industrial Tools: Pandas, Jupyter, Numpy, Excel, SQL, Power BI, etc.
  • Hands-on Practice with Real-World Datasets
  • Career Guidance: Explore roles like Data Analyst, Business Analyst, QA Analyst, Market Research Analyst
  • Get bonus content of Certification Course Questions to understand the types of questions on certification exams

Projects Covered:

  • E-Commerce Product Analysis with Excel & Python
  • Analyzing the Movie Industry with SQL
  • Analysing Food Industry
  • 100K Books Analysis

Complimentary Course Content:

  • Python: Basics to Advanced
  • Excel: Basics to Advanced
  • SQL: Basics to Advanced
  • Power BI: Basics to Advanced
  • Supplementary materials provided for certifications such as Google, AWS, and IBM.

What Sets Us Apart

24 X 7 Doubt Support

Expert Mentors

Course Features
24 X 7 Doubt Support

A dedicated service provided with this course for free to help you overcome any doubt, at any time, and anywhere. So unleash your coding potential with confidence, as our Doubt Support service stands by your side! 

Benefits of this service: 

- Access to Expert TAs
- Prompt Response
- Tailored Guidance
- 1:1 Video & On-Call Support
& Much More

Now code with confidence, triumph over doubts, and level up your skills!

What Sets Us Apart

24 X 7 Doubt Support

A dedicated service provided with this course for free to help you overcome any doubt, at any time, and anywhere. So unlea

Read more...
Expert Mentors

With a passion for teaching, our mentor(s) sessions will provide tailored guidance to all the aspiring coders. Launch a successful tech career with

Read more...
IBM Certification Exams
Add More Value To Your Course
IBM-Certified Exams
Put your skills to the test with exclusive IBM exams.
Global Recognition
Gain recognition from top employers worldwide.
Boost Your Career
Gain a certification that sets you apart from the competition.

Course Content

01Week 1: Excel

Day 1: Introduction to Excel for Data Analysis

  • Overview of Excel interface
  • Basics of navigating and working with sheets
  • Introduction to cells, rows, columns, and ranges
  • Understanding basic functions (SUM, AVERAGE, COUNT)
  • Working with mathematical and statistical functions
  • Introduction to text functions for data manipulation

Day 2: Advanced Formulas and Functions

  • Working with logical functions (IF, AND, OR)
  • Exploring lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
  • Introduction to array formulas
  • Identifying and handling missing data
  • Removing duplicates and dealing with errors
  • Text-to-columns and data-splitting techniques
  • Formatting data for analysis
  • Creating basic charts and graphs
  • Tips for effective data presentation
  • Introduction to PivotTables for dynamic data analysis
  • Creating PivotCharts for visual insights
  • Customizing and formatting PivotTables and PivotCharts
  • Time-saving shortcuts and productivity hacks
  • Excel with AI
02Week 2: SQL

Day 1: Introduction to SQL and Database Fundamentals

  • Overview of SQL and its applications
  • Introduction to Relational Databases
  • Basic SQL syntax and structure
  • Creating and modifying tables with CREATE and ALTER
  • Understanding data types and constraints

Day 2: Retrieving Data with SELECT Statements

  • Basics of SELECT statements
  • Filtering data with WHERE clause
  • Sorting results with ORDER BY
03Week 3: Advanced SQL Techniques

Day 1: Aggregation and Grouping

  • Understanding aggregate functions (SUM, AVG, COUNT)
  • Grouping data with GROUP BY
  • Working with complex WHERE conditions
  • Using operators (AND, OR, NOT, etc)

Day 2: Window Functions and Analytic Queries

  • Introduction to window functions
  • Performing analytic queries with OVER clause
04Week 4: Advanced SQL

Day 1: Joins and Subqueries

  • Performing INNER and OUTER joins
  • Using subqueries for complex queries

Day 2: Case Statements and CTE Queries

  • Understanding and using CASE statements in SQL
  • Applying CASE statements in data analysis scenarios
  • Introduction to Common Table Expressions
  • Using CTEs for recursive queries and data manipulation
Read more

Course Instructor

instructor.png
Ashish Jangra
Mentor @ GeeksforGeeks
Ashish is working as a Data Science Mentor at GeeksForGeeks.He has made India's first Self Driving Cars course with his ETG. He trained 10000+ students on different technologies like AI, Data Science, Computer Vision, and Internet of Things. He is passionate about teaching and giving students the skillset to learn cutting-edge skills.
Demo Video
Associated Batches:
DA Noida Weekend 10
instructor.png
Durgesh Yadav

Senior Data Analyst at 7-11

Durgesh Yadav is a Data Analyst with 2.7 years of experience in handling complex datasets, ranging from 1 million to over 1 billion records, leading to a 20% improvement in data accuracy. Skilled in SQL, Python, Excel, and Power BI, he has optimized algorithms that saved millions and improved real-time data accuracy by 90%. At Target Corporations, Durgesh developed 20+ key metrics and contributed to a 15% increase in data-driven decision-making efficiency through insightful visualizations and reports.

Previously, as a Software Engineer at Coforge Private Limited, he boosted project efficiency by 15% and enhanced decision-making accuracy by 20%. Durgesh’s expertise in data visualization, predictive analytics, and ETL processes, along with his work on academic projects in machine learning and e-commerce analysis, make him an excellent mentor for students aspiring to excel in data analytics.

Demo Video
Associated Batches:
DA BLR Weekdays Batch - 2
instructor.png
Bhagirath Koli

Data Analyst Trainer  at ARC Technologies and Institute

Bhagirath Koli, an experienced Data Analyst Trainer and MSc Data Science student, brings expertise in SQL, Python, Power BI, Tableau, and data visualization. With hands-on experience in real-world projects like voice cloning and stock analysis, Bhagirath excels in simplifying complex concepts and fostering critical thinking. Passionate about mentoring, he offers personalized guidance to help students build practical skills, enabling them to excel in data-driven careers and contribute effectively to business growth.

Demo Video
Associated Batches:
DA Pune Batch 4
instructor.png
Deepak Kumar

Trainer | Data Analyst

Deepak Kumar is a highly skilled data analyst and data science instructor with extensive experience in predictive analytics, machine learning, and artificial intelligence. Currently an Analyst at the Indian School of Business and a Corporate Trainer at IKIGAI Labs, Deepak has previously served as an Assistant Professor at the University of Petroleum and Energy Studies. His projects have spanned a range of applications, from designing interactive chatbots using Google Cloud's Dialog Flow to developing sophisticated predictive models for diverse sectors. A certified Data Analyst, Deepak holds a Master's in Power System Engineering from IIT (ISM) Dhanbad and has contributed to research with several patents and publications.

Demo Video
Associated Batches:
DA Hyderabad Batch 2
instructor.png
Harshvardhan Singhlinked in

Data Analyst | Data Science | Mentor

Harshvardhan Singh is a dedicated Data Science and Data Analysis mentor who has trained 2000+ students. He specializes in foundational and advanced topics like Data Analytics, Machine Learning, Deep Learning, NLP, and LLMs. His teaching covers essential skills such as data wrangling, exploratory data analysis, statistical modeling, and data visualization using tools like Python, SQL, and Excel. Harshvardhan also delves into predictive modeling, feature engineering, and deploying machine learning models to solve real-world problems. Passionate about empowering learners, he ensures students gain hands-on experience in tackling data-driven challenges and mastering cutting-edge technologies.

Demo Video
Associated Batches:
DA Noida WD Batch 9
instructor.png
Bidhan Sen

Senior BI Engineer @ Skillsoft

Bidhan Sen is a seasoned Senior BI Engineer with expertise in data analytics and visualization, specializing in Power BI, Tableau, SQL, and advanced analytics techniques. With over three years of experience in industry giants like Brillio, Amazon, and TCS, he excels in creating impactful BI solutions that drive data-driven decision-making and business growth across diverse sectors.

Demo Video
Associated Batches:
DA Bengaluru Batch 8

Upcoming Batches

Pune
Hyderabad
Noida
Bengaluru
Batch
DA Pune Batch 4
Mentor
Bhagirath Koli
STARTING FROM
Mar 29, 2025
TIMINGS

01:30 AM EST -Sat, Sun

$ 599.98

$ 440

Batch
DA Pune WD Batch 1
STARTING FROM
Apr 02, 2025
TIMINGS

02:30 AM EST -Wed to Fri

$ 599.98

$ 440

map_icon

3rd Floor Sneh Centre, 1182/2 F.C. Road Opp. Hotel Lalit Mahal, Shivaji Nagar Pune, Maharashtra, India - 411 005,
Opp. Hotel Lalit Mahal, Pune, Maharashtra

Get Directions

Batch
DA Hyderabad Batch 2
Mentor
Deepak Kumar
STARTING FROM
Mar 29, 2025
TIMINGS

08:00 AM EST -Sat, Sun

$ 599.98

$ 440

map_icon

Reliance Cyber Ville Plot No 17 to 24 Vittal Rao Nagar, Madhapur, Hyderabad- 5000081,
Reliance Cyber Ville, Hyderabad, Telangana

Get Directions

Batch
DA Noida WD Batch 9
Mentor
Harshvardhan Singh
STARTING FROM
Apr 02, 2025
TIMINGS

01:30 AM EST -Wed to Fri

$ 599.98

$ 440

Batch
DA Noida Weekend 10
Mentor
Ashish Jangra
STARTING FROM
Apr 11, 2025
TIMINGS

11:00 PM EST -Fri, Sat

$ 599.98

$ 440

map_icon

A-143, 6th Floor, Sovereign Corporate Tower, Sector-136, Noida, Uttar Pradesh - 201305,
GFG Headquarters, Noida, Uttar Pradesh

Get Directions

Batch
DA BLR Weekdays Batch - 2
Mentor
Durgesh Yadav
STARTING FROM
Mar 30, 2025
TIMINGS

11:30 PM EST -Tue, Thu, Sun

$ 599.98

$ 440

Batch
DA Bengaluru Batch 8
Mentor
Bidhan Sen
STARTING FROM
Apr 18, 2025
TIMINGS

11:00 PM EST -Fri, Sat

$ 599.98

$ 440

map_icon

315 Work Avenue HSR2, L77, 15th Cross Rd, Sector 6, HSR Layout, 3rd floor, Bengaluru, Karnataka 560102,
315 Work Avenue HSR2, Bengaluru, Karnataka

Get Directions

Reviews and Ratings

Sagar Patle
Sagar Patle
Placed at QualityKiosk Technologies
Before joining, I struggled to make sense of data, but now I can confidently analyze massive datasets, uncover meaningful insights, and make impactful decisions. This journey wasn’t just about learning; it was about discovering my true potential. And the best part? It landed me a dream job at QualityKiosk Technologies! A huge thank you to GeeksforGeeks for being such an incredible part of my success story. This course didn’t just teach me skills; it gave me a future!

Reviews and Ratings

user profile
Laxmi Kumari Sinha
Working with HustleHub as a Research Analyst.
I learned skills such as SQL, Python, advanced Excel, and Power BI, progressing from basics to a level where I could successfully crack interviews. The mentor excelled at simplifying complex topics. Overall, this course helped me launch my analytical career.
user profile
Abison Mathew
Promoted in TCS
This course contributed significantly to my promotion at TCS. The Python portion was exceptionally clear and distinct. Overall, it was a wonderful experience with well-curated, hands-on activities.
user profile
Sagar Patle
Placed at QualityKiosk Technologies
Before joining, I struggled to make sense of data, but now I can confidently analyze massive datasets, uncover meaningful insights, and make impactful decisions. This journey wasn’t just about learning; it was about discovering my true potential. And the best part? It landed me a dream job at QualityKiosk Technologies! A huge thank you to GeeksforGeeks for being such an incredible part of my success story. This course didn’t just teach me skills; it gave me a future!
user profile
Snehal Santosh Kotkar
Placed at Celebal Technologies
This course helped me develop strong skills and build confidence in data analytics. The comprehensive content and practical exercises made it easier to grasp complex concepts and apply them effectively in real-world scenarios.
user profile
Yash Saxena
Placed at LTIMindtree
This was the best course ever on data analytics that I purchased. From the documentation part to the video lectures, all was very good. Though I found the course content slightly basic, I would recommend members of GFG update the course contents to the intermediate level. It would be great. Thanks for taking my views. I was placed at LTIMindtree as a software engineer.
user profile
Potta Lokesh
Interned at Microsoft, Paytm
This course is excellent for beginners, thoroughly covering the fundamentals of Python and introducing essential data analytics concepts. It provides a solid foundation for understanding how to analyze data effectively.
user profile
Yash Saxena
Placed at LTIMindtree
This was the best course ever on data analytics that I purchased. From the documentation part to the video lectures, all was very good. Though I found the course content slightly basic, I would recommend members of GFG update the course contents to the intermediate level. It would be great. Thanks for taking my views. I was placed at LTIMindtree as a software engineer.
user profile
Shiwani Gupta
Placed at Mphasis
This course has significantly enhanced my understanding of Data Analysis. I have acquired specific skills in Excel, SQL, Power bi, Python and statistic. Big thanks to Priya Bhatia .With her guidance and the way she taught , I am able to achieve my goal
user profile
Somshubhra
Placed at Infosys
I have gained a great deal of knowledge from this course, many of which are applicable to current industrial initiatives. I begin working as a developer and then go into data analysis with this training.

Frequently Asked Questions

01

Will I get 90% of my course fee back?

02

Is 90% refund applicable on IBM Certification amount?

03

How will these classes be conducted?

04

Is there any number to contact for query?

05

How does the admission process work for this course?

06

Is there any online course material available with this course?

07

What is the Batch Strength of this course?

08

Do we have doubt support in this program?