Business Intelligence for the Excel User and Accountant

in #excel2 years ago

Over the last few posts, we looked at Business Intelligence and an example of how it can be used in a small business. But is Business Intelligence for the Excel User? And does it have anything to do with Accountants? ( missed the first post, you can access it here. You can also access the second post here)

Business Intelligence for the Excel User

In every organization I have visited or worked at, Excel is used by most employees at some level. Senior-level employee, marketing, sales, finance, and accounting. Everyone uses Excel. Like it or not, no matter how much money companies spend on powerful software packages, people tend to dump data from the software into excel for slicing, dicing, analyzing and reporting (I bet you are guilty of this too!). Even worse, each person and each department have their own set of reports. From all these reports that are produced, how many of them are actually shared around the company? Or just kept for the use of the employee or the department?

What if you have access to all of these reports? All of these data sets, along with other data sets, both internal and external. What insights could this provide for your organization and your company?

Well, now you do have access because Excel has a suite of tools. Power Tools: Power Query, Power Pivot, and Power View. All work stand alone and, all combined make a very powerful BI system. Business Intelligence for the Excel User!

Let me explain

Power Query can be described as SQL for Excel users (without the need for knowing SQL). It allows users find data from many sources (including big data source), combine data, transform data, and make the data usable for reporting and data analytics.
Power Pivot will allow you to carry out complex calculations across multiple tables of data (using DAX) and model data in a way that is structured for reporting and visualizations.
In Power View, you can quickly create a variety of visualizations, from tables and matrices to bubble charts and sets of small multiple charts. With these visualizations trends in data are easily spotted making business decisions easier and actionable

Business Intelligence and the Accountant

'What’s all this got to do with the Accountant?' I hear you say! Plenty. For years now accountants have been rationalizing data. Making sense of the numbers. Producing reports to explain the story. This places accountants in a prime position to recognize data that is useful, data that can help align business with its strategic plan. Then analyze that data and report on it.

Accountants are already Excel users. New software is just a barrier right! Why fix what’s not broken! Excels BI tools are not a new software to learn. THIS is just an extension to the tools Accountants already have.

I am here to help. Below you will find links to my Power Courses (Each of these BI tools can be used in isolation, therefore we have a course for each). If you want to provide business intelligence services in your organization, now is the time to upskill.

Sound’s interesting - I would like to preview Power Query

I’m curious - tell me more about Power Pivot

Access All Areas Unlimited Excel Learning – Explore now

Business Intelligence for the Excel user and accountant brings the power of data to the ordinary business.

Would you like exclusive offers and discounts on our courses? Sign up for my newsletter to get Tips and trick on Excel and Business intelligence and exclusive discounts that are only available for my newsletter subscribers

If you are still not convinced you to need to learn Excel Power Tools, why don't you check out these demonstrations and watch Excel Power Tools in Action


Power View does not work for me. I have the icon in the ribbons but it does not activate anything. Have you any idea how I can fix this problem?

Great series, I read all 3 articles and I enjoyed them very much. I need to share them with my boss, working in a small company I would love to be able to make the time to provide insights other than the accounts I prepare. I just do not have the time.

It was funny, we had our big team meeting yesterday and my organization has big contracts with Microsoft for office 365 for the suite of things in their software but what are they going with to produce dashboards? Tableau. I was like really? All of these incredible tools that are available to us for money we already spend and we are going with a different system that we get charged per license? Foolish to me but I’m going to learn tableau alongside excel since other companies probably won’t be so silly with the choice lol