Kapil Valand Statistics, R, Python, Tableau, Six Sigma, TQM,
No reviews yet

As a highly skilled senior consultant, with 10 years of experience in consulting, I am writing to express my interest in the teaching line. I have worked with Concept Business Excellence Pvt. Ltd. (CBEPL) for the 7 years. During my tenure at CBEPL I have worked with more than 40 organizations for improvement of Quality and productivity through Data Analysis.
I am certified six sigma black belt from the BMGI in the year of 2012 and I have implemented more than 20 projects of data analysis. I have also worked in the area of lean manufacturing and some of the work in quality management system implementation. I have trained employee of Organizations as well as students of diffrent Universties in India.
I have completed my data science from Middlesex University in 2021. During my study have learned more advanced analysis tools like R, Python, Tableau, Power BI, Visual Studion code, Matlab, KNIME. Apart from this i also know SPSS, MINITAB and Microsoft Excel for data analysis.
Generally i am beleiving in starting of any teaching from the scratch and becuase of this i am able to make my student very strong in the particular subject.

Subjects

  • SPSS Beginner-Expert

  • Lean Six Sigma Beginner-Expert

  • Minitab Beginner-Intermediate

  • Power BI Beginner-Expert

  • Tableau Beginner-Expert

  • Statistical Analysis Beginner-Expert

  • Six Sigma Green Belt Beginner-Expert

  • Power BI dashboard Beginner-Expert

  • Microsoft Power BI Beginner-Expert

  • Microsoft Excel Dashboard Beginner-Expert

  • Statistical Data Analysis Beginner-Expert

  • R & Python Beginner-Expert

  • Statistical Machine Learning Beginner-Expert

  • Six sigma and quality management Beginner-Expert

  • Power BI Desktop Beginner-Expert

  • Power BI Dashboards Beginner-Expert

  • Power Pivot, Power BI, Power Query Beginner-Expert

  • Analytical packages (MS-Excel, MS-Power BI) Beginner-Expert

  • PowerPoint and Power BI Beginner-Expert

  • Machine learning projects Beginner-Expert

Experience

  • Senior Consultant (Aug, 2021–Present) at Stat Modeller, Vadodara
    1) Training on various subjects like R, Python, Excel etc.
    2) Project execution on various topics of data science.
  • Senior Consultant (Dec, 2012–Aug, 2019) at Concept Business Excellence Pvt. Ltd.
     Identifying Clients requirements and Submit Gap assessment report
     Training on Quality Improvement topics to client’s employee
     Data Analysis through Microsoft Excel, Minitab, SPSS and other Software
     Implementation of Six Sigma Projects through various team of Clients
     Training to students of various Institute on Data Analysis Tools, Six Sigma and other tools

Education

  • MSC Data Science (Oct, 2019–Jul, 2021) from Middlesex University of London
  • MSC Quality and Productivity Management (Jul, 2010–Jun, 2012) from Department of Statistics, Sardar Patel University–scored 69%

Fee details

    £12–30/hour (US$15.19–37.97/hour)

    Depends on the student level and time required

Courses offered

  • Advanced Excel Master Class

    • £450
    • Duration: 30 Hours
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English, Hindi, Gujarati
    • Certificate provided: Yes
    Understanding of Excel Interface
    Understanding & Customization of Quick Access Bar
    Understanding & Customization of Ribbon
    Row, Column, Cell & Cell Content
    Formula bar & Function Library
    Name Box / Address Bar
    Understanding of File Extensions & It’s usage
    Saving, Sharing, Protecting, Inspecting Workbook
    Saving & Sharing workbook
    Protect Workbook
    Inspect Workbook
    Export workbook to another extension
    Basic Formula & Functions
    Mathematical Operations
    Basic Formulas (Min, Max, Average, Count, CountA, CountBlank etc.,)
    Text Functions (Mainly used for data cleaning)
    Date & Time Functions
    Cell References
    What is Cell Reference
    What is Range Reference
    Cell Reference Style
    Types of Cell Reference & It’s uses
    Sorting & Filtering
    What is Sorting & purpose of using Sorting
    Sorting & Advance Sorting Options
    (Vertical, Horizontal, Custom list & Multi Level Sorting)
    What is Filtering & purpose of using Filtering
    Filtering & Advanced Filtering Options
    (Alphabetical, Numeric, Custom, Color)
    Conditional Formatting
    Highlight Cell Rule
    Top / Bottom Rule
    Data Bar, Color Scale, Icon Set
    Custom Conditional Formatting
    Data Tools
    Text to Columns
    Flash Fill (MS AI Tool)
    Remove Duplicates
    Data Validation
    Data Consolidation
    Forecasting
    What-If Analysis

    Goal-Seek
    Scenario Manager
    Data Table
    Forecast Sheet
    Advanced Formulas
    Aggregating values with condition(s).
    (SUMIF/ SUMIFS, COUNTIF/ COUNTIFS, AVERAGE/ AVERAGEIFS)
    Nesting formulas for dynamic result
    Large/Small (Indexing Values)
    Row/Column (Support Functions for easy reporting)
    Choose, Switch (Sometimes alternative to IF)
    Transpose, Filter, Sort
    Lookup Functions
    Vlookup, Hlookup, 2 Way Lookup, Partial Lookup
    Index, Match,
    XLookup, Xmatch
    Excel Table & Pivot Table
    Excel Table (Creating, Modifying & exploring)
    Adding, using & modifying Slicers & Time-line
    Data Summarization through Pivot Table
    Forms Controls
    Combo Box (Advanced Drop-down)
    Spin Button (Switching between values)
    Check Box (Show/Hide Data/Objects/chart series etc.,)
    Scroll Bar (Display large data into small space)
    Option Button (Switch between different option)
    List Box (Select items to display data/objects/chart series etc.,)
    Excel Basic Charts
    Introduction to Excel Charts & Graphics
    Different types of Excel Charts
    (Column Charts, Bar Charts, Line/ Area Chart, Pie Chart, Scatter Plot, Bubble Plot etc...)
    Excel Advanced Charts
    Advanced Stake Column Chart,
    Chart modification using Error Bar
    Dynamic chart using naming series
    Sunburst Chart, Treemap
    Geo Map
    Combo Charts
    Statistical Charts (Histogram, Pareto Chart, Boxplot)
    Dashboard
    What is Dashboard?
    Overview on types of Dashboards
    Benefits of using Dashboard
    Things to consider before building Dashboard
    How to create Dynamic Dashboard in Excel
    Use Case #1 – Sales Dashboard
    Use Case #2 – Financial Dashboard
    ChatGPT With Microsoft Excel
    ChatGPT Excel Formula Writing
    ChatGPT Excel Formula Explanation
    ChatGPT Excel Formula Examples with Data
    ChatGPT Excel Formula Debugging
    Capstone Projects
    Project #1 – Manufacturing Dashboard

  • Data Visualisation using Power BI

    • US$325
    • Duration: 22 Hours
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English, Hindi, Gujarati
    • Certificate provided: Yes
    Introduction to BI
    What is BI (Business Intelligence)
    Importance of BI
    Different Tools of BI
    Get Started with Power BI
    Introduction to Power BI
    Overview: Power BI concepts
    User Interface of Power BI
    Sign up for Power BI
    Import Data from different Sources
    Import from various sources like Excel, CSV, Text, Website, Folder, SQL, SharePoint etc.
    Data Transformation - Power Query Editor
    Get data
    Reduce data
    Transform data
    Load data
    Building Data Model
    Introduction to Data Modelling
    Importance of Data Modelling
    Understanding of Primary Key vs Foreign Key
    Create, edit and delete relationship between tables
    Active vs In Active relationship
    Understanding of Snowflake Schema, Star Schemas
    Viz and Tiles
    Overview: Visualizations
    Creating, Modifying & formatting visualizations
    Create a new report
    Creating a report layout
    Use a slicer to filter visualizations
    Sort, copy, and paste visualizations
    Download and use a custom visual from the gallery
    DAX functions
    Understanding Data Analysis Expression
    Creating Calculated Columns, Measures
    Date and time functions
    Text Functions
    Logical Functions
    Related Functions
    Implicit vs Explicit Measures
    Statistics Functions
    Filter Functions
    X-factor Functions
    Time intelligence Functions
    Rank Functions
    New Table and Quick Measures
    Publishing Reports to Workspace
    Share Data within Organisation and to Others
    Publish a report to the web
    Manage published reports
    Share a dashboard
    Embed a report in Share-Point Online
    Capstone Projects
    Project #1 – Manufacturing Dashboard
    Project #2 – E-commerce Dashboard

  • SQL for Data Analytics

    • US$225
    • Duration: 15 Hours
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English, Hindi, Gujarati
    • Certificate provided: Yes
    Basics of Database
    What is Database?
    What is RBMS (Relational Database Management System)
    Introduction SQL
    What is SQL Query
    Usage of SQL
    What you can do with SQL
    User Interface of MySQL
    Installation of MySQL
    Various options in MySQL
    Starts working with MySQL
    CREATE, ALTER and DROP Database
    CREATE, RENAME and DROP Table
    Data Types and Constraints
    Foreign Key Constraint
    Unique & Check Constraint
    Data Manipulation
    Insert Data to Table
    Update Data in a Table
    Delete Data
    Basic Statements
    Select Statements and Alias
    Where Clause and Operators
    Sorting and Grouping Data
    SORT BY Statements
    GROUP BY Statements
    Wild Card Operations
    LIKE Clause and its application
    IF-THEN Statements
    CASE Clause
    Conversion Functions
    CONVERT and CAST Function
    Concept of JOINS
    Inner Join, Left Join, Right Join, Full Join and Self Join
    Retrieve data from Multiple Tables
    Other Important Functions
    DATETIME Function
    STRING Function
    MATH Function
    Concept of Subqueries
    Subquery with SELECT Statement
    Single Row, Multiple Row Subqueries

  • Python for Data Analytics

    • US$450
    • Duration: 30 Hours
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English, Hindi, Gujarati
    • Certificate provided: Yes
    Introduction to Python
    Installation Python
    Options for IDE (Integrated Development Environment)
    Installation of Anaconda Distribution and Jupyter Framework
    Basic Operations in Python
    Arithmetic Operations
    Variable Assignment
    String Operator
    Introduction to Lists
    Data types in Python
    Object, List, Array, Dictionary, Tuple, Set, Dictionary
    Numpy Library
    Importance and use of Numpy Library
    Data Handling in Python (Using Pandas Library)
    Import Pandas Library
    Import from .csv, .xls, text etc…
    Working with Data Frame (Using Pandas Library)
    Subset of the Data
    Adding / Deleting columns or Rows of the data
    Numeric Filter, String Filter, Filter with Multiple Conditions
    Sorting of the Data
    String Operations (Upper Case, Lower Case, Title Case, Replace)
    Summarize data
    Measurement of Central Tendency (Mean, Median, Mode)
    Measurement of Spread (Range, Variance, Standard Deviation)
    Quartile, Frequency Table
    Find Descriptive Statistics using single command
    Use of Group by function for Cross Tabulation
    Pivot Table in Python (Numpy and Pandas Libraries)
    Custom Function
    Define your own custom function
    Concept of Looping
    For Loop
    While Loop
    Data Visualization (Using Matplotlib Library)
    Bar chart, Histogram, Pie Chart, Box Plot, Scatter Plot, Matrix Plot
    Introduction to Testing of Hypothesis
    Null Hypothesis & Alternate Hypothesis
    Decision Rules, Types of Error, Level of Significance, p-value
    Parametric Test (Using Scipy - Stats Library)
    One sample t-test
    Independent two sample t-test
    Paired t-test
    ANOVA
    Introduction to Machine Learning
    Types of Machine Learning
    Supervised Machine Learning
    Unsupervised Machine Learning
    Reinforcement Learning
    Model Evaluation Approach
    Train and Test on the same dataset

    Train-Test Split
    K-Fold Method
    Linear Regression
    Model y = F(x), the Dependent Variable, Independent Variable, Intercept, Slope, Assumptions
    Simple Linear Regression
    Multiple Linear Regression
    Logistic Regression
    Sigmoid Function
    Use Cases
    Decision Tree Algorithm
    Decision Tree Regression
    Decision Tree Classifier
    Use Cases
    Random Forest
    Random Forest Regression
    Random Forest Classifier
    Use Cases
    Support Vector Algorithms
    Support Vector Regression
    Support Vector Classifier
    Use Cases
    Capstone Projects
    Project #1 – EDA of the Sales Data
    Project #2 – Healthcare Prediction using ML

Reviews

No reviews yet. Be the first one to review this tutor.