AtliQ Hardware, a leading global manufacturer, embarked on a journey to harness data-driven insights crucial for informed decision-making across various business domains. They were facing challenges in finding the insights from the data so we were given the task to create reports and dashboards and find the insights from the data they provided to us.
โก Power BI
โก Power Query Editor
โก DAX Language
โก DAX Studio (for report optimization)
โก Project Management tools
๐น Project initiation questions ๐น Calculated column creation ๐น Measure creation using DAX language ๐น Data modelling โ Snowflake Schema ๐น Utilizing Bookmarks for visual switching ๐น Page navigation with buttons ๐น Creating date tables using M language ๐น Dynamic titles based on applied filters ๐น Using KPI indicators ๐น Conditional formatting in visuals ๐น Data validation techniques ๐น Power Bi services ๐น Publishing reports to Power Bi services
โ Gross price โ Pre-invoice deductions โ Post-invoice deductions โ Net Invoice sale โ Gross Margin โ Net sales โ Net profit โ COGS - Cost of goods sold โ YTD - Year to Date โ YTG - Year to Go
CALCULATE, ALLNOBLANKROW, RELATEDTABLE, SAMEPERIODLASTYEAR, SWITCH, HASONEVALUE, ISCROSSFILTERED, IF, DIVIDE, etc
Cards & KPIs, Table & Matrix, filtering, Bookmark, Button, Tooltip, Drill Through, tools like Conditional formatting and Top N slicers, and report navigation helped to add interactivity. Charts used - Donut, Scatter, Area, Ribbon, Waterfall, Line and clustered Column.
๐ ๐๐ข๐ฏ๐ ๐๐ฎ๐๐ต๐ฏ๐ผ๐ฎ๐ฟ๐ฑ ๐๐ง๐ญ๐๐ซ๐๐๐ญ๐ข๐จ๐ง: โ https://lnkd.in/dwyq6u7e
๐ฝ๏ธ ๐ฃ๐ฟ๐ฒ๐๐ฒ๐ป๐๐ฎ๐๐ถ๐ผ๐ป ๐ฉ๐ถ๐ฑ๐ฒ๐ผ: - https://lnkd.in/dnaVeQwn