𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝗳𝗿𝗼𝗺 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀:
𝗞𝗣𝗜 𝗕𝗮𝗻𝗻𝗲𝗿: Created a dynamic KPI banner displaying Year-to-Date (YTD) Sales, YTD Profit, YTD Quantity Sold, and YTD Profit Margin. Also, incorporated Year-on-Year (YoY) growth for each KPI with YTD sparklines to visualise monthly trends.
𝗖𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗖𝗮𝘁𝗲𝗴𝗼𝗿𝘆 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀: Identified YTD Sales, Previous Year-to-Date (PYTD) Sales, and Year-on-Year (YoY) Sales growth for different customer categories, with trend icons for each category.
𝗦𝘁𝗮𝘁𝗲-𝘄𝗶𝘀𝗲 𝗦𝗮𝗹𝗲𝘀 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲: Analyzed YTD Sales performance by each state to uncover regional insights.
𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀: Identified the Top 5 and Bottom 5 Products by Sales for strategic decision-making.
𝗥𝗲𝗴𝗶𝗼𝗻𝗮𝗹 𝗦𝗮𝗹𝗲𝘀 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀: Visualized YTD Sales by Region to understand performance across the country. Shipping Type Analysis: Examined YTD Sales by Shipping Type to optimize delivery processes.
𝗦𝘁𝗲𝗽𝘀 𝗜 𝘂𝘀𝗲𝗱: ➤ Data Modelling with three tables ➤ Data cleaning in Power Query ➤ Creating a Date Table in Power BI ➤ Leveraging Time Intelligence functions (TOTALYTD, SAMEPERIODLASTYEAR, etc.) ➤ Creating Dynamic and Complex KPIs ➤ Advanced DAX Queries ➤ Applying Conditional Formatting and adding dynamic icons ➤ Utilizing various DAX functions like Calculate, Sum, Sumx, return, concatenate, divide, var, etc. ➤ Creating different charts, maps, and formatting them for insightful analysis ➤ Exporting Reports for sharing and collaboration
Final Dashboard
