Welcome!

Microsoft Cloud Authors: Yeshim Deniz, Janakiram MSV, Andreas Grabner, Stackify Blog, Liz McMillan

Related Topics: Microsoft Cloud, Silverlight

Microsoft Cloud: Article

You Can Have My Excel When You Pry It from My Cold Dead Hands

Stop articulating about IT and the enterprise technology architect

It's frustrating that business users will often articulate about IT and the enterprise technology architect, but more frequently in an environment where one of the major ERP vendor products like SAP or Oracle Business Suite have been invested in. I am talking about the general disregard and dismissal of the electronic spreadsheet. Even in this era of mobile devices and electronic forms, tweeting, ecommerce and in-memory analytics engines spreadsheets are one of those seemingly Jurassic technologies that IT still appears to have a hard time getting its head around.

I thought I'd drop a few thoughts on the subject simply because lately I have seen a resurgence of solutions where using a spreadsheet was more pivotal to solving the problem than looking exclusively at one of the newer technologies. The Enterprise Architect (for technologies) has a tough job, there's no doubt about that. Blending the right combination of technologies to keep business operations contemporary and agile enough to match or beat competitors is a challenge. There are many choices of vendors, still many platforms and very few clear leaders. The more cautious architect will perhaps have learned from past mistakes or those of predecessors. Examples might be those who bet on technologies like Adobe Flash, Google Wave or WebOS. We always think of those that go with outlier or fringe technology as a strategic direction, as risk takers. Sometimes they are innovators, pioneers or on the bleeding edge. On other occasions they have a significant investment already pinned to the technology choice and there is inevitability to the technology choice. Sometimes the choice is made because many other attempts have been made to solve a particular problem and they have failed.

Spreadsheets have the advantage in that they cover a broad swathe of capabilities that have been difficult to replicate with enterprise software. Your arsenal may include a database, a datamart, your Online Transaction Processing (OLTP) system and a Business Intelligence or Business Warehouse system for slicing and dicing data and performing analytics, but almost certainly you also have a back office automation suite like Microsoft Office, Google Docs or one of the open source suites like Open Office. In the past, Microsoft would report on direct revenues that flowed from Microsoft Office, but these days they aggregate that number with the sales of Microsoft Exchange and SharePoint (this represents a significant portion of their revenue) roughly equating to a third of all revenue. Google has its eye on this space with a twist. Google's objective is to progress business transition from on-premise applications to applications on the cloud. Companies like Winshuttle have of course embraced this direction with support for Google spreadsheets in flagship product Transaction.

In fact electronic spreadsheets are so ubiquitous in business that the mere suggestion that they should be done away with is considered by all but the naïve, as ludicrous. The very flexibility of the spreadsheet is a double edged sword however. The flexibility of being able to insert hundreds of thousands of rows of data into a desktop application to perform some sort of analysis is cause for concern for auditors and information security personnel especially if this tool becomes the preferred environment for maintaining data over the centralized system. Concerns flow from fears that the data will be lost, incorrectly manipulated or inappropriately shared externally. These are all valid concerns and of course measures can be put in place to help to mitigate the risks. Completely disallowing or attempting to block these capabilities are almost never successful.

Offering flexible and adaptable ways to maintain the key systems of record and still address the ad hoc scenarios that the business needs, have to become focal to making everyone a winner without compromising on the fundamental strengths that each technology brings.

I've previously talked about how forms shouldn't be considered the solution to all multi participant or incremental data gathering requirements, and again I'd like to emphasize that spreadsheets shouldn't be considered the best environment for gathering, aggregating and then performing mass actions against certain kinds of data. Spreadsheets by their very nature, are a fluid technology. You can shore up their capability, validation and control with formulae, data validation rules, macros and protected data but eventually you will get to a point where the spreadsheet is so complex that it becomes difficult to debug, tricky to enhance or hard to work with. Spreadsheets are a great place to manipulate presentation, stage data, perform simple what-if analysis or transformations. Be careful about using them when working with hundreds of thousands of records though as small transcription or formatting errors can result in disastrous results like it did for Barclays bank back in 2008 over the Lehman brothers debacle.

Further reading

More Stories By Clinton Jones

Clinton Jones is a Product Manager at Winshuttle. He is experienced in international technology and business process with a focus on integrated business technologies. Clinton also services a technical consultant on technology and quality management as it relates to data and process management and governance. Before coming to Winshuttle, Clinton served as a Technical Quality Manager at SAP. Twitter @winshuttle

@ThingsExpo Stories
"We provide IoT solutions. We provide the most compatible solutions for many applications. Our solutions are industry agnostic and also protocol agnostic," explained Richard Han, Head of Sales and Marketing and Engineering at Systena America, in this SYS-CON.tv interview at @ThingsExpo, held June 6-8, 2017, at the Javits Center in New York City, NY.
"We've been engaging with a lot of customers including Panasonic, we've been involved with Cisco and now we're working with the U.S. government - the Department of Homeland Security," explained Peter Jung, Chief Product Officer at Pulzze Systems, in this SYS-CON.tv interview at @ThingsExpo, held June 6-8, 2017, at the Javits Center in New York City, NY.
SYS-CON Events announced today that Calligo, an innovative cloud service provider offering mid-sized companies the highest levels of data privacy and security, has been named "Bronze Sponsor" 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. Calligo offers unparalleled application performance guarantees, commercial flexibility and a personalised support service from its globally located cloud plat...
Internet of @ThingsExpo, taking place October 31 - November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 21st Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The Internet of Things (IoT) is the most profound change in personal and enterprise IT since the creation of the Worldwide Web more than 20 years ago. All major researchers estimate there will be tens of billions devic...
"The Striim platform is a full end-to-end streaming integration and analytics platform that is middleware that covers a lot of different use cases," explained Steve Wilkes, Founder and CTO at Striim, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
SYS-CON Events announced today that DXWorldExpo has been named “Global Sponsor” 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. Digital Transformation is the key issue driving the global enterprise IT business. Digital Transformation is most prominent among Global 2000 enterprises and government institutions.
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...
"We are focused on SAP running in the clouds, to make this super easy because we believe in the tremendous value of those powerful worlds - SAP and the cloud," explained Frank Stienhans, CTO of Ocean9, Inc., in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
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.
"MobiDev is a Ukraine-based software development company. We do mobile development, and we're specialists in that. But we do full stack software development for entrepreneurs, for emerging companies, and for enterprise ventures," explained Alan Winters, U.S. Head of Business Development at MobiDev, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
While the focus and objectives of IoT initiatives are many and diverse, they all share a few common attributes, and one of those is the network. Commonly, that network includes the Internet, over which there isn't any real control for performance and availability. Or is there? The current state of the art for Big Data analytics, as applied to network telemetry, offers new opportunities for improving and assuring operational integrity. In his session at @ThingsExpo, Jim Frey, Vice President of S...
SYS-CON Events announced today that DXWorldExpo has been named “Global Sponsor” 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. Digital Transformation is the key issue driving the global enterprise IT business. Digital Transformation is most prominent among Global 2000 enterprises and government institutions.
In his opening keynote at 20th Cloud Expo, Michael Maximilien, Research Scientist, Architect, and Engineer at IBM, discussed the full potential of the cloud and social data requires artificial intelligence. By mixing Cloud Foundry and the rich set of Watson services, IBM's Bluemix is the best cloud operating system for enterprises today, providing rapid development and deployment of applications that can take advantage of the rich catalog of Watson services to help drive insights from the vast t...
SYS-CON Events announced today that EnterpriseTech has been named “Media Sponsor” 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. EnterpriseTech is a professional resource for news and intelligence covering the migration of high-end technologies into the enterprise and business-IT industry, with a special focus on high-tech solutions in new product development, workload management, increased effic...
SYS-CON Events announced today that Massive Networks, that helps your business operate seamlessly with fast, reliable, and secure internet and network solutions, 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. As a premier telecommunications provider, Massive Networks is headquartered out of Louisville, Colorado. With years of experience under their belt, their team of...
SYS-CON Events announced today that Cloud Academy named "Bronze Sponsor" of 21st International Cloud Expo which will take place October 31 - November 2, 2017 at the Santa Clara Convention Center in Santa Clara, CA. Cloud Academy is the industry’s most innovative, vendor-neutral cloud technology training platform. Cloud Academy provides continuous learning solutions for individuals and enterprise teams for Amazon Web Services, Microsoft Azure, Google Cloud Platform, and the most popular cloud com...
SYS-CON Events announced today that Cloudistics, an on-premises cloud computing company, has been named “Bronze Sponsor” 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. 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 ...
SYS-CON Events announced today that CHEETAH Training & Innovation 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. CHEETAH Training & Innovation is a cloud consulting and IT training firm specializing in improving clients cloud strategies and infrastructures for medium to large companies.
SYS-CON Events announced today that Datanami has been named “Media Sponsor” 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. Datanami is a communication channel dedicated to providing insight, analysis and up-to-the-minute information about emerging trends and solutions in Big Data. The publication sheds light on all cutting-edge technologies including networking, storage and applications, and thei...
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...