Ronu Mondeep Mohanty

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Class 10 Tuition

6

Teaching Experience in detail in Class 10 Tuition

This course provides a complete and structured coverage of Class 10 History, starting from the absolute basics and gradually developing a deeper understanding of important historical events, societies and developments. The course covers: * Harappan Civilisation * Kings, Farmers and Towns * Kinship, Caste and Class * Thinkers, Beliefs and Buildings * Travellers’ Accounts * Bhakti–Sufi Traditions * Vijayanagara Empire * Peasants, Zamindars and the Mughal State * Colonialism and Rural Society * Revolt of 1857 * Colonial Cities * Mahatma Gandhi and the National Movement * Partition of India * Making of the Indian Constitution The focus is on conceptual clarity rather than rote learning. Important events are explained through their causes, consequences and historical context, along with chronology, maps, timelines, important personalities and historical sources. The course is designed to make History easy to understand, connect and remember, while also helping students develop the ability to analyse historical events instead of simply memorising facts. Suitable for students who want to build a strong and comprehensive foundation in Indian History.

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Spoken English classes

10

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Snowflake Training

6

Teaching Experience in detail in Snowflake Training

This Snowflake : Basic to Advanced course is designed to take you from absolute beginner level to advanced Data Analytics and Data Engineering concepts using Snowflake. The course starts from scratch, so no prior Snowflake experience is required. We gradually move from fundamentals to real-world and advanced concepts used in modern data platforms. Topics covered include: • Snowflake Architecture & core concepts • Databases, Schemas, Tables & Data Types • Data Loading & Unloading • Stages, File Formats & COPY commands • SQL for Data Analytics • Joins, CTEs, Subqueries & Window Functions • Views, Secure Views & Materialized Views • Streams & Change Data Capture (CDC) • Tasks & automated data pipelines • Dynamic Tables • Stored Procedures & User-Defined Functions • Snowflake Scripting • Time Travel & Fail-safe • Zero-Copy Cloning • Data Sharing • Roles, RBAC & Access Management • Virtual Warehouses & Resource Management • Query Profile, Query Plan & Performance Optimization • Clustering, Micro-partitions & Pruning • Semi-structured data (JSON, VARIANT, FLATTEN) • Snowflake features relevant to Data Engineering and Analytics The course focuses not only on what a feature does, but when, why, and how it is used in real projects. The content can also be customised based on the learner’s experience and requirements, and hands-on assignments, use cases, and project work can be included to provide practical exposure. The objective is to help learners confidently use Snowflake for both Data Analytics and Data Engineering workloads, starting from the fundamentals and progressing toward production-level concepts.

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Class 12 Tuition

6

Teaching Experience in detail in Class 12 Tuition

This course provides a complete and structured coverage of Class 12 History, starting from the absolute basics and gradually developing a deeper understanding of important historical events, societies and developments. The course covers: * Harappan Civilisation * Kings, Farmers and Towns * Kinship, Caste and Class * Thinkers, Beliefs and Buildings * Travellers’ Accounts * Bhakti–Sufi Traditions * Vijayanagara Empire * Peasants, Zamindars and the Mughal State * Colonialism and Rural Society * Revolt of 1857 * Colonial Cities * Mahatma Gandhi and the National Movement * Partition of India * Making of the Indian Constitution The focus is on conceptual clarity rather than rote learning. Important events are explained through their causes, consequences and historical context, along with chronology, maps, timelines, important personalities and historical sources. The course is designed to make History easy to understand, connect and remember, while also helping students develop the ability to analyse historical events instead of simply memorising facts. Suitable for students who want to build a strong and comprehensive foundation in Indian History.

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Class 9 Tuition

6

Teaching Experience in detail in Class 9 Tuition

Class 9 History – Complete Course This course provides complete and structured coverage of Class 9 History, starting from the absolute basics and making historical events easy to understand and remember. The course covers major themes of modern world history, including: * The French Revolution – causes, major events, important personalities and its impact on the world * Socialism in Europe and the Russian Revolution – rise of socialist ideas, the Russian Revolution and its consequences * Nazism and the Rise of Hitler – Germany after World War I, Hitler’s rise to power, Nazi ideology and its consequences * Forest Society and Colonialism – impact of colonial rule on forests and forest communities * Pastoralists in the Modern World – pastoral communities and how political and economic changes affected their lives The focus is on conceptual understanding rather than memorising dates and facts. Topics are explained through simple examples, timelines, maps, cause-and-effect relationships and connections between important events. The course is suitable for students who want to strengthen their fundamentals, improve their understanding of History and prepare confidently for school examinations.

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Class 8 Tuition

6

Teaching Experience in detail in Class 8 Tuition

Class 8 History Complete Course This course provides complete and easy-to-understand coverage of Class 8 History, starting from the basics and gradually building a strong understanding of Modern Indian History. Students will learn about the major political, economic and social changes that shaped India during the colonial period. Major topics covered: * How, When and Where * From Trade to Territory – rise of the East India Company * Ruling the Countryside * Tribals, Dikus and the Vision of a Golden Age * The Revolt of 1857 and its aftermath * Colonialism and Indian society * Weavers, Iron Smelters and Factory Owners * Civilising the “Native” and Education * Women, Caste and Social Reform * The Making of the National Movement * India after Independence The course focuses on understanding the story behind historical events rather than simply memorising dates. Important concepts are explained using timelines, maps, stories, important personalities, causes and consequences, helping students connect different events and understand how modern India gradually developed. Suitable for students looking to build strong fundamentals in History and prepare confidently for their school examinations.

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Data Analytics classes

6

Teaching Experience in detail in Data Analytics classes

Data Analytics – Basic to Advanced This course is designed to take learners from absolute beginner level to practical Data Analytics, covering the major tools and technologies used by Data Analysts in real-world projects. No prior experience in programming, databases or analytics is required. The course starts from scratch and gradually progresses towards advanced concepts and hands-on analysis. Technologies & Topics Covered * Excel – Data Cleaning, Formulas, Pivot Tables, Lookups and Analysis * SQL & SQL Server – Queries, Joins, Subqueries, CTEs, Views, Stored Procedures and Window Functions * Snowflake – Architecture, Data Loading, Warehouses, Tables, Views, CTEs, Streams, Dynamic Tables and analytical queries * Python for Data Analytics – Python fundamentals, NumPy, Pandas, data cleaning, transformation and exploratory data analysis * Tableau – Data Connections, Calculated Fields, Filters, Parameters, Dashboards, Visualisations and Storytelling * Data Cleaning & Transformation * Data Modelling & Database Fundamentals * Exploratory Data Analysis (EDA) * Data Visualisation & Dashboard Development * Business-oriented analytical problem solving The focus is not limited to learning individual tools. Students will understand how SQL Server, Snowflake, Python and Tableau work together in an end-to-end analytics workflow from extracting raw data and transforming it to analysing the information and presenting insights through dashboards. The course can be customised according to the learner’s requirements, with hands-on exercises, case studies and real-world project work included for practical exposure.

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in SQL Server Training

6

Teaching Experience in detail in SQL Server Training

SQL Server for Data Analytics – Basic to Advanced This course is designed to teach Microsoft SQL Server from a Data Analytics perspective, starting from absolute basics and gradually progressing to advanced SQL concepts used for analysing real-world datasets. The focus is on learning how to extract, clean, transform and analyse data using SQL rather than only understanding database theory. Topics Covered * Introduction to Databases, RDBMS & SQL Server * Tables, Rows, Columns, Primary & Foreign Keys * SQL Data Types * DDL, DML, DQL & TCL Commands * SELECT, DISTINCT, WHERE, ORDER BY and TOP * Filtering using IN, BETWEEN, LIKE and NULL * Aggregate Functions – SUM, COUNT, AVG, MIN & MAX * GROUP BY and HAVING * CASE Statements * Joins – INNER, LEFT, RIGHT, FULL & Self Join * Subqueries & Correlated Subqueries * Common Table Expressions (CTEs) * UNION, UNION ALL, INTERSECT & EXCEPT * Date, String and Numeric Functions * Views & Temporary Tables * Stored Procedures * Window Functions – ROW_NUMBER, RANK, DENSE_RANK, LAG & LEAD * Running Totals and Moving Averages * Query Execution Plans & Basic Query Optimisation * Indexing Fundamentals * Data Cleaning and Transformation using SQL * Analytical and Business Case Studies Special emphasis is given to solving real-world analytical problems, such as identifying trends, customer analysis, ranking, month-on-month comparisons, finding duplicates, latest transactions and KPI calculations. The course can be customised and can include hands-on exercises, interview-oriented SQL problems and end-to-end Data Analytics projects using SQL Server.

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Tableau Training

6

Teaching Experience in detail in Tableau Training

Tableau for Data Analytics – Basic to Advanced This course is designed to teach Tableau from absolute basics to advanced Data Analytics and dashboard development, with a strong focus on practical and business-oriented use cases. No prior Tableau experience is required. The course starts from scratch and gradually progresses towards building interactive, professional and insightful dashboards. Topics Covered * Introduction to Tableau & Business Intelligence * Tableau Desktop & Tableau Server/Cloud * Connecting Tableau with Excel, CSV, SQL Server, Snowflake and other data sources * Dimensions & Measures * Discrete vs Continuous Data * Live Connections vs Extracts * Data Relationships, Joins & Unions * Data Cleaning and Data Preparation * Filters, Sorting, Groups, Sets & Hierarchies * Calculated Fields * Date, String, Number and Logical Functions * Parameters * Level of Detail (LOD) Expressions * Table Calculations * Charts, Maps and Advanced Visualisations * KPIs and Business Metrics * Dashboard Designing & Formatting * Interactive Filters, Actions & Navigation * Dashboard Performance Optimisation * Extract Refreshes & Data Source Management * Publishing and Sharing Dashboards * Tableau Server/Cloud Fundamentals * User Permissions & Access Management * Data-driven Alerts & Subscriptions * Dashboard Design Best Practices The course focuses on turning raw data into meaningful business insights rather than simply creating charts. Learners will work with practical datasets to understand the complete analytics journey — connecting data, analysing it, identifying trends and KPIs, and presenting insights through interactive dashboards. The course can also be customised with hands-on exercises, business case studies and end-to-end Tableau projects.

Class Location

Online class via Zoom

Student's Home

Tutor's Home

Years of Experience in Python Training classes

6

Teaching Experience in detail in Python Training classes

Python for Data Analytics – Basic to Advanced This course is designed to teach Python from absolute basics to practical Data Analytics, with a strong focus on working with real-world datasets. No prior programming experience is required. The course starts with Python fundamentals and gradually progresses towards data cleaning, transformation, analysis and visualisation. Topics Covered * Introduction to Python & its use in Data Analytics * Variables, Data Types & Operators * Strings, Lists, Tuples, Sets & Dictionaries * Conditional Statements – IF, ELIF & ELSE * Loops – FOR & WHILE * Functions & Lambda Functions * Exception Handling * Working with Files – CSV, Excel, JSON, etc. * Introduction to NumPy * Arrays, Indexing & Mathematical Operations * Introduction to Pandas * Series & DataFrames * Reading and Writing Data * Filtering, Sorting & Selecting Data * Handling Missing Values & Duplicates * Data Cleaning & Transformation * GroupBy & Aggregations * Merge, Join & Concatenation * Pivot Tables & Cross Tabulation * Working with Dates & Time-Series Data * Apply, Map & Vectorised Operations * Exploratory Data Analysis (EDA) * Statistical Analysis Fundamentals * Data Visualisation using Matplotlib * Introduction to Seaborn * Connecting Python with SQL Databases * Extracting and Analysing SQL Data using Python * Automation of repetitive analytical tasks * Working with larger datasets * Real-world Business Analytics Case Studies The emphasis is on using Python as an analytical tool rather than simply learning programming syntax. Learners will understand how to take raw data, clean and transform it with Pandas, analyse patterns and trends, perform exploratory analysis, and communicate findings through visualisations. The course can be customised and can include hands-on assignments, interview-oriented problems and end-to-end Data Analytics projects using Python.