Data Analytics

Teacher

Ms.Indira Kumar

What Will I Learn?

Python
Statistics and EDA
SQL
Power BI
Tableau
Advanced Excel
Basics Of Data Analytics In Cloud
2 Capstone Project
1 Live Project
Value Added Sessions
Resume Preparation
Mock Interviews

Requirements

64-bit PC with 8GB/16GB RAM capable of processing 500MB data (recommended).
Or a Mac capable of capable of processing 500MB data (must support Metal).
About 25GB of free disc space.

Description

🚀 Break Into Data Analytics – No Coding Experience Needed!

Data is the new currency of the digital world, and businesses are desperate for skilled data analysts who can turn raw data into meaningful insights. The best part is that You don’t need to be a programmer or have a technical background to learn Data Analytics! Our course is specially designed for absolute beginners and non-tech professionals who want to master data-driven decision-making without any prior experience in coding, statistics, or complex tools.

Why This Course?

✅ No Technical Background Required – We start with the absolute basics, ensuring you understand every concept without any prior knowledge of coding or statistics.

✅ Hands-On Learning – Learn by doing! Work on real-world projects, gain practical experience, and build a portfolio to showcase your skills.

✅ Simplified Learning Approach – Complex topics are broken down into simple, easy-to-understand explanations so that anyone can grasp them.

✅ Comprehensive Curriculum – From understanding data analysis and visualization to implementing AI-driven solutions, we cover everything you need to become job-ready.

✅ Learn at Your Own Pace – The course includes high-quality, professionally recorded lessons with handwritten subtitles so you can pause, rewind, and learn at your convenience.

✅ Exclusive Community Support – Join a thriving community of like-minded learners, engage in discussions, and get guidance from instructors and fellow students.

What will you learn?

📊 Introduction to Data Analytics – What is Data Analytics, and why is it the most in-demand skill today?

📈 Data Visualization & Storytelling – Learn how to use charts, graphs, and dashboards to make data-driven decisions.

📉 Business Intelligence & Insights – Discover how companies use data to grow, optimize, and improve operations.

🤖 Introduction to AI & Machine Learning – Understand AI concepts, how machines learn, and how AI is used in everyday applications.

🔍 Excel, SQL & Power BI – Master industry-standard tools used for data cleaning, analysis, and reporting – all without coding!

📑 Google Sheets & Tableau – Learn how to create interactive dashboards and reports with drag-and-drop simplicity.

📌 Predictive Analytics (No Coding Required!) – Learn how businesses forecast trends, identify risks, and make strategic decisions using AI-powered tools.

🚀 Career & Business Opportunities in Data Analytics – Understand how Data Analytics can supercharge your career or business, whether you're in marketing, finance, healthcare, sales, or any industry.

Who Is This Course For?

🔹 Complete Beginners – If you have ZERO experience in analytics or coding, this course is perfect for you!

🔹 Business Professionals & Managers – Learn to interpret and analyze data to make smarter decisions.

🔹 Entrepreneurs & Small Business Owners – Use data insights to increase profits, optimize strategies, and grow your business.

🔹 Finance & Marketing Professionals – Leverage data analytics to track performance, improve campaigns, and maximize ROI.

🔹 Anyone Curious About Data Analytics – If you're excited about making sense of data, this is your perfect entry point.

Get Started Today!

Data is everywhere, and companies need data-literate professionals NOW more than ever. Don’t let technical fear hold you back! Join thousands of learners who have taken their first step into the world of Data Analytics without any prior experience.

📌 Enroll now and take charge of your future with Data Analytics!

Curriculum For This Course

113 Lectures

157+ Hours

Python 12 Lectures 32:01:29

Introduction to Python and Its Advantages01:01:39
Introduction To IDEs00:21:43
Variable And Its Rules02:07:48
Operators02:01:39
Data Types05:23:00
Functions And Parameters03:09:40
Exception Handling and File Handling03:00:03
Regular Expressions03:00:03
Pandas03:00:03
Numpy03:00:03
Matplotlib03:00:03
Seaborn03:00:03
os03:00:03

Statistics - EDA 12 Lectures 27:26:45

Introduction To Statistics00:10:39
Data Collection, Data Preparation and Inference01:01:43
Sampling, Types Of Sampling and Varinace in Sample02:07:48
Data Types02:01:39
Descriptive Statistics03:45:12
Data Distributions03:09:40
Probability Theory02:00:03
Central Limit Theorem01:00:03
Confidence Interval03:00:03
Hypothesis Testing02:00:03
Correlation and Covariance02:00:03
Data Preparation06:00:03
Mini Project10:00:03

SQL 12 Lectures 42:18:36

Instroduction to DataBase01:01:39
Understanding The Architecture of the DataBase02:01:43
Data Types In SQL02:07:48
Command Types in SQL06:01:39
Operators in SQL03:12:00
Constraints in SQL06:09:40
Joins05:00:03
Sub Queries04:00:03
Index, Views and Union02:00:03
Common Table Expression04:00:03
Window Functions03:00:03
Triggers04:00:03

Power BI 11 Lectures 30:01:12

Get Or Connect To Data02:00:13
Profile and Clean The Data03:01:43
Transform and Load The Data03:07:48
Design And Implement The Data Model01:01:39
Create Model Calculation Using Data Model02:23:12
DAX06:09:14
Optimize Model Performance02:09:40
Enhance Reports For Usability And Story Telling03:00:03
Identify Patterns And Trends03:00:03
Create And Manage WorkSpaces and Assets03:20:03
Secure and Govern Power BI Items03:00:03

Tableau 20 Lectures 08:21:29

Discover the Tableau Platform00:05:23
Learn Application Terminology00:45:39
Identify Visual Cues for Field00:08:43
Understand the Tableau Workflow00:40:39
Recognize Elements of a Visualization00:43:00
Get Started in Tableau00:09:40
Setup Identify Tableau File Types and Extensions00:20:03
Create a Live Data Connection00:50:03
Save and Edit a Data Source00:20:03
Modify Data Attributes00:20:03
Understand Changes to Data00:30:03
Filter Data00:20:03
Create Date Filters00:20:03
Sort Data00:15:03
Use Groups & Create and Use Hierarchies00:20:03
Create and Use Hierarchies00:20:03
Generate Grand Totals, Subtotals, and Changing Aggregation00:20:03
Build Highlight Tables00:20:03
Work with Dates in Tableau00:10:03
Use Discrete Date Parts and Continuous Date Values00:10:03
Measure Values and Names00:20:03
Combine or Share Axis Charts00:25:03
Show Correlations and Outliers with Scatter Plots 00:15:03
Create a Scatter Plot Analyze Using the Highlighter00:10:03
Analyze an Outlier with the Data Guide00:15:03
Use the Analytics Pane00:15:03
Build Trend Lines and Models Reference Lines and Bands00:15:03
Map in Tableau00:15:03
Navigate and Select in Maps00:10:03
Calculate in Tableau00:15:03
Choose Between Calculation Types00:20:03
Create and Edit Calculated Fields00:15:03
Follow Formula Editor Conventions00:22:03
Identify Types of Calculated Fields00:20:03
Conduct Calculations and Aggregations00:15:03
Use String Functions00:10:03
Build Splits and Custom Splits00:22:03
Convert Types00:20:03
Calculate Dates00:22:03
Discover Table Calculations00:15:03
Use Quick Table Calculations00:20:03
Harness Rank To Show Biggest to Smallest00:10:03
Generate Pie Charts and Parts of the Whole00:22:03
Create Tree Maps00:22:03
Build Dashboards00:20:03
Demonstrate Relations Between Dashboards and Worksheets00:10:03
Generate Tiled or Floating Objects00:22:03
Format Components00:20:03
Change Dashboard Device Layouts 00:15:03
Conduct Dashboard Actions00:22:03
Publish Your Dashboard Online00:20:03

Advanced Excel 20 Lectures 22:01:29

Introduction to Spreadsheet Software01:05:00
Basic Functions03:01:43
Data Management 00:47:48
Review Tools00:50:00
View Options & Developer Tools01:05:00
Basic Formulas03:00:00
Referencing Techniques00:25:00
PivotTables02:30:00
Logical Functions02:05:00
Statistical Functions03:30:00
Advanced PivotTable Techniques03:30:00
Advanced Logical Functions00:35:00
Chart Data Manipulation00:50:00
Date and Time Functions03:30:00
Text Functions00:30:00
Data Validation02:05:00
Advanced Filters02:30:00
Advanced Sorting01:05:00
Hyperlinking and Data Linking01:30:00
Query Editor in Excel01:30:00
Connecting With Local Database00:35:00
Connecting With Cloud Database00:30:00

Value Added Sessions 13 Lectures 25:01:15

PySpark06:00:03
Databricks04:00:03
AWS04:00:03
Azure04:00:03
Incorporation Of AI in Data Analytics Tools03:00:03
Basics Of Machine Learning06:00:03
OpenAI API For Data Analytics03:00:03

Instructors

4.7 .7 Average rating
25,182 Reviews
11,085 Students
2 Courses

(4 votes)

Certificate Program In Data Analytics

Teacher: Mr. IndiraKumar Anbu

Hi! I'm Indira Kumar, a passionate Data Scientist with four years of experience in AI, machine learning, and data-driven solutions. Over the years, I've worked on complex AI models, optimized data pipelines, and developed cutting-edge applications that drive real business impact. Now, I'm embarking on a new journey—building an institution that leverages the power of AI to transform industries. Our mission is to help businesses harness the true potential of data, from predictive analytics to intelligent automation. Having worked with diverse datasets and industries, I’ve gained deep expertise in developing scalable AI solutions, from computer vision models to NLP-based applications. I believe in making AI accessible, efficient, and impactful. Through my work, I’ve mentored aspiring data scientists, collaborated with industry leaders, and built AI solutions that redefine possibilities. My goal with this new venture is to empower businesses and individuals with the best AI-driven insights and solutions.

share