This repository differs widely from the previously created ones in a lot of unique aspects. In this repository, I dived into solving real life data analysis job scenarios and answering useful business intelligence questions. The Main aim of the Projects was to give as much Analysis that can be carried out following the questions we wanted out of the data and also look into spaces where there might be need to perform some EDA. The Datasets were picked from the best among other datasets in the Internet, mostly from The Forage where you can get real life Data Analytics Job simulations to help enlighten your understanding of the profession.
The Projects in this repository provided valuable insight that an Analyst can use to get further into what part of the datasets he is looking to put most of his time and analysis into.
BI ANALYTICS PROJECTS
-
Customer Retention Analysis : This project focused on analyzing the reasons for customers quitting and understanding where it actually has impact the most, then we look for Solutions that can drive the Retention Manager to a fruitful Operation.
Particularly, we are going to be focusing on dragging out the reasons for the churning from the Minority of the dataset columns, running uni-variate and Bi-variate analysis between occasions to understand fully where people churned and where they didn't.
We performed data cleaning with Microsoft Excel and little of MySQL, after which an interactive dashboard was created in POWER BI for deriving useful insights. We finished by running report on PYTHON and also R programming languages, generating script that contains Uni-variate and Bi-variate Analysis and also Graphs and Bar Charts. -
KPMG Data Analytics (Relational Database) : This Project will focus on analyzing the profit and sales margin of Sporty Rocket Central, a firm that deals with bicycle sales across America.
The Project was gotten from KPMG Data Analytics Virtual Internship job Simulation on The Forage.
The Project was seen as a means to further my undestanding in data analytics, i cleaned the dataset with Microsoft Excel to avoid much minimal errors, I then created a database in the MySQL server and also in MS SQL server that helped me with my understanding of Joins, ETL, SSIS
i Delivered a nice Power BI dashboard that helped understand the questions we asked from the very beginning. and also I wrote codes in Python an R programming Languages to understand our question and finally, give the answers we feel is highly correct.
Understanding the process in data analytics gave me the knowledge to bring business out of their problems and offer the best solution possible with the available resources. this is a work well done and i look forward to completing other projects in the future. Thanks