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
Assignment help
Predictive modeling
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 advanced
Data Science for kids
Data Science for beginners
Your data science tutor also teaches
Data Analysis
Excel
Power BI
Tableau
Data Science concepts taught by Jay
The Student and Tutor reviewed an Excel automation macro for Shopify sales data processing, which extracts size and color information. They discussed enhancing the output report to include a multi-level sorting and breakdown by gender and product type for better business insights. The session also involved troubleshooting Excel's macro security settings to enable the tool on the Student's system for future use. The next session will focus on implementing the advanced sorting requirements.
Shopify Sales Report Automation Overview
Raw Data Structure & Pre-processing
Enhanced Data Columns: Size & Color Extraction
Sales Data Categorization & Hierarchical Sorting
VBA Macro Execution & Troubleshooting
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.
Automation & Shopify Integration
Differentiated Reporting: Sales vs. Stock
Interactive Sales Summary with Slicers
Custom Data Presentation & Formatting
Variant Data Extraction & Standardization
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.
PowerBI Dashboard Essentials
Advanced PivotTables for Distinct Counts
Dynamic Calculations with PivotTable Calculated Fields
Excel vs. PowerBI: When to Use Which Tool
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
Essential Cell Formatting & Data Entry Shortcuts
Advanced Pasting with "Paste Special"
Data Conversion: From Text to Numbers with "Text to Column"
Mastering Quick Access Toolbar & Keyboard 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
Understanding Data for Business Insights
Introduction to VBA/Macros for Automation
Boosting Efficiency with Excel Shortcuts
Conditional Formulas for Targeted Analysis
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.
XLOOKUP Function
Introduction to Data Visualization Tools
Excel Formulas: COUNTIF
SUMIF
AVERAGEIF
Pivot Tables 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.