Data Management & Visualization with SQL, Excel & Power
Duration – 3 Days
Objectives
To provide participants with industry-ready data analysis skills through hands-on exposure to RDBMS (MySQL), advanced Excel tools, and Power BI dashboards, helping them apply data-driven decision-making in real-world scenarios and enhance job readiness.
Tools & Platforms
- MongoDB Atlas, MongoDB Compass
- React JS, Node.js, Express JS
- Postman, VS Code, GitHub
Pre-requisites
- Basic knowledge of computers and spreadsheets
- Familiarity with Excel (helpful but not required)
- Interest in data handling and reporting
- Laptop with internet access and MS Excel installed
Take away
By the end of this 2-day workshop, participants will:
- Gain confidence in writing efficient SQL queries and managing relational databases
- Use Excel functions and dashboards for dynamic reporting and analysis
- Build end-to-end Power BI reports with real-time interactivity and insights
- Understand data lifecycle from raw input to business-ready visuals
Day 2 - Excel for Data Analysis
- Core Excel Functions (VLOOKUP, IF, Pivot Tables)
- Data Cleaning and Manipulation Techniques
- Introduction to Data Validation & Conditional Formatting
- Dynamic Dashboards using Slicers & Charts
Day 3 - Business Intelligence with Power BI
- Architecture, Data Sources & Power Query
- Data Cleaning and Transformation
- Data Modelling and Relationship Management
- Introduction to DAX (Measures & Calculated Columns)
- Creating Interactive Reports & Dashboards
- Publishing Reports to Power BI Service
