Data Analytics

1Welcome to the Data Analytics Certificate▸ 2What is Data Analytics▸ 3The Role of a Data Analyst▸ 4How Companies Use Data▸ 5DataDriven Decision Making▸ 6The Data Ecosystem▸ 7Data Analyst Skills▸ 8Module 1 Review▸ 9T Final Module Assessment▸ 10T1 Mid Module Quiz▸

1What is Analytical Thinking▸ 2Five Aspects of Analytical Thinking▸ 3Thinking About Outcomes▸ 4Asking the Right Questions▸ 5DataDriven Decisions in Action▸ 6Working with Spreadsheets Introduction▸ 7Module 2 Review▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1The Data Life Cycle▸ 2The Data Analysis Process▸ 3Data Life Cycle vs Data Analysis Process▸ 4Types of Data▸ 5Data Formats and Collection▸ 6Fairness in Data▸ 7Module 3 Review▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Spreadsheets Your First Analytics Tool▸ 2Basic Spreadsheet Functions▸ 3Introduction to SQL▸ 4Writing Your First SQL Query▸ 5Data Visualization Seeing the Data▸ 6Choosing the Right Tool▸ 7Module 4 Review▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Data Analyst Career Opportunities▸ 2Data Analyst vs Other Data Roles▸ 3Building Your Professional Presence▸ 4Whats Ahead in This Program▸ 5Course 1 Glossary▸ 6Course 1 WrapUp▸ 7T Final Module Assessment▸ 8T1 Mid Module Quiz▸

1ProblemSolving with Data Analytics▸ 2The SMART Questions Framework▸ 3Types of Questions▸ 4Common Question Mistakes▸ 5Questions in Practice▸ 6Module 1 Review▸ 7T Final Module Assessment▸ 8T1 Mid Module Quiz▸

1Understanding DataDriven Decisions▸ 2Quantitative vs Qualitative Data▸ 3Big Data vs Small Data▸ 4Metrics and KPIs▸ 5Dashboards Data at a Glance▸ 6Mathematical Thinking in Data▸ 7Module 2 Review▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Spreadsheet Anatomy▸ 2Entering and Formatting Data▸ 3Essential Formulas and Functions▸ 4Sorting and Filtering Data▸ 5Working with Multiple Sheets▸ 6Pivot Tables Introduction▸ 7Module 3 Review▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Structured Thinking for Clear Communication▸ 2Who Are Your Stakeholders▸ 3Managing Stakeholder Expectations▸ 4Presenting Data Insights▸ 5Effective Meetings and Communication▸ 6Module 4 Review▸ 7T Final Module Assessment▸ 8T1 Mid Module Quiz▸

1What is Data Bias▸ 2Types of Bias in Data▸ 3Data Credibility ROCCC Framework▸ 4Data Ethics▸ 5Ensuring Fair Analysis▸ 6Course 2 Glossary▸ 7Course 2 WrapUp▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Data Types Deep Dive▸ 2Data Formats Wide vs Long▸ 3Data File Formats▸ 4Data Tables and Relationships▸ 5Boolean Logic in Data▸ 6Activity Exploring Different Data Types▸ 7Module 1 Review▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Data Collection Methods▸ 2First Second and ThirdParty Data▸ 3Data Ethics Core Principles▸ 4Data Anonymization▸ 5Open Data and Data Accessibility▸ 6Activity Evaluating Data Sources▸ 7Module 2 Review▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Introduction to Databases▸ 2Relational Databases▸ 3SQL for Data Analysts Review▸ 4What is Metadata▸ 5Metadata in Practice▸ 6Managing Data with Databases▸ 7Module 3 Review▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1File Naming Conventions▸ 2Organizing Data Files and Folders▸ 3Data Security Basics▸ 4Data Integrity▸ 5Data Governance Overview▸ 6Activity Organize a Dataset▸ 7Module 4 Review▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Course 3 Recap▸ 2Course 3 Glossary▸ 3Course 3 WrapUp▸ 4T Final Module Assessment▸ 5T1 Mid Module Quiz▸

1What is Dirty Data▸ 2Data Integrity Threats▸ 3Insufficient Data▸ 4Sample Size and Statistical Power▸ 5Data Constraints▸ 6Testing Data Integrity▸ 7Module 1 Review▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Data Cleaning Workflow▸ 2Finding and Removing Duplicates▸ 3Handling Missing Values▸ 4Fixing Formatting Issues▸ 5Advanced Spreadsheet Cleaning Functions▸ 6Data Validation in Spreadsheets▸ 7Activity Clean a Messy Dataset▸ 8Module 2 Review▸ 9T Final Module Assessment▸ 10T1 Mid Module Quiz▸

1SQL for Data Cleaning Overview▸ 2SELECT DISTINCT Duplicate Detection▸ 3Handling NULL Values▸ 4String Manipulation Functions▸ 5Data Type Conversions▸ 6Date Functions for Cleaning▸ 7CASE Statements for Data Transformation▸ 8Activity SQL Data Cleaning Project▸ 9Module 3 Review▸ 10T Final Module Assessment▸ 11T1 Mid Module Quiz▸

1Verification Is Your Data Really Clean▸ 2Verification Techniques Spreadsheets▸ 3Verification Techniques SQL▸ 4Changelog Documenting Changes▸ 5Data Cleaning Report▸ 6Course 4 Glossary▸ 7Course 4 WrapUp▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Analysis ke liye Data Organize Karna Introduction▸ 2Sorting Data in Spreadsheets▸ 3Filtering Data in Spreadsheets▸ 4Sorting aur Filtering in SQL▸ 5Pivot Tables Introduction aur Setup▸ 6Pivot Tables Advanced Techniques▸ 7Large Datasets ko Efficiently Handle Karna▸ 8Module 1 Review aur Practice Quiz▸ 9T Final Module Assessment▸ 10T1 Mid Module Quiz▸

1Data Formatting ki Importance▸ 2Converting aur Formatting Data Types▸ 3Conditional Formatting▸ 4Data Validation Rules▸ 5Merge aur Split Columns aur Data▸ 6String Manipulation Techniques▸ 7Spreadsheet Functions for Data Transformation▸ 8Module 2 Review aur Practice Quiz▸ 9T Final Module Assessment▸ 10T1 Mid Module Quiz▸

1Data Aggregation kya hai▸ 2SQL Aggregate Functions▸ 3GROUP BY Clause Mastery▸ 4HAVING Clause Grouped Data Filter Karna▸ 5SQL Subqueries Introduction▸ 6Subqueries Advanced Patterns▸ 7Spreadsheet me Aggregation Techniques▸ 8Combining Data from Multiple Sources▸ 9Module 3 Review aur Practice Quiz▸ 10T Final Module Assessment▸ 11T1 Mid Module Quiz▸

1Spreadsheet Calculations Foundation▸ 2VLOOKUP Vertical Lookup Mastery▸ 3HLOOKUP aur Other Lookup Functions▸ 4INDEX aur MATCH Power Combination▸ 5Advanced Spreadsheet Formulas▸ 6SQL Common Table Expressions CTEs▸ 7SQL Temporary Tables aur Views▸ 8Calculations ke liye Best Practices▸ 9Module 4 Review aur Practice Quiz▸ 10T Final Module Assessment▸ 11T1 Mid Module Quiz▸

1Data Validation aur Verification▸ 2CrossChecking Data with Multiple Sources▸ 3Identifying Trends in Data▸ 4Identifying Patterns aur Correlations▸ 5Data Analysis Process Complete Walkthrough▸ 6Analysis Results ko Present Karne ke liye Prepare Karna▸ 7Course WrapUp aur Final Assessment▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Data Visualization kyun Zaroori Hai▸ 2Charts ke Types Kab Kaunsa Use Karna Hai▸ 3Design Principles Color Layout Clarity▸ 4David McCandless ka Effective Visuals Framework▸ 5Misleading Visualizations Kya Avoid Karna Hai▸ 6Accessibility in Data Visualization▸ 7Module 1 Review aur Practice Quiz▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Tableau ka Introduction▸ 2Data Sources Connect Karna▸ 3Bar Charts aur Line Charts▸ 4Scatter Plots Maps aur Advanced Charts▸ 5Calculated Fields aur Table Calculations▸ 6Filters aur Parameters▸ 7Formatting aur Best Practices▸ 8Module 2 Review aur Practice Quiz▸ 9T Final Module Assessment▸ 10T1 Mid Module Quiz▸

1Dashboard Design Principles▸ 2Tableau me Dashboard Create Karna▸ 3Filter Actions aur Interactivity▸ 4DrillDowns aur Navigation▸ 5KPI Cards aur Summary Metrics▸ 6Mobile aur Responsive Dashboards▸ 7Dashboards Share aur Publish Karna▸ 8Module 3 Review aur Practice Quiz▸ 9T Final Module Assessment▸ 10T1 Mid Module Quiz▸

1Data Storytelling kya hai▸ 2Narrative Structure for Data▸ 3Audience ko Samajhna▸ 4Tableau Stories▸ 5Presentation Slides Design Karna▸ 6Presentation Deliver Karna▸ 7Course WrapUp aur Final Assessment▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1R kya hai aur Data Analysis ke liye Kyun▸ 2R aur RStudio Install Karna▸ 3R Console aur Basic Operations▸ 4Variables aur Data Types▸ 5Operators Arithmetic Comparison Logical▸ 6Comments aur Code Organization▸ 7Module 1 Review aur Practice Quiz▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Vectors R ka Fundamental Data Structure▸ 2Lists aur Matrices▸ 3Data Frames Tabular Data in R▸ 4Conditional Statements ifelse▸ 5Loops for aur while▸ 6Functions Likhna▸ 7Packages Install aur Use Karna▸ 8Data Import aur Export▸ 9Module 2 Review aur Practice Quiz▸ 10T Final Module Assessment▸ 11T1 Mid Module Quiz▸

1Tidyverse ka Introduction▸ 2dplyr select aur filter▸ 3dplyr mutate aur arrange▸ 4dplyr summarize aur group by▸ 5tidyr Data Reshape Karna▸ 6Datasets Join Karna▸ 7Missing Data Handle Karna▸ 8Practical Data Wrangling Project▸ 9Module 3 Review aur Practice Quiz▸ 10T Final Module Assessment▸ 11T1 Mid Module Quiz▸

1Grammar of Graphics kya hai▸ 2Pehla ggplot2 Chart▸ 3Bar Charts Histograms aur Boxplots▸ 4Line Charts Area Charts aur Time Series▸ 5Aesthetics Colors Sizes Shapes▸ 6Facets Small Multiples▸ 7Themes aur Labels PublicationQuality Output▸ 8Module 4 Review aur Practice Quiz▸ 9T Final Module Assessment▸ 10T1 Mid Module Quiz▸

1R Markdown kya hai aur Kyun Zaroori Hai▸ 2Pehla R Markdown Document▸ 3Markdown Formatting Text aur Structure▸ 4Code Chunks Options aur Control▸ 5Visualizations aur Tables in R Markdown▸ 6Output Formats HTML PDF Word▸ 7Reproducible Analysis Share Karna▸ 8Course WrapUp aur Final Assessment▸ 9T Final Module Assessment▸ 10T1 Mid Module Quiz▸

1Capstone Project ka Introduction▸ 2Case Study Tracks Choose Your Project▸ 3Business Scenario aur Objectives Samajhna▸ 4Ask Phase Effective Questions Frame Karna▸ 5Analysis Approach ki Planning▸ 6Module 1 Review▸ 7T Final Module Assessment▸ 8T1 Mid Module Quiz▸

1Datasets Collect aur Import Karna▸ 2Data Exploration Initial Assessment▸ 3Data Cleaning Practical Application▸ 4Data Transformation aur Feature Engineering▸ 5Data Organization aur Documentation▸ 6Module 2 Review▸ 7T Final Module Assessment▸ 8T1 Mid Module Quiz▸

1Exploratory Data Analysis EDA▸ 2Spreadsheet Analysis▸ 3SQL Analysis▸ 4R Analysis▸ 5Patterns Trends aur Key Findings▸ 6Analysis Validation aur CrossChecking▸ 7Module 3 Review▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸

1Visualizations Create Karna Case Study ke liye▸ 2Dashboard Build Karna▸ 3Case Study Report Likhna▸ 4Presentation Build Karna▸ 5Data Storytelling Compelling Narrative▸ 6Module 4 Review▸ 7T Final Module Assessment▸ 8T1 Mid Module Quiz▸

1Analytics Portfolio Kya aur Kyun▸ 2Portfolio Pieces Compile Karna▸ 3GitHub Profile Setup▸ 4Resume aur LinkedIn Optimization▸ 5Interview Preparation Technical Questions▸ 6Interview Preparation Behavioral aur Case Study Questions▸ 7Certificate Complete Next Steps▸ 8T Final Module Assessment▸ 9T1 Mid Module Quiz▸