In this HR data analysis case study, I undertook the task of exploring a dataset for a fictitious software company. The goal of the study was to import, analyze, and visualize Human Resources data in Tableau. The dataset was downloaded from kaggle and cleaned in pgadmin prior to analysis. ... Read more
In this project i have performed data analysis and visualization for healthcare system data of flu shots using SQL and Tableau. Data is downloaded from synthea which is an open source platform for healthcare data. Using this data I will be summaryzing the flu shots analysis in 2022. I have designed and developed a flu shots dashboard which shows : ... Read more
In this project i have worked on a fast food chain in Brazil named vivendo with over 200 outlets. Customers often claim compensation from the company for food poisoning. The legal team processes these claims. The legal team has offices in four locations. The legal team wants to improve how long it takes to reply to customers and close claims. The analysis is provided for the legal team as team wants to improve the time it takes to reply to customers and close the claims. I used pgadmin for validation and cleaning of data. Tableau is used for the data visualization purpose.Here i listed each task performed in the question, answer format. ... Read more
In this project, I will be working with data from investment firm to analyze trends in high-growth companies. The goal is to identify industries which are producing the highest valuations and the rate at which new high-value companies are emerging. This data will provide insightful information to give investment firms a competitive insight about the ongoing industry trends and how they should structure their portfolio looking forward. ... Read more
In this tutorial I share how to import csv data files into a locally running postgresql on a docker container using python libraries pandas, sqlalchemy ... Read more
In this project, I used 2016 airbnb data from seattle and visualize it using Tableau to get deeper insights into pricing trends. ... Read more
In this project I have worked with data provided by the United States Social Security Administration, which lists first names along with the number and sex of babies they were given to in each year. For processing speed purposes, we've limited the dataset to first names which were given to over 5,000 American babies in a given year. Our data spans 101 years, from 1920 through 2020. ... Read more
In this project, we'll explore the top 400 best-selling video games created between 1977 and 2020. We'll compare a dataset on game sales with critic and user reviews to determine whether or not video games have improved as the gaming market has grown. ... Read more