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
Predictive modeling
Assignment help
Statistical analysis
Data visualization
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 advanced
Data Science for adults
Data Science for kids
Data Science for beginners
Data Science for intermediate
Your data science tutor also teaches
Data Analysis
Excel
Power BI
Tableau
Data Science concepts taught by Jay
The Student and Tutor worked on transforming and analyzing product sales data in Excel, focusing on splitting inconsistent product variant information into separate columns. They developed a pivot table summary with a brand filter to analyze sales performance and discussed future automation for report generation. The next session will involve a demo of the automated solution.
Variant Data Extraction & Standardization
Custom Data Presentation & Formatting
Interactive Sales Summary with Slicers
Differentiated Reporting: Sales vs. Stock
Automation & Shopify Integration
Future Stock Reorder Logic & Data Correlation
The Student and Tutor explored advanced data analysis techniques using PowerBI and Excel. The session covered the functionalities of PowerBI dashboards, different user roles in BI, and complex data grouping methods. In Excel, they delved into simple versus data model pivot tables, focusing on distinct count, and the implementation of calculated fields for dynamic analysis, with a plan for the Student to practice these concepts hands-on in future sessions using a Windows system.
Advanced PivotTables for Distinct Counts
Excel vs. PowerBI: When to Use Which Tool
Dynamic Calculations with PivotTable Calculated Fields
PowerBI Dashboard Essentials
The Tutor introduced the Student to fundamental Excel concepts, including the user interface, various file formats, and essential features for data manipulation and formatting. They practiced using important keyboard shortcuts and explored the functionalities of 'Paste Special,' 'Text to Column,' and different number and date formatting options. The Student was assigned homework to download a dataset and practice all the concepts learned during the session.
Understanding Excel's User Interface
Mastering Quick Access Toolbar & Keyboard Shortcuts
Data Conversion: From Text to Numbers with "Text to Column"
Advanced Pasting with "Paste Special"
Essential Cell Formatting & Data Entry Shortcuts
The Tutor and Student engaged in an introductory session on Excel for data analysis, focusing on refreshing the Student's skills for decision-making. They explored how to interpret datasets, utilize Pivot Tables for data summarization, and apply formulas such as `UNIQUE`, `COUNTIF`, and `SUMIF` on a project management dataset. The Tutor outlined a comprehensive learning plan covering shortcuts, AI integration, and basic VBA macros, recommending 10-15 subsequent sessions.
Summarizing Data with Pivot Tables
Conditional Formulas for Targeted Analysis
Boosting Efficiency with Excel Shortcuts
Introduction to VBA/Macros for Automation
Understanding Data for Business Insights
The tutor guided the student through practical data analysis techniques in Excel, including pivot tables and conditional formulas like COUNTIF, SUMIF, and AVERAGEIF. They also introduced data visualization tools such as Looker Studio and Power BI, and discussed the potential of AI tools for upskilling.
Pivot Tables in Excel
Excel Formulas: COUNTIF
SUMIF
AVERAGEIF
Introduction to Data Visualization Tools
XLOOKUP Function
The student and tutor collaborated to resolve discrepancies in an Excel budget tracking spreadsheet, specifically focusing on budget totals and implementing a new forecasting tool. They corrected data entry errors, refined departmental inclusions, and set up a system for managers to forecast expenses and track remaining budgets.
Data Visualization and Dashboard Design Principles
Forecasting Tools and Techniques in Spreadsheets
FP Code Management and Error Correction
Budget vs. Actuals Reconciliation
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.