Do hamburgers really come from Hamburg? This may still be a matter of debate, but the popularity of American-style burger joints not just in Hamburg but all over Germany, is clear. Germany’s top two fast food companies are both burger chains. One of them is BURGER KING®, a global brand that welcomes more than 11 million customers worldwide every day. The company arrived in Germany in 1976, when its first restaurant opened in Berlin. It now operates more than 100 restaurants across Germany, with franchisees operating more than 600 restaurants of their own.

“In the fast food industry, being able to move quickly is very important. That means delivering the right promotion to our app or launching a viral campaign within days. To do that across more than 700 restaurants, we need the support of the right technology.”

—Oliver Mielentz, IT Manager, BURGER KING® Deutschland GmbH

Previously a subsidiary of the U.S. business, BURGER KING® Germany became an independent company in 2015. As a result, it needed to develop its own IT infrastructure, and the changeover needed to happen fast. “We had to put in place systems that would work for the entire network of franchisees and enable us to easily roll out campaigns,” explains Oliver Mielentz, IT Manager at BURGER KING® Deutschland GmbH.

With the help of Google Cloud Premier partner Cloudwürdig, BURGER KING® Germany chose Google Cloud and G Suite as the right combination to suit its needs.

“In the fast food industry, being able to move quickly is very important,” says Oliver. “That means delivering the right promotion to our app or launching a viral campaign within days. To do that across more than 700 restaurants, we need the support of the right technology.”

Building a franchisee platform in just three months

When a business has multiple franchisees, it’s important to make sure everyone is on the same page, especially in the fast-paced fast food environment. “We have to collate data from all our franchisees and produce reports quickly in order to react to changes in customer behavior,” explains Oliver. “That means processing every transaction that takes place in our restaurants.” Following the restructure, BURGER KING® Germany also needed to build a secure invoicing system with data storage and optimize its communication channels.

“Using Tableau with BigQuery, we’re able to produce reports very quickly. Previously, it took much longer, as data had to be fetched manually. Our reaction time is now almost a business day faster.”

—Oliver Mielentz, IT Manager, BURGER KING® Deutschland GmbH

With support from Witter-IT, BURGER KING® Germany chose Cloudwürdig to build its BKD Connect internal platform on Google Cloud. Thanks to the ready-to-go tools on Google Cloud, it was able to put its invoicing system and data warehouse in place in just three months.

For the BURGER KING® Germany data warehouse, Cloudwürdig built an ETL pipeline that channels ticket data for every sale into BigQuery. “Data is gathered from the restaurants,” says Oliver, “and using Tableau with BigQuery, we’re able to produce reports very quickly. Previously, it took much longer, as data had to be fetched manually. Our reaction time is now almost a business day faster.”

As the ticket data for every transaction is stored in BigQuery, the marketing team can easily see exactly which products are selling well. That’s crucial for tweaking promotions as well as monitoring the supply chain to make sure enough produce is delivered to restaurants in response to changes in demand.

“Thanks to BigQuery, we have a speedy data pipeline that enables us to react on the same day to changes in the market and eliminate bottlenecks in production,” says Oliver.

Switching to G Suite to improve communication

To enable franchisees to sign in to its BKD Connect Platform, BURGER KING® Germany needed a secure authentication system. To solve that problem, it chose to provide franchisees with G Suite accounts. “It’s really easy to set up a new franchisee on the platform. I just create a new G Suite account and Drive folder for it, and it’s ready to go,” says Oliver. G Suite also helps the franchise network to run efficiently, as daily reports are automatically saved to Drive and shared to the appropriate regional network. “Thanks to that system, it’s much easier for any team at headquarters to access the information it needs,” Oliver explains.

BURGER KING® Germany also recently extended its use of G Suite across the whole company. “Following an evaluation of our previous email and productivity software, I made the decision to switch solely to G Suite,” says Oliver. BURGER KING® Germany employees now use Gmail, Calendar, and Drive for their day-to-day productivity needs. “We only just completed the migration, but already, everyone’s happy,” says Oliver. “It’s so easy to share a file using Drive or set up a meeting on Calendar.”

“We’re big fans of Hangouts Meet, and we have two rooms here at our Hanover headquarters equipped with Hangouts Meet hardware,” Oliver adds. “The speech quality is good, and it’s helpful to be able to see every participant, especially when you’re running a meeting with multiple franchisees.”

Optimizing infrastructure to power innovative campaigns

The BURGER KING® app, available for iOS and Android, helps the company to deliver a great customer experience. Through their MyBK accounts, guests can access coupons and special promotions. “We had a really interesting campaign for Easter: guests used the app to hunt for virtual Easter eggs,” explains Oliver. “We knew it was going to be big, and our previous back end wouldn’t have been able to handle the traffic.”

To enable the marketing campaign to go ahead, BURGER KING® Germany moved the back end of the app, along with its website, to Google Cloud. For developing and running its web and app back ends, it now uses App Engine and virtual machines on Compute Engine, as well as Memorystore and Cloud Functions. For monitoring and logging, it uses Stackdriver, and Cloud CDN and Cloud DNS to easily handle its traffic.

“We ran the campaign without any performance issues, even though we were receiving several million hits a day,” says Oliver. Since migrating the back end to Google Cloud, the marketing team also launched the popular “Escape the Clown” campaign. “That campaign blew our minds!” says Oliver. “It wouldn’t have been possible without Google Cloud, because it required a lot of back end capacity.”

To develop the app infrastructure it needs, BURGER KING® Germany relies on Cloudwürdig. “Working with Cloudwürdig is great because the team has the same agile mindset as us,” says Oliver. “When we have a new idea, we just set up a meeting, and in a couple of days the new infrastructure is in place. For Escape the Clown, it only took a few weeks to get everything ready to launch.”

Leveraging integrated tools to grow the business

Using Google Cloud together with G Suite enables BURGER KING® Germany to run its franchise network efficiently, while keeping its IT team lean. “Google Cloud and G Suite are the perfect fit for the way of working at BURGER KING® Germany,” says Oliver. “Many of the company’s operatives are often on the road, visiting restaurants and franchisees. With these tools, they can work flexibly and react quickly to the situation on the ground.”

“In order to grow the business, we need to use the data we receive every day to understand exactly what is happening in our restaurants. With the tools provided by Google Cloud, we can get more guests through the door and offer them a better experience.”

—Oliver Mielentz, IT Manager, BURGER KING® Deutschland GmbH

It also helps to keep infrastructure costs under control. “With Google Cloud, we only pay for what we use, which is really important for us,” Oliver explains. “It means we can scale up quickly if we see an opportunity to react to a trend in customer behavior and launch a new marketing campaign that resonates with the moment. When it’s finished, we can then scale down again, and that definitely saves us money.”

BURGER KING® is now working with Cloudwürdig to add more functionality to the BURGER KING® app using Google Kubernetes Engine. “We like to work with customers long-term to support their digital transformation. BURGER KING® Germany is a great example of how one project can develop into a great collaboration,” says Benny Woletz, Managing Director of Cloudwürdig.

BURGER KING® also plans to expand its presence in Germany and gain a greater market share by further tailoring both its marketing and the way it runs its restaurants to answer its guests’ needs. “In order to grow the business, we need to use the data we receive every day to understand exactly what is happening in our restaurants,” says Oliver. “With the tools provided by Google Cloud, we can get more guests through the door and offer them a better experience.”

For over five decades, Randstad has matched businesses worldwide with millions of temporary and permanent workers, creating long-lasting, successful working relationships. Today, the company operates a vast multinational recruitment network, with 35,000 employees applying HR expertise in markets from Norway to Malaysia, and more than 37 countries in-between.

To give staff a more mobile, low-maintenance alternative to their previous communications solution, Randstad offered G Suite to its staff in 2012, giving them the option to switch. All of Randstad’s workforce made that choice, assisted by a Randstad “Transformation Kit” containing everything a team needs for a successful migration. Now Randstad’s global community of G Suite users are looking to unleash the full potential of the platform, moving beyond Gmail and Calendar to engineer major efficiencies across the organization.

“Technology gives us more time to be in contact with people,” says Senne Beckers, Senior Accounts Specialist at Randstad. “It means we can give more attention to the people we outsource, our colleagues, and our customers. Our administrative ability is what makes Randstad successful, and G Suite makes all our processes more efficient.”

Sharing tips worldwide to make the most of G Suite tools

“In Sheets, I can create a pivot table and then I can drop Sheets visualizations directly into Slides for presentations. In the past, we would need visual designers to do that, but now I can do it in a matter of minutes.”

– Frank van der Bijl, Business Analyst IT, Randstad

Using Google+, Randstad workers share their ideas for applying G Suite to their work. “We share tips and tricks with each other from all over the world,” says Frank van der Bijl, Business Analyst IT at Randstad. “There’s always someone you can learn from or educate, and that’s an innovation in and of itself. In the past, when we wanted to share information like this, we would contact the internal communications team for them to put something on the company intranet. Now we go straight to Google+ and post it directly.” Randstad calls this project “Google to the Max”, and the boost in collaboration and efficiency helps its staff around the globe be more productive.

Those tips range from saving time by using Calendar to book meeting rooms and check colleague availability, to minimizing unnecessary travel by replacing meetings with Google Hangouts Meet. As an HR company, Randstad handles, optimizes, and edits thousands of résumés every day. By using Google Forms to collect data for résumés and Google Docs to edit them, Randstad teams streamline that core process. “Rather than send résumés back and forth with corrections and suggestions, we work on them all together, directly in Docs,” says Frank. “It’s a collaboration, like how we centralize information in Google Sheets to give everyone on a team a single, up-to-the-minute overview on customers and candidates, maximizing the chances of a successful match.”

Many of the innovations tackle processes that used to create bottlenecks by requiring specialist knowledge. “In Sheets, I can create a pivot table,” says Frank, “then I can drop Sheets visualizations directly into Google Slides for presentations. In the past, we would need visual designers to do that, but now I can do it in a matter of minutes.”

Streamlining annual assessments with Forms and Sheets

“We have more than 1,000 people working for a global airline through Randstad, and because G Suite is so open, the airline, like other clients, uses Google tools to send us information.”

– Senne Beckers, Senior Accounts Specialist, Randstad

In addition to improving internal processes, the innovations directly benefit Randstad clients, as Senne explains: “We have more than 1,000 people working for a global airline through Randstad, and because G Suite is so open, the airline, like other clients, uses Google tools to send us information, even though they work with a different communication platform.”

That flexibility allows Senne and her team to apply G Suite technology to problems outside of Randstad. “We used to have a very old-fashioned way of collecting annual assessments on each of the people we have with the airline,” says Senne. “We would email a document to an airline shift leader, who had to go to his or her computer to receive it, print it, fill out the document, scan it, save it, and then email it back. At one point, the workload was so high that we had to stop taking feedback altogether.”

To simplify the process, Senne implemented Forms, as a fast, mobile way for shift leaders to send their assessments. “With Forms, shift leaders can be inside a plane or out on the runway, and when they want to comment on an employee they can give us instant feedback that goes directly into our system,” explains Senne. Back at the Randstad office, HR then pulls all the data they need directly from Sheets, without having to reference the CRM, chase clients, or search emails.

As a result, it now takes five minutes to create an annual assessment, instead of one hour. Because there are 1,000 employees, a task that took 1,000 hours a year, or 140 working days, can be finished in two and a half weeks.

“Because Sheets translates information directly into graphs as it arrives, we can track the situation at a glance,” says Senne. “Streamlining the creation of annual assessments with Forms doesn’t just make the process more efficient, it also means we can spend more time properly discussing feedback with employees. That’s good for them and great for the airline’s management, which now wants to roll out this approach to more business units.”

Bringing teams together with Google Keep

“Everyone has their own approach, and we’re all sharing our experiences through Google+ and helping colleagues. Every day we find a new feature, which helps us be more efficient, and all we need to implement it is an internet connection.”

– Frank van der Bijl, Business Analyst IT, Randstad

As HR specialists, Randstad employees know that solving individual work issues is only part of the story. For teams to work effectively, solutions need to be brought together in a single place, where they can feed into each other. To make that happen, staff across Randstad use Google Keep to communicate.

“Keep really helps me to structure workflows and share my ideas directly with my team,” says Senne. “I have a lot of ideas all of the time, and Keep means I can make them known to the people I work with, at the same moment as I jot them down during a meeting. It brings Docs, Forms, and Sheets together in one place where we can arrange things intuitively and set priorities. With our to-do lists visible on that central hub, we can all check in on each other and track progress in a transparent way.”

For Senne, that functionality couples neatly with Google Cloud Search. “As a senior account specialist, it’s my responsibility to know what is happening in our teams, and Google Cloud Search helps me keep all of the information at my fingertips, ready for me to share. It’s the home screen on my Chrome browser.”

Recognizing that this agile, fast-paced way of working may be unfamiliar to new employees, Frank uses Google Keep to introduce people to the G Suite tools. “When people are new to a company, they’re sometimes nervous about asking for advice, such as how to ask for a day off,” says Frank. “To help them, I’ve created a four-step checklist of ‘Things you should do when you join Randstad’, which directs them to the information they need to on-board. With Keep I can see where they are in the process and follow up with them if I think they might need help.”

Embracing the interconnected environment

In each of the 39 countries where Randstad is active, operations are moving at their own pace towards greater G Suite integration. And though each is at a different stage in the process, the direction of travel is clear.

“Across the company, the next step will be Chromebooks, so that we fully embrace the interconnected app environment,” says Frank. “Some countries have already fully switched to Chromebooks, and some are migrating all of their data to the cloud. Everyone has their own approach, and we’re all sharing our experiences through Google+ and helping colleagues. Every day we find a new feature, which helps us be more efficient, and all we need to implement it is an internet connection.”

We recently announced the general availability of Connected Sheets, which brings you the power and scale of a BigQuery data warehouse in the familiar context of Google Sheets. With Connected Sheets, you can analyze billions of rows and petabytes of data in Sheets without specialized knowledge of computer languages like SQL. This makes it easy for anyone, not just data analysts, to apply pivot tables, charts, and formulas to massive datasets and unlock insights.

Our customers use Connected Sheets to enable data-driven decision-making across their organizations. We’ve heard many stories about how Connected Sheets has enabled them to achieve operational efficiencies and new ways of unlocking the power of their data; we’d like to share a few here.

Operate with agility

Now more than ever, it’s critical for organizations to react with flexibility and agility to new realities. Connected Sheets helps organizations harness and collaborate on massive amounts of data, making it easier to understand and quickly respond to today’s dynamic landscape. 

The United Nations Office for Project Services (UNOPS) helps the UN and its partners deliver peace and security, humanitarian, and development solutions. As COVID-19 emerged, UNOPS used Connected Sheets to help coordinate a swift global response. Says Tushar Dighe, Chief Information Officer at UNOPS, “When the COVID-19 pandemic started, we needed to quickly assess the status of our operational capacity in order to assist governments with the response. We used a Connected Sheet with data from our BigQuery data warehouse combined with manual status inputs on the same Sheet, where colleagues in more than 80 countries were able to collaboratively provide inputs. The results in the form of pivots and charts were instantly available live. It took less than three hours to design and implement the solution, and we had status information from more than 80 countries within the first 24 hours.”

Improve business and financial reporting

Reports and dashboards displaying business metrics, like revenue figures or operational KPIs, play a critical role in organizations. These reports help sales teams track performance, enable finance teams to make projections, and provide business leaders with a picture of their organization’s health. Especially now, as businesses adapt their planning to reflect the new normal and employees remain dispersed, it’s doubly important that teams can quickly access and collaborate on business and financial dashboards, from wherever they are. But building and maintaining these reports can be time consuming and error-prone, and requests for changes or new views result in manual work for data analysts. All of this just extends the time to insight and action. 

Connected Sheets helps automate report creation, while maintaining a single source of truth for data in BigQuery. The live connection between BigQuery and Sheets also means that data stays fresh, minimizing the risk that people make decisions based on outdated information and avoiding the data integrity risks of manual data pulls. 

Says Alexander Danilowicz, a Software Engineer at data connectivity company LiveRamp, “Our Finance team uses Connected Sheets to automate reports that are shared with other stakeholders to run the business. This enables our business partners to analyze and create pivot tables on massive datasets, which is not possible in a traditional spreadsheet.”

“Now that it’s all integrated, there’s no human error involved. Changes can be made at the click of a button, resulting in 10 hours saved per month,” he adds.

Track product adoption

It’s important for teams across the business to understand customer adoption of products and services, whether it’s the product team tracking usage of a newly released feature or the support team trying to anticipate incoming service requests. Similarly,  IT teams need to analyze adoption of an organization’s internal applications and systems, so they know what tools employees are using and how they are being used. But product adoption datasets are often too large for traditional spreadsheets to handle, and new data is continuously being added. 

Connected Sheets can provide teams access to large, powerful, and up-to-date usage datasets, in the familiar Sheets interface. PwC, a global professional services organization, uses Connected Sheets as part of its efforts to make technology and data more accessible across its workforce. One way PwC uses Connected Sheets is to monitor and analyze internal adoption of tools like G Suite. 

Says Peter Van Nieuwerburgh, Global Change Manager at PwC, “If you look at our own adoption dashboarding, it’s more than three terabytes of data—good luck putting that in any spreadsheet. With Connected Sheets, we’re not really pulling the data into the spreadsheet, rather it lives in the database where it belongs. The ability to go and so easily analyze and visualize the data is really powerful.”

We hope Connected Sheets helps to scale data-driven decision making at your organization, by making powerful data easily accessible across your sales, finance, product, and IT teams.

Whether they’re reading the newspaper on the way to work, or catching up on the latest headlines on their smartphones, readers expect up-to-the-minute news wherever and whenever makes the most sense for them. As a result, media companies are increasingly looking for ways to improve, expand, and simplify their offerings, and they’re increasingly looking to the cloud to do it.

For more than 160 years The Telegraph has been counted on by readers across the United Kingdom and globally for award-winning news and journalism. An early adopter of cloud technology, it’s been a G Suite customer since 2008 and has already been using Google Cloud Platform to analyze digital behaviors to improve engagement and advertising performance since 2016.

Recently, The Telegraph announced it’s migrating fully to Google Cloud. By migrating all their production and pre-production services, they aim to deliver content faster, provide compelling experiences to readers, and reduce environmental impact.

“We are delighted to announce our newest collaboration with Google Cloud,” said Chris Taylor, Chief Information Officer, The Telegraph. “We have always worked closely with Google as they help us to provide our readers with great experiences on our digital products, collaboration software and internet scale through search. Their continued leadership in projects such as Kubernetes are enabling us to build flexible development environments that truly support DevOps.”

Powering the Digital Publishing Ecosystem

The Telegraph produces large volumes of digital content every day. It was imperative for them to find a cloud provider they could trust to support this ecosystem. By working with Google Cloud they have changed the way they see and engage with data: they can collect new information about their products every second and use that to continually hone their strategy. The Telegraph are placing more confidence and trust in the data captured about their content and now have one of the best available pieces of technology for capturing and analyzing the stories they publish in real-time.

Leveraging AI to support journalists

Time is critical when journalists are on a story, and The Telegraph wants to put important data in the hands of its journalists right when they need it. To do this, it will be using AutoML to classify content for journalists and make it more discoverable. For example, a reporter will be able to bring up relevant assets that link to their stories. It will also apply AutoML to classify Telegraph stock photos to help journalists attach compelling visual content to their stories faster.

Building compelling reader experiences with the help of APIs

Readers have an ever-increasing expectation of personalization. To meet this need, The Telegraph launched My Telegraph, currently live in beta, to offer registered readers personalized news experiences based on their interests or the particular journalists they want to follow. My Telegraph was developed on an API management platform provided by Google Cloud’s Apigee. You can learn more about how it’s applying API management to My Telegraph, in this blog post.

Working for environmental good

The Telegraph is the biggest selling quality newspaper in the UK, an accolade which requires it to print and distribute hundreds of thousands of copies each day. Optimal management of print production is important, and by using a combination of the cloud and machine learning, The Telegraph is better able to predict demand for physical newspapers, maximizing sales and minimizing waste. This makes great business sense for The Telegraph but also has great environmental benefit.

Born in Iran as a refugee during the Soviet invasion of Afghanistan, I understand the challenges many people face there to get access to formal education. I was one of eight children in a progressive, yet financially limited, family. We left everything behind in Herat to move to a new country. To make ends meet, my mother sold handmade clothing. She invested what little she earned in my education, which made it possible for me to finish high school. 

While opportunities for education in Afghanistan have increased over the past few decades, there are still many barriers that stand in the way of education for Afghan women—familial expectations, socioeconomic circumstances, cultural stigmas, societal norms and even safety issues. These circumstances make it challenging for women to find work and explain why only 19 percent participate in the workforce, 84 percent lack formal education and are often illiterate, and just 2 percent have access to higher education.

2001 marked the fall of the Taliban in Afghanistan, and many Afghan families, including my own, found hope in their motherland again. The next year, I returned to Herat. Seeing my peers —women just like me with so much potential—I felt compelled to do something. But I knew that in order to help others, I first needed to further my own education. I earned a bachelor’s degree in Computer Science, and later a Master’s degree from the Technical University of Berlin in Germany. 

When I returned to Afghanistan after school, I hoped to share my newly-minted tech skills with Herat women by teaching at the local university. At the time, few women were participating in the public workforce and there were still many extremist, conservative views in the country. I was vocal about inequalities and faced backlash from the community; because of these threats, I came to the United States as an asylum seeker in 2012. 

After arriving in the United States, I was inspired to start Code to Inspire, the first coding school for girls in Afghanistan between the ages of 15 and 25 that provides free after school education in gaming, web development, graphic design, mobile applications and full stack development. Our goal is to empower women with the skills they need to program so that they can drive change in their communities and gain equal access to opportunities and financial independence.

Determined to make this coding school happen, I found myself faced with an interesting obstacle: how could I build an education center in Afghanistan without ever leaving the US? 

To make this possible, I turned to technology—just as I had hoped my future students would. I took a side job teaching Farsi to pay my bills, and built the blueprint for Code to Inspire from a laptop in Brooklyn. I managed everything from my computer working from cafes in New York: fundraising, shipping equipment, recruiting mentors, registering applicants, and developing the curriculum.

To move things forward day-to-day, I use G Suite to communicate and collaborate with my team. I use Hangouts Meet to connect with students remotely during weekly calls and monthly check-ins. We use Google Docs, Sheets and Slides to create essential documents and keep track of our operations. We even used Slides for our first pitch deck, which I shared with my board to get their feedback. This power and connectivity enabled a refugee to make her dream come true, and built up the digital literacy of the women I was working with back home!

Since opening its doors, 150 girls have studied with us, and the students have created so many interesting projects. One inspiring example is the popular mobile game, Afghan Hero Girl, which has taken off in Afghanistan and abroad, and was even recognized by the local government. The girls developed the game to show a female protagonist dressed in traditional Afghan garb, who undergoes obstacles that are relatable to them.  

Over 50 women have graduated from Code to Inspire, and 20 have secured remote full-time employment and freelance projects. Many of these women are even out-earning their male relatives who have become huge supporters of the program.

By 2030, we hope to open two additional schools in Kabul and Mazar that can serve up to 500 girls and provide employment opportunities within six months of graduation. From the ruins of a shattered nation and shattered lives of refugees can come treasure, if we know where to find it. For me, the girls in Afghanistan are the treasure and investing in their education is the future of a peaceful Afghanistan.