Provide Insights to Management In the Consumer Goods Domain AtliQ Hardware is a consumer goods electronics company having operations in various countries.
Domain: Consumer Goods
Function: Sales
Problem Statement:
AtliQ's business is growing rapidly and they still rely on Excel files for data analytics. Excel files are hard to consume and not effective in generating insights. Also due to the lack of effective analytics, the company faced a major loss in Latin America.
Task :
As a data analyst, perform the following tasks
Get P & L statements for any customer/product/country or aggregation over any time period.
Get forecast accuracy, net error, and risk profile for product, segment, category, customer, etc.
A top-level dashboard for executives consolidating top insights from all dimensions of business.
Tech Stacks :
SQL
PowerBI Desktop
Excel
Dax Language
Data Model
👉 Data modeling plays a vital role and is considered the basement of the report. All the visuals will be built upon the data model
👉 In this project, we have followed the Snowfall data modeling method.
Home :
Financial View :
Sales View :
Marketing View :
Supply Chain View :
Executive View :
Understanding business P & L Statements :
👉 Gross price
👉 Pre-invoice deductions
👉 Post-Invoice deductions
👉 Net Invoice sale
👉 Gross Margin
👉 Net sales
👉 Net profit
👉 COGS- Cost of goods sold
PowerBI techniques Learnt :
🔥 What are all the questions that should be asked before starting the project
🔥 Creating calculated columns
🔥 Creating measures using DAX language
🔥 Data modeling
🔥 Using Bookmarks to switch between two visuals
🔥 Page navigation with buttons
🔥 Using KPI indicators
🔥 Conditional formatting of the values in visuals using icons or background color
🔥 Data validation techniques
🔥 PowerBI services
🔥 Publishing reports to PowerBI services
🔥 Setting up the personal gateway to set up the auto-refresh of data
🔥 Collaboration, workspace, and access permissions in PowerBi services
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent