Skip to content
View JyotiVGupta's full-sized avatar
1 follower · 1 following

Block or report JyotiVGupta

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
JyotiVGupta/README.md

🙋‍♀️ Hi!! I’m Jyoti

I am a certified Consulting Data Analyst with over 3 years of experience working for clients across various industries (Telecommunication, Healthcare, Pharmaceutical, Recruitment, Travel, and Logistics). Specialization includes Tableau, Alteryx, and SQL. Skilled in end-to-end project execution, from designing and building customized data solutions to effectively engaging with stakeholders. Proficient in client and stakeholder management. Notable achievements include scoping and developing an efficient Active Support Ticket tracker dashboard which boosted resolution efficiency by 40%. . 🚀📊

LinkedIn

Portfolio/Profiles

Tableau Public: https://public.tableau.com/app/profile/jyoti.v.gupta/vizzes

Alteryx Community: https://community.alteryx.com/t5/user/viewprofilepage/user-id/263782

Alteryx Mentor Connect: https://mentor.alteryx.com/advisors/advanced-analytics/jyoti-gupta-12fe317c-e618-4047-ae17-c858c32a36e2?q=Jyoti

Resume: https://jyotivgupta.github.io/portfolio/

Certifications


 
 
 

Data Viz Projects

   

SQL Challenges

◈ Murder Mystery Challenge

(click the image to open the repository)

SQL Techniques Used

  • Queries with constraints (WHERE, AND/OR, IN, BETWEEN, LIKE, etc.)
  • Filtering and Sorting Query (e.g. ORDER BY, and LIMIT)
  • Table Joins

◈ Preppin'Data Challenges using SQL

 
 
(click an image to open the corresponding repository)

SQL Techniques Used

  • Common Table Expressions and multi-key Joins
  • Aggregation and column type conversion
  • Queries with constraints (WHERE, AND/OR, IN, BETWEEN, LIKE, etc.)
  • Filtering and Sorting Query (e.g. ORDER BY, and LIMIT)
  • Table Joins
  • Pivot & Removing Duplicates

◈ 8WeeksSQLchallenges

(click an image to open the corresponding repository)

SQL/Snowflake Techniques Used

  • Common Table Expressions and multi-key Joins
  • Aggregation and column type-conversion
  • Queries with constraints
  • Filtering and sorting
  • CASE Statement

Pinned Loading

  1. Recruitment-Analysis-Dashboard Recruitment-Analysis-Dashboard Public

    This repository highlights the Alteryx data preparation techniques I used to create a fake dataset for my Tableau dashboard project showcasing the financial aspect of the recruitment process.

    1

  2. 8-Week-SQL-Challenge-Case-Study-1 8-Week-SQL-Challenge-Case-Study-1 Public

    SQL solution to the Case Study #1 - Danny's Diner

  3. SQL-Murder-Mystery SQL-Murder-Mystery Public

    exercise meant as a way to practice SQL skills

  4. Preppn-Challenge-2023-Week-2 Preppn-Challenge-2023-Week-2 Public

    Solving Tableau Prep challenge 2023 Week 2 using SQL/Snowflake

  5. Preppn-Challenge-2023-Week-3 Preppn-Challenge-2023-Week-3 Public

    Solving Tableau Prep challenge 2023 Week 3 using SQL/Snowflake

  6. Preppn-Challenge-2023-Week-4 Preppn-Challenge-2023-Week-4 Public

    Solving Tableau Prep challenge 2023 Week 4 using SQL/Snowflake