Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

Project video

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project
1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Project video

Project Details

I took on the role of a Marketing Data Analyst, working with a survey that gathered responses from 10,000 people across ten cities. My job was to turn these survey results into useful insights:

SQL: I delved into the data using SQL, a tool that helps us dig deep and find important information.
Power BI: I used Power BI, another tool, to create clear and interesting charts and graphs. This helped the Marketing team understand the data better and make smart decisions.
These insights helped the Marketing team make smart decisions. This project also helped me get better at using SQL and Power BI. It's a great example of how data can help us make important choices in the world of marketing.

Project video

Project Details

In this project, we embark on a journey to gain a deeper understanding of our customer base and revenue generation at Shield Insurance. We prioritize tracking customer numbers and total revenue, while also closely monitoring daily growth rates for both. This real-time monitoring ensures we stay on course towards our goals.
I've tackled the following aspects:
Understand how many customers they have and how much money they make.
Keep an eye on how fast the money and customer numbers are growing every day.
Looked at how the insurance policies change from one month to another to spot trends and areas to improve.
Sorting the customers by age groups and see which cities and age groups make the most money and have the most customers.
Used filters like sales methods, age groups, cities, months, and policy IDs to analyze our data faster.
Separate page to study how different age groups impact the business - like what policies they prefer and how they settle claims.

Project video

Project Details

In this project I studied the dashboard data to understand how introducing 5G has influenced our business.

1. Identified Underperforming KPI: Pinpointed which key performance indicator (KPI) hasn't met expectations since the 5G launch.

2. Plan Performance Evaluation: Analyzed revenue trends to determine which plans are thriving and which ones need improvement.

3. Strategic Plan Assessment: Evaluated if any plan has been significantly affected by 5G and advised whether it should continue or be discontinued.

4. Plan Changes Post-5G: Examined if any plans have been stopped after the 5G launch, and provided reasons for these decisions.

5. Insights for Informed Decisions: Offered valuable insights that guide smart choices for future strategies and business growth.

Project video

Project Details

Handled 10 Unexpected SQL Tasks:
Managed a range of immediate SQL requests to help the company make better decisions. Gained a deeper understanding of important SQL concepts like Common Table Expressions (CTE), different ways to join data, and using window functions. Used these skills to work with and analyzed the database information.
Skillfully applying these concepts, I successfully transformed raw data into actionable insights, contributing to a more informed and strategic approach for the company's future endeavors.

Project video