Portfolio
Welcome to my portfolio page, where you can see some of the data analysis projects I have completed. Please explore more to go to the detailed page, where you can learn more about the data sources, methods, tools, and results. I hope you enjoy exploring my portfolio and feel free to contact me if you have any questions or feedback.
Navigating Road Safety
This report evaluates the effectiveness of distracted driving laws in British Columbia from 2004 to 2019, focusing on their impact on road safety metrics.
Ecommerce Sales Analysis
Utilizing MySQL and Excel, an analysis of an ecommerce company sales data to find out how traffic sources, landing pages, conversion rates and products affect revenue.
Human Resources Dashboard
The Human Resource Dashboard is a Power BI solution for HR data. It shows HR metrics such as headcount, attrition, diversity, performance, and engagement in interactive dashboards.
Patient Healthcare Report
An analysis of survey results of patients’ perspectives on hospital care performed and presented on Excel, detailing hospital scores, linear regression trend lines and areas of progresss.
Executive KPI Dashboard
A Power BI dashboard of top-level KPIs for the executive team, highlighting performance in key areas, including sales trends, product performance, key customers, and shipping costs.
Customer Satisfaction Report
A Power BI report of customer satisfaction survey scores, including a Likert scale and a gap analysis for the different factors contributing to customer sentiment.
Creating Custom Fiscal Calendars
Developed in Power Query using M code, this template creates custom fiscal calendars. It allows for the selection of start and end dates, number of weeks in a year, and the quarterly week structure.