Power BI
This page showcases a personal project developed using Power BI. It demonstrates the application of Power BI for data analysis, insight generation, and interactive report creation, highlighting the ability to deliver meaningful visualizations and data-driven insights that can be utilized in real-world business scenarios.
Regional Sales
Analyzed a dataset of 160k rows records related to bicycle products, focusing on reseller and internet sales. Utilized SQL for data cleaning and analysis, emphasizing sales trends and performance metrics.
Created a Power BI dashboard to visualize trends in product types, regions, and sales periods. A report recommending inventory management and optimization strategies for sales was also developed.
The report highlights total sales, costs, and gross profit, with geographical insights displayed on a map.
HR Resources
Utilized Kaggle and AI-generated data to conduct an in-depth analysis of employee data, providing valuable insights to support strategic decision-making in the HR department. Dynamic measures and filters were employed to maximize the efficiency of data exploration and visualization.
Power BI dashboard was designed, consisting of three individual pages, each systematically classifying and analyzing HR resources according to various metrics. This dashboard enables in-depth analysis of employee performance and resource allocation, clearly demonstrating the efficiency of HR management.
Financial Report
Conducted an analysis using SQL to derive insights on sales trends and performance metrics from a dataset containing 15k records of company sales data. The dataset included information on product lines and discount rates.
Independently performed data cleaning and analysis to evaluate the impact of discount rates, customer segments, and enterprise characteristics on sales rates and profits. Built a performance dashboard in Power BI to visualize trends in sales performance across different segments and discount strategies, providing actionable insights and recommendations for the sales and marketing teams.
US Natural Disasters
Utilized a dataset from Kaggle summarizing natural disasters in 2017 to analyze the impact of these events on various states. The analysis focused on key metrics, including death rates, financial losses, and the frequency of natural disasters across different regions.
This project aimed to identify patterns and correlations between natural disasters and their effects on each state, providing insights that can inform disaster response strategies and policy-making.
