Projects

Bank Loan Analysis Dashboard

This project involves the creation of a comprehensive dashboard to analyze bank loan data. The dashboard provides key insights into various aspects of the bank's loan portfolio, including loan applications, funding, interest rates, and more. It is divided into three main pages, "Summary" and "Overview," and "Details" each offering different levels of detail and analysis.......

Data Analytics Python Project with Quantium

In this project, we completed a job simulation focused on Data Analytics and Commercial Insights as part of the Quantium Data Analytics Job Simulation. This Python-based project involved developing expertise in data preparation and customer analytics, where we utilized transaction datasets to extract valuable insights and deliver data-driven commercial recommendations. We extended our analytical capabilities by identifying........

Coffee Shop Sales Analysis Dashboard

This project analyzes the sales data of a coffee shop, focusing on identifying sales trends, top product categories, and customer behavior patterns. The insights derived from this analysis will help in optimizing inventory, designing targeted marketing strategies, and improving overall customer satisfaction.....

Evaluating Solar Footprints in California: A Statistical Analysis of Spatial and Technoeconomic Factors

This research project investigates the factors influencing solar installations in California, focusing on solar footprint sizes, installation types, and technoeconomic efficiency. The study evaluates how proximity to electrical substations, urban versus rural settings, and substation voltage levels impact solar energy adoption. Statistical analyses were conducted using SPSS, including correlation, independent samples t-tests, and chi-square tests........

AdventureWorks Sales Analysis Dashboard 

The Adventure Works Sales Analysis project centers around a detailed examination and visualization of sales data for the years 2005 to 2008. This comprehensive dashboard offers insights into various Key Performance Indicators (KPIs) and overall business performance, facilitating strategic.....

Ecommerce Sales Analysis Power BI Dashboard 

The aim of this project is to analyze the sales performance of a company in the year 2011 to 2014. With increasing competition, understanding sales trends and identifying key factors influencing performance are crucial for strategic planning. Our objectives are to  analyze total sales, total orders and total profit.....

Bank Loan Analysis - SQL Project

In this SQL project we will utilize advanced querying techniques to present our findings in a clear and concise manner. This will enable stakeholders to easily interpret the results and make informed decisions based on the insights derived from the Bank Loan Database.

In addition, we plan to implement strict data security......

Human Resource Dashboard - PwC Project

This project focuses on creating an interactive human resources dashboard for PwC to track key metrics related to employee demographics, performance, and promotions. The dashboard provides insights into the workforce, allowing management to make data-driven decisions. This dashboard empowers HR departments to monitor workforce composition, identify potential gaps, and assess performance across different demographics.........

Accenture North America Data Analytics and Visualization Job Simulation on Forage

This project aims to analyze the content categories on Social Buzz, a rapidly growing technology platform, to identify the top 5 most popular content categories. With a vast amount of user-generated content, understanding the popularity of different categories is essential for strategic content planning and enhancing user engagement.......

Call Centre Analysis - PwC Project

This project involves the analysis and visualization of data from a call center for PwC Switzerland. The goal was to provide key insights into call center performance and agent efficiency to help improve customer service. The dashboard allows filtering based on various criteria, such as agent performance, satisfaction ratings, and call topics, to help decision-makers optimize operations. It delivers a comprehensive view of call center performance, enabling PwC Switzerland to enhance customer satisfaction........

Online Retail Store Sales Analysis

In this project, I analyzed data from an online retail store, focusing on identifying key insights such as monthly revenue trends, top-performing products, highest-revenue regions, and customers with the most purchases. 

Road Accident Analysis Dashboard

The aim of this project is to analyze road accident data to identify key trends and factors contributing to road accidents in 2021-2022. Understanding these metrics is crucial for developing targeted safety measures and reducing casualties. 

Retention Analysis Dashboard

Welcome to the Retention Analysis Dashboard, developed entirely using Power BI. This interactive dashboard offers a deep dive into customer retention metrics and service statistics, enabling businesses to understand customer behavior and enhance retention strategies effectively.

HR Analytics Dashboard

The aim of this project is to analyze the HR metrics and workforce demographics of a company for the year 2024. Understanding these metrics is crucial for strategic planning in employee retention, satisfaction, and overall workforce management.