A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
Whenever one talks about the use of Excel in business intelligence (BI) and business analytics (BA), the role of the IT department springs up to the discussion. The fact of the matter is that IT personnel are seen by many BI or BA Specialists as obstacles in adoption of BI systems. From their experience as BI consultants and Excel developers, our very own experts discuss this issue and much more in this topic!
As ad hoc tools and spreadsheets are gaining momentum, the role of IT is being pushed more and more into the background. Such a momentum is being falsely perceived as a reduction in the role of IT. These feelings seem to be strengthening as the pace of evolution in the IT sector is decreasing. Under such pressures, IT personnel often create obstructions for BI specialists in order to maintain their influence. These obstructions could take the form of “data hoarding” and unnecessary disagreements.
It is important for IT guys to realize that it is the BI analysts who are connected with the executives. They have the business knowledge to analyze various datasets lying with the IT department. And it is the role of the IT department to empower these analysts through rolling out ad hoc tools for them. BI problems, most of the time, could be too small for IT personnel to cater to: malfunctioning Excel procedures, integration of transactions executed under an exception to a rule etc. Solving these problems requires a strong knowledge of the business, its operating models, its revenue models and its cost centers among other things. All of this falls outside the realm of the IT knowledge.
There are two notable trends concerning the BI market that have been around for quite a while:
Within the BI landscape, the role of Excel is very central. This can be seen from the fact that most, if not all, BI tools have a “connect to Excel” button as a primary feature. This is true ever for BI tools which costs millions of dollars. Excel is what has been adopted widely for the analysis of data. And it is important for the IT people to acknowledge this fact.
One way to enable collaboration between the IT and BI personnel is to have people from business backgrounds get trained in IT. These could be the people who aim to be super-users of technology and would desire to become and IT person.
Another way to settle the dust around data gathering issues is to have dedicated ‘Data Champions’ ensuring the quality of data and keeping track of their flows through various reports. It is important for these data champions not to be performing the role as an IT or a BI person.
We would love to read about your unique experiences. Please leave your comments below.
Do not forget to share the amazing ideas presented here with your colleagues!
Excel Data Visualization: Presidential Approval Ratings with Slicers & Power Query – Chart Tricks
Advanced Excel Tutorial – VLOOKUP() Speed in Excel | Excel TV, Episode 54
Excel Tutorial Concat Function in Excel with TEXTJOIN – Excel.TV Episode: 53
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide