AtliQ Hardware's is a consumer goods electronics company having operations in various countries.
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.
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.
- SQL
- PowerBI Desktop
- Excel
- Dax Language
👉 Data modeling plays a vital role and is considered as the basement of report. All the visuals will be build upon the data model
👉 In this project, we have followed Snowfall data modeling method
👉 Gross price
👉 Pre-invoice deductions
👉 Post-Invoice deductions
👉 Net Invoice sale
👉 Gross Margin
👉 Net sales
👉 Net profit
👉 COGS- Cost of goods sold
🔥 What are all the questions should be asked before staring the project
🔥 Creating calculated columns
🔥 Creating measure using DAX language
🔥 Data modeling
🔥 Using Bookmarks to switch between two visuals
🔥 Page navigation with buttons
🔥 Using KPI indicators
🔥 Conditional formatting the values in visuals using icons or background color
🔥 Data validation techniques
🔥 PowerBI services
🔥 Publishing reports to PowerBI services
🔥 Setting up personal gateway to set up the auto refresh of data
🔥 Collaboration, workspace, access permissions in PowerBi services
🔥 Uploading Large size files using GitHub LFS
🔥 Tracking the particular type of file extensions for LFS