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
Assignment help
Business intelligence
Deep Learning
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 adults
Data Science for intermediate
Data Science for kids
Data Science for beginners
Data Science for advanced
Your data science tutor also teaches
Data Analysis
Data Science
Excel
Data Science concepts taught by Darshankumar
PMT Function (Periodic Payment)
PV Function (Present Value)
FV Function (Future Value)
Enabling and Using the Analysis ToolPak for Histograms
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.
VLOOKUP for Merging Data
Data Entry Forms in Excel
Creating and Customizing Charts
Subtotal Function and Structured References
Using Formulas with Tables
Creating and Managing Excel Tables
Structured References for Calculations
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
VLOOKUP Function: Finding Information Across Tables
Datedif Function: Calculating Time Differences
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
Calculated Fields and Profit Margins
Slicers and Interactive Dashboards
Frequency Distribution and Charts
Pivot Table Fundamentals
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.
Summarizing and Analyzing Pivot Table Data
Multi-Level Pivot Tables and Percentage Calculations
Two-Dimensional Pivot Tables and Grouping
Designing a Pivot Table
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: Manage Rules
Advanced Formulas for Conditional Formatting
Data Bars
Color Scales
and Icon Sets
Conditional Formatting: Highlight Cell Rules
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.