AtliQ Hardware, a leading electronics company, faced financial loss in their Latin American expansion due to relying on surveys and Excel-based decisions. To surpass competitors like HP and Dell, they are implementing Power BI to enhance data-driven decision-making.
The project aims to onboard data analysts and develop user-friendly dashboards for finance, sales, supply chain, marketing, and executive views to deliver actionable insights by improving data transparency and accuracy.
🔗 [Live Dashboard] (https://app.powerbi.com/view?r=eyJrIjoiM2YyMTQyMWMtYzZkYi00YzE5LWFlNzUtMzNjNGM4YTBhOGRjIiwidCI6ImM2ZTU0OWIzLTVmNDUtNDAzMi1hYWU5LWQ0MjQ0ZGM1YjJjNCJ9)
👨💻 Tech Stacks
• SQL
• Power BI Desktop
• Excel
• DAX Language
• DAX Studio (For optimizing the report)
🎓 Power BI Fundamentals
• Creating calculated columns
• Creating measures using DAX language
• Data modelling
• Using tooltips to save page area
• Creating Toggle button to switch between two visuals
• Using Bookmarks to switch between visuals
• Page navigation with buttons
• Using divide function to prevent zero division errors
• Creating date table using M Language
• Dynamic titles based on applied filters
• Using KPI indicators
• Conditional formatting in visuals
• Data validation techniques
• Publishing reports to Power BI Services
• Setting up Personal Gateway for auto-refresh
• Creating workspace and access permissions in Power BI Services
💼 Business Jargons
• Gross Margin, Gross Margin %
• Pre-Invoice Deductions
• Post-Invoice Deductions
• Net Invoice Sales
• Net Sales
• Absolute Error
• Forecast Accuracy
• Risk (Excess Inventory, Out Of Stock)
• Net Profit, Net Profit %
• COGS (Cost of Goods Sold)
• YTD (Year to Date)
• YTG (Year to Go)
• Direct
• Retailer
• Distributor
• Consumer
• Brick & Mortar
• E-commerce
Soft Skills
• Project Initiation: Team creation, Writing Emails, Sharing details via email
• Project Management: About project charter document.
• Stakeholder Mapping: Analysis and management
• Effective Communication: Engaging with stakeholders and managing feedback
• Domain Knowledge: Sales, finance, marketing, supply chain , executive.
AtliQ Hardware is an electronics company that sells computers and accessories globally through two platforms:
• Brick & Mortar: Physical Stores (e.g., Chroma)
• E-Commerce : Online stores (e.g., Amazon, Flipkart)
They sell accessories through three different channels:
• Retailer
• Direct
• Distributor
AtliQ Fiscal Year starts from 1st September to 31st August
• Import datasets from MySQL database and Excel/CSV file to Power BI by providing the database access credentials.
• Use Snowflake Schema approach to build relations between tables for visuals.
• Based on mock-ups received from business stakeholders, design visuals and create measures as required.
1) Home View
• All view buttons will be available, leading to specific pages:
a.) Information
b.) Finance View
c.) Sales View
d.) Marketing View
e.) Supply Chain View
f.) Executive View
g.) Support
2) Page Navigation Menu Panel
• It includes home, finance, sales, marketing, supply chain, executive, filter pane, information and support icon on clicking on it will lead to that page.
3) Page Navigation Filter Pane
• It includes Back to Menu button which will lead to menu panel.
• Further it also includes slicers according to year wise, quarter wise, region wise, country wise, category wise, abbreviations and clear all filter button.
4) Scroller Header Bar Visual
• It includes heading of specific page and for that specific measures have been created.
5) Finance View
• Detailed financial analysis, including revenue, expenses, and profit margins.
• Benchmarks against previous year and target goals for budgeting.
6) Sales View
• Insights into product and customer performance.
• Enhance customer relationship management
7) Marketing View
• Regional and product-wise market performance reports.
• Identified market trends and tracked KPIs.
• Enhance brand awareness and customer interaction.
8) Supply Chain View
• Analysed forecast accuracy, net error, and absolute error trends.
• Developed metrics for managing supply by customers and products.
9) Executive View
• Important metrics for high- level management decisions.
• Developed an executive dashboard for real-time performance monitoring.
• Visualized revenue by division, customer, product, and channel including donut chart, ribbon chart, area chart and column bar stacked chart for manufacturers.
• The dashboard offers actionable insights, enabling AtliQ to make informed choices that enhance profitability and streamline operations.
Please take a moment to share your valuable thoughts and suggestions on email id : shvetamaini6@gmail.com . I shall be very thankful to all of you.