Imad Hamdani

• Designed and developed interactive Power BI dashboards tailored for sales, marketing, and operations teams, driving data-informed decision-making. • Built optimized data models and advanced DAX calculations to enhance reporting accuracy and performance. • Created reusable Power BI dataflows, empowering business users to perform their own analyses with consistent and reliable data. • Streamlined data integration by developing ETL pipelines using SSIS and Azure Synapse, connecting Dynamics 365 and external sources. • Collaborated with cross-functional teams to define KPIs, align dashboards with strategic objectives, and provide actionable insights. • Documented processes and delivered training sessions to improve user adoption of Power BI solutions.

Analytics: • Provide weekly insights (to Business Planning Manager) on brand performance: market share, stock level, availability, distribution, and visibility. • Used R scripts to automate 90% of reports and repetitive analysis. • Used R programming for data manipulation and visualization mainly through "Dplyr" and "ggplot2" packages. •Design and development of Power Bi and MS Excel dashboards for internal stakeholders. • Extract data from existing sources using SQL queries. Operational analytics: • Support the field team to achieve better territory management by providing KPIs on their respective territories. • Development of operational merchandising guidelines to be implemented at the national level. • With the support of the field team, summarize information on competition activities through a report.

Client servicing: • Generate & deliver reports to clients summarizing the business data (Monthly basis). • Provided daily support for clients (20 across Maghreb region) in terms of data analysis & data pull from the database. • Provided basic training to clients on Nielsen tools and solutions • Built relationships with client and their support teams to ensure quality and timely service Analytics: • Analyse and interpret sales data and consumer data for clients. • Draft presentation, build a story and finalize conclusions and proposes recommendations. • Attended client strategic meetings and presentations over the phone and in person. • Used VBA macros to automate reports.