Data Analytics

8 Courses | 274 Lessons
🔍
📖 C1 Foundations Data Everywhere 5 Modules | 35 Lessons
▶ M1 Introducing Data Analytics 8
1L1 Welcome to the Data Analytics Certificate→ 2L2 What is Data Analytics→ 3L3 The Role of a Data Analyst→ 4L4 How Companies Use Data→ 5L5 DataDriven Decision Making→ 6L6 The Data Ecosystem→ 7L7 Data Analyst Skills→ 8L8 Module 1 Review→
▶ M2 Thinking Analytically 7
1L1 What is Analytical Thinking→ 2L2 Five Aspects of Analytical Thinking→ 3L3 Thinking About Outcomes→ 4L4 Asking the Right Questions→ 5L5 DataDriven Decisions in Action→ 6L6 Working with Spreadsheets Introduction→ 7L7 Module 2 Review→
▶ M3 The Wonderful World of Data 7
1L1 The Data Life Cycle→ 2L2 The Data Analysis Process→ 3L3 Data Life Cycle vs Data Analysis Process→ 4L4 Types of Data→ 5L5 Data Formats and Collection→ 6L6 Fairness in Data→ 7L7 Module 3 Review→
▶ M4 Setting Up Your Data Toolbox 7
1L1 Spreadsheets Your First Analytics Tool→ 2L2 Basic Spreadsheet Functions→ 3L3 Introduction to SQL→ 4L4 Writing Your First SQL Query→ 5L5 Data Visualization Seeing the Data→ 6L6 Choosing the Right Tool→ 7L7 Module 4 Review→
▶ M5 Data Career Possibilities 6
1L1 Data Analyst Career Opportunities→ 2L2 Data Analyst vs Other Data Roles→ 3L3 Building Your Professional Presence→ 4L4 Whats Ahead in This Program→ 5L5 Course 1 Glossary→ 6L6 Course 1 WrapUp→
📖 C2 Ask Questions 5 Modules | 33 Lessons
▶ M1 Effective Questions 6
1L1 ProblemSolving with Data Analytics→ 2L2 The SMART Questions Framework→ 3L3 Types of Questions→ 4L4 Common Question Mistakes→ 5L5 Questions in Practice→ 6L6 Module 1 Review→
▶ M2 Data Driven Decision Making 7
1L1 Understanding DataDriven Decisions→ 2L2 Quantitative vs Qualitative Data→ 3L3 Big Data vs Small Data→ 4L4 Metrics and KPIs→ 5L5 Dashboards Data at a Glance→ 6L6 Mathematical Thinking in Data→ 7L7 Module 2 Review→
▶ M3 Spreadsheet Basics 7
1L1 Spreadsheet Anatomy→ 2L2 Entering and Formatting Data→ 3L3 Essential Formulas and Functions→ 4L4 Sorting and Filtering Data→ 5L5 Working with Multiple Sheets→ 6L6 Pivot Tables Introduction→ 7L7 Module 3 Review→
▶ M4 Stakeholder Communication 6
1L1 Structured Thinking for Clear Communication→ 2L2 Who Are Your Stakeholders→ 3L3 Managing Stakeholder Expectations→ 4L4 Presenting Data Insights→ 5L5 Effective Meetings and Communication→ 6L6 Module 4 Review→
▶ M5 Bias and Data Credibility 7
1L1 What is Data Bias→ 2L2 Types of Bias in Data→ 3L3 Data Credibility ROCCC Framework→ 4L4 Data Ethics→ 5L5 Ensuring Fair Analysis→ 6L6 Course 2 Glossary→ 7L7 Course 2 WrapUp→
📖 C3 Prepare Data 5 Modules | 31 Lessons
▶ M1 Data Types and Structures 7
1L1 Data Types Deep Dive→ 2L2 Data Formats Wide vs Long→ 3L3 Data File Formats→ 4L4 Data Tables and Relationships→ 5L5 Boolean Logic in Data→ 6L6 Activity Exploring Different Data Types→ 7L7 Module 1 Review→
▶ M2 Data Collection and Ethics 7
1L1 Data Collection Methods→ 2L2 First Second and ThirdParty Data→ 3L3 Data Ethics Core Principles→ 4L4 Data Anonymization→ 5L5 Open Data and Data Accessibility→ 6L6 Activity Evaluating Data Sources→ 7L7 Module 2 Review→
▶ M3 Databases and Metadata 7
1L1 Introduction to Databases→ 2L2 Relational Databases→ 3L3 SQL for Data Analysts Review→ 4L4 What is Metadata→ 5L5 Metadata in Practice→ 6L6 Managing Data with Databases→ 7L7 Module 3 Review→
▶ M4 Organize and Protect Data 7
1L1 File Naming Conventions→ 2L2 Organizing Data Files and Folders→ 3L3 Data Security Basics→ 4L4 Data Integrity→ 5L5 Data Governance Overview→ 6L6 Activity Organize a Dataset→ 7L7 Module 4 Review→
▶ M5 Course Wrap Up 3
1L1 Course 3 Recap→ 2L2 Course 3 Glossary→ 3L3 Course 3 WrapUp→
📖 C4 Process Data 4 Modules | 31 Lessons
▶ M1 Data Integrity 7
1L1 What is Dirty Data→ 2L2 Data Integrity Threats→ 3L3 Insufficient Data→ 4L4 Sample Size and Statistical Power→ 5L5 Data Constraints→ 6L6 Testing Data Integrity→ 7L7 Module 1 Review→
▶ M2 Data Cleaning Spreadsheets 8
1L1 Data Cleaning Workflow→ 2L2 Finding and Removing Duplicates→ 3L3 Handling Missing Values→ 4L4 Fixing Formatting Issues→ 5L5 Advanced Spreadsheet Cleaning Functions→ 6L6 Data Validation in Spreadsheets→ 7L7 Activity Clean a Messy Dataset→ 8L8 Module 2 Review→
▶ M3 Data Cleaning SQL 9
1L1 SQL for Data Cleaning Overview→ 2L2 SELECT DISTINCT Duplicate Detection→ 3L3 Handling NULL Values→ 4L4 String Manipulation Functions→ 5L5 Data Type Conversions→ 6L6 Date Functions for Cleaning→ 7L7 CASE Statements for Data Transformation→ 8L8 Activity SQL Data Cleaning Project→ 9L9 Module 3 Review→
▶ M4 Verify and Document 7
1L1 Verification Is Your Data Really Clean→ 2L2 Verification Techniques Spreadsheets→ 3L3 Verification Techniques SQL→ 4L4 Changelog Documenting Changes→ 5L5 Data Cleaning Report→ 6L6 Course 4 Glossary→ 7L7 Course 4 WrapUp→
📖 C5 Analyze Data 5 Modules | 41 Lessons
▶ M1 Organize Data for Analysis 8
1L1 Analysis ke liye Data Organize Karna Introduction→ 2L2 Sorting Data in Spreadsheets→ 3L3 Filtering Data in Spreadsheets→ 4L4 Sorting aur Filtering in SQL→ 5L5 Pivot Tables Introduction aur Setup→ 6L6 Pivot Tables Advanced Techniques→ 7L7 Large Datasets ko Efficiently Handle Karna→ 8L8 Module 1 Review aur Practice Quiz→
▶ M2 Format and Adjust Data 8
1L1 Data Formatting ki Importance→ 2L2 Converting aur Formatting Data Types→ 3L3 Conditional Formatting→ 4L4 Data Validation Rules→ 5L5 Merge aur Split Columns aur Data→ 6L6 String Manipulation Techniques→ 7L7 Spreadsheet Functions for Data Transformation→ 8L8 Module 2 Review aur Practice Quiz→
▶ M3 Data Aggregation 9
1L1 Data Aggregation kya hai→ 2L2 SQL Aggregate Functions→ 3L3 GROUP BY Clause Mastery→ 4L4 HAVING Clause Grouped Data Filter Karna→ 5L5 SQL Subqueries Introduction→ 6L6 Subqueries Advanced Patterns→ 7L7 Spreadsheet me Aggregation Techniques→ 8L8 Combining Data from Multiple Sources→ 9L9 Module 3 Review aur Practice Quiz→
▶ M4 Perform Calculations 9
1L1 Spreadsheet Calculations Foundation→ 2L2 VLOOKUP Vertical Lookup Mastery→ 3L3 HLOOKUP aur Other Lookup Functions→ 4L4 INDEX aur MATCH Power Combination→ 5L5 Advanced Spreadsheet Formulas→ 6L6 SQL Common Table Expressions CTEs→ 7L7 SQL Temporary Tables aur Views→ 8L8 Calculations ke liye Best Practices→ 9L9 Module 4 Review aur Practice Quiz→
▶ M5 Data Analysis Techniques 7
1L1 Data Validation aur Verification→ 2L2 CrossChecking Data with Multiple Sources→ 3L3 Identifying Trends in Data→ 4L4 Identifying Patterns aur Correlations→ 5L5 Data Analysis Process Complete Walkthrough→ 6L6 Analysis Results ko Present Karne ke liye Prepare Karna→ 7L7 Course WrapUp aur Final Assessment→
📖 C6 Share Data Visualization 4 Modules | 30 Lessons
▶ M1 Data Visualization Principles 7
1L1 Data Visualization kyun Zaroori Hai→ 2L2 Charts ke Types Kab Kaunsa Use Karna Hai→ 3L3 Design Principles Color Layout Clarity→ 4L4 David McCandless ka Effective Visuals Framework→ 5L5 Misleading Visualizations Kya Avoid Karna Hai→ 6L6 Accessibility in Data Visualization→ 7L7 Module 1 Review aur Practice Quiz→
▶ M2 Tableau Visualizations 8
1L1 Tableau ka Introduction→ 2L2 Data Sources Connect Karna→ 3L3 Bar Charts aur Line Charts→ 4L4 Scatter Plots Maps aur Advanced Charts→ 5L5 Calculated Fields aur Table Calculations→ 6L6 Filters aur Parameters→ 7L7 Formatting aur Best Practices→ 8L8 Module 2 Review aur Practice Quiz→
▶ M3 Build Dashboards 8
1L1 Dashboard Design Principles→ 2L2 Tableau me Dashboard Create Karna→ 3L3 Filter Actions aur Interactivity→ 4L4 DrillDowns aur Navigation→ 5L5 KPI Cards aur Summary Metrics→ 6L6 Mobile aur Responsive Dashboards→ 7L7 Dashboards Share aur Publish Karna→ 8L8 Module 3 Review aur Practice Quiz→
▶ M4 Data Storytelling Presentations 7
1L1 Data Storytelling kya hai→ 2L2 Narrative Structure for Data→ 3L3 Audience ko Samajhna→ 4L4 Tableau Stories→ 5L5 Presentation Slides Design Karna→ 6L6 Presentation Deliver Karna→ 7L7 Course WrapUp aur Final Assessment→
📖 C7 Data Analysis with R 5 Modules | 41 Lessons
▶ M1 Introduction to R 7
1L1 R kya hai aur Data Analysis ke liye Kyun→ 2L2 R aur RStudio Install Karna→ 3L3 R Console aur Basic Operations→ 4L4 Variables aur Data Types→ 5L5 Operators Arithmetic Comparison Logical→ 6L6 Comments aur Code Organization→ 7L7 Module 1 Review aur Practice Quiz→
▶ M2 Programming in R 9
1L1 Vectors R ka Fundamental Data Structure→ 2L2 Lists aur Matrices→ 3L3 Data Frames Tabular Data in R→ 4L4 Conditional Statements ifelse→ 5L5 Loops for aur while→ 6L6 Functions Likhna→ 7L7 Packages Install aur Use Karna→ 8L8 Data Import aur Export→ 9L9 Module 2 Review aur Practice Quiz→
▶ M3 Working with Data in R 9
1L1 Tidyverse ka Introduction→ 2L2 dplyr select aur filter→ 3L3 dplyr mutate aur arrange→ 4L4 dplyr summarize aur group by→ 5L5 tidyr Data Reshape Karna→ 6L6 Datasets Join Karna→ 7L7 Missing Data Handle Karna→ 8L8 Practical Data Wrangling Project→ 9L9 Module 3 Review aur Practice Quiz→
▶ M4 Data Visualization ggplot2 8
1L1 Grammar of Graphics kya hai→ 2L2 Pehla ggplot2 Chart→ 3L3 Bar Charts Histograms aur Boxplots→ 4L4 Line Charts Area Charts aur Time Series→ 5L5 Aesthetics Colors Sizes Shapes→ 6L6 Facets Small Multiples→ 7L7 Themes aur Labels PublicationQuality Output→ 8L8 Module 4 Review aur Practice Quiz→
▶ M5 R Markdown 8
1L1 R Markdown kya hai aur Kyun Zaroori Hai→ 2L2 Pehla R Markdown Document→ 3L3 Markdown Formatting Text aur Structure→ 4L4 Code Chunks Options aur Control→ 5L5 Visualizations aur Tables in R Markdown→ 6L6 Output Formats HTML PDF Word→ 7L7 Reproducible Analysis Share Karna→ 8L8 Course WrapUp aur Final Assessment→
📖 C8 Data Analytics Capstone 5 Modules | 32 Lessons
▶ M1 Capstone Project Overview 6
1L1 Capstone Project ka Introduction→ 2L2 Case Study Tracks Choose Your Project→ 3L3 Business Scenario aur Objectives Samajhna→ 4L4 Ask Phase Effective Questions Frame Karna→ 5L5 Analysis Approach ki Planning→ 6L6 Module 1 Review→
▶ M2 Data Preparation Processing 6
1L1 Datasets Collect aur Import Karna→ 2L2 Data Exploration Initial Assessment→ 3L3 Data Cleaning Practical Application→ 4L4 Data Transformation aur Feature Engineering→ 5L5 Data Organization aur Documentation→ 6L6 Module 2 Review→
▶ M3 Analysis and Insights 7
1L1 Exploratory Data Analysis EDA→ 2L2 Spreadsheet Analysis→ 3L3 SQL Analysis→ 4L4 R Analysis→ 5L5 Patterns Trends aur Key Findings→ 6L6 Analysis Validation aur CrossChecking→ 7L7 Module 3 Review→
▶ M4 Share Results 6
1L1 Visualizations Create Karna Case Study ke liye→ 2L2 Dashboard Build Karna→ 3L3 Case Study Report Likhna→ 4L4 Presentation Build Karna→ 5L5 Data Storytelling Compelling Narrative→ 6L6 Module 4 Review→
▶ M5 Portfolio Career Prep 7
1L1 Analytics Portfolio Kya aur Kyun→ 2L2 Portfolio Pieces Compile Karna→ 3L3 GitHub Profile Setup→ 4L4 Resume aur LinkedIn Optimization→ 5L5 Interview Preparation Technical Questions→ 6L6 Interview Preparation Behavioral aur Case Study Questions→ 7L7 Certificate Complete Next Steps→