The analytics landscape is changing at a fast pace in this ‘bring-your-own-tools’ world. The universe of data technologies has grown exponentially complex over the last few decades, particularly so after the introduction of Big Data concepts. In such a world, where does the role of an Excel user lie? Makes becomes of people like you and me?
Let us explore the budding opportunities around us.
Business Intelligence
Nowadays, many multi-million dollar business intelligence solutions can be found in the market. And many firms are adopting these products to become efficient or to better understand their customers. But the employees of such firms, most probably, are in a habit of using Excel for their daily problem solving. Therefore, catering to these employees can become the major factor differentiating success from failure.
Excel Add-Ins is one way through which these business intelligence solutions capture the market. In fact, as ‘Dirty Grantham’ puts it, these solutions should primarily act as data consolidators/providers and feed the Excel users. It is the job of the IT people to get the data to Excel users for analysis. Incorporation of tools to deal with problems that might be difficult to solve within Excel should be secondary to these technological solutions.
Small to Medium-Sized Enterprises
A great number of firms are years, if not decades, away from using tools like PowerPivot or PowerBI due to lack of appropriate infrastructure within the firm. So, they mostly rely on Excel to solve problems which these tools are created to deal with. This is where the nimble Excel user comes in with its enhanced capabilities to fetch and sift through data at the ground level.
Databases
Data cleansing at various levels in a database happens as an evolutionary process. Same is the case with the use a database’s output is put to, e.g. report calculations. If the logic working on a database changes, it can be very costly to fix the processes running inside it to let the output be as desired. Using Excel to deal with this problem is a cheaper and faster solution. Moreover, possessing know-how of the outputs of databases, Excel users can direct changes in the logic of databases to ease data analysis across the enterprise. They act as a liaison between IT and functions like finance, planning and reporting.
Share with us what you have conquered with Excel
Leave your comments below.
And… keep an eye out for more!
- SSSVEDA DAY 7 – Every Team Needs Someone Who Understands Data - February 18, 2018
- SSSVEDA DAY 5 – When Data Analysis is Wrong - October 31, 2017
- SSSVEDA DAY 4 – Sharing the Excel Knowledge - July 18, 2017
Bravo. These real-life analyst problems are rarely discussed but play a huge role in business operations. I’ve got a recurring task that has grown in complexity at work, and it’s time to try moving some of it “up a layer.” Your suggestion to point out repeated, consistent rules will help a lot here.
Great show, thanks for hosting!
Wow..Just a bit late on hearing this video, but all of you had some great thoughts and ideas. And most were validating my observations of IT and finance and Excel users that I have worked with over the years. I was always the one in finance pushing the IT guys to give me more data , pushing the reporting envelope. I do report writing for clients within the QuickBooks communities. With Modern Excel , small businesses can enjoy sophisticated data models and reporting that to date has been up to larger well staffed corporations. I am hoping I can put small businesses in the forefront of reporting prowess. That they can be nimble and be willing to take advantage of the new tools with consultants to guide them. Reporting styles are changing and it will be up to us consultants to learn and take advantage of these new tools to help them move forward.