Welcome!

@CloudExpo Authors: Mark Hauser, Yeshim Deniz, Carmen Gonzalez, Bob Gourley, Pat Romanski

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
With billions of sensors deployed worldwide, the amount of machine-generated data will soon exceed what our networks can handle. But consumers and businesses will expect seamless experiences and real-time responsiveness. What does this mean for IoT devices and the infrastructure that supports them? More of the data will need to be handled at - or closer to - the devices themselves.
SYS-CON Events announced today that DatacenterDynamics has been named “Media Sponsor” of SYS-CON's 18th International Cloud Expo, which will take place on June 7–9, 2016, at the Javits Center in New York City, NY. DatacenterDynamics is a brand of DCD Group, a global B2B media and publishing company that develops products to help senior professionals in the world's most ICT dependent organizations make risk-based infrastructure and capacity decisions.
SYS-CON Events announced today that Hitachi, the leading provider the Internet of Things and Digital Transformation, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Hitachi Data Systems, a wholly owned subsidiary of Hitachi, Ltd., offers an integrated portfolio of services and solutions that enable digital transformation through enhanced data management, governance, mobility and analytics. We help globa...
NHK, Japan Broadcasting, will feature the upcoming @ThingsExpo Silicon Valley in a special 'Internet of Things' and smart technology documentary that will be filmed on the expo floor between November 3 to 5, 2015, in Santa Clara. NHK is the sole public TV network in Japan equivalent to the BBC in the UK and the largest in Asia with many award-winning science and technology programs. Japanese TV is producing a documentary about IoT and Smart technology and will be covering @ThingsExpo Silicon Val...
Keeping pace with advancements in software delivery processes and tooling is taxing even for the most proficient organizations. Point tools, platforms, open source and the increasing adoption of private and public cloud services requires strong engineering rigor – all in the face of developer demands to use the tools of choice. As Agile has settled in as a mainstream practice, now DevOps has emerged as the next wave to improve software delivery speed and output. To make DevOps work, organization...
The explosion of new web/cloud/IoT-based applications and the data they generate are transforming our world right before our eyes. In this rush to adopt these new technologies, organizations are often ignoring fundamental questions concerning who owns the data and failing to ask for permission to conduct invasive surveillance of their customers. Organizations that are not transparent about how their systems gather data telemetry without offering shared data ownership risk product rejection, regu...
Building a cross-cloud operational model can be a daunting task. Per-cloud silos are not the answer, but neither is a fully generic abstraction plane that strips out capabilities unique to a particular provider. In his session at 20th Cloud Expo, Chris Wolf, VP & Chief Technology Officer, Global Field & Industry at VMware, will discuss how successful organizations approach cloud operations and management, with insights into where operations should be centralized and when it’s best to decentraliz...
The 20th International Cloud Expo has announced that its Call for Papers is open. Cloud Expo, to be held June 6-8, 2017, at the Javits Center in New York City, brings together Cloud Computing, Big Data, Internet of Things, DevOps, Containers, Microservices and WebRTC to one location. With cloud computing driving a higher percentage of enterprise IT budgets every year, it becomes increasingly important to plant your flag in this fast-expanding business opportunity. Submit your speaking proposal ...
“DevOps is really about the business. The business is under pressure today, competitively in the marketplace to respond to the expectations of the customer. The business is driving IT and the problem is that IT isn't responding fast enough," explained Mark Levy, Senior Product Marketing Manager at Serena Software, in this SYS-CON.tv interview at DevOps Summit, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
@DevOpsSummit at Cloud taking place June 6-8, 2017, at Javits Center, New York City, is co-located with the 20th 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 no time to wait for long developm...
Grape Up is a software company, specialized in cloud native application development and professional services related to Cloud Foundry PaaS. With five expert teams that operate in various sectors of the market across the USA and Europe, we work with a variety of customers from emerging startups to Fortune 1000 companies.
Financial Technology has become a topic of intense interest throughout the cloud developer and enterprise IT communities. Accordingly, attendees at the upcoming 20th Cloud Expo at the Javits Center in New York, June 6-8, 2017, will find fresh new content in a new track called FinTech.
@GonzalezCarmen has been ranked the Number One Influencer and @ThingsExpo has been named the Number One Brand in the “M2M 2016: Top 100 Influencers and Brands” by Analytic. Onalytica analyzed tweets over the last 6 months mentioning the keywords M2M OR “Machine to Machine.” They then identified the top 100 most influential brands and individuals leading the discussion on Twitter.
Cloud Expo, Inc. has announced today that Aruna Ravichandran, vice president of DevOps Product and Solutions Marketing at CA Technologies, has been named co-conference chair of DevOps at Cloud Expo 2017. The @DevOpsSummit at Cloud Expo New York will take place on June 6-8, 2017, at the Javits Center in New York City, New York, and @DevOpsSummit at Cloud Expo Silicon Valley will take place Oct. 31-Nov. 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
Cognitive Computing is becoming the foundation for a new generation of solutions that have the potential to transform business. Unlike traditional approaches to building solutions, a cognitive computing approach allows the data to help determine the way applications are designed. This contrasts with conventional software development that begins with defining logic based on the current way a business operates. In her session at 18th Cloud Expo, Judith S. Hurwitz, President and CEO of Hurwitz & ...
SYS-CON Events announced today that Interoute, owner-operator of one of Europe's largest networks and a global cloud services platform, has been named “Bronze Sponsor” of SYS-CON's 20th Cloud Expo, which will take place on June 6-8, 2017 at the Javits Center in New York, New York. Interoute is the owner-operator of one of Europe's largest networks and a global cloud services platform which encompasses 12 data centers, 14 virtual data centers and 31 colocation centers, with connections to 195 add...
Today we can collect lots and lots of performance data. We build beautiful dashboards and even have fancy query languages to access and transform the data. Still performance data is a secret language only a couple of people understand. The more business becomes digital the more stakeholders are interested in this data including how it relates to business. Some of these people have never used a monitoring tool before. They have a question on their mind like “How is my application doing” but no id...
With major technology companies and startups seriously embracing IoT strategies, now is the perfect time to attend @ThingsExpo 2016 in New York. Learn what is going on, contribute to the discussions, and ensure that your enterprise is as "IoT-Ready" as it can be! Internet of @ThingsExpo, taking place June 6-8, 2017, at the Javits Center in New York City, New York, is co-located with 20th Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry p...
Multiple data types are pouring into IoT deployments. Data is coming in small packages as well as enormous files and data streams of many sizes. Widespread use of mobile devices adds to the total. In this power panel at @ThingsExpo, moderated by Conference Chair Roger Strukhoff, panelists will look at the tools and environments that are being put to use in IoT deployments, as well as the team skills a modern enterprise IT shop needs to keep things running, get a handle on all this data, and deli...
SYS-CON Events announced today that CollabNet, a global leader in enterprise software development, release automation and DevOps solutions, will be a Bronze Sponsor of SYS-CON's 20th International Cloud Expo®, taking place from June 6-8, 2017, at the Javits Center in New York City, NY. CollabNet offers a broad range of solutions with the mission of helping modern organizations deliver quality software at speed. The company’s latest innovation, the DevOps Lifecycle Manager (DLM), supports Value S...