SPARQ Sessions - Data Analytics 101
With Hands on healthcare/ecommerce case studies
Dates
June 21-22, 2025
2 Full Days
Time
9:00 AM - 5:00 PM
14 Hours Total
Location
SB Highschool
Chhatrapati Sambhajinagar
Laptop Requirements
Minimum 4 GB RAM
8 GB recommended for Tableau
2-3 GB free storage
For software and datasets
Fully charged + charger
14-hour workshop duration
USB ports or internet
For data transfer
Required Software
Microsoft Excel 2016+
With PivotTables, VLOOKUP support
Tableau Public (Free)
Recommended Accounts
Google Account (shared files)
LinkedIn (networking session)
GitHub (project showcase)
Detailed Workshop Schedule
Comprehensive 2-day program covering tools, techniques, and real-world business applications
What is Data Analytics?
Why do we need this? Practical Applications
Data Handling in Excel: Foundations
Basic data manipulation and organization techniques
Excel Formulas for Everyday Analysis
Essential formulas and functions for data analysis
Advanced Excel: Logical & Lookup Functions
VLOOKUP, INDEX-MATCH, IF statements, and complex logic
Lunch Break
Networking and refreshments
Practical Case of Analytics - Operating with Large Datasets
Real-world data handling and processing techniques
Introduction to Data Visualization - Tableau
Getting started with Tableau Public and basic visualizations
Create Dashboard on Tableau based on practical case
Hands-on dashboard creation using real datasets
What You'll Master
Excel Mastery
Advanced formulas, PivotTables, VLOOKUP, INDEX-MATCH, and data manipulation techniques
Tableau Visualization
Creating interactive dashboards, charts, and meaningful visualizations for business insights
Business Case Analysis
Real-world e-commerce and healthcare analytics with customer retention and churn analysis
Career Guidance
Industry insights, career paths in data analytics, and professional development strategies