Welcome!

@CloudExpo Authors: Yeshim Deniz, Liz McMillan, Elizabeth White, Pat Romanski, JP Morgenthal

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
SYS-CON Events announced today that CA Technologies has been named “Platinum Sponsor” of 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, and the 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 ...
Niagara Networks exhibited at the 19th International Cloud Expo, which took place at the Santa Clara Convention Center in Santa Clara, CA, in November 2016. Niagara Networks offers the highest port-density systems, and the most complete Next-Generation Network Visibility systems including Network Packet Brokers, Bypass Switches, and Network TAPs.
Extreme Computing is the ability to leverage highly performant infrastructure and software to accelerate Big Data, machine learning, HPC, and Enterprise applications. High IOPS Storage, low-latency networks, in-memory databases, GPUs and other parallel accelerators are being used to achieve faster results and help businesses make better decisions. In his session at 18th Cloud Expo, Michael O'Neill, Strategic Business Development at NVIDIA, focused on some of the unique ways extreme computing is...
SYS-CON Events announced today that HTBase 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. HTBase (Gartner 2016 Cool Vendor) delivers a Composable IT infrastructure solution architected for agility and increased efficiency. It turns compute, storage, and fabric into fluid pools of resources that are easily composed and re-composed to meet each application’s needs. With HTBase, companies can quickly prov...
SYS-CON Events announced today that Outlyer, a monitoring service for DevOps and operations teams, has been named “Bronze Sponsor” of 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. Outlyer is a monitoring service for DevOps and Operations teams running Cloud, SaaS, Microservices and IoT deployments. Designed for today's dynamic environments that need beyond cloud-scale monitoring, we make monitoring effortless so you ...
SYS-CON Events announced today that MobiDev, a client-oriented software development company, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place June 6-8, 2017, at the Javits Center in New York City, NY, and the 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. MobiDev is a software company that develops and delivers turn-key mobile apps, websites, web services, and complex softw...
What if you could build a web application that could support true web-scale traffic without having to ever provision or manage a single server? Sounds magical, and it is! In his session at 20th Cloud Expo, Chris Munns, Senior Developer Advocate for Serverless Applications at Amazon Web Services, will show how to build a serverless website that scales automatically using services like AWS Lambda, Amazon API Gateway, and Amazon S3. We will review several frameworks that can help you build serverle...
In his General Session at 17th Cloud Expo, Bruce Swann, Senior Product Marketing Manager for Adobe Campaign, explored the key ingredients of cross-channel marketing in a digital world. Learn how the Adobe Marketing Cloud can help marketers embrace opportunities for personalized, relevant and real-time customer engagement across offline (direct mail, point of sale, call center) and digital (email, website, SMS, mobile apps, social networks, connected objects).
SYS-CON Events announced today that Hitrons Solutions will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Hitrons Solutions Inc. is distributor in the North American market for unique products and services of small and medium-size businesses, including cloud services and solutions, SEO marketing platforms, and mobile applications.
For organizations that have amassed large sums of software complexity, taking a microservices approach is the first step toward DevOps and continuous improvement / development. Integrating system-level analysis with microservices makes it easier to change and add functionality to applications at any time without the increase of risk. Before you start big transformation projects or a cloud migration, make sure these changes won’t take down your entire organization.
Historically, some banking activities such as trading have been relying heavily on analytics and cutting edge algorithmic tools. The coming of age of powerful data analytics solutions combined with the development of intelligent algorithms have created new opportunities for financial institutions. In his session at 20th Cloud Expo, Sebastien Meunier, Head of Digital for North America at Chappuis Halder & Co., will discuss how these tools can be leveraged to develop a lasting competitive advanta...
Your homes and cars can be automated and self-serviced. Why can't your storage? From simply asking questions to analyze and troubleshoot your infrastructure, to provisioning storage with snapshots, recovery and replication, your wildest sci-fi dream has come true. In his session at @DevOpsSummit at 20th Cloud Expo, Dan Florea, Director of Product Management at Tintri, will provide a ChatOps demo where you can talk to your storage and manage it from anywhere, through Slack and similar services ...
VeriStor Systems has announced that CRN has named VeriStor to its 2017 Managed Service Provider (MSP) 500 list in the Elite 150 category. This annual list recognizes North American solution providers with cutting-edge approaches to delivering managed services. Their offerings help companies navigate the complex and ever-changing landscape of IT, improve operational efficiencies, and maximize their return on IT investments. In today’s fast-paced business environments, MSPs play an important role...
SYS-CON Events announced today that Cloudistics, an on-premises cloud computing company, has been named “Bronze Sponsor” of 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. Cloudistics delivers a complete public cloud experience with composable on-premises infrastructures to medium and large enterprises. Its software-defined technology natively converges network, storage, compute, virtualization, and management into a ...
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...
SYS-CON Events announced today that Juniper Networks (NYSE: JNPR), an industry leader in automated, scalable and secure networks, 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. Juniper Networks challenges the status quo with products, solutions and services that transform the economics of networking. The company co-innovates with customers and partners to deliver automated, scalable and secure network...
My team embarked on building a data lake for our sales and marketing data to better understand customer journeys. This required building a hybrid data pipeline to connect our cloud CRM with the new Hadoop Data Lake. One challenge is that IT was not in a position to provide support until we proved value and marketing did not have the experience, so we embarked on the journey ourselves within the product marketing team for our line of business within Progress. In his session at @BigDataExpo, Sum...
DevOps is often described as a combination of technology and culture. Without both, DevOps isn't complete. However, applying the culture to outdated technology is a recipe for disaster; as response times grow and connections between teams are delayed by technology, the culture will die. A Nutanix Enterprise Cloud has many benefits that provide the needed base for a true DevOps paradigm. In his Day 3 Keynote at 20th Cloud Expo, Chris Brown, a Solutions Marketing Manager at Nutanix, will explore t...
DevOps is often described as a combination of technology and culture. Without both, DevOps isn't complete. However, applying the culture to outdated technology is a recipe for disaster; as response times grow and connections between teams are delayed by technology, the culture will die. A Nutanix Enterprise Cloud has many benefits that provide the needed base for a true DevOps paradigm.
SYS-CON Events announced today that Ocean9will 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. Ocean9 provides cloud services for Backup, Disaster Recovery (DRaaS) and instant Innovation, and redefines enterprise infrastructure with its cloud native subscription offerings for mission critical SAP workloads.