Manish Chauhan Advanced Excel, Database, SQL
No reviews yet

My greatest passion in life is teaching. I was born and brought up in Jharkhand and experienced great success at school and at university due to amazing and unforgettable teachers. This is the foundation of my commitment to helping out my students, whatever their abilities may be. Currently, I completed masters degree specializing in Business Analytics and Machine Learning. I have been tutoring and teaching for 3 years in various settings – tutoring small and large groups, private individual tutoring, and teaching in rural, suburban, and urban classroom and home settings. I have taken various subjects ranging from Physics, Chemistry, Math, English, Hindi, Social Science, Computer Science Foundation, Excel from basic to advanced including macros, SQL from basics to complex and optimized queries, Database from basics to designing schemas. I have a very unique style of teaching, i don't follow the traditional teaching style rather i follow teaching methods which is more visual based because our brain works very well with pictures rather than complex equation and texts. This method of teaching helped a lot of my students.

Subjects

  • PySpark Beginner-Intermediate

  • GIT Beginner-Expert

  • Statistics and Probability Beginner-Intermediate

  • Microsoft Power BI Beginner-Intermediate

  • Power Query Beginner-Intermediate

  • Python 3 Beginner-Intermediate

  • SQL RDBMS Beginner-Intermediate

  • Excel Advanced Beginner-Expert

  • Azure DataBricks Beginner-Intermediate

  • Azure Fundamentals AZ-900 Beginner-Expert

Experience

  • Business Analyst (Dec, 2022–Present) at Amazon Development Centre
    Querying database by writing complex sql queries, Automation using python,hypothesis testing, statistical analysis, project management.

Education

  • PGDM (Jun, 2018–Oct, 2020) from PGDBM from Welingkar, Bangalore–scored 7/10

Fee details

    ₹700–1,000/hour (US$8.39–11.98/hour)

Courses offered

  • Introduction to SQL from basic to Advanced

    • ₹9000
    • Duration: 40 hours
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English
    • Certificate provided: No
    In this course, i will teach you all the fundamentals concepts of SQL language. After learning the basics, we will practise a lot of problems asked in interviews of companies like Amazon, Microsoft, Google etc. The next phase will be building the intermediate to advance concepts and then will finish the course with some real life projects.

    Course details:
    1. Creating database and tables.
    2. Inserting data into tables.
    3. Basic SELECT, FROM, WHERE clauses.
    4. HAVING clause and differnce between WHERE and HAVING.
    5. JOINS and UNIONS.
    6. Sub Queries.
    7. CTE tables
    8. WINDOWS Functions.

  • Introduction to statistics

    • ₹10000
    • Duration: 40 hours
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English
    • Certificate provided: No
    Topics covered:
    1. Measurment of data
    2. Measure of central tendency
    3. Measure of variation
    4. Data visualization
    5. Introduction to hypothesis testing
    6. One sample-two sample z-test
    7. One sample t-test, two sample t-test with equal/unequal variance, paired sample t-test.
    8. F-test for significance
    9. ANOVA one way and two way.
    10. Probability distribution
    11. Correlation analysis
    12. Introduction to regression analysis.
    13. Simple linear regression.
    14. Multiple linear regression.

  • Python a beginners guide

    • ₹7000
    • Duration: 30 hours
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English
    • Certificate provided: No
    Course details:
    1. Data types in python.
    2. IF condition and For loops
    3. User defined functions.
    4. Numpy and Pandas.
    5. Matplotlib
    6. Data analysis using python

  • Introduction to power bi

    • ₹10000
    • Duration: 40hours
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English
    • Certificate provided: No
    Course details:
    1. What is power bi and what's its use.
    2. Components of power bi.
    3. Introduction to power query.
    4. Importing data in power bi.
    5. Data modelling.
    6. DAX
    7. Visualization in power bi
    8. Publishing the power bi report.

Reviews

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