Darshankumar Chauhan
Data Science Expert over 9 years plus experience total academic experience 15 years
Loading...
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
Data visualization
Deep Learning
Assignment help
Data engineering
Statistical analysis
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 kids
Data Science for adults
Data Science for intermediate
Data Science for advanced
Your data science tutor also teaches
Data Analysis
Data Science
Excel
Data Science concepts taught by Darshankumar
The tutor guided the student through advanced features of Excel Pivot Tables, focusing on creating, configuring, and analyzing data. Topics included grouping data by category and date, utilizing multi-dimensional pivot tables, and implementing interactive slicers. The session also covered calculated fields, refreshing data, and generating pivot charts for data visualization, with plans to cover VLOOKUP in future sessions.
Value Field Settings: Count vs. Sum
Calculated Fields and Items
Slicers for Interactive Filtering
Two-Dimensional and Multi-Level Pivot Tables
Grouping Data by Date and Custom Ranges
Pivot Table Creation and Design
The session focused on practical Excel skills, including data separation using 'Text to Columns' and 'Flash Fill', and implementing logical functions like 'IF', 'AND', 'OR', and 'NOT' for conditional analysis. The student practiced applying these functions to various scenarios, including score evaluation and data comparison, with plans to cover pivot tables in the next session.
Text to Columns
Flash Fill
IF Function
AND
OR
NOT Functions
ROW Function
The class provided a comprehensive introduction to Microsoft Excel, covering fundamental concepts like cell selection and ranges, advanced auto-fill techniques for various data types, and custom list creation. The student also learned about practical data management tools such as 'Paste Special' with 'Skip Blanks,' conditional formulas using 'IF' and 'ISBLANK,' and dynamic data manipulation with the 'Transpose' function and a unique 'Transpose Magic' method.
Excel Basics: Cells
Rows
Columns
and Ranges
Cell Selection and Navigation Techniques
Auto-Fill and Series Generation
Custom Lists for Specialized Data Entry
Transpose: Switching Rows and Columns
The tutor provided an introductory lesson on the VLOOKUP function in Excel, explaining its syntax and demonstrating its use with practical examples. The student practiced identifying the components of the VLOOKUP formula and observed its application in retrieving data from tables. They agreed to book future sessions to cover more advanced Excel topics.
Table Array and Column Index
Exact vs. Approximate Match
Handling Duplicates with VLOOKUP
VLOOKUP Function
Teaching tools used by data science tutor
Jupyter Notebook
Google Colab
Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.