Welcome!

Microsoft Cloud Authors: Nick Basinger, Kevin Benedict, Pat Romanski, Liz McMillan, Lori MacVittie

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

IoT & Smart Cities Stories
IT professionals are also embracing the reality of Serverless architectures, which are critical to developing and operating real-time applications and services. Serverless is particularly important as enterprises of all sizes develop and deploy Internet of Things (IoT) initiatives. Serverless and Kubernetes are great examples of continuous, rapid pace of change in enterprise IT. They also raise a number of critical issues and questions about employee training, development processes, and opera...
AI and machine learning disruption for Enterprises started happening in the areas such as IT operations management (ITOPs) and Cloud management and SaaS apps. In 2019 CIOs will see disruptive solutions for Cloud & Devops, AI/ML driven IT Ops and Cloud Ops. Customers want AI-driven multi-cloud operations for monitoring, detection, prevention of disruptions. Disruptions cause revenue loss, unhappy users, impacts brand reputation etc.
This month @nodexl announced that ServerlessSUMMIT & DevOpsSUMMIT own the world's top three most influential Kubernetes domains which are more influential than LinkedIn, Twitter, YouTube, Medium, Infoworld and Microsoft combined. NodeXL is a template for Microsoft® Excel® (2007, 2010, 2013 and 2016) on Windows (XP, Vista, 7, 8, 10) that lets you enter a network edge list into a workbook, click a button, see a network graph, and get a detailed summary report, all in the familiar environment of...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
Atmosera delivers modern cloud services that maximize the advantages of cloud-based infrastructures. Offering private, hybrid, and public cloud solutions, Atmosera works closely with customers to engineer, deploy, and operate cloud architectures with advanced services that deliver strategic business outcomes. Atmosera's expertise simplifies the process of cloud transformation and our 20+ years of experience managing complex IT environments provides our customers with the confidence and trust tha...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
The Japan External Trade Organization (JETRO) is a non-profit organization that provides business support services to companies expanding to Japan. With the support of JETRO's dedicated staff, clients can incorporate their business; receive visa, immigration, and HR support; find dedicated office space; identify local government subsidies; get tailored market studies; and more.
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations. Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility. As they do so, IT professionals are also embr...
In his general session at 19th Cloud Expo, Manish Dixit, VP of Product and Engineering at Dice, discussed how Dice leverages data insights and tools to help both tech professionals and recruiters better understand how skills relate to each other and which skills are in high demand using interactive visualizations and salary indicator tools to maximize earning potential. Manish Dixit is VP of Product and Engineering at Dice. As the leader of the Product, Engineering and Data Sciences team at D...