Rumpi R.

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Microsoft Excel Training classes

5

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Microsoft Power BI classes

2

Teaching Experience in detail in Microsoft Power BI classes

I have 5 years of experience in training, with a strong focus on Microsoft Power BI, along with 5 years of corporate experience in Data Analytics. My training approach emphasizes practical, hands-on learning and real-world business scenarios to help students understand and apply Power BI concepts effectively. I provide training on Power BI from basic to advanced levels, covering topics such as: Power BI Fundamentals: Introduction to Power BI, its architecture, components, and workspace; Data Connectivity: Connecting Power BI to various data sources, including Excel, CSV, SQL Server, and other databases; Power Query: Data cleaning, transformation, merging, appending, and data preparation using Power Query Editor; Data Modelling: Creating relationships, understanding star and snowflake schemas, and developing efficient data models; DAX: Teaching calculated columns, measures, calculated tables, and commonly used DAX functions such as SUM, CALCULATE, FILTER, RELATED, and time intelligence functions; Data Visualization: Creating interactive reports and dashboards using charts, tables, cards, slicers, and other visualization tools; Power BI Service: Publishing reports, creating workspaces, sharing dashboards, managing access, and understanding scheduled data refresh; Real-Time Projects: Guiding learners through practical projects involving business data, KPI reporting, sales analysis, and performance dashboards. My teaching methodology focuses on explaining concepts in a simple and structured manner, followed by practical demonstrations, assignments, and real-world projects. My corporate experience helps me provide industry-relevant examples and prepare learners to work confidently on Power BI in professional environments. My goal is to make learners proficient in Microsoft Power BI and equip them with the practical skills required for Data Analyst roles.

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in PL/SQL Classes

2

Teaching Experience in detail in PL/SQL Classes

I have 5 years of experience in training, along with 5 years of corporate experience in Data Analytics, where I have worked extensively with SQL for data extraction, manipulation, analysis, and reporting. My training approach focuses on building strong SQL fundamentals and developing practical query-writing skills through real-world business scenarios. I provide SQL training from basic to advanced levels, covering the following topics: SQL Fundamentals: Introduction to SQL, databases, tables, data types, and basic SQL commands. DDL, DML, DQL & TCL: Understanding and working with CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, COMMIT, and ROLLBACK. Data Filtering & Sorting: WHERE, ORDER BY, DISTINCT, TOP, LIMIT, and different filtering conditions. SQL Functions: Aggregate functions, string functions, date functions, mathematical functions, and conversion functions. Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN, and SELF JOIN with practical examples. Subqueries: Single-row, multiple-row, correlated subqueries, and nested queries. Advanced SQL: Common Table Expressions (CTEs), Views, Temporary Tables, and Set Operators. Window Functions: ROW_NUMBER(), RANK(), DENSE_RANK(), LEAD(), LAG(), and aggregate window functions. Stored Procedures & Functions: Understanding and implementing reusable SQL logic. Performance Optimization: Indexes, query optimization techniques, and writing efficient SQL queries. Real-Time Projects: Practical exercises involving sales analysis, customer data analysis, employee databases, and business reporting. My teaching methodology includes step-by-step explanations, live query demonstrations, hands-on exercises, assignments, and real-world projects. I focus on simplifying complex SQL concepts and helping learners develop logical thinking and problem-solving abilities. With my combination of corporate and training experience, I aim to make learners confident in writing SQL queries, analyzing large datasets, and applying SQL skills effectively in real-world Data Analyst roles.