Jay S
Master Data Science tutor with Expertise in Excel, Power BI, and Tableau, Looker Studio
Show all photos
Jay S
Masters degree
/ 55 min
About your data science tutor
As a seasoned tutor with over 5 years of experience and a Master's degree in data science, I specialize in tutoring Data Science for beginners, intermediates, advanced learners, adults, and kids. My expertise lies in Tableau, Excel, Data Analysis, and Power Bl. I offer personalized learning experiences in various specialties such as Data Visualization, Machine Learning, Statistical Analysis, and Business Intelligence. I excel in providing tailored support in Assignment Help, Case Studies, Mock Tests, Grade Improvement, and Study Plans. Whether you need assistance with Data Engineering, Deep Learning, or Predictive Modeling, I've got you covered. My teaching methods focus on enhancing concepts understanding and improving skills through practical applications. I am dedicated to helping students enhance their Data Science skills, excel in their projects, and achieve their academic or professional goals. Let's embark on this learning journey together and unlock your full potential in data science! I offer personalized learning experiences in various specialties such as Data Visualization, Machine Learning, Statistical Analysis, and Business Intelligence.
Meet Jay
Jay graduated from Delhi University
Data Science tutor skills
Assignment help
Data visualization
Statistical analysis
Predictive modeling
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 intermediate
Data Science for kids
Data Science for beginners
Data Science for advanced
Data Science for adults
Your data science tutor also teaches
Data Analysis
Excel
Power BI
Tableau
Data Science concepts taught by Jay
The tutor and student worked through various Microsoft Excel tasks, including data navigation, cell formatting, column manipulation, and formula application for profit calculation. They practiced filtering data and briefly discussed the SUMIF function for conditional summation, with plans to review specific formulas further.
Formatting Cells: Currency and Percentages
Freezing Panes in Spreadsheets
Applying Filters and Removing Duplicates
Creating Formulas: Profit Calculation
Hiding and Unhiding Columns/Rows
The student and tutor worked on refining an Excel spreadsheet to match a specific formatting standard. This involved making detailed adjustments to colors, borders, bolding, and cell alignment to improve data presentation and readability. The tutor provided feedback on the formatting, and the student agreed to implement the requested changes.
Data Formatting and Standardization
Color Coding in Data Presentation
Data Cleaning and Refinement
Importance of Consistent Data Structure
The Student and Tutor extensively practiced and troubleshooted advanced Excel functions, primarily focusing on VLOOKUP with multi-column retrieval using curly brackets. They worked through data cleaning techniques like 'Text to Columns' and 'IFERROR' to handle data inconsistencies and errors, and discussed methods for applying formulas and saving finalized data sets. The next session will involve reviewing a past Excel test task the Student has.
IFERROR Function
Text to Columns Feature
Handling Multiple Return Values with Curly Brackets
VLOOKUP Function
The session involved a tutor guiding a student through advanced Excel functions, focusing on data extraction using the `FILTER` function and data retrieval with `VLOOKUP`. The student practiced applying these formulas and learned about error handling techniques to ensure accurate data manipulation.
Value Pasting in Excel
Excel VLOOKUP Function with IFERROR
Excel FILTER Function
Excel Keyboard Shortcuts
The Tutor and Student worked on refining an Excel stock planning tool, focusing on calculating stock availability dates based on lead times and creating actionable dashboards. They adjusted lead times for practical supply chain considerations and discussed how to present this data effectively. Future sessions will focus on presentation preparation and further Excel skill development.
Safety Stock and Buffer Time
Order Timing Prioritization
Inventory Summary Dashboard
Stock Availability Calculation
The student demonstrated an automated sales data processing file to the tutor, showcasing category and vendor filtering. They then worked on implementing refinements, specifically handling multiple colors within product styles by adding distinct subtotals and visual indicators for clarity. The tutor approved the updated file, and the student planned to share it for further practice.
Automated Data Processing and Reporting
Data Summarization and Categorization
Multi-Color Style Analysis
User Interface and Workflow
Teaching tools used by data science tutor
Looker
Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.