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



Show all photos
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
Data engineering
Machine learning
Business intelligence
Learner types for data science class
Data Science for kids
Data Science for adults
Data Science for intermediate
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.
Expert in debugging code
Breaks down coding issues into manageable steps.
Debugging and problem-solving focus
85% of students improve debugging skills.
Highly rated for problem-solving approach
95% of students improve problem-solving skills and speed.
Your data science tutor also teaches
Data Analysis
Databases
Excel
Machine Learning
Python
Statistics

15 days Refund
Free Tutor Swap

Data Science concepts taught by Anshuman
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)
What-If Analysis
Goal Seek
INDEX and MATCH
XLOOKUP
HLOOKUP
VLOOKUP
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
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
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
Teaching tools used by data science tutor
Google Colab
Jupyter Notebook
Interactive data science classes
Record lessons
Chat for quick help
Note taking
Parent feedback
Open Q&A

Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.
