Atliq-Financial-Analytics-Report ๐๐๐ฃ๐๐๐ญ๐ข๐ฏ๐ AtliQ Hardware, a hardware retail company, offers a range of products such as PCs, mouse, printers, etc. Its customers like Croma, Amazon, Best Buy Flipkart, etc. Tasked by AtliQ's Business users, the objective is to harness data from files containing over 1.5 million records to prepare sales and financial reports.
S๐ญ๐๐ฉ๐ฌ ๐ข๐ง๐ฏ๐จ๐ฅ๐ฏ๐๐ ๐ข๐ง ๐ฆ๐๐ค๐ข๐ง๐ ๐ญ๐ก๐ข๐ฌ ๐๐๐ฉ๐จ๐ซ๐ญ
๐๐๐ (๐๐ฑ๐ญ๐ซ๐๐๐ญ ๐๐ซ๐๐ง๐ฌ๐๐จ๐ซ๐ฆ ๐๐ง๐ ๐๐จ๐๐) Load all the CSV files that were provided, to Power Query. Ensured there were no missing values, all dimension tables contained a unique column, removed duplicate values, corrected the spelling errors, and in the end loaded the files in the Power Pivot.
๐๐๐ญ๐ ๐๐จ๐๐๐ฅ๐ข๐ง๐ Connect all the tables using star schema. Create a new table dim_date using Power Query that includes the date, month, and year in a separate column. Add a new column for adding AtiliQ Hardware Fiscal year that runs from September to August and then connect the table with others.
๐ฃ๐ถ๐๐ผ๐ ๐ง๐ฎ๐ฏ๐น๐ฒ ๐ฎ๐ป๐ฑ ๐ฃ๐ผ๐๐ฒ๐ฟ ๐ฃ๐ถ๐๐ผ๐ Integrate the data model with a Pivot Table for quick data analysis. Utilize Power Pivot to create new measures and columns. Employ Power Query for seamless data transformation and connectivity.
๐๐๐ (๐๐๐ญ๐ ๐๐ง๐๐ฅ๐ฒ๐ฌ๐ข๐ฌ ๐๐ฑ๐ฉ๐ซ๐๐ฌ๐ฌ๐ข๐จ๐ง) Create 10 + new Measures such as Net sales for each year, Gross Margin, GM %, and COGS using Formulas like Calculate, Sum, Divide, etc. Create new Columns using Functions like Related, Calculate, Format and extract quarterly months by adding 4 months to the calendar year for a fiscal year perspective.
๐๐จ๐ง๐๐ข๐ญ๐ข๐จ๐ง๐๐ฅ ๐ ๐จ๐ซ๐ฆ๐๐ญ๐ญ๐ข๐ง๐ Applied Conditional Formatting to enhance data presentation by applying rules, and formatting numbers and text. This approach highlights important data, identifies trends, and improves overall data readability for more effective analysis.
๐๐ง๐ฌ๐ข๐ ๐ก๐ญ๐ฌ
India emerges as the forerunner in net sales at a staggering 161.3M AQ Master wired x1 Ms takes the crown as our highest-sold product Festive seasons witness soaring sales from October to December.