Yasmin Shaker

Project Accomplished: Sales Analysis Dashboard: POC for Turkish Food Manufacturer Scenario: Analyse product sales performance. Tools used: Power BI & Excel Solution: Developed an interactive dashboard to monitor sales across product categories. The dashboard identifies bestselling products, compares actual sales to budget targets, and evaluates year-over-year growth. It also highlights the most effective sales channels. Users can toggle between sales amount and volume as the primary KPI for flexible analysis. Headcount Analysis Dashboard: Scenario: Create a dashboard to analyse the headcoount of the company. Tools used: Power BI and Azure Databrick Solution: Created a comprehensive dashboard to track headcount trends over time, including year-overyear comparisons. The dashboard delivers key insights into new joiners, employee turnover by reason, and Emiratization percentage. It also highlights critical HR metrics such as average tenure, promotion rates, youth representation, average employee age, and the number of employees currently in their probation period. A dynamic and interactive visual component enables users to filter and analyze headcount data across multiple dimensions, including gender, department, section, and grade. Attendance Insights Dashboard: Scenario: Develop a dashboard to monitor employee attendance performance. Tools used: Power BI and Azure Databrick Solution: Built an interactive dashboard to track key attendance metrics, including the average number of employees working on-site, working remotely, or on leave—categorized by type of leave. The dashboard also monitors average employee lateness. KPIs are viewable across multiple dimensions such as gender, age group, and job role, and can be analyzed as monthly trends with both absolute figures and percentages. Additionally, Row-Level Security (RLS) was implemented based on department and section head flag filters, ensuring that department heads only access their own team’s data, while HR maintains a full organizational overview. Revenue Analysis Dashboard: Scenario: Develop a dashboard to analyse the company revenue performance. Tools used: Power BI and Azure Databrick Solution: • Gathered business requirements through collaboration with key stakeholders. • Designed the dashboard layout and defined key performance indicators (KPIs). • Created a data model on power bi which is connected to Azure Databricks table. • Developed DAX measures and implemented field parameters for dynamic analysis. • Created an interactive dashboard to monitor essential financial metrics including Revenue, EBITDA, Net Profit, and Comprehensive Income. • Implemented conditional formatting to visually highlight budget performance—green for above budget, red for below— and utilized gauge charts for intuitive visualization of progress against targets. • Enabled revenue analysis by stream and business unit, with drill-down views into individual revenue categories. • Provided flexible perspectives such as revenue by customer and a decomposition tree view for category insights. • Integrated toggle functionality for users to switch between Monthly and Year-to-Date (YTD) views. • Presented the final solution to business. • Published the dashboard to the Power BI workspace, configured daily data refresh, and managed user access permissions. Note: All figures are blurred as the dashboard uses live production data.