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
Business intelligence
Statistical analysis
Data visualization
Predictive modeling
Assignment help
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 advanced
Data Science for intermediate
Data Science for adults
Data Science for kids
Your data science tutor also teaches
Data Analysis
Excel
Power BI
Tableau
Data Science concepts taught by Jay
The Student and Tutor reviewed and practiced various Excel features, including data validation, removing duplicates using a shortcut and the `UNIQUE` formula, and basic statistical functions like `COUNTIF`, `COUNT`, `SUM`, `MAX`, and `MIN`. They also explored how to use Pivot Tables for data summarization. The Student was assigned to practice these concepts using a shared Excel file.
Data Validation for Structured Entry & Professionalism
Efficient Unique Value Extraction
Core Data Aggregation Formulas
Introduction to Pivot Tables for Data Summarization
Student and Tutor worked on building a standardized Excel sheet for tracking customer orders. They implemented data validation for consistent data entry, applied conditional formatting for visual alerts on due dates and completion statuses, and discussed various Excel file formats and their practical uses. The Student was encouraged to practice these new skills and gather more data for the next session.
Data Validation for Standardized Input
Paste Special: Beyond Basic Copy-Paste
Customizing the Quick Access Toolbar (QAT)
Excel File Formats: XLSX
XLSB
and CSV
Conditional Formatting for Visual Cues
Excel Layout & Basic Formatting
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
Importance of Consistent Data Structure
Color Coding in Data Presentation
Data Cleaning and Refinement
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.
VLOOKUP Function
Handling Multiple Return Values with Curly Brackets
Text to Columns Feature
IFERROR 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.
Excel FILTER Function
Excel Keyboard Shortcuts
Excel VLOOKUP Function with IFERROR
Value Pasting in Excel
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.
