Darshankumar Chauhan
Data Science Expert over 9 years plus experience total academic experience 15 years
Show all photos
Darshankumar Chauhan
Masters degree
/ 55 min
About your data science tutor
I am Darshankumar Chauhan, a Data Science tutor with over 9 years of experience. I hold a Master's degree and specialize in Excel, Data Science, and Data Analysis tutoring. My expertise spans a wide range of subjects including Business Intelligence, Machine Learning, Data Visualization, and more. I offer personalized learning experiences tailored to students of all levels, from beginners to advanced learners. Whether you are a kid venturing into the world of Data Science or an adult looking to deepen your understanding, I can help you excel in your Data Science journey. My specialities include providing assistance with assignments, conducting mock tests, creating study plans, and improving grades through comprehensive concept learning. I focus on practical applications such as Case Studies, Predictive Modeling, and Statistical Analysis to ensure a holistic understanding. Join me to explore the realms of Data Science through engaging sessions that enhance your skills in Excel, Data Analysis, and beyond. Let's embark on this educational adventure together and unlock your full potential in the world of Data Science! Thank you so much if you need more help contact me . All the Best .
Darshankumar graduated from JNU
Data Science tutor skills
Statistical analysis
Business intelligence
Assignment help
Deep Learning
Data visualization
CoTutorAI modules
Summary
Podcast
Quiz
Learnings
Flashcard
Spotlight
Zero Risk Guaranteed
15-days refund
Free tutor swap
No cancel fee
1-yr validity
24/7 support
Learner types for data science class
Data Science for beginners
Data Science for adults
Data Science for intermediate
Data Science for kids
Data Science for advanced
Your data science tutor also teaches
Data Analysis
Data Science
Excel
Data Science concepts taught by Darshankumar
The Student and Tutor focused on mastering advanced Excel lookup functions, specifically INDEX and MATCH. They practiced combining these functions for single-criterion lookups and then progressed to two-way lookups, retrieving data based on multiple criteria. The Student completed several practical exercises and was assigned homework for continued practice, with the next session planned to cover Left Lookup and Two-Column Lookup.
MATCH Function: Finding Position
Nesting MAX with INDEX & MATCH
INDEX & MATCH (2-Way Lookup)
INDEX & MATCH (1-Way Lookup)
INDEX Function: Retrieving Value by Position
The Student and Tutor practiced advanced Excel lookup functions, specifically VLOOKUP and XLOOKUP, focusing on retrieving data from multiple sheets. The session involved several practical exercises, including extracting patient information, calculating student fees based on their major, and assigning grades based on test scores. The Tutor also clarified when to use VLOOKUP with an approximate match for range-based data. Future sessions will continue with XLOOKUP practice.
VLOOKUP for Range Lookups (Approximate Match)
Comparing VLOOKUP and XLOOKUP
Absolute & Relative Cell References
XLOOKUP Introduction: Flexible Data Retrieval
VLOOKUP Essentials: Syntax and Cross-Sheet Lookups
The tutor and student reviewed Excel functions, starting with basic terms and operators before diving into VLOOKUP and XLOOKUP. They practiced retrieving data, handling errors, and understanding the directional search capabilities of these functions. The session concluded with exercises on XLOOKUP and a brief mention of two-way lookups for future sessions.
VLOOKUP Function
IFERROR Function
XLOOKUP Function
Locking Ranges (Absolute References)
The class focused on learning and practicing several Excel functions. The Student and Tutor explored the `REPT`, `OFFSET`, `TRANSPOSE`, and `VLOOKUP` functions, applying them to various data manipulation scenarios. They also discussed and practiced an alternative method for extracting unique values using the Advanced Filter. The plan is to revisit `XLOOKUP` in the next session.
REPT Function (Repeat Text)
XLOOKUP Function (Conceptual)
VLOOKUP Function
OFFSET Function
Data Transposition (Paste Special)
Extracting Unique Values (Advanced Filter Method)
The session focused on building an interactive sales dashboard in Excel. The Student practiced creating multiple charts (column, bar, stacked area) from PivotTables, grouped by month, and learned to connect these charts to a slicer for dynamic data filtering. The Tutor assigned homework to replicate the dashboard and then create a new one using different chart types, with plans to cover XLOOKUP and XMATCH in upcoming classes.
Dashboard Foundation: Pivot Tables & Column Charts
Comparative Analysis Using Multi-Select Slicers
Interactive Dashboards with Slicers
Multiple Pivot Tables for Comprehensive Metrics
Advanced Chart Customization & Data Presentation
The Student and Tutor worked on building an interactive dashboard in Excel, focusing on data visualization and organization. They practiced formatting text, inserting icons, linking dynamic data, and applying slicers for data filtering. The session concluded with the student learning to apply conditional formatting to a pivot table, and plans were made to add graphs in the next class.
Interactive Slicers for Filtering Data
Conditional Formatting with Data Bars
PivotTables for Data Summarization
Inserting & Customizing Icons
Dashboard Layout & Basic Formatting
Dynamic Data Display with Text Boxes
Teaching tools used by data science tutor
Google Colab
Jupyter Notebook
Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.