Using a Supply chain data set obtained from kaggle I constructed fact and dimension tables in Microsoft SQL server. ETL was done in Power Query. Subsequenty A STAR Model was built in Power BI where I also formed relevant dax measures to create this dashboard.
This project investigates diverse facets of gender and income trends in the United States across multiple decades. Split into four sections, each section delves into distinct aspects of the gender-income relationship, employing a range of statistical tests to uncover meaningful insights.
Power BI and DAX code was utilised to create this Dashboard, developed using a Human Resources Data set obtained from Kaggle.
This Dashboard was created using Power BI, measures were formed using DAX Code. Using a SuperStore Data Set from the years 2015-2017.
This is a data exploration project using MYSQL to analyse the London Housing Market from the years 2001-2018. Tables used: Monthly Data and Yearly Data.
In this project, I used MySQL to tidy up raw data I scraped in an earlier project. This was done to preprocess the data, a crucial step within the data analysis workflow.
This project invovled using python to webscrape 400 pages of data from the Reed.co.uk website. This code gathered raw data contained within over 10,000 job posts.
Portfolio Projects
by edward-renton1.
I am a graduate of Lund University, holding a BSc in Business and Economics with a focus on International Business. Originally from the UK, I've been based in Sweden since the start of my studies.
Following my graduation, I embarked on a journey into the realm of data by obtaining the Google Data Analytics Professional Certificate. This initial step was followed by additional online courses in SQL, Power BI, and more recently, R.
I'm currently wokring as an Analytics Consultant at Lunicore Student Consulting, whilst undergoing Swedish language studies.
For inquiries, feel free to reach out to me via email: edwardmrenton@gmail.com, or connect with me on LinkedIn: .