This Website will exhibit my 5 core skills
And also to show some of the projects that I have done

My core skills as a data analyst are:

  1. Profficiency in Excel
    • Pivot Tables
    • Data Validation
    • VBA Macros
  2. Intermediate knwoledge in SQl
    • Data Cleaning
    • Data Manipulation
    • Data Transformation
  3. Intermediate knwoledge of Data Visualisation, using:
    • Excel
    • Power BI
    • Tableau
  4. General Knowledge of Python
    • Data Frames with Pandas
    • Webscraping with BeautifulSoup
    • Data Visualisation with Matplotlib and Seabon
  5. General Knowledge of R
    • Documentation and presentation with (R Markdown)
    • Data Visualisation with ggplot2
    • Statistics with Hmisc

Projects Using SQL (Sturctured Query Language)

For this project I used SQL since the data was too large to work with in excel. I applied data cleaning methods

I Extracted the Nashville housing data, cleaned it and organised it for Visualisation using SQL

Data Visualisation Using Excel

I created a dashboard based on a company selling multiple products, analysing how much revenue the company was generating. so divided my analysis into four categories in the company 1. Sales by individual stores 2. Sales by individual sales persons 3. highest selling product 4. Total Sales

From a bike selling company dataset,I created a dashboard showing 1. average income per gender, per bike purchase. 2. purchased bikes per group. 3. average distance per customer comute. 4. cars owned per bike sales

Data analysis projects in jupyter notebooks

To analyze the Sales Report from 12 months worth of data. the data comes in 12 individual files representing the sales of that month, and my job is to analyze the data and give recommendation per question asked

Used youtube API to scrape data from my favourite youtube channels and analyzed the data they contained

Used python libraries to scrape the EPL website in order to collect data that I will in turn load to a database and query it

Projects Using SQL inside jupyter notebooks (SQL Magic)

On this Project I was given three sets of tables 1. Chicago_Crime_data 2. Chicago_Public_Schools 3. Census_data And I had to perform analysis on this data and produce answers to the given questions.

On this Project I am desplaying my skills of access IBM database using python. I use the API that I get from the db2 services in IBM and use it to connect to the databases in order to access the dataset that I need to work on

Projects Using R

On this project I used 'tidyverse, skimr, and janitor' libraries to help me perform data analysis in R, and from the tidyverse library I used ggplot to visualize my findings

I was dealing with a large dataset in this project and using R made working (cleaning and manipulation of data) with dataset a lot easier using libraries like gglot to visualize the data gave me alot of control in how I displayed my visuals