Conerlious_Portfolio
Data Analytics Portfolio Please check my Data Science Portfolio for more projects.
Project 1: Cyclistic Bike share - Case study
- Made recommendations on How can Cyclistic company convert casual riders/users to anual memebership? business task for a company called Cyclistic.
- I defined the problem and developed a business task based on the company’s problem statement.
- Data was collected from Motivate International Inc.
- Cleaned the data using R language and Excel.
-
Created visualisations using RStudio.
Project 2: Data Analysis Salary Estimator
- This project is about a tool i created which can be used to estimate data analyst salaries. The tool can be used by data analysts to negotiate their incomewhen they get new jobs.
- The tool features the expected data analyst skill and shows how companies value them for a certain income. I used Python, Tableau, AWS, Spark, R, SQL and R.
- Made use of Random Forest, Lasso and Linear Regressors using GridsearchCV to get the best model for the tool.
- Finally, i built a client facing API using Flask.
| Correlation Visual | Age, Avg_Salary, Rating |
|---|---|
 |
 |
| Avg_Salary | Positions by Sector |
|---|---|
 |
 |
Project 3: Revenue and Profit Analysis for Rickaby Hardware
Rickaby hardware is a company which supplies the hardware peripherals to different clients such as nomad stores etc. They have a head office in Mumbai India, and they have different regional offices in different cities of India. Dumisani Sagas is the sales director of this company, and he Is managing the business from the head office. So, what is happening with this company is that sales are declining and Dumisani as a sales director is having a lot of struggle tracking where the business is failing due to the size of the company which is big. When Dumisani calls his reginal mangers asking for information on why the sales are declining, unfortunately, his reginal managers are always giving him fuzzy and unclear information which can help him understand the root cause. In addition to that, they always give him big excel files of all transactions which is very difficult for Dumisani to transform all those excel sheets into insights. However, Dumisani calls for an emergency meeting with the sales director, marketing, customer, data analysis and IT teams.
Based on Dumisani’s request i managed to come up with
-
Revenue breakdown by cities.
-
Revenue breakdown by years and months.
-
Show top 5 customers by revenue and sales quantity.
-
Top 5 products by revenue number.
Revenue Analysis Dashboard
For interactive experience use this link to Revenue Analysis dashboard
Profit Analysis Dashboard
For interactive experience use this link to Profit Analysis dashboard
