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 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

Live Interactive Dashboard

Project Details

As part of the CodeBasics SQL Challenge, I conducted a comprehensive analysis for Atliq Hardware, an imaginary computer hardware company, integrating SQL queries and Power BI visualizations. The project involved addressing ten business questions ranging from market segmentation to sales performance. Notable achievements include identifying APAC markets, calculating unique product increases, and determining high-performing customers. Leveraging SQL for data analysis and Power BI for visualization, this project showcases my proficiency in extracting meaningful insights from complex datasets and translating them into actionable business intelligence. The skills demonstrated include data querying, analysis, and visualization, making it a valuable addition to my portfolio, and highlighting my capabilities in business data analytics.

Project Details

The objective of this pilot project is to conduct a thorough examination of customer growth and revenue patterns at Shield Insurance Company.

⚒️Tools Used :
✅Ms-Excel
✅Power-BI
✅Canva (ppt)

🎯 Key Focus Area:
✍ Tracking customer and revenue
✍ Daily revenue and customer growth rate
✍ Sales mode Analysis
✍ Trends in customer and revenue growth
✍ Age group analysis

🌟 Lessons learned from the dashboard

✨Premium: The amount of money paid by the policyholder to the insurance company for coverage.

✨Policy: The contract between the insured and the insurer that outlines the terms and conditions of the insurance coverage.

✨Coverage: The protection provided by the insurance policy against specific risks or events.

✨Claim: A formal request made by the insured to the insurance company to seek compensation for covered losses or damages.

Live Interactive Dashboard