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
Statistical analysis
Assignment help
Data visualization
Data engineering
Business intelligence
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 kids
Data Science for advanced
Data Science for intermediate
Data Science for adults
Data Science for beginners
Your data science tutor also teaches
Data Analysis
Data Science
Excel
Data Science concepts taught by Darshankumar
The Tutor and Student explored various advanced features within Excel tables. They practiced creating, manipulating, and analyzing data within tables, including calculating subtotals, bonuses, and generating charts. The session concluded with an introduction to Excel forms for efficient data entry.
Creating and Managing Excel Tables
Data Entry Forms in Excel
Creating and Customizing Charts
VLOOKUP for Merging Data
Structured References for Calculations
Subtotal Function and Structured References
Using Formulas with Tables
The tutor and student worked through several advanced Excel exercises focusing on data analysis and reporting. Topics covered included pivot tables, VLOOKUP functions, cohort analysis, weighted average price calculations, Pareto analysis, and variance calculations, with practical application on sales data.
Pivot Tables: Summarizing and Analyzing Data
Pareto Analysis: Identifying Key Contributors
Weighted Average: Calculating Averages with Significance
Datedif Function: Calculating Time Differences
VLOOKUP Function: Finding Information Across Tables
The class covered advanced Excel topics, focusing on Pivot Tables and Slicers for data analysis and reporting. The student practiced creating and manipulating Pivot Tables for various summary tasks and learned to use Slicers for interactive filtering, with plans to continue exploring these tools.
Date Grouping and Trends
Pivot Table Fundamentals
Frequency Distribution and Charts
Calculated Fields and Profit Margins
Slicers and Interactive Dashboards
The Tutor instructed the Student on various advanced Pivot Table features in Excel, including data analysis, sorting, counting orders, creating two-dimensional Pivot Tables, grouping data, and analyzing quarterly sales. They also covered multi-level Pivot Tables and displaying values as percentages of the grand total, with plans to cover Pivot Charts and slicers in future sessions.
Designing a Pivot Table
Summarizing and Analyzing Pivot Table Data
Two-Dimensional Pivot Tables and Grouping
Multi-Level Pivot Tables and Percentage Calculations
The tutor and student reviewed Excel conditional formatting techniques, including highlight rules, managing rules, data bars, color scales, and icon sets. They practiced applying these features to highlight specific data conditions and identify duplicate values using both built-in tools and custom formulas. The next session will cover pivot tables and charts.
Conditional Formatting: Highlight Cell Rules
Conditional Formatting: Manage Rules
Data Bars
Color Scales
and Icon Sets
Advanced Formulas for Conditional Formatting
The Tutor and Student reviewed Excel functions including INDIRECT, XLOOKUP, and XMATCH, practicing their application for data retrieval and error handling. They also covered Conditional Formatting rules for highlighting data based on various criteria, including custom formulas, with plans to continue practicing homework assignments.
INDEX and XMATCH Combination
Conditional Formatting with Formulas
XMATCH Function
XLOOKUP 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.