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
7.Power Pivot
8.Pivot Table
9.Advanced Functions like Lookups & Calculate

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

The goal is to be one report which could be used by stakeholders from sales, marketing, finance, Supply Chain and executive team.

1. Robust Data Modeling
2. Analyzing according to Business Concepts
3. Clear Visuals to get Insights and Outcomes

I learned the following things:

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

Every day, tens of thousands of customers buy hardware electronics from AtliQ.
Depending on region, markets and products we can use this data to understand customer preferences for sold quantity, forecast accuracy, discounts and Net sales. And we can use this to raise sales and customer satisfaction.

Features Used:
1-Views.
2-Stored Procedures.
3-User Defined Functions.
4-Window Functions.
5-CTE.
6-Subquery.

......and more.

Project Details

The Situation:
Adventure Works Cycles, a global manufacturing company, wants to design and deliver an end-to-end business intelligence solution to have a way to track KPIs sales, revenue, profit, returns), compare regional performance, analyze product level trends and forecasts, and identify high value customers.

THE OBJECTIVE:
Use Power BI Desktop to:
Connect and transform the raw data.
Build a relational data model.
Create new calculated columns and DAX measures.
Design an interactive report to analyze and visualize the data.

Features and techniques used:
Connecting to server.
Cleaning Data using Power Query.
Data modeling.
Dax Functions.
Calculated Columns.
Visualizing Data.

Live Interactive Dashboard