Excel is probably the closest thing we have to the perfect tool for analysing & reporting on data. It’s greatest downfall, however, is that it doesn’t really scale beyond a single user, and the result is organisations find their data and IP locked up in un-verifiable (but easily shareable) files.
James Diekman, who’s recently joined the Digital Village network as a Producer, sat down with DV co-founder Luke Fabish to share his solution.
[Luke Fabish] Hi James, we’re pumped to welcome you aboard as a DV Producer – could you tell us a little about yourself?
[James Diekman] Thanks! I’ve been in the IT industry my entire career, starting out in support to more recently becoming a Microsoft specialist consulting to government agencies and large enterprises which has been super exciting. I’ve got a passion for business applications and leveraging them to solve business problems and getting involved with the Power Platform community and also not for profits.
[LF] Hey, that’s great James. Recently we were talking about one of the technologies you work with, Microsoft Power Platform, and about how it has the potential to solve one of the biggest problems affecting IT in organisations… Excel is used for everything! What are your thoughts on that?
[JD] Completely agree! Use Excel for what it’s good at – analysing data. Don’t use it as a store of record, it simply wasn’t built for that and you’re missing out on turning your data into valuable insights. Also it’s not just Excel… We often see Word, OneNote and good old Microsoft Access heavily used because it’s all the users had at hand. These products have been around for eons.
[LF] So could someone who’d normally open up Excel to get a job done use Power Apps just as easily?
[JD] Absolutely. Organisations, however, need to look at PowerApps as a better way to capture data that can be stored in a common data service. From here organisations can start to automate processes they were never able to before because the data is stored in one place in a structured format. Start adding more applications and more data and you start to build up a valuable data estate that you can analyse and interpret by levering new technologies like artificial intelligence (AI).
[LF] That sounds amazing! So what you’re saying is we can solve some of the problems introduced by the pervasive use of Excel as a data store?
[JD] Yes… from simple problems such as versioning, multiple users, and data corruption to relating and querying large data sets. Thousands of disparate Excel files are of little value. Leveraging tools like PowerApps and the Power Platform allows you to turn data into business insights you previously didn’t have available to you before.
[LF] Thanks so much, James. For me, the big takeaway seems to be the ability to remove complexity and open up a way more collaborative approach to data than is possible in Excel on its own.
I know we’ve barely scratched the surface here… The Power Platform is at heart a powerful system for rapid digital transformation that can provide deep and integrated value across an organisation’s entire digital landscape.
Want to learn more? We have an upcoming live event with James where he’ll be highlighting the breadth of capability that Power Apps can bring to an organisation (plus he has some great tips for getting the I.T. department on board with it as well).
So to learn more about rapid innovation and digital transformation with Microsoft’s Power Platform, register for our upcoming event here.