Sheela Ponnusamy
Online
Skills :
About :
About me: Driven Data Analyst with 8+ years of experience in data analysis, data visualization, data modeling, data profiling, data visualization, data mapping, data loading and da…
About me: Driven Data Analyst with 8+ years of experience in data analysis, data visualization, data modeling, data profiling, data visualization, data mapping, data loading and data quality analysis. Proficient knowledge in the analysis, design, development, testing and implementation of Business Intelligence solutions using PowerBI, Data Warehouse/Data Mart Design, SQL, ETL, BI, OLAP, OLTP Client/Server applications.
●Core Skills: Data Analysis, Data Migration, Data Visualization, Excel, PowerBI, SQL Reporting, Dashboards, Python, Tableau, ETL
●Data Analysis: Data Analyst experienced in delivering business reporting and analytics. Extensively created detailed design documents, report templates and enrollment details, tabular/matrix reports, chart reports for key performance indicators, summary reports, parameterized reports, dashboard reports and sub reports. Experienced working in a variety of capacities with the ability to jump in and work effectively in a multitude of systems. Strong leadership skills with experience as the primary resource to team members and data stewards for training, problem resolution, data profiling and provided analytic support including data importing, data wrangling and data visualization.
●Visualization Experience: Over 4 years of experience reporting and developing dashboards in PowerBI/Tableau. Strong data governance/profiling experience including data cleansing, data quality, data archiving and data/code migration experience using SQL. Extensive experience in creating new data collection systems using MySQL that optimize data management, capturing, delivery and quality. As a Data Consultant, was responsible for building queries and data transformation using Power BI desktop to create data visualization with form controls and to build dynamic dashboard.
●Excel: Proficient MS Excel knowledge including VLOOKUP, POWERPIVOT, functions and other analytical formulae. Expertise with combining multiple tables and creating reports from them. Experience with processing data from difference sources and getting output to Excel. Data visualization using various Excel charts.
●Soft Skills: Excellent written and verbal communications skills able to effectively collaborate with various business and technical teams to gather requirements around data quality rules and propose data optimization.
Sheela Ponnusamy
Online
Skills :
About me: Driven Data Analyst with 8+ years of experience in data analysis, data visualization, data modeling, data profiling, data visualization, data mapping, data loading and da...
About me: Driven Data Analyst with 8+ years of experience in data analysis, data visualization, data modeling, data profiling, data visualization, data mapping, data loading and data quality analysis. Proficient knowledge in the analysis, design, development, testing and implementation of Business Intelligence solutions using PowerBI, Data Warehouse/Data Mart Design, SQL, ETL, BI, OLAP, OLTP Client/Server applications.
●Core Skills: Data Analysis, Data Migration, Data Visualization, Excel, PowerBI, SQL Reporting, Dashboards, Python, Tableau, ETL
●Data Analysis: Data Analyst experienced in delivering business reporting and analytics. Extensively created detailed design documents, report templates and enrollment details, tabular/matrix reports, chart reports for key performance indicators, summary reports, parameterized reports, dashboard reports and sub reports. Experienced working in a variety of capacities with the ability to jump in and work effectively in a multitude of systems. Strong leadership skills with experience as the primary resource to team members and data stewards for training, problem resolution, data profiling and provided analytic support including data importing, data wrangling and data visualization.
●Visualization Experience: Over 4 years of experience reporting and developing dashboards in PowerBI/Tableau. Strong data governance/profiling experience including data cleansing, data quality, data archiving and data/code migration experience using SQL. Extensive experience in creating new data collection systems using MySQL that optimize data management, capturing, delivery and quality. As a Data Consultant, was responsible for building queries and data transformation using Power BI desktop to create data visualization with form controls and to build dynamic dashboard.
●Excel: Proficient MS Excel knowledge including VLOOKUP, POWERPIVOT, functions and other analytical formulae. Expertise with combining multiple tables and creating reports from them. Experience with processing data from difference sources and getting output to Excel. Data visualization using various Excel charts.
●Soft Skills: Excellent written and verbal communications skills able to effectively collaborate with various business and technical teams to gather requirements around data quality rules and propose data optimization.
FindMyGuru is a tutor discovery platform that helps students find and connect with experienced tutors and institutes across a wide range of subjects and skills. Students can explore tutor profiles, compare expertise, and contact tutors directly for online or in-person learning.FindMyGuru facilitates discovery and connections between students and tutors or institutes. All classes and learning arrangements are handled directly between students and the respective tutors or institutes
Courses by Sheela Ponnusamy
Online
3 Month
English
TC Palya, Bangalore, 64 1st main street
600 INR
Week Days / Weekends
Course Content
The Data Analytics Program with Excel, SQL & Python is a comprehensive online training course designed to help learners build strong, job-ready skills in data analysis. This program provides a structured learning path covering advanced Excel, data cleaning techniques, SQL databases, and Python fundamentals, enabling students to understand how real-world data is handled, analyzed, and interpreted.
Ideal for beginners, students, and working professionals, the course focuses on both theoretical knowledge and hands-on practice. Learners gain practical exposure to building dashboards, analyzing datasets, writing SQL queries, and using Python for automation and data processing. By the end of the program, participants will understand the full workflow of data analytics, from data collection to visualization and reporting.
What Students Will Learn
1.Excel Fundamentals + Essential Formulas
Excel interface, ribbon, worksheets
Cell referencing: Relative, Absolute, Mixed
Basic formatting & shortcuts
Essential formulas
2. Data Cleaning + Professional Data Handling
Remove Duplicates
Flash Fill
Text to Columns
Data Validation
Conditional Formatting
Find & Replace
Excel tables, sorting, filtering
3. Lookups, Mapping & Data Relationships
VLOOKUP
HLOOKUP
XLOOKUP
INDEX + MATCH
MATCH, OFFSET
Multi-sheet lookups
Mapping datasets
4. Pivot Tables + Data Analysis Models
Creating Pivot Tables
Grouping (dates, categories, numbers)
Calculated fields
Pivot charts
Drill-down analysis
Slicers & timelines
KPI analysis
5. Data Visualization + Excel Dashboards
Charts: Bar, Column, Line, Area, Pie, Donut, Histogram
KPI Cards
Dynamic charts
Slicers + interactive elements
Dashboard layout design
6. Introduction to Databases & SQL
What is a database?
SQL vs MySQL vs others
Relational database concepts
Tables, rows, columns, keys
7. MySQL Installation & Setup
Installing MySQL Server
Using MySQL Workbench
Creating databases and schemas
8. Basic SQL Commands
SELECT, DISTINCT
ORDER BY, LIMIT
WHERE filtering
Operators: IN, BETWEEN, LIKE
9 SQL Joins
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN
CROSS JOIN
Self JOIN
10 Advanced Conditions
AND, OR, NOT
CASE WHEN expressions
11 Aggregations
COUNT, SUM, AVG, MIN, MAX
GROUP BY
HAVING
12 Subqueries
Subqueries in SELECT
Subqueries in WHERE
Subqueries in FROM
Correlated subqueries
13 Data Cleaning in SQL
TRIM, REPLACE
SUBSTRING
LOWER, UPPER
NULL handling
COALESCE
14 Window Functions
OVER
ROW_NUMBER
RANK, DENSE_RANK
LEAD, LAG
Running totals, moving averages
15 Table Operations
CREATE, INSERT, UPDATE, DELETE
ALTER TABLE
TRUNCATE
16 Data Modeling Concepts
ER diagrams
1NF, 2NF, 3NF
Keys & constraints
17 Views & Temporary Tables
Creating and using views
Temporary tables
CTEs (WITH clause)
18 MySQL Functions for Analytics
Date functions: DATEDIFF, DATE_ADD, YEAR, MONTH
Math: ROUND, CEIL, FLOOR
String: CONCAT, LPAD, RPAD
Performance Basics
Indexes
EXPLAIN query optimization
19 Importing & Exporting Data
LOAD DATA INFILE
Import CSV
Export results
Connecting MySQL with Excel/Power BI
20 Python
Week 1 → Basics + Data Types + Operators
Week 2 → Conditionals + Loops
Week 3 → Strings + Lists
Week 4 → Tuples + Sets + Dictionaries
Week 5 → Functions + File Handling
Week 6 → OOP + Mini Project
Teaching Method
This course is delivered through live online interactive sessions, combining theory with practical application:
Step-by-step demonstrations using real datasets
Hands-on exercises and assignments
Case-based learning and practical scenarios
Regular doubt-clearing and guidance sessions
Focus on real-world analytics workflows
The structured approach ensures students gain both technical knowledge and practical confidence.
Why This Tutor
The tutor focuses on practical, industry-oriented training, helping learners understand data analytics concepts clearly and apply them effectively. The teaching style emphasizes real-world examples, interactive learning, and gradual skill development.
Benefits & Outcomes
By completing this program, learners will:
Develop strong data analysis skills using Excel, SQL, and Python
Learn professional data cleaning and visualization techniques
Build interactive dashboards and reports
Understand database management and query optimization
Gain confidence to pursue careers in data analytics
This program provides a solid foundation for those aspiring to enter the data analytics and business intelligence field.