Anshuman Shahi

Data Analysis & Data Engineering Tutor | Excel, Python, SQL, PySpark, Databricks & Azure | Practical, Hands-on Teaching

4.5(176)

FREE TRIAL

Loading...
Profile photo of Anshuman, Data Science tutor at Wiingy
Data Science learning materials by Anshuman
Travel snapshot of Anshuman during a trip
Travel snapshot of Anshuman during a trip

Show all photos

tutor-image
tutor-image

Anshuman Shahi

Bachelors degree

/ 55 min

About your data science tutor

I am a Data Engineer with strong expertise in Python, SQL, PySpark, Databricks, and Azure, excel,focused on building scalable data solutions and transforming raw data into meaningful insights. As a tutor, I follow a hands-on and beginner-friendly teaching style where I simplify complex concepts using real-world examples and practical use cases. I emphasize learning by doing, guiding students through step-by-step explanations, live problem-solving, and project-based learning. Whether it’s Python for data handling, SQL for querying and optimization, PySpark for big data processing, Databricks for real-time workflows, or Azure for cloud-based data engineering, my approach ensures that students not only understand the concepts but also gain the confidence to apply them in real projects and job roles. In my sessions, I focus on building a strong foundation first and then gradually moving towards advanced concepts, ensuring that every learner progresses with clarity and confidence. I break down complex topics into smaller, easy-to-understand parts and encourage interactive learning where students can ask questions freely and think critically. I also incorporate real industry scenarios, helping students understand how data engineering works in practical environments rather than just theoretical setups.

Data Science tutor skills

Data visualization icon

Data visualization

Data engineering icon

Data engineering

Machine learning icon

Machine learning

Business intelligence icon

Business intelligence

Learner types for data science class

Data Science for kids icon

Data Science for kids

Data Science for adults icon

Data Science for adults

Data Science for intermediate icon

Data Science for intermediate

Data Science for beginners icon

Data Science for beginners

Data sciece class overview

make Python, SQL, Power BI, and Excel intuitive by mixing vivid stories, live sketches, and hands‑on labs. Each topic follows a repeatable arc: Hook with a real business pain; Map the core idea using metaphors—loops = factory belts, joins = zipper teeth, DAX = self‑updating blueprints—while I draw diagrams that anchor jargon to visuals; Do co‑coding challenges where beginners clean data, intermediates craft KPIs, and advanced learners refactor into reusable functions; Seal the concept with tweet‑length recaps, instant polls, and micro‑quizzes that resurface key points later. A “questions answered fast” Slack, peer code reviews, and weekly office hours keep feedback constant. Capstone projects—Python ETL pipelines, SQL analytics, and Power BI dashboards—turn class skills into job‑ready portfolio artifacts, ensuring students can translate data into decisive action.

icon

Expert in debugging code

Breaks down coding issues into manageable steps.

icon

Debugging and problem-solving focus

85% of students improve debugging skills.

icon

Highly rated for problem-solving approach

95% of students improve problem-solving skills and speed.

Your data science tutor also teaches

Data Analysis

Data Analysis

Databases

Databases

Excel

Excel

Machine Learning

Machine Learning

Python

Python

Statistics

Statistics

propsition image
Refund icon

15 days Refund

Swap icon

Free Tutor Swap

Icons

Data Science concepts taught by Anshuman

Tommy learned 11 months ago

Anshuman trained Tommy on essential Excel financial functions, including PV, FV, PMT, and IRR, and demonstrated the use of Goal Seeker for financial planning. Tommy used ChatGPT to create practice workbooks and successfully applied Goal Seeker to adjust expenses to meet a savings goal. Anshuman provided support for Tommy's upcoming Excel proficiency test.

Goal Seeker

Internal Rate of Return (IRR)

Payment (PMT) Function

Future Value (FV)

Present Value (PV)

Show more

Tommy learned 11 months ago

Anshuman taught Tommy about Excel lookup functions (VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH) and What-If Analysis (Goal Seek). Tommy practiced using these functions, and they scheduled a follow-up session for next week to continue the lesson.

What-If Analysis

Goal Seek

INDEX and MATCH

XLOOKUP

HLOOKUP

VLOOKUP

Show more

Tommy learned 11 months ago

Anshuman taught Tommy spreadsheet skills, including date functions, `NETWORKDAYS`, and the `IF` function with logical operators. Tommy practiced using `IF` and `AND` to check multiple conditions and learned to copy data between sheets. Their next meeting is scheduled for Saturday, May 3rd, at 2 PM.

Troubleshooting Excel Formulas

Applying IF with AND

AND Operator

Conditional Statements (IF)

Networkdays Function

Date Functions in Excel

Show more

Tommy learned 11 months ago

Anshuman taught Tommy various Excel text functions, including case manipulation, string length, concatenation, substring extraction, and replacement. Tommy found these functions easier than math functions. Anshuman will email a function list, and they plan to cover date and lookup functions in the next session, with a suggestion for Tommy to explore PowerBI and Python.

Text Functions in Excel

Data Extraction Tools

SUBSTITUTE Function

REPLACE Function

Wildcard Characters

FIND vs. SEARCH

Date Formatting

Show more

Tommy learned 11 months ago

Anshuman tutored Tommy on essential Excel functions and formulas, including AVERAGE, SUM, COUNT, SUMIF(S), and COUNTIF(S), with a focus on absolute and relative referencing. Tommy received clarification on SUMIFS. Anshuman will send the example Excel sheet, and they scheduled a follow-up session to cover more advanced formulas.

MAX/MIN

Worksheet Organization

COUNT Variants

Naming Cells/Groups

Autofill

Alignment

Freeze Panes

Hyperlinks

Show more

Teaching tools used by data science tutor

Google Colab image

Google Colab

Jupyter Notebook image

Jupyter Notebook

Interactive data science classes

Record lessons icon

Record lessons

Chat for quick help icon

Chat for quick help

Note taking icon

Note taking

Parent feedback icon

Parent feedback

Open Q&A icon

Open Q&A

tutorFooter

Data Science tutors on Wiingy are vetted for quality

Every tutor is interviewed and selected for subject expertise and teaching skill.