Welcome!

@CloudExpo Authors: Pat Romanski, Yeshim Deniz, Elizabeth White, Liz McMillan, Mamoon Yunus

Related Topics: @CloudExpo, Agile Computing, @BigDataExpo

@CloudExpo: Blog Post

Would You Use Your Car to Plow a Field? By @IanKhanLive | @CloudExpo #Cloud

One of the most common ways of managing information and data in general has traditionally been through the use of spreadsheets

Ask anyone who is working with data "What is your biggest challenge?" The answer most of the time is "the inability to use our data fully." This and similar statements signify one common thread of pain. With data growing at 44% over the next 10 years, it goes without saying that your business is going to be inundated with data from all sides. With "making a profit" on the minds of over 35% of SMB survey respondents, it goes without saying that the challenge is multi-fold with being able to sustain the business and ensure profitability being prime.

How Is SMB Analyzing Data
One of the most common ways of managing information and data in general has traditionally been through the use of spreadsheets. Spreadsheets applications such as Microsoft Excel and others have changed the way we manage information and work with information on an everyday basis. Information workers really benefited from spreadsheets and from that we should really credit the companies that invented them.

In today's data-intensive applications and now that data is being generated to the tune of zettabytes, some challenges have arisen.

Spreadsheets Are Great But!
There are over 750 million Excel users worldwide. These users are comprised of power users, casual users, and users who manage every aspect of their business performance in Excel. The usage of spreadsheets has become more rampant not only in the financial side of things but also in every other aspect of business to the extent that users and organizations today are glued to spreadsheets like never before. Business operations are fed by an intricate maze of connected spreadsheets that define price lists, financial models, revenue projections, production data, weather data, patterns, forecasts and more. Spreadsheets have also led to the phenomenon of ‘spreadsheet addiction" where spreadsheets are being used for every aspect of business, in essence jeopardizing the essence of business. One example that I can point out is actually that of a large bank that inaccurately used Excel to generate a financial projection that potentially jeopardized the entire organization. Here take a peek at the Report of "JPMorgan Chase & Co. Management Task Force Regarding 2012 CIO Losses" that will give you a completely different perspective on how Excel was used in the most inappropriate financial manner. Let's for once agree now that while Excel sheets have tremendous features and functionality, they are not a Swiss army knife of data and information.

The Problem with Business Intelligence and Analytics
BI and analytics form a key strategic part of a business that is key to the overall success of the organization. To do justice to Excel, I must mention that Excel was never designed to be a business intelligence and analytics platform. Imagine using your Chevy to plow the fields. Yes it can be done with due medications and a large amount of welding, breaking and re-welding, but it's not meant to be. It's not what it was designed to do. It's the same case with Excel. It is not a BI tool and was never designed to be one, so Mr. IT Manager who knows it all, just stop.

Why Do Folks Use Excel
Excel is conveniently available as part of your Microsoft Office. Other companies use Excel in this format; Excel is easy to use; Excel has Pivot Charts; Excel has graphs and charts; I can design a macro in Excel. And so on. These are some of the answers we got when we asked a random set of Excel BI users why they were using Excel for analytics. Not one of them responded that they were using Excel because it was one of the best BI tools they had ever seen. I hope you get the picture. I don't blame any of this on Excel or spreadsheets but the whole blame is on vendors that have failed to inform their customers of the true value they can unlock with a true analytics platform or solution. A system based on sharing files is also prone to the problem of data insecurity. Spreadsheets are stored on network shares, private computers, on non-secure online applications and as things go, face the problem of not being able to maintain versions and security in the most efficient way. Adding to that is the problem of the inability of easily integrating with the multiple data sources that hold your data. This now being cloud databases plus many more. I hope you are seeing the larger picture.

Do You Really Want Data to Drive Intelligence for Your Business
You have to start thinking differently. With business intelligence or analytics, you have to go through a new route to get to the destination you really want to go to. The traditional ways of IT that worked 20 years ago have been transformed and the battle today is more about helping people lose their bad habits than helping them adapt and build new habits. Building habits, although time- consuming, may have an effect on your bottom line. If you are one of the businesses that are looking for sustenance and profitability, let alone growth, you may need to emphasize this more than anything else. BI challenges are faced by companies of all sizes and every type of business. Data analysis users within these organizations are still battling the demons of spreadsheets just like anyone else. Start thinking of your needs perspective and look at best practices that will help you achieve more in less time with fewer resources. In many cases you can use the investment in manual time-consuming tasks to scale building applications and growth that will help your business grow.

I am also running a webinar about the challenges of Spreadsheets and Analytics on Feb 24. Join me to learn more and how you can shift your organizations focus to that of a profitable entity. More than anything I want you to keep your Chevy and utilize it for your personal use rather than use it to plow the fields. There are other specialized vehicles that can do that.

More Stories By Ian Khan

Ian Khan leads Innovation & Marketing initiatives at Solgenia, a global Cloud services provider with more than 3500 enterprise customers globally that includes Top Fortune 100 and Fortune 500 companies. An advocate of Cloud computing and a thought leader driving change within the industry, Ian is a catalyst for collaboration and Cloud solutions.

He has written for multiple industry publications, presented at various industry events worldwide, and brings more than 15 years of in depth technology experience across various industries.

Ian is a PMP Certified Project Manager, MCSE, and an Instrumentation Technology engineer.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


@CloudExpo Stories
As businesses adopt functionalities in cloud computing, it’s imperative that IT operations consistently ensure cloud systems work correctly – all of the time, and to their best capabilities. In his session at @BigDataExpo, Bernd Harzog, CEO and founder of OpsDataStore, presented an industry answer to the common question, “Are you running IT operations as efficiently and as cost effectively as you need to?” He then expounded on the industry issues he frequently came up against as an analyst, and ...
SYS-CON Events announced today that Datera, that offers a radically new data management architecture, has been named "Exhibitor" of SYS-CON's 21st International Cloud Expo ®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Datera is transforming the traditional datacenter model through modern cloud simplicity. The technology industry is at another major inflection point. The rise of mobile, the Internet of Things, data storage and Big...
FinTechs use the cloud to operate at the speed and scale of digital financial activity, but are often hindered by the complexity of managing security and compliance in the cloud. In his session at 20th Cloud Expo, Sesh Murthy, co-founder and CTO of Cloud Raxak, showed how proactive and automated cloud security enables FinTechs to leverage the cloud to achieve their business goals. Through business-driven cloud security, FinTechs can speed time-to-market, diminish risk and costs, maintain continu...
As more and more companies are making the shift from on-premises to public cloud, the standard approach to DevOps is evolving. From encryption, compliance and regulations like GDPR, security in the cloud has become a hot topic. Many DevOps-focused companies have hired dedicated staff to fulfill these requirements, often creating further siloes, complexity and cost. This session aims to highlight existing DevOps cultural approaches, tooling and how security can be wrapped in every facet of the bu...
SYS-CON Events announced today that CA Technologies has been named "Platinum Sponsor" of SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CA Technologies helps customers succeed in a future where every business - from apparel to energy - is being rewritten by software. From planning to development to management to security, CA creates software that fuels transformation for companies in the applic...
SYS-CON Events announced today that Pulzze Systems will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Pulzze Systems Inc, provides the software product "The Interactor" that uniquely simplifies building IoT, Web and Smart Enterprise Solutions. It is a Silicon Valley startup funded by US government agencies, NSF and DHS to bring innovative solutions to market.
As many know, the first generation of Cloud Management Platform (CMP) solutions were designed for managing virtual infrastructure (IaaS) and traditional applications. But that’s no longer enough to satisfy evolving and complex business requirements. In his session at 21st Cloud Expo, Scott Davis, Embotics CTO, will explore how next-generation CMPs ensure organizations can manage cloud-native and microservice-based application architectures, while also facilitating agile DevOps methodology. He wi...
SYS-CON Events announced today that CAST Software will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CAST was founded more than 25 years ago to make the invisible visible. Built around the idea that even the best analytics on the market still leave blind spots for technical teams looking to deliver better software and prevent outages, CAST provides the software intelligence that matter ...
Businesses and business units of all sizes can benefit from cloud computing, but many don't want the cost, performance and security concerns of public cloud nor the complexity of building their own private clouds. Today, some cloud vendors are using artificial intelligence (AI) to simplify cloud deployment and management. In his session at 20th Cloud Expo, Ajay Gulati, Co-founder and CEO of ZeroStack, discussed how AI can simplify cloud operations. He covered the following topics: why cloud mana...
From 2013, NTT Communications has been providing cPaaS service, SkyWay. Its customer’s expectations for leveraging WebRTC technology are not only typical real-time communication use cases such as Web conference, remote education, but also IoT use cases such as remote camera monitoring, smart-glass, and robotic. Because of this, NTT Communications has numerous IoT business use-cases that its customers are developing on top of PaaS. WebRTC will lead IoT businesses to be more innovative and address...
Blockchain is a shared, secure record of exchange that establishes trust, accountability and transparency across business networks. Supported by the Linux Foundation's open source, open-standards based Hyperledger Project, Blockchain has the potential to improve regulatory compliance, reduce cost as well as advance trade. Are you curious about how Blockchain is built for business? In her session at 21st Cloud Expo, René Bostic, Technical VP of the IBM Cloud Unit in North America, will discuss th...
While some vendors scramble to create and sell you a fancy solution for monitoring your spanking new Amazon Lambdas, hear how you can do it on the cheap using just built-in Java APIs yourself. By exploiting a little-known fact that Lambdas aren’t exactly single-threaded, you can effectively identify hot spots in your serverless code. In his session at @DevOpsSummit at 21st Cloud Expo, Dave Martin, Product owner at CA Technologies, will give a live demonstration and code walkthrough, showing how ...
WebRTC is great technology to build your own communication tools. It will be even more exciting experience it with advanced devices, such as a 360 Camera, 360 microphone, and a depth sensor camera. In his session at @ThingsExpo, Masashi Ganeko, a manager at INFOCOM Corporation, will introduce two experimental projects from his team and what they learned from them. "Shotoku Tamago" uses the robot audition software HARK to track speakers in 360 video of a remote party. "Virtual Teleport" uses a...
Translating agile methodology into real-world best practices within the modern software factory has driven widespread DevOps adoption, yet much work remains to expand workflows and tooling across the enterprise. As models evolve from pockets of experimentation into wholescale organizational reinvention, practitioners find themselves challenged to incorporate the culture and architecture necessary to support DevOps at scale.
When shopping for a new data processing platform for IoT solutions, many development teams want to be able to test-drive options before making a choice. Yet when evaluating an IoT solution, it’s simply not feasible to do so at scale with physical devices. Building a sensor simulator is the next best choice; however, generating a realistic simulation at very high TPS with ease of configurability is a formidable challenge. When dealing with multiple application or transport protocols, you would be...
SYS-CON Events announced today that CA Technologies has been named “Platinum Sponsor” of SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CA Technologies helps customers succeed in a future where every business – from apparel to energy – is being rewritten by software. From planning to development to management to security, CA creates software that fuels transformation for companies in the applic...
yperConvergence came to market with the objective of being simple, flexible and to help drive down operating expenses. It reduced the footprint by bundling the compute/storage/network into one box. This brought a new set of challenges as the HyperConverged vendors are very focused on their own proprietary building blocks. If you want to scale in a certain way, let’s say you identified a need for more storage and want to add a device that is not sold by the HyperConverged vendor, forget about it....
With Cloud Foundry you can easily deploy and use apps utilizing websocket technology, but not everybody realizes that scaling them out is not that trivial. In his session at 21st Cloud Expo, Roman Swoszowski, CTO and VP, Cloud Foundry Services, at Grape Up, will show you an example of how to deal with this issue. He will demonstrate a cloud-native Spring Boot app running in Cloud Foundry and communicating with clients over websocket protocol that can be easily scaled horizontally and coordinate...
SYS-CON Events announced today that Elastifile will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Elastifile Cloud File System (ECFS) is software-defined data infrastructure designed for seamless and efficient management of dynamic workloads across heterogeneous environments. Elastifile provides the architecture needed to optimize your hybrid cloud environment, by facilitating efficient...
For financial firms, the cloud is going to increasingly become a crucial part of dealing with customers over the next five years and beyond, particularly with the growing use and acceptance of virtual currencies. There are new data storage paradigms on the horizon that will deliver secure solutions for storing and moving sensitive financial data around the world without touching terrestrial networks. In his session at 20th Cloud Expo, Cliff Beek, President of Cloud Constellation Corporation, d...