Welcome!

@CloudExpo Authors: Elizabeth White, John Rauser, Mark Leake, Liz McMillan, Derek Weeks

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
In his session at @ThingsExpo, Eric Lachapelle, CEO of the Professional Evaluation and Certification Board (PECB), provided an overview of various initiatives to certify the security of connected devices and future trends in ensuring public trust of IoT. Eric Lachapelle is the Chief Executive Officer of the Professional Evaluation and Certification Board (PECB), an international certification body. His role is to help companies and individuals to achieve professional, accredited and worldwide re...
The current age of digital transformation means that IT organizations must adapt their toolset to cover all digital experiences, beyond just the end users’. Today’s businesses can no longer focus solely on the digital interactions they manage with employees or customers; they must now contend with non-traditional factors. Whether it's the power of brand to make or break a company, the need to monitor across all locations 24/7, or the ability to proactively resolve issues, companies must adapt to...
Wooed by the promise of faster innovation, lower TCO, and greater agility, businesses of every shape and size have embraced the cloud at every layer of the IT stack – from apps to file sharing to infrastructure. The typical organization currently uses more than a dozen sanctioned cloud apps and will shift more than half of all workloads to the cloud by 2018. Such cloud investments have delivered measurable benefits. But they’ve also resulted in some unintended side-effects: complexity and risk. ...
It is ironic, but perhaps not unexpected, that many organizations who want the benefits of using an Agile approach to deliver software use a waterfall approach to adopting Agile practices: they form plans, they set milestones, and they measure progress by how many teams they have engaged. Old habits die hard, but like most waterfall software projects, most waterfall-style Agile adoption efforts fail to produce the results desired. The problem is that to get the results they want, they have to ch...
With major technology companies and startups seriously embracing Cloud strategies, now is the perfect time to attend 21st Cloud Expo October 31 - November 2, 2017, at the Santa Clara Convention Center, CA, and June 12-14, 2018, at the Javits Center in New York City, NY, and learn what is going on, contribute to the discussions, and ensure that your enterprise is on the right path to Digital Transformation.
In 2014, Amazon announced a new form of compute called Lambda. We didn't know it at the time, but this represented a fundamental shift in what we expect from cloud computing. Now, all of the major cloud computing vendors want to take part in this disruptive technology. In his session at 20th Cloud Expo, Doug Vanderweide, an instructor at Linux Academy, discussed why major players like AWS, Microsoft Azure, IBM Bluemix, and Google Cloud Platform are all trying to sidestep VMs and containers wit...
The taxi industry never saw Uber coming. Startups are a threat to incumbents like never before, and a major enabler for startups is that they are instantly “cloud ready.” If innovation moves at the pace of IT, then your company is in trouble. Why? Because your data center will not keep up with frenetic pace AWS, Microsoft and Google are rolling out new capabilities. In his session at 20th Cloud Expo, Don Browning, VP of Cloud Architecture at Turner, posited that disruption is inevitable for comp...
No hype cycles or predictions of zillions of things here. IoT is big. You get it. You know your business and have great ideas for a business transformation strategy. What comes next? Time to make it happen. In his session at @ThingsExpo, Jay Mason, Associate Partner at M&S Consulting, presented a step-by-step plan to develop your technology implementation strategy. He discussed the evaluation of communication standards and IoT messaging protocols, data analytics considerations, edge-to-cloud tec...
New competitors, disruptive technologies, and growing expectations are pushing every business to both adopt and deliver new digital services. This ‘Digital Transformation’ demands rapid delivery and continuous iteration of new competitive services via multiple channels, which in turn demands new service delivery techniques – including DevOps. In this power panel at @DevOpsSummit 20th Cloud Expo, moderated by DevOps Conference Co-Chair Andi Mann, panelists examined how DevOps helps to meet the de...
When growing capacity and power in the data center, the architectural trade-offs between server scale-up vs. scale-out continue to be debated. Both approaches are valid: scale-out adds multiple, smaller servers running in a distributed computing model, while scale-up adds fewer, more powerful servers that are capable of running larger workloads. It’s worth noting that there are additional, unique advantages that scale-up architectures offer. One big advantage is large memory and compute capacity...
"When we talk about cloud without compromise what we're talking about is that when people think about 'I need the flexibility of the cloud' - it's the ability to create applications and run them in a cloud environment that's far more flexible,” explained Matthew Finnie, CTO of Interoute, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
Cloud applications are seeing a deluge of requests to support the exploding advanced analytics market. “Open analytics” is the emerging strategy to deliver that data through an open data access layer, in the cloud, to be directly consumed by external analytics tools and popular programming languages. An increasing number of data engineers and data scientists use a variety of platforms and advanced analytics languages such as SAS, R, Python and Java, as well as frameworks such as Hadoop and Spark...
The Internet giants are fully embracing AI. All the services they offer to their customers are aimed at drawing a map of the world with the data they get. The AIs from these companies are used to build disruptive approaches that cannot be used by established enterprises, which are threatened by these disruptions. However, most leaders underestimate the effect this will have on their businesses. In his session at 21st Cloud Expo, Rene Buest, Director Market Research & Technology Evangelism at Ara...
Join us at Cloud Expo June 6-8 to find out how to securely connect your cloud app to any cloud or on-premises data source – without complex firewall changes. More users are demanding access to on-premises data from their cloud applications. It’s no longer a “nice-to-have” but an important differentiator that drives competitive advantages. It’s the new “must have” in the hybrid era. Users want capabilities that give them a unified view of the data to get closer to customers and grow business. The...
"We are a monitoring company. We work with Salesforce, BBC, and quite a few other big logos. We basically provide monitoring for them, structure for their cloud services and we fit into the DevOps world" explained David Gildeh, Co-founder and CEO of Outlyer, in this SYS-CON.tv interview at DevOps Summit at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
"Loom is applying artificial intelligence and machine learning into the entire log analysis process, from start to finish and at the end you will get a human touch,” explained Sabo Taylor Diab, Vice President, Marketing at Loom Systems, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
"Tintri focuses on the Ops side of the DevOps, which basically is pushing more and more of the accessibility of the infrastructure to the developers and trying to get behind the scenes," explained Dhiraj Sehgal of Tintri in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
@DevOpsSummit at Cloud Expo taking place Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center, Santa Clara, CA, is co-located with the 21st International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is ...
You know you need the cloud, but you’re hesitant to simply dump everything at Amazon since you know that not all workloads are suitable for cloud. You know that you want the kind of ease of use and scalability that you get with public cloud, but your applications are architected in a way that makes the public cloud a non-starter. You’re looking at private cloud solutions based on hyperconverged infrastructure, but you’re concerned with the limits inherent in those technologies.
A look across the tech landscape at the disruptive technologies that are increasing in prominence and speculate as to which will be most impactful for communications – namely, AI and Cloud Computing. In his session at 20th Cloud Expo, Curtis Peterson, VP of Operations at RingCentral, highlighted the current challenges of these transformative technologies and shared strategies for preparing your organization for these changes. This “view from the top” outlined the latest trends and developments i...