Data Analytics Job Ready Program

Overview of Data Analytics: What, Why, and How? | Understanding the Data Analytics Workflow | Real-World Applications and Job Opportunities

Introduction to Data Analytics Tools and Technologies | Data Collection, Cleaning, and Preparation Basics | Introduction to Basic Data Visualization

Excel Fundamentals: Interface, Formulas, and Functions | Data Entry, Sorting, Filtering, and Basic Calculations | Using Excel Tables for Structured Data Analysis

Data Cleaning and Preparation Techniques in Excel | Introduction to Pivot Tables and Basic Data Visualization | Essential Keyboard Shortcuts and Productivity Tips

Advanced Formulas and Functions (LOOKUPs, IF, AND, OR) | Using Named Ranges, Data Validation, and Conditional Formatting | Creating Interactive Dashboards with Slicers

Advanced Pivot Tables and Power Query for Data Manipulation | Data Analysis ToolPak and Statistical Analysis in Excel | Introduction to Macros for Automation

Introduction to SQL: Understanding Databases, Tables, and Relationships | Basic SQL Commands: SELECT, INSERT, UPDATE, DELETE | Filtering, Sorting, and Retrieving Data from Multiple Tables

Using Aggregate Functions (SUM, COUNT, AVG) and Grouping Data | Joining Tables (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN) | Writing Subqueries and Nested Queries for Complex Analysis

Assignment 1