Welcome!

Agile Computing Authors: Pat Romanski, Shelly Palmer, Glenda Sims, Paul Simmons, APM Blog

Related Topics: @CloudExpo, Agile Computing, @DXWorldExpo

@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

CNN Futurist, Forbes Contributor, Author, 3 Time TEDx Speaker and Technology Futurist, over the last 20 years Ian Khan has had the privilege to serve the needs of over 5000 organizations by fueling their growth through technology solutions. He has helped a diverse set of businesses ranging from Technology Companies, Oil Companies, Power Generation & Renewables Operators, Microsoft Ecosystem Partners, SAP Customers and Partners, Healthcare Providers, Manufacturers, Facility Operators, Startups, Educational Institutions, Nonprofits & associations and more. Ian’s experiences with these organizations led him to a unique position of being able to identify the common challenges of growth for all these organizations. The bottom line as he found out, is that we all are hungry for success and want to grow and make a difference. Where we fall short is by failing to understand our environment and taking the right action within that environment. After 20 years serving the needs of the industry Ian’s natural pivot was to answer his calling and help organizations at a broader level understand what tomorrow brings. His work and study of all these organizations brought forward very unique perspectives that he now share through his work. Today, hands down, we live in the great time for humanity. Technology is a great thing, but it also has its victims. Many organizations of tomorrow will fail under the pressure of a fast changing world, much of which is fueled and driven by technology. Ian’s mission is to help organizations avoid that pitfall, and propel themselves into success in today’s era and go from digital disruption to digital transformation in the fastest and most sustainable way. This is the only way, according to him, we can together create limitless value, create solutions that are faced by us locally as well as by others around the globe, and make the world a happier place. Today Ian’s work spans working with people by delivering keynotes, consulting and by promoting his 7 –Axioms methodology through his book and workshops. He is also working on an ambitious project of releasing a documentary in spring of 2018 called Industry 4.0. Industry 4.0 will capture the thoughts and insights of some of the world’s leading thinkers and help us understand the 4th Industrial Revolution, Its Impact, and how we can all be have an opportunity to be part of the emerging future and make the right choices. For more information please visit www.iankhan.com

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.


@ThingsExpo Stories
DX World EXPO, LLC, a Lighthouse Point, Florida-based startup trade show producer and the creator of "DXWorldEXPO® - Digital Transformation Conference & Expo" has announced its executive management team. The team is headed by Levent Selamoglu, who has been named CEO. "Now is the time for a truly global DX event, to bring together the leading minds from the technology world in a conversation about Digital Transformation," he said in making the announcement.
"Space Monkey by Vivent Smart Home is a product that is a distributed cloud-based edge storage network. Vivent Smart Home, our parent company, is a smart home provider that places a lot of hard drives across homes in North America," explained JT Olds, Director of Engineering, and Brandon Crowfeather, Product Manager, at Vivint Smart Home, in this SYS-CON.tv interview at @ThingsExpo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
SYS-CON Events announced today that Conference Guru has been named “Media Sponsor” of the 22nd International Cloud Expo, which will take place on June 5-7, 2018, at the Javits Center in New York, NY. A valuable conference experience generates new contacts, sales leads, potential strategic partners and potential investors; helps gather competitive intelligence and even provides inspiration for new products and services. Conference Guru works with conference organizers to pass great deals to gre...
The Internet of Things will challenge the status quo of how IT and development organizations operate. Or will it? Certainly the fog layer of IoT requires special insights about data ontology, security and transactional integrity. But the developmental challenges are the same: People, Process and Platform. In his session at @ThingsExpo, Craig Sproule, CEO of Metavine, demonstrated how to move beyond today's coding paradigm and shared the must-have mindsets for removing complexity from the develop...
In his Opening Keynote at 21st Cloud Expo, John Considine, General Manager of IBM Cloud Infrastructure, led attendees through the exciting evolution of the cloud. He looked at this major disruption from the perspective of technology, business models, and what this means for enterprises of all sizes. John Considine is General Manager of Cloud Infrastructure Services at IBM. In that role he is responsible for leading IBM’s public cloud infrastructure including strategy, development, and offering m...
"Evatronix provides design services to companies that need to integrate the IoT technology in their products but they don't necessarily have the expertise, knowledge and design team to do so," explained Adam Morawiec, VP of Business Development at Evatronix, in this SYS-CON.tv interview at @ThingsExpo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
To get the most out of their data, successful companies are not focusing on queries and data lakes, they are actively integrating analytics into their operations with a data-first application development approach. Real-time adjustments to improve revenues, reduce costs, or mitigate risk rely on applications that minimize latency on a variety of data sources. In his session at @BigDataExpo, Jack Norris, Senior Vice President, Data and Applications at MapR Technologies, reviewed best practices to ...
Widespread fragmentation is stalling the growth of the IIoT and making it difficult for partners to work together. The number of software platforms, apps, hardware and connectivity standards is creating paralysis among businesses that are afraid of being locked into a solution. EdgeX Foundry is unifying the community around a common IoT edge framework and an ecosystem of interoperable components.
Large industrial manufacturing organizations are adopting the agile principles of cloud software companies. The industrial manufacturing development process has not scaled over time. Now that design CAD teams are geographically distributed, centralizing their work is key. With large multi-gigabyte projects, outdated tools have stifled industrial team agility, time-to-market milestones, and impacted P&L stakeholders.
"Akvelon is a software development company and we also provide consultancy services to folks who are looking to scale or accelerate their engineering roadmaps," explained Jeremiah Mothersell, Marketing Manager at Akvelon, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
"IBM is really all in on blockchain. We take a look at sort of the history of blockchain ledger technologies. It started out with bitcoin, Ethereum, and IBM evaluated these particular blockchain technologies and found they were anonymous and permissionless and that many companies were looking for permissioned blockchain," stated René Bostic, Technical VP of the IBM Cloud Unit in North America, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Conventi...
In his session at 21st Cloud Expo, Carl J. Levine, Senior Technical Evangelist for NS1, will objectively discuss how DNS is used to solve Digital Transformation challenges in large SaaS applications, CDNs, AdTech platforms, and other demanding use cases. Carl J. Levine is the Senior Technical Evangelist for NS1. A veteran of the Internet Infrastructure space, he has over a decade of experience with startups, networking protocols and Internet infrastructure, combined with the unique ability to it...
22nd International Cloud Expo, taking place June 5-7, 2018, at the Javits Center in New York City, NY, and co-located with the 1st DXWorld Expo will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud ...
"Cloud Academy is an enterprise training platform for the cloud, specifically public clouds. We offer guided learning experiences on AWS, Azure, Google Cloud and all the surrounding methodologies and technologies that you need to know and your teams need to know in order to leverage the full benefits of the cloud," explained Alex Brower, VP of Marketing at Cloud Academy, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clar...
Gemini is Yahoo’s native and search advertising platform. To ensure the quality of a complex distributed system that spans multiple products and components and across various desktop websites and mobile app and web experiences – both Yahoo owned and operated and third-party syndication (supply), with complex interaction with more than a billion users and numerous advertisers globally (demand) – it becomes imperative to automate a set of end-to-end tests 24x7 to detect bugs and regression. In th...
"MobiDev is a software development company and we do complex, custom software development for everybody from entrepreneurs to large enterprises," explained Alan Winters, U.S. Head of Business Development at MobiDev, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
Coca-Cola’s Google powered digital signage system lays the groundwork for a more valuable connection between Coke and its customers. Digital signs pair software with high-resolution displays so that a message can be changed instantly based on what the operator wants to communicate or sell. In their Day 3 Keynote at 21st Cloud Expo, Greg Chambers, Global Group Director, Digital Innovation, Coca-Cola, and Vidya Nagarajan, a Senior Product Manager at Google, discussed how from store operations and ...
"There's plenty of bandwidth out there but it's never in the right place. So what Cedexis does is uses data to work out the best pathways to get data from the origin to the person who wants to get it," explained Simon Jones, Evangelist and Head of Marketing at Cedexis, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
SYS-CON Events announced today that CrowdReviews.com has been named “Media Sponsor” of SYS-CON's 22nd International Cloud Expo, which will take place on June 5–7, 2018, at the Javits Center in New York City, NY. CrowdReviews.com is a transparent online platform for determining which products and services are the best based on the opinion of the crowd. The crowd consists of Internet users that have experienced products and services first-hand and have an interest in letting other potential buye...
SYS-CON Events announced today that Telecom Reseller has been named “Media Sponsor” of SYS-CON's 22nd International Cloud Expo, which will take place on June 5-7, 2018, at the Javits Center in New York, NY. Telecom Reseller reports on Unified Communications, UCaaS, BPaaS for enterprise and SMBs. They report extensively on both customer premises based solutions such as IP-PBX as well as cloud based and hosted platforms.