Join this 16 weeks, Job-ready Program to master Data Analytics from scratch with Top Data Analysts from Microsoft, KPMG, Amazon, and Rapido.
11rs LPA
Average CTC
34000+
Jobs on LinkedIn Alone
7+
Industry Mentors
3,785 already upskilled!
Early Bird Offer
40% off for First 50 Seats
Total Program Fee:
89,000 rs
50,000 rs
-40% off
By continuing, you agree to WsCube Tech’s Privacy Policy and Terms & Conditions. Please note that the Cohort Fee can be paid via custom payment link offered by Program Advisor at the point of enrollment only and we don’t offer any public link for payments.
Kickstart your Data Analytics journey with Excel! From pivot tables to essential functions and from charts to dashboards learn every essential to become a Data Analyst. Excel isn't just a tool, it's your new superpower!
Week 1
Overview Of Excel
Introduction to Data Analytics
Basic Feature in Excel
Formatting in Excel
Dealing with Raw Data
Functions in Excel
Week 2
Deep Dive with Excel II
Data Connectors in Excel
Cleaning in Power Query Collector
Adding Conditional Column using Power Query Collector
Data modelling and its importance
Cardinality and filter Direction
Week 3
Master Advance Excel III
Pivot Table in Excel
Chart in Excel
Slicers in Excel
Measures in Excel
Creating a Dashboard in Excel
Project
Create an interactive Excel dashboard that summarizes the monthly performance of a retail store, using pivot tables, charts, and Power Query.
Excel Jam Session
In this session, you'll master Excel for data analytics interviews. Learn insider tips on using Excel effectively, tackling real world scenarios, and impressing interviewers with your data manipulation skills.
Milestone 2- Duration 3 Weeks
Programming with SQL
Live Session
Project
Cheat Sheet
Quizes
Want to retrieve, clean, manipulate and analyse the data?? Do it efficiently by using SQL queries!! This milestone covers everything from basic queries to complex joins, empowering you to extract valuable insights from large datasets with ease.
Week 4
Welcome to MySQL
Introduction to MySQL
Basic MySQL Syntax
Clauses in MySQL
Operators in MySQL
Dealing With Null Values in MySQL
Week 2
Advanced SQL Queries and Functions in MySQL
Functions in MySQL
Case Operator in MySQL
Group By in MySQL
Having Clause in MySQL
Joins in MySQL
Week 3
Advanced SQL Concepts and Techniques in MySQL
Subqueries in MySQL
Union, Intersect, Except in MySQL
Stored Procedures in MySQL
Common Table Expressions(CTE)
Window Functions in MySQL
Project
You're working as a data analyst at a retail company that operates both online and offline. The company wants you to extract meaningful insights from their sales and customer databases to improve business decisions. Your task is to use MySQL to analyze data and answer key business questions.
SQL Jam Session
SQL is the backbone of data analysis. Get ready to deep dive into complex queries, optimize your understanding of database management, and leave with pro tips to stand out in SQL-based interview questions.
Milestone 3- Duration 3 Weeks
Data Visualization Power BI
Live Session
Project
Cheat Sheet
Quizes
Empower your data journey with Python! Learn Pandas, NumPy, and Matplotlib to wield the tools of data magic. Uncover insights, visualize trends, and conquer complex datasets with flair!
Week 7
Data Visualisation with Power BI
Introduction to Power BI
Data Connectors
Power Query Editor and Tools Power Query Editor
Append Queries and Merge Queries
Pivoting and Unpivoting of data
Week 8
Advanced-Data Modeling and DAX in Power BI
Data Modelling and Cardinality
Cross Filter Direction
Measures vs Calculated Columns
Functions in DAX
Cumulative Sales and Moving Average Using DAX
Week 9
Visualizations and Dashboard Creation in Power BI
ChatGPT for Measures
Column Charts and Slicers
Matrix vs Tables
Cards, KPI and Gauge Chart
Formatting a Dashboard
Project
Create a Sales and Marketing Dashboard using Power BI to track product sales, marketing campaigns, customer behavior, and overall performance. Visualize key metrics like sales trends, customer acquisition, and marketing effectiveness.
Power BI Jam Session
Visual storytelling is crucial for any data analyst. In this jam session, discover how to leverage Power BI to create impactful reports, turn data into insights, and gain a competitive edge in interviews.
Milestone 4- Duration 4 Weeks
Python & Libraries
Live Session
Project
Cheat Sheet
Quizes
Master Python for Data Analytics! From data manipulation with Pandas to visualization with Matplotlib & Seaborn, and numerical computing with NumPy, this milestone will equip you with
essential coding skills to alyze, transform, and visualize data efficiently.
Week 10
Python Basics
Introduction to Python for Data Analytics
Datatypes and Variables
Operators in Python
Control Flow in Python
Data Structures in Python
Week 11
Python Advance
Functions in Python
In built Modules
Pickle Library
Introduction to Numpy
Statistical Functions in Array
Week 12
Python Libraries - Pandas, Matplotlib and Seaborn
Introduction to Pandas
Cleaning Data with Pandas
Merge, concatenate and join Pandas
Introduction to Matplotlib
Charts in Matplotlib
Week 13
Python Libraries - Web scraping and Text Analysis
What is WebScraping
BeautifulSoup and Requests Library in Pythonn
Extracting Data from Tables
Extracting Data from Multi Page Websites
Text Analysis using Python
Project
Analyze and visualize customer purchase behavior using Python and its powerful libraries — NumPy, Pandas, Matplotlib, Seaborn, and perform web scraping and text analysis on customer reviews.
Python Jam Session
Elevate your understanding of statistics and Python for data analysis interviews. From hypothesis testing to coding challenges, this session will prepare you to demonstrate your statistical and programming expertise.
Milestone 5- Duration 3 Weeks
States & Machine Learning
Live Session
Project
Cheat Sheet
Quizes
Build a strong foundation in Statistics & Machine Learning! Learn probability, hypothesis testing, and inferential statistics, then advance to regression, classification, clustering,
and AI-driven insights. Gain hands on experience applying ML algorithms to real world datasets and making data driven decisions!
Week 14
Maths & Applied Statistics
Introduction to Statistics
Descriptive Statistics
Hypothesis Testing
AB Testing
Fundamentals of Probability
Week 15
Machine Learning - I
What is ML?
Applications of Machine Learning
Linear Regression
Decision Trees
Random Forests and Ensemble Methods
Week 16
Machine Learning - II & AI
Clustering algorithms
K means clustering
Dimensionality Reduction
Cross validation
Evaluation metrics and ROC curves
AI for data analytics
Project
Use statistics and machine learning techniques to identify customers who are likely to churn and gain insights that help reduce churn rate.
ML & AI Jam Session
Ready to dive into the future of data analytics? In this jam session, you'll explore machine learning and AI applications, and gain tips on how to shine in interviews by showcasing your ability to implement these cutting-edge technologies.
Tools You Will Master
Be in the spotlight by getting certified!
A detailed overview of the course, including key topics, objectives, and module sequence.
