Power BI for a Financial Analyst who doesn't have the patience to wait for IT
April 17, 2017
Power BI for a Financial Analyst who doesn't have the patience to wait for IT
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft Power BI
It is only used by a small handful of departments - finance, financial planning, audit, and IT. So it hasn't reached the masses yet. We are talking about less than 10 users in a Fortune 500 company.
For a financial analyst with a novice level of IT knowledge, Power BI is able to gather and handle VERY large amounts of data while slicing and dicing quickly how you want it. Once you get past several million rows of data, Excel blows up. That's where Power BI comes in.
For a financial analyst with a novice level of IT knowledge, Power BI is able to gather and handle VERY large amounts of data while slicing and dicing quickly how you want it. Once you get past several million rows of data, Excel blows up. That's where Power BI comes in.
- The filtering is top notch. I am able to create a 'dashboard' so to speak where I can click filters off and on. For instance, if I want to select one year or multiple years, one channel (such as e-commerce), or all channels. etc. Once you have it set up, it is very easy to use, and easy for non-users to view in a presentation type scenario.
- There are so many options for graphs that I switch to right on the spot. Sometimes I find myself just clicking through them just to try to see what works and many times I'll come across a visualization that fits which I hadn't even thought of.
- It's free. As users, you have nothing to lose. The best way to learn is to have everyone who is testing it out to communicate openly about what they discover.
- I love creating a matrix. It's very similar to the pivot in Excel. However, when I export out of power Bi into Excel, it turns back into a raw data dump. From there I can do the pivot in Excel, but what's the point of doing the matrix then. I would like for the data to export how the matrix is showing.
- Small but important tasks like inserting a column, combining metrics like time and year, and many others take 3 or 4 steps instead of 1 to 2.
- Googling "how to" when figuring out a sticky situation in Power BI doesn't always lead to a resolution. It's probably because not enough folks use Power BI like Excel, for instance, and thus you might only find one explanation to go by. And in some cases that ONE explanation isn't worded quite right for a particular user's level of expertise. With Excel, you Google a problem, and there are many write-ups to read through. And one of those write-ups turns the light bulb on in your head in your head. Or better yet you might read several different ways to solve a problem. Don't normally have that luxury with Power BI.
I am an just a business analyst
Power BI is used by someone like me in a scenario where I want to bypass IT (which can take transaction data and slice it in SQL or HALO) but at the same time could never replace Anaplan or Excel where the raw data is small enough to be handled by those platforms. So the situation for me has to be just right to bring Power BI into the fold......an extremely large amount of untouched raw data.
In other words there really is no "other" for Power BI. if the situation is just right, then Power BI is the only way.
Power BI is used by someone like me in a scenario where I want to bypass IT (which can take transaction data and slice it in SQL or HALO) but at the same time could never replace Anaplan or Excel where the raw data is small enough to be handled by those platforms. So the situation for me has to be just right to bring Power BI into the fold......an extremely large amount of untouched raw data.
In other words there really is no "other" for Power BI. if the situation is just right, then Power BI is the only way.