This Data Analytics course provides comprehensive training in using various tools and techniques for analyzing data. Learners will gain hands-on experience with Excel, SQL, and powerful data visualization tools such as Tableau and Power BI. By the end of the course, students will be able to analyze complex datasets and provide actionable insights.
Live
Session on our platform
24 Weeks
Fellowship timelines
Mentorship
with experienced managers
Placement
Support for 1 year
CURRICULUM
Week 1 - 3
Advanced Excel for Analytics
Data Analytics
Data Science
Master advanced Excel techniques, Power Query, and VBA to efficiently analyze and manipulate data.
Topics
Advanced formulas (INDEX-MATCH, VLOOKUP, IFs)
Power Query for data cleaning and transformation
PivotTables and PivotCharts for dynamic reporting
VBA scripting for automation and macro development
Week 4 - 6
SQL for Data & Business Analytics
Data Analytics
Data Science
Learn how to query databases and manage large datasets using SQL to extract insights for business analysis.
Topics
Writing complex queries (JOINs, Subqueries)
Data aggregation and window functions
Database schema design and normalization
Real-time case studies using business databases
Week 7 - 9
Data Visualization & BI Tools
Data Analytics
Data Science
Create interactive dashboards and visualizations using Tableau and Power BI to present data insights clearly.
Topics
Interactive dashboards in Power BI
KPI indicators and business metrics tracking
Connecting BI tools to databases and APIs
Week 10-12
Statistical Analysis & Modelling
Data Analytics
Data Science
Understand statistical techniques and probability models to analyze data and build predictive models.
Topics
Descriptive statistics and data distributions
Hypothesis testing and confidence intervals
Regression analysis (linear and logistic)
Time series forecasting and anomaly detection
Week 13-15
Python for Data Science & EDA
Use Python for exploratory data analysis (EDA) and data wrangling with libraries like NumPy, Pandas, and Matplotlib.
Topics
Data manipulation with Pandas and NumPy
Exploratory data analysis techniques
Data visualization using Matplotlib and Seaborn
Handling missing data and outliers
Week 16-18
Machine Learning Models
Build and deploy machine learning models using popular libraries like Scikit-learn, TensorFlow, and Keras.
Topics
Supervised vs unsupervised learning
Building ML pipelines with Scikit-learn
Cross-validation and hyperparameter tuning
Model evaluation metrics (accuracy, precision, recall)
Week 19-20
Deep Learning & AI
Explore deep learning techniques and artificial intelligence concepts, including neural networks and computer vision.
Topics
Fundamentals of neural networks
Building models with TensorFlow and Keras
Image recognition using CNNs
Introduction to reinforcement learning
Week 21-22
NLP & Text Analytics
Learn how to process and analyze textual data using Natural Language Processing (NLP) tools and libraries.
Topics
Sentiment analysis using NLP libraries
Topic modeling with LDA
Building chatbots using NLP tools
Text preprocessing (tokenization, stemming, lemmatization)
Week 23-24
Big Data & Cloud Integration
Handle large datasets and integrate cloud platforms for scalable data processing and analysis using Hadoop and Spark.
Topics
Real-time analytics using cloud-based tools
Working with distributed file systems (HDFS)
Cloud services (AWS, GCP) for data processing
Big Data concepts: Hadoop & Spark fundamentals
Weekly LIVE Masterclasses and QnA Sessions
Get on weekly calls with your mentors for live learning sessions and timely doubt resolution
30+ Hours of Recorded
Content
Your weekly dose of content to give you a 360 degree understanding of foundational UX Design concepts.
Lifetime Access to Community
& Events
Engage with a community of 30,000+ designers to build lifelong connections and find collaborative opportunities and gigs.
Project-Based Learning
Build real-world projects that showcase your skills.
Industry Mentors
Learn from experts actively working in the tech industry.
Flexible Learning
Balance your studies with live sessions and self-paced content.
Placement Support
Resume building to job applications, we guide you every step.
AI integration Learning
Integrate high end AI tools and technology into your learning to 10X your productivity
Your Future Job Title
Data Analyst
Business Intelligence Analyst
Data Visualization Specialist
Data Engineer
Operations Analyst
Data Scientist
Machine Learning Engineer
AI Engineer
Big Data Engineer
Fresher Data Analyst/Scientist Salary
₹4 - ₹8 Lakhs
Average Data Analyst/Scientist Salary
₹8 - ₹17 Lakhs
Experienced Professionals
₹17 - ₹25 Lakhs
Shubham Lal
AI/ML Developer
View Profile
Worked with
Bhagyashree Kulkarni
Data Scientist
View Profile
Worked with
© 2025 All Rights Reserved | Balloon Networks