Hi, I am Nishtha! I hold MBA degree in Finance & IT. I have done my engineering in Electronics before starting my career as quality assurance professional in Aug 2007.I have played several roles over the years such as Quality engineer, Project Delivery executive and KYC/AML Senior analyst.
Over the past 6 months I am transitioning myself into Data analyst career path through training from AnalytixLabs.
This is a repository that I have created to showcase skills, share projects and track my progress in Data Analytics / Data Science related topics.
In this section I will list data analytics projects briefly describing the technology stack used to solve cases.
In this section, there will be case studies/analysis performed on the given data using excel formulaes/macros.
Github link: https://github.com/JaisNish/Data-Analyst-Portfolio/tree/main/Data%20Visualization%20%26%20Analytics/Excel%20Assignments.
Description: There is a given data about airlines. Using excel formulaes/macros, please answer all the queries within the excel sheets.
Github link: https://github.com/JaisNish/Data-Analyst-Portfolio/tree/main/Data%20Visualization%20%26%20Analytics/Excel%20Assignments.
Description: There is a given data about sports events. Using excel formulaes/macros, please answer all the queries within the excel sheets.
In this section, there will be case studies/analysis performed on the given data which will help in understanding writing complex SQL queries to retrieve different kind of datasets.
Github link: https://github.com/JaisNish/Data-Analyst-Portfolio/tree/main/Data%20Visualization%20%26%20Analytics/SQL%20Assignments/Mobile%20manufacturer%20case%20study
Description: There is a given database cellphone information which contains details on the cell phone or transactions. Answer all the questions based on this data on the SQL queries.
Github link: https://github.com/JaisNish/Data-Analyst-Portfolio/tree/main/Data%20Visualization%20%26%20Analytics/SQL%20Assignments/Retail%20case%20study.
Description: A retail store would like to understand customer behaviour using their point of sale data(POS).
In this section, there will be case studies/analysis performed on the given data which will help in retrieving datasets and mapping the business objectives based on the Tableau report.
Tableau Public: dashboard
Github link: https://github.com/JaisNish/Data-Analyst-Portfolio/tree/main/Data%20Visualization%20%26%20Analytics/Tableau%20Assignments/Laptop%20sales%20case%20study
Description: One of the leading retail chains in London having more than 15 stores sells Laptops and accessories. The company would like to define product strategy and pricing policies that will maximise company projected revenues in 2016. Kindly create tableau report showcasing the necessary data based on the given queries.
Tableau Public: dashboard
Github link: https://github.com/JaisNish/Data-Analyst-Portfolio/tree/main/Data%20Visualization%20%26%20Analytics/Tableau%20Assignments/Sport%20equipment%20sales%20analysis
Description: Our client is a leading retailer of the Sports Equipments across the globe.Product manager of the company wants to analyze combined Revenue generated in year 2014 across different countries. As part of this case study, kindly retrive data as per the given questions.