I analyze this sales data for Contoso Stores to understand their Sales Financial Performance,
identify growth opportunities, and address pain points for future planning.
In this project I answered 5 questions which was analyzed in the dashboard.
1. What is the best and least selling product category?
2. What is the highest selling store?
3. Daily and weekly sales.
4. Which country has the highest sales?
5. The business KPIs.
As an Analyst at Ray Gadgets, my task involves building an efficient Data Model,
create multiple dashboard that contains, A summary dashboard with KPIs metrics,
diagnose what happen in specific month, Profitability analysis and create a calendar table.
This should help minimize redundancy, boost performance speed, gives real and live report that update itself
and enable streamlined analysis of profit across diverse product categories of the business.
I Leverage the Power BI workflow by using the ETL to extract the data from excel,
transforming and cleaning the data in power bi Query Editor and Loading the data to power bi service for analysis.
Understanding primary and foreign keys is very crucial as it creates relationship among tables, Fact and Dimension tables play key roles also.
This project involves analysing Hospital data containing 28 columns and 230 rows of doctors and patients’
information to improve the financial and operational performance of the hospital.
The hospitality industry faces significant challenges, from seasonal fluctuations and complex pricing dilemmas
to understanding customer behavior and staying competitive. This project is designed to tackle these issues head-on by:
1. Enhancing Customer Experience: By analyzing booking data and customer behavior, the aim to personalize guest experiences, leading to higher satisfaction and repeat business.
2. Optimizing Revenue: Through predictive analysis, setting dynamic pricing strategies to maximize revenue while staying competitive.
3. Improving Operational Efficiency: Accurate demand forecasting will help in allocating resources effectively, reducing costs and enhancing service quality.
4. Gaining Competitive Advantage: I analyze competitor data to stay ahead of market trends and refine our strategies for a stronger market position.