Building data-driven culture

Bernadett Remenyfy-Kiser

Azure
Microsoft Excel
Power BI
1) Project overview
My client faced challenges related to business productivity, decision-making, and identifying new opportunities. The issues they faced were related to: inefficient data management processes, lack of insights from data, data was stored in non-scalable text or Excel files, inconsistent and outdated reports and confusing KPI definition which were measured differently in different systems and regions.
2) Actions
Restructured the company’s data management processes and implemented business intelligence tools to turn our data into valuable insights for our management
Understood business needs & created insightful analyses in order to maintain the company’s competitive position & profitability
Acted as a liaison between the different regional teams working on different systems and executive management to redefine core metrics focusing on supply chain, finance, and customer service areas
Migrated all the company’s data stored in text files into Azure SQL Data Warehouse, and set up automated pipelines to refresh them in daily batches
Took over the governance of 15 weekly, monthly and quarterly reports and ensured that these are scalable and always up-to-date
Restructured and centralized core data-driven processes such as customer satisfaction metrics & capacity planning, so the different departments speak the same language
Introduced a new KPI system to ensure that the main stakeholders have a clear view on the company’s performance, regardless of which region or underlying system the data is coming from
Tools: Microsoft Excel, Microsoft Azure, Power BI
3) Result
KPI Transparency: Introduced a new KPI system, ensuring that key stakeholders have clear visibility into company performance.
Profitability: Contributed to a 10% increase in profitability through cutting costs without revenue impact thanks to better analytics capabilities
Data Accessibility: Achieved 98%+ data accessibility by migrating data from text files to Azure SQL Data Warehouse, ensuring real-time access to accurate data from all parts of the value chain
Partner With Bernadett
View Services

More Projects by Bernadett