Is The Cloud Ready For Data Warehousing?

Lindsey Nelson

Is The Cloud Ready For Data Warehousing?Infinite capacity, fast deployments, and high availability – at trivial cost. What’s not to like about public clouds? Even setting data privacy and security aside, for data warehousing, likeability depends on database workloads.

True, Web and online start-ups have shown us that the cloud can support transaction processing, with its relatively simple and predictable access patterns.

But for the complex compute- and read-intensive characteristics of business intelligence (BI) and analytics workloads, success with public clouds is problematic. If the history of the commoditization of electricity generation and transmission teaches us anything, it’s that we’re at least five years away the mature, standardized public cloud architecture needed to support BI and analytics. So for the next five years, IT will be discussing private clouds as the promising alternative.

In a recent white paper from Third Nature, research analyst and former CTO Mark Madsen describes the experiences of several organizations that have moved from traditional server-based data warehousing to a private cloud. The benefits of applying the private cloud model to standard approaches for BI analytics are compelling.

Enterprise-wide control: From system to platform – The data warehouse is no longer constrained as a passive repository and reporting system that often left BI and analytics siloed. The cloud-based data warehouse allows IT to support separate environments for different groups – all integrated and managed within a single platform.

Cost: From product to service – Planning data warehouse infrastructure no longer centers on capacity planning and up-front payments. The cloud pay-for-use model allows companies to shift the mix of money from capital expenses to operating expenses, which can be pushed to the business departments and lead to faster management approval of BI projects.

Performance: From managing for peaks to self-service provisioning – Environments are no longer sized for expected peak workloads – and adjusted quarterly at best. On-demand and automatic resource provisioning accommodate the unplanned, real-time demand typical of BI and analytics projects.

Agility: From long lead times to on-demand capacity – Large projects are no longer the only above-the-line projects. On-demand resources allow IT to quickly develop, test, and deploy even small BI and analytic projects as needed.

According to Madsen, the private cloud works as an environment for BI and analytics workloads, delivering many of the benefits of public clouds without some of the problems. Download “Cloud Computing Models for Data Warehousing” for an in-depth discussion of this topic.

About Lindsey Nelson

Lindsey is the Content Curator for the Business Innovation site as well as a regular contributor. Join her in conversation @LindseyNNelson Twitter on LinkedIn or Google+.

Recommended for you:

13 Scary Statistics On Employee Engagement [INFOGRAPHIC]

Jacob Shriar

There is a serious problem with the way we work.

Most employees are disengaged and not passionate about the work they do. This is costing companies a ton of money in lost productivity, absenteeism, and turnover. It’s also harmful to employees, because they’re more stressed out than ever.

The thing that bothers me the most about it, is that it’s all so easy to fix. I can’t figure out why managers aren’t more proactive about this. Besides the human element of caring for our employees, it’s costing them money, so they should care more about fixing it. Something as simple as saying thank you to your employees can have a huge effect on their engagement, not to mention it’s good for your level of happiness.

The infographic that we put together has some pretty shocking statistics in it, but there are a few common themes. Employees feel overworked, overwhelmed, and they don’t like what they do. Companies are noticing it, with 75% of them saying they can’t attract the right talent, and 83% of them feeling that their employer brand isn’t compelling. Companies that want to fix this need to be smart, and patient. This doesn’t happen overnight, but like I mentioned, it’s easy to do. Being patient might be the hardest thing for companies, and I understand how frustrating it can be not to see results right away, but it’s important that you invest in this, because the ROI of employee engagement is huge.

Here are 4 simple (and free) things you can do to get that passion back into employees. These are all based on research from Deloitte.

1.  Encourage side projects

Employees feel overworked and underappreciated, so as leaders, we need to stop overloading them to the point where they can’t handle the workload. Let them explore their own passions and interests, and work on side projects. Ideally, they wouldn’t have to be related to the company, but if you’re worried about them wasting time, you can set that boundary that it has to be related to the company. What this does, is give them autonomy, and let them improve on their skills (mastery), two of the biggest motivators for work.

Employees feel overworked and underappreciated, so as leaders, we need to stop overloading them to the point where they can’t handle the workload.

2.  Encourage workers to engage with customers

At Wistia, a video hosting company, they make everyone in the company do customer support during their onboarding, and they often rotate people into customer support. When I asked Chris, their CEO, why they do this, he mentioned to me that it’s so every single person in the company understands how their customers are using their product. What pains they’re having, what they like about it, it gets everyone on the same page. It keeps all employees in the loop, and can really motivate you to work when you’re talking directly with customers.

3.  Encourage workers to work cross-functionally

Both Apple and Google have created common areas in their offices, specifically and strategically located, so that different workers that don’t normally interact with each other can have a chance to chat.

This isn’t a coincidence. It’s meant for that collaborative learning, and building those relationships with your colleagues.

4.  Encourage networking in their industry

This is similar to number 2 on the list, but it’s important for employees to grow and learn more about what they do. It helps them build that passion for their industry. It’s important to go to networking events, and encourage your employees to participate in these things. Websites like Eventbrite or Meetup have lots of great resources, and most of the events on there are free.

13 Disturbing Facts About Employee Engagement [Infographic]

What do you do to increase employee engagement? Let me know your thoughts in the comments!

Did you like today’s post? If so you’ll love our frequent newsletter! Sign up here and receive The Switch and Shift Change Playbook, by Shawn Murphy, as our thanks to you!

This infographic was crafted with love by Officevibe, the employee survey tool that helps companies improve their corporate wellness, and have a better organizational culture.


Recommended for you:

Supply Chain Fraud: The Threat from Within

Lindsey LaManna

Supply chain fraud – whether perpetrated by suppliers, subcontractors, employees, or some combination of those – can take many forms. Among the most common are:

  • Falsified labor
  • Inflated bills or expense accounts
  • Bribery and corruption
  • Phantom vendor accounts or invoices
  • Bid rigging
  • Grey markets (counterfeit or knockoff products)
  • Failure to meet specifications (resulting in substandard or dangerous goods)
  • Unauthorized disbursements

LSAP_Smart Supply Chains_graphics_briefook inside

Perhaps the most damaging sources of supply chain fraud are internal, especially collusion between an employee and a supplier. Such partnerships help fraudsters evade independent checks and other controls, enabling them to steal larger amounts. The median loss from fraud committed
by a single thief was US$80,000, according to the Association of Certified Fraud Examiners (ACFE).

Costs increase along with the number of perpetrators involved. Fraud involving two thieves had a median loss of US$200,000; fraud involving three people had a median loss of US$355,000; and fraud with four or more had a median loss of more than US$500,000, according to ACFE.

Build a culture to fight fraud

The most effective method to fight internal supply chain theft is to create a culture dedicated to fighting it. Here are a few ways to do it:

  • Make sure the board and C-level executives understand the critical nature of the supply chain and the risk of fraud throughout the procurement lifecycle.
  • Market the organization’s supply chain policies internally and among contractors.
  • Institute policies that prohibit conflicts of interest, and cross-check employee and supplier data to uncover potential conflicts.
  • Define the rules for accepting gifts from suppliers and insist that all gifts be documented.
  • Require two employees to sign off on any proposed changes to suppliers.
  • Watch for staff defections to suppliers, and pay close attention to any supplier that has recently poached an employee.

About Lindsey LaManna

Lindsey LaManna is Social and Reporting Manager for the Digitalist Magazine by SAP Global Marketing. Follow @LindseyLaManna on Twitter, on LinkedIn or Google+.


Recommended for you:

Innovation Without Boundaries: Why The Cloud Matters

Michael Haws

Is it possible to innovate without boundaries?

Of course – if you are using the cloud. An actual cloud doesn’t have any boundaries. It’s fluid. But more important, it can provide the much-needed precipitation that brings nature to life. So it is with cloud technology – but it’s your ideas that can grow and transform your business.USA --- Clouds, Heaven --- Image by © Ocean/Corbis

Running your business in the cloud is no longer just a consideration during a typical use-case exercise. Business executives are now faced with making decisions on solutions that go beyond previous limitations with cloud computing. Selecting the latest tools to address a business process gap is now less about features and more about functionality.

It doesn’t matter whether your organization is experienced with cloud solutions or new to the concept. Cloud technology is quickly becoming a core part of addressing the needs of a growing business.

5 considerations when planning your journey to the cloud

How can your organization define its successful path to the cloud? Here are five things you should consider when investigating whether a move to the cloud is right for you.

1. Understanding the cloud is great, but putting it into action is another thing.

For most CIOs, putting a cloud strategy on paper is new territory. Cloud computing is taking on new realms: Pure managed services to software-as-a-service (SaaS). Just as legacy computing had different flavors, so does cloud technology.

2. There is more than one way to innovate in the cloud.

Alignment with an open cloud reference architecture can help your CIO deliver on the promises of the cloud while using a stair-step approach to cloud adoption – from on-premise to hybrid to full cloud computing. Some companies find their own path by constantly reevaluating their needs and shifting their focus when necessary – making the move from running a data center to delivering real value to stakeholders, for example.

3. The cloud can help accelerate processes and lower cost.

By recognizing unprecedented growth, your organization can embark on a path to significant transformation that powers greater agility and competitiveness. Choose a solution set that best meets your needs, and implement and support it moving forward. By leveraging the cloud to support the chosen solution, ongoing maintenance, training, and system issues becomes the cloud provider’s responsibility. And for you, this offers the freedom to focus on the core business.

4. You can lock down your infrastructure and ensure more efficient processes.

Do you use a traditional reporting engine against a large relational database to generate a sequential batched report to close your books at quarter’s end? If so, you’re not alone. Sure, a new solution with new technology may be an obvious improvement. But how valuable to your board will you become when you reduce the financial closing process by 1–3 days? That’s the beauty of the cloud: You can accelerate the deployment of your chosen solution and realize ROI quickly – even before the next full reporting period.

5. The cloud opens the door to new opportunity in a secure environment.

For many companies, moving to the cloud may seem impossible due to the time and effort needed to train workers and hire resources with the right skill sets. Plus, if you are a startup in a rural location, it may not be as easy to attract the right talent as it is for your Silicon Valley counterparts. The cloud allows your business to secure your infrastructure as well as recruit and onboard those hard-to-find resources by applying a managed services contract to run your cloud model

The cloud means many things to different people. What’s your path?

With SAP HANA Enterprise Cloud service, you can navigate the best path to building, running, and operating your own cloud when running critical business processes. Find out how SAP HANA Enterprise Cloud can deliver the speed and resources necessary to quickly validate and realize solid ROI.

Check out the video below or visit us at

Connect with us on Twitter: @SAPServices



Recommended for you:

How To Prepare Your IT Landscape For The Digital Economy

Sei Drake

Remember Tom Cruise’s 2002 movie Minority Report? Set in the futuristic world of 2054, the film featured self-driving cars, autonomous manufacturing robots, and multimedia advertising billboards that broadcast personalized messages to individuals as they passed by. What seemed like science fiction in 2002 is now a reality, with personalized and targeted social media and marketing, smart technologies such as robotics, autonomous vehicles, and 3D printing – not to mention digital machine-to-machine hyperconnectivity of the Internet of Things (IoT). Digital transformation means that all of these things will become the norm in the next few years. The future of many enterprises will depend on their ability to embrace these technologies and innovations.

Over the last two decades, many companies have built large, complex IT landscapes to support traditional business processes. The legacy systems in these landscapes were not designed for the age of Internet hyperconnectivity and the resulting high data and transaction volumes. Extending these landscapes to support new, digitally connected processes and models will further complicate IT landscapes and inhibit business innovation and agility.

The architecture of the digital enterprise will not only need to support Big Data and analytics, but a host of other things. It must also use the datastream from evolving digital technologies to trigger actions and alerts in new and existing business processes, enabling increased revenue, improved customer experience, enhanced supply chain efficiencies, and innovative business models.

To keep pace with rapid change, businesses like yours need to do three things:

  1. Simplify your IT landscape.
  1. Transition to modern platforms such as cloud-based solutions and a “digital core.”
  1. Build innovative business solutions using the latest digital capabilities to  strategically differentiate from both current and future new competitors.

Yet most organizations lack the skills to tackle these tasks alone. So who can best help you navigate this shift? 

Support for a strong foundation 

Surprise! Your best choice may be the support organization of your enterprise software and solutions provider. Over the past 15 years, many enterprise support organizations have evolved beyond providing reactive break/fix support to acting as an architectural quality advisor that can oversee the complete software lifecycle. The support provider is a smart partner for both proactive landscape simplification and co-innovation initiatives.   That’s a fundamental shift driven by the market forces of this “new normal” of digital transformation.

Support providers tend to be close to their customers, understanding their existing technologies, business processes, and revenue models. And because software solution providers often lead in the introduction of new solutions based on the latest innovations and technologies – such as IoT, cloud, robotics, autonomous cars, and 3D printing – their experienced support teams can architect solutions that will give you a strategic and sustainable advantage over your competitors.

The proof is with customers. For example the Global Service & Support organization at SAP is working with a Fortune 100 chemical company on an IT simplification initiative. After numerous mergers and acquisitions over the years, this company needed help consolidating four unique IT landscapes into one. What is an overly complex, burdensome infrastructure will be a simplified, modern solution architecture.

SAP is also working with a large energy distribution company to co-engineer an innovative Big Data, IoT data management solution. The solution is structured to deliver fast, responsive analytics from a data store of 120 terabytes of smart meter data. The utility will use predictive analytics to anticipate demand, allowing buyers to make smarter wholesale energy purchases. In the future, this Big Data and analytics platform will be extended to support innovative solutions for the utility’s customers.

Minimize risk and maximize outcomes 

Working with support organizations to simplify and innovate offers clear benefits, too. These teams are naturally close to their development organizations. They understand cutting-edge technology and they have direct access to the best talent for building new solutions. Support organizations also have extensive experience working in high-volume, high-velocity transaction and data environments.

Because they already know your business and your technology infrastructure, partnering with your software and solutions support provider can reduce risk. Remember that support organizations are measured on their ability to help their customers succeed, not on maximizing billable hours. In a world of “outcomes-based” solutions, that’s a true win-win for all.

When building innovative solutions, support teams develop in short cycles, conduct proof-of-concept exercises, and take steps to minimize cost and risk. And they can do all of this while helping you continue supporting your traditional business operations, looking for opportunities to optimize processes, reduce costs, and increase efficiency.

We may not be able to predict what innovations and new technologies will exist in the year 2054, but we know that there are technology advancements available now that will have a significant impact on our world. Work with your enterprise software provider’s support organization and start planning your digital transformation.

Click here to learn more how Global Service & Support can provide support services to help you prepare for the digital economy and realize rich value.  Visit us at


About Sei Drake

Sei Drake has been helping SAP customers for over 18 years as a solutions expert and architecture advisor. In his current role as a Co-Engineering Architect in the Global Service and Support organization, he helps customers build innovative, industry leading capabilities with SAP technologies.

Recommended for you: