{"id":8288,"date":"2020-05-06T06:00:32","date_gmt":"2020-05-06T13:00:32","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/ikea-sweden\/"},"modified":"2024-09-25T13:33:48","modified_gmt":"2024-09-25T20:33:48","slug":"ikea-sweden","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/ikea-sweden\/","title":{"rendered":"IKEA Sweden \u2013 Reimagining the customer experience with Microsoft Power Platform"},"content":{"rendered":"\n
IKEA is a Swedish company that was established in 1943. The company designs and sells ready-to-assemble furniture, kitchen appliances and home products, among other goods and home services. Across the globe, IKEA has 211,000 employees, 433 stores, and operates in 50 e-commerce markets.<\/p>\n\n\n\n
In this post we look at how IKEA Sweden<\/a> partnered with Capgemini<\/a>, a Microsoft Gold Partner, to build a Dynamics 365 and Power Platform solution for its sales staff to improve the kitchen buying experience for individual customers (B2C) and businesses (B2B). They wanted to provide their customers with a sense that \u201cIKEA sees me\u201d when working through the process of building a new kitchen. This project contributes to realizing the vision of having a holistic single view of the customer over the lifetime of their relationship with IKEA.<\/p>\n\n\n\n \u201cMicrosoft Dynamics 365 and Power Platform ensures that our customers feel seen. It makes it smoother for our co-workers to take the customer through the kitchen buying process. It has been an enabler to build long term business relationships based on quality and trust.\u201d<\/p>\n\n\n\n -Michel Tabakovic, IKEA Country Sales Manager<\/p>\n<\/blockquote>\n\n\n\n As the Country Sales Manager, Michel Tabakovic (Miki) leads the sales teams across IKEA Sweden. IKEA is evolving its business from being primarily perceived as a do-it-yourself furniture store to providing complete home solutions, such as large-scale kitchen remodel projects. Miki\u2019s vision for technology is to \u201cprovide a single source for the customer view and enable IKEA to be a part of the customer\u2019s long-term journey \u2013 for end customers and businesses.\u201d He sees digital transformation being a key to improving the \u201chuman to human connection\u201d \u2013 equipping the sales teams with customer stories and data points that will help them serve customers today and for years to come.<\/p>\n\n\n\n Miki\u2019s motivation and drive to adopt Dynamics 365 and the Power Platform started when the IKEA Board and CEO asked questions about kitchen sales, such as \u2013 sales conversation rates, why were customers not buying kitchens with IKEA, who were the existing B2B customers, what was the potential size of the B2B market, and more. The team did not have answers to these questions because the data was not captured in a structured manner. Miki decided to take the lead from within the business to find a technology solution for these challenges. Initially, he did not receive much support from Corporate IT, but he continued to push on convincing multiple stakeholders and getting the necessary funding for the project. In his words \u2013 \u201cI refused to take no for an answer but I was humble at the same time, understanding that the process was complex and the project needed to be scalable globally.\u201d<\/i><\/p>\n\n\n\n Now, with the IKEA Sales Tool, Miki believes that IKEA kitchen and B2B sales teams will be able to make data driven decisions that benefit the customer through the entirety of the kitchen buying process. The data will enable capturing trends early before they become mainstream. For example \u2013 kitchen islands were an emerging trend before they became mainstream, customers have now started buying two ovens, what is the next trend? The system will allow the sales teams to learn and act on these quickly during the sales cycle. He considers this as just the beginning, the foundation of being part of the customer journey for many years to come. He continues to stress that the tool is ultimately for his sales team in the field to form stronger human connections with their customers.<\/p>\n\n\n The kitchen is the place where family and friends gather to cook, socialize, and eat together. Many might say it is the most important room in one\u2019s home, as it is the center of the family\u2019s day-to-day life. Considering its importance, it is natural to go about an organized approach, pay attention to details, and spend the necessary time when planning a new kitchen. While IKEA\u2019s intention was to take the customer through an exceptional journey from initial idea to a ready kitchen, the reality in each local store was quite different.<\/p>\n\n\n\n The kitchen departments lacked a structured process for documenting and managing sales. IKEA heard from customers that the main reason they did not purchase kitchens at IKEA was because they felt the company did not provide good support through the buying process. Meanwhile the high demand for kitchen sales continued to grow in the market, with a growing awareness of the increased competition and greater customer expectations for the buying journey and final product. For all these reasons, IKEA needed to transition the way they sold kitchens for B2C and B2B customers.<\/p>\n\n\n\n Before the Dynamics 365 and Power Platform solution, the kitchen department used a homegrown spreadsheet-based solution to keep track of kitchen planning appointments, prospective customers, ongoing projects and the various elements that define the kitchen-buying journey.<\/p>\n\n\n\n Similarly, the B2B sales team also used Excel spreadsheets to track individual and aggregated kitchen sales. The homegrown \u201clow tech\u201d solutions created by individual sellers lacked a structured or unified approach.<\/p>\n\n\n\n Besides B2C and B2B sales, the Customer Support Center (CSC) process of making appointments was also manual. If a customer called the CSC to make an appointment, the agent would put the customer on hold and call the local store to schedule a kitchen consultation. The local store would then look at an excel spreadsheet to see what was available. Once the meeting was booked the notification back to the customer was done manually.<\/p>\n\n\n\n This process resulted in several challenges, such as:<\/p>\n\n\n\n Screenshot of old Excel spreadsheet that was used prior to Power Platform solution<\/em><\/p>\n\n\n\n The IKEA leadership team in Sweden and thought leaders from local IKEA stores worked with Capgemini and Microsoft to build a solution that enabled tracking of the sales process from the first meeting with the customer to the installation of the kitchen. It also serves as the foundation of IKEA being part of the customer\u2019s home improvement journey for many years to come. The implementation is a collection of apps built with Microsoft Dynamics 365 and Power Platform, collectively referred to as the IKEA Sales Tool.<\/p>\n\n\n\n The development effort on the solution started in December 2018 with a directive from Miki to Capgemini to \u201cbuild an app that required no more than \u00bd hour of training for the sales staff.\u201d The app was piloted by one sales team in May 2019 and was rolled out across all stores in Sweden by June 2019. In total, more than a thousand employees and managers use the solution. Of these, ~250 employees use the full Dynamics 365 capabilities and ~750 use Power Apps. Five months after the go-live, up to 90% of the target employees were actively using the solution.<\/p>\n\n\n\n The IKEA Sales Tool consists of four apps:<\/strong><\/p>\n\n\n\n Here\u2019s more detail about what each Power App does, followed by a summary of the various technology components used to implement the solution.<\/p>\n\n\n\n Kitchen App<\/strong> The app also enables the sales management team to view analytics associated with the kitchen buying process, such as \u201cbooked appointments\u201d, \u201ccancelled appointments\u201d, \u201cbusiness opportunities\u201d. It is very important for IKEA to have these statistics because they want to change the way they do business and increase the number of scheduled customers versus drop-in customers.<\/p>\n\n\n\n The Kitchen App is a Power Apps model-driven app<\/strong> that leverages Dynamics 365 Field Service<\/strong>. The app provides a subset of the Dynamics 365 Field Service capabilities scoped to IKEA\u2019s specific requirements. It uses the resource scheduling module for managing schedule boards, bookable resources, and more. Power Automate<\/strong> is used to simplify the user experience \u2013 each time a co-worker hits start or end on an appointment, a flow is triggered to automatically calculate and record the duration of the meeting and update the status. Azure Functions and Logic Apps are used to connect to IKEA\u2019s SMS delivery system and send text message notifications to customers. Dynamics 365 workflows are used to send emails. The team plans to eventually migrate all workflows to use Power Automate.<\/p>\n\n\n Co-worker App<\/strong> The app also includes a calendar, implemented as a custom control in the model-driven app, which simplifies the customer journey for booking appointments. A web calendar is implemented on IKEA\u2019s customer facing website<\/a> and connects directly to Dataverse. Customers navigate to the appointment page and select the desired store. They describe their requirements and request an appointment. The web portal checks if it\u2019s an existing customer and either fetches their profile or creates a new profile. A new opportunity is automatically booked and visible on the scheduling board. Customers can use this web page to directly view the status of their bookings, information about the co-worker that will handle their meeting, and more.<\/p>\n\n\n\n Whether the customer is booking an appointment for service planning through IKEA\u2019s website or making an appointment for kitchen planning in the store, their appointments are all managed and updated via a common system and data store.<\/p>\n\n\n\n As a result of the Power Apps solution, this is the first time that a co-worker has been able to use a single tool to look for customer information and status in one place. They can also get a view into the sales progress made by each co-worker. They plan to continue expanding on this by adding goal management capabilities for co-workers.<\/p>\n\n\n\n In addition to using Power Apps, co-workers use two other tools in their day-to-day process to design kitchens and place orders. These are standalone custom tools \u2013 (a) a Design Tool to plan and design the custom kitchen and (b) an Order Management Tool (ISell) to generate a list of products based on the output from the Design Tool.<\/p>\n\n\n\n Azure Functions are used to fetch and publish data on a recurring cadence from the ISell system into Dataverse, thereby making all the kitchen order information directly available within the Power Apps app.<\/p>\n\n\n B2B App<\/strong> All B2B sales reps now use the new app to input new and existing customers’ information. This has allowed the team and IKEA management to have a view into who is taking care of the customer, active opportunities and general customer pipeline. They can also track sales activities such as revenue, estimated close dates, etc.<\/p>\n\n\n Customer Support Center (C2C) App<\/strong> During the call with the customer, support agents can also look them up to get their detailed history along with all their prior conversations with co-workers. This has been a far superior experience over trying to navigate multiple spreadsheets for this information. Since previously new sheets were created every three weeks, there was no historic view available.<\/p>\n\n\n\n This is an important goal for IKEA \u2013 to collect customer data so that they can build long term relationships and support the customer through their furniture buying journey in the present and the future.<\/p>\n\n\n\n The IKEA Sales Tool has been in production for less than six months. While collecting more detailed impact metrics will require at least one sales cycle of 6+ months to complete, the following are early indicators of the benefits and impact of this solution:<\/p>\n\n\n\n A summary of the Microsoft technologies used in the solution is as follows:<\/p>\n\n\n\n Implemented Azure Function to create booking slots dynamically based on calendar configured for resource, which will consider holidays, working hours & business closures specific to stores, reducing manual work for all co-workers.<\/p>\n\n\n\n The IKEA team in partnership with Capgemini plans to continue to add new capabilities to the existing Power Apps solution. The capabilities include:<\/p>\n\n\n\n IKEA, in partnership with the Microsoft team, led by Customer Success Manager, Seraj Agahi, worked through goals, expectations and projected outcomes from the initiative. The team documented this as their \u201cStrategic Intent\u201d and conducted success planning workshops to create common expectations, assess the complexity of the project and understand transformation readiness of the organization. Based on this, an action plan was created to ensure expected impact and benefits from the new platform and the change in behavior was maximized.<\/p>\n\n\n\n The Capgemini team developed the Dynamics 365 and Power Platform solution, adopting low-code automation and out of box functionality with advanced features & cloud capabilities. Microsoft FastTrack Solution Architect Robert Rensen provided deep technical architecture and design guidance, including best practices for performance and security. This has resulted in high performance and low maintenance, with centralized data, increased mobility and data integrity. The team worked in close collaboration with each other as well as IKEA product owners to achieve the set goals.<\/p>\n\n\n Capgemini is a multi-national IT-consulting firm with presence in over 40 countries with over 200,000 employees. With expertise in several avenues of IT and technology, ranging from infrastructure to graphic design, Capgemini Group offers end-to-end digital transformation capabilities and experience to support both technical and organizational implementations at scale. The delivery team in this project worked with information systems, mostly ERP and CRM that specialize in application management, development and implementation of information systems.<\/p>\n\n\n\n Capgemini has 24,000+ Microsoft consultants that focus on the end to end Microsoft platform including Dynamics 365, Office 365 and Azure. They are one of the leading Microsoft partners worldwide having more than 15 Microsoft Gold competencies – Gold Cloud Customer Relationship Management, Gold Application Development, Gold Application Integration and Gold Application Lifecycle Management. Some of the awards are: 2018 Capgemini France, Microsoft Country Partner of the Year, 2017 Microsoft Partner of the Year DevOps Finalist and Inner Circle for Dynamics 365. View more about Capgemini\u2019s partnership with Microsoft here<\/a>.<\/p>\n\n\n\n Capgemini is one of the largest global system Integrators of the Dynamics 365 platform worldwide demonstrating a strong 45%+ year over year growth over the past 3 years. Today, Capgemini has more than 800 Dynamics 365 consultants across 15 countries. The consultants are connected via the Global Dynamics 365 community having regular touchpoints for experience sharing and cross-geo support. Approximately 400 out of 800 have focus on Dynamics 365 Customer Engagement (CRM) within primarily Sales, Service, Field-Service, Marketing, Power Apps and Power Platform\/Dataverse. The other 400 focus on Finance & Operations domain. More information about this can be found here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":" IKEA Sweden partnered with Capgemini to build a Dynamics 365 and Power Platform solution for its sales staff to improve the kitchen buying experience for individual (B2C) and businesses (B2B) customers. This post describes details of the solution and key benefits to the team at IKEA.<\/p>\n","protected":false},"author":90,"featured_media":8289,"comment_status":"open","ping_status":"open","template":"","power-apps-category":[1580],"power-apps-tag":[1581,1590,1650],"coauthors":[2350],"class_list":["post-8288","power-apps","type-power-apps","status-publish","has-post-thumbnail","hentry","power-apps-category-case-studies","power-apps-tag-customer-story","power-apps-tag-dataverse","power-apps-tag-model-driven-apps"],"yoast_head":"\n\n
Meet Miki<\/strong><\/h3>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
Business challenge<\/strong><\/h3>\n\n\n\n
Before Power Platform<\/strong><\/h3>\n\n\n\n
\n
<\/figure>\n\n\n\n
Power Platform Solution – IKEA Sales Tool<\/strong><\/h3>\n\n\n\n
\n
The studio host is the person who welcomes the customer into the kitchen area. They use the Kitchen App to check whether they are an existing customer, verify the scheduled appointment, and assign a \u201cco-worker\u201d to serve the customer. The app helps them plan the day and gain an overview of the bookings and resources available, so that they can successfully manage the drop-in customers.<\/p>\n\n\n\n<\/figure>\n\n\n\n
After the customer is checked into the store by a studio host and assigned to a sales rep (\u201cco-worker\u201d), they begin to use the Co-Worker App, which is a Power Apps model-driven app<\/strong> that connects to data stored in Dataverse<\/strong>. The co-worker uses the app to add meeting notes, update the kitchen project revenue, and book revisits with the customer. Revisits are a significant step in IKEA\u2019s sales process. They drive increased revenue and form the start of building a long-term relationship with the customer.<\/p>\n\n\n\n
The B2B sales force is responsible for selling IKEA products to small and large businesses to use in their office buildings. They use a Power Apps model-driven app<\/strong> that leverages the Dynamics 365 Sales capabilities to track the sales pipeline and provide insights into their B2B customers. The app also enables the sales team to keep ongoing communications and build better relationships with customers. Keeping with the theme of \u201cless is more\u201d, the app is a simplified version of the Dynamics 365 Sales capabilities, e.g. has a reduced set of sitemap and navigation options.<\/p>\n\n\n\n
Customer support agents use this Power Apps model-driven app<\/strong> to book, rebook or cancel appointments on behalf of customers. The usage of the app has grown from six members to over twenty and new members continue be added on a regular cadence. Despite its small number of users, the app has transformed the way CSC deals with customers who call to make appointments. The agents can directly book appointments via the app and no longer need to put the customer on hold while they call the store to confirm the schedule.<\/p>\n\n\n\nImpact and benefits<\/strong><\/h3>\n\n\n\n
\n
Solution architecture<\/strong><\/h3>\n\n\n\n
\n
<\/figure>\n\n\n\n
Looking ahead<\/strong><\/h3>\n\n\n\n
\n
Working together – IKEA, Capgemini & Microsoft<\/strong><\/h3>\n\n\n\n
<\/figure>\n\n\n\n
About the partner \u2013 Capgemini<\/strong><\/h3>\n\n\n\n