Master Excel for Data Tasks

• Clean & organize data (remove duplicates, fix inconsistencies, handle missing values)
• Use essential functions (SUM, AVERAGE, COUNTIF, VLOOKUP, INDEX MATCH)
• Analyze large datasets with PivotTables & advanced filtering
• Create professional charts & dashboards for data storytelling

Hands-On Practice

• Import/export data from CSV, TXT files
• Apply logical functions (IF, AND, OR) for decision-making
• Build a mini-project to solidify skills

Query & Manage Databases

• Write SQL queries (SELECT, WHERE, ORDER BY, GROUP BY)
• Use aggregate functions (SUM, AVG, COUNT) to summarize data
• Combine tables with JOINs (INNER, LEFT, RIGHT)
• Modify data (INSERT, UPDATE, DELETE)

Real-World Applications

Apply Excel and SQL skills to real-world datasets with hands-on practice and guided exercises, building job-ready confidence.

Master Tableau Basics

• Connect to Excel, CSV, and databases
• Create bar charts, line graphs, maps, and dashboards
• Design interactive reports with filters and drill-downs

Real-World Skills

• Build a sales performance dashboard
• Visualize customer data on maps
• Publish and share dashboards online

R Fundamentals

• Import and clean CSV, Excel, and text files
• Use dplyr to filter, summarize, and reshape data
• Run statistical analysis (mean, median, correlation)

Data Visualization in R

• Create professional charts (bar plots, scatter plots, boxplots)
• Customize visuals with ggplot2

Real-World Skills

Perform Exploratory Data Analysis (EDA) to spot trends and analyze sales, customer behavior, or financial data.

Python Fundamentals

• Write Python scripts to automate data tasks
• Use Pandas & NumPy to clean, filter, and analyze datasets
• Perform Exploratory Data Analysis (EDA) to uncover trends

Professional Visualizations

• Create static charts with Matplotlib & Seaborn
• Build interactive dashboards with Plotly
• Analyze time-series data (sales trends, stock prices)

Data Modeling & Cleaning

• Connect to Excel, SQL, and web data
• Clean messy data using Power Query
• Build data models with relationships

Interactive Dashboards

• Design bar charts, maps, KPIs, and drill-down reports
• Add filters, slicers, and bookmarks for interactivity
• Publish dashboards to Power BI Service and share with teams