{"id":15,"date":"2024-08-14T12:23:59","date_gmt":"2024-08-14T12:23:59","guid":{"rendered":"https:\/\/project2.itc-consult.net\/?post_type=success-stories&p=15"},"modified":"2024-08-14T12:24:51","modified_gmt":"2024-08-14T12:24:51","slug":"having-all-of-our-data-in-one-single-place-has-allowed-us-to-quickly-build-dashboards-helping-improve-the-speed-to-insight","status":"publish","type":"success-stories","link":"https:\/\/project2.itc-consult.net\/index.php\/success-stories\/having-all-of-our-data-in-one-single-place-has-allowed-us-to-quickly-build-dashboards-helping-improve-the-speed-to-insight\/","title":{"rendered":"\u201cHaving all of our data in one single place\u2026 has allowed us to quickly build dashboards\u2026 helping improve the speed to insight.\u201d"},"content":{"rendered":"
\n

Marks and Spencer (M&S) is a UK-based retailer that delivers food, clothing, home and beauty goods to more than 30 million customers around the world each year. Founded in 1884, the retailer now has over 1,400 stores across 57 countries and 100+ websites. Over the years, M&S has been known for product innovation and swiftly adapting to the ever-changing demands of its customers, and more recently prides itself on customer-focused digital innovation, prioritizing collaboration and technology to better serve its customers as a leading omnichannel retailer.<\/h4>\n<\/div>\n
\n
\n

M&S\u2019s journey with data<\/h3>\n

With technology and innovation at the heart of M&S\u2019s business, data has increasingly become key to improving customer and colleague experiences. Due to its scale, M&S deals with huge amounts of data. From supply chain logistics to retail shopping metrics, M&S aims to integrate relevant data into all decision-making across the business\u2014and so opening up access to relevant, high-quality data is crucial for its growth and operations.<\/p>\n

At the beginning of its data journey, M&S had many disparate data homes across the organization and underwent a project to consolidate data into an on-premises data environment to support analytics across the organization. While adoption of this project was successful and a substantial percentage of data was consolidated into a single platform, M&S\u2019s legacy system continued to support many analytics processes and reporting initiatives. With remaining on-premises data, it became difficult to keep up with customer and retail demands in real time, while also trying to scale systems and reporting. Wanting to move beyond the strain and costs of on-premises systems, M&S started its cloud journey to migrating the remainder of its legacy systems and data to the cloud.<\/p>\n

Now, M&S has established BEAM, its cloud data platform and the home of its data tooling, the data itself and the new capabilities and solutions it is powering. BEAM is enabling new capabilities through data science and analytics solutions across the business to better serve customers and colleagues, and supporting M&S\u2019s efforts to democratize data for all, giving teams access to the reporting needed to enable faster, better decisions as part of continued data transformation at M&S.<\/p>\n

Finding the right solution to foster a data-driven culture<\/h3>\n

For M&S, having data architecture that could efficiently support and process its organizational and operational data while also handling scale and speed was key. M&S felt that\u00a0Microsoft Azure Synapse Analytics<\/a>\u00a0could keep up with performance requirements, provide necessary scale and serve as a strong foundation for the BI analytics platform, all while remaining the most cost-effective option. Plus, with\u00a0Microsoft Power BI<\/a>\u00a0as the primary reporting tool, the easy integration made the choice of Synapse feel even easier. Synapse stood out for its query execution performance within selected capacity, Power BI connectivity and performance, and easy data orchestration abilities.<\/p>\n<\/div>\n<\/div>\n

<\/div>\n

\"Story<\/p>\n

\n
\n

Figure 1 \u2013 M&S\u2019s current data architecture.\u00a0<\/em><\/p>\n

After choosing Azure Synapse Analytics for its cloud data platform, the BEAM team worked closely with Microsoft to build the architecture. M&S source data originates in many different locations: legacy data, third party applications, IOT devices, streaming data, and more. Raw source data is moved to an Azure Data Lake via a workflow manager. Within Azure Data Lake, data is cleaned and modeled. Azure Databricks and Spark notebooks help transform data even further. After data is transformed, it is then orchestrated into Azure Synapse Analytics via Azure Data Factory. After data has been modeled for reporting, it is ingested into Power BI to serve the numerous reports across M&S.<\/p>\n

Taking reporting to the next level and enabling data-driven decisions with Power BI<\/h3>\n

Making relevant data more accessible for its colleagues to make faster, better decisions is integral to success at M&S and plays a key part in driving cultural change.<\/p>\n

Power BI has now reached all corners of the organization, with reports and dashboards serving a large variety of needs. From within the BEAM team, a central analytics team guides reporting initiatives and supports organizational standards for best practices across M&S. Paired with self-service reporting, the central analytics team uses Power BI to build large reports across the organization and help federated teams find solutions for more niche reporting use cases. With numerous reporting initiatives across the organization, data and high-quality analytics are now easily accessible. However, to drive business value, this work is supported by an Adoption & Education arm, BEAM Academy, to drive change through colleagues.<\/p>\n

One of the bigger reports that the central analytics team built was the Stock Movement Tool, a reporting solution that shows how food goods move through the supply chain. The previous tool didn\u2019t quite fit the needs of analysts and business users and was costly to maintain. Getting real time data through reports took a long time and made it difficult for analysts to make timely decisions on goods within the supply chain. To keep up with demands, users needed a real-time solution. Now, with Power BI, users can access insights at a click that are real-time\u2014a huge improvement. Stock Movement Tool reports are also embedded into a web portal so suppliers can access and track data too, enabling more effective collaboration between partners.<\/p>\n

For retail colleagues on the frontline, especially management, Power BI Premium capacities support an app where they can access and interrogate reports to look at insight such as sales and stock metrics, operational performance, people data and more. The reports within the app are accessed by 2,000 colleagues every week, and help stores run more efficiently, more commercially and build a better experience for customers.<\/p>\n

Building a knowledge base across the organization<\/h3>\n

When M&S was first ramping up Power BI adoption, the BEAM Academy developed a two-week event to engage and educate thousands of their support centre colleagues on Power BI\u2014covering numerous use cases and topics for both citizen and practitioner audiences. This highly rated event was a real step change moment for colleagues and Power BI and led to a similar event for all of M&S\u2019s frontline retail managers on their bespoke reporting.<\/p>\n

This was a key starting point for BEAM Academy that reinforced colleagues\u2019 appetite and requirements for a broader proposition: a place for colleagues to receive learning and support on tools within the BEAM ecosystem to really get the most out of it. BEAM Academy now hosts many programs including industry-leading data apprenticeships, live learning events and workshops, hackathons, and more\u2014supporting company-wide adoption and value back to the business through getting the most out of data.<\/p>\n

This has resulted in colleagues being inspired and empowered to build their own reports and serve their own specific analytics needs, seeing self-service reporting across the organization growing tremendously. To really enable this further, M&S has a focus on adoption to make the transition between technologies and new behaviours easier\u2014especially for the community of analysts and colleagues actively interrogating data in their roles across the business to get the most out of data and reporting for their business areas.<\/p>\n<\/div>\n<\/div>\n","protected":false},"featured_media":17,"template":"","brands":[3],"class_list":["post-15","success-stories","type-success-stories","status-publish","has-post-thumbnail","hentry","brands-ms"],"_links":{"self":[{"href":"https:\/\/project2.itc-consult.net\/index.php\/wp-json\/wp\/v2\/success-stories\/15","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/project2.itc-consult.net\/index.php\/wp-json\/wp\/v2\/success-stories"}],"about":[{"href":"https:\/\/project2.itc-consult.net\/index.php\/wp-json\/wp\/v2\/types\/success-stories"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/project2.itc-consult.net\/index.php\/wp-json\/wp\/v2\/media\/17"}],"wp:attachment":[{"href":"https:\/\/project2.itc-consult.net\/index.php\/wp-json\/wp\/v2\/media?parent=15"}],"wp:term":[{"taxonomy":"brands","embeddable":true,"href":"https:\/\/project2.itc-consult.net\/index.php\/wp-json\/wp\/v2\/brands?post=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}