Power Pivot and Power View are powerful tools that can help organizations make better decisions based on data. If you’re looking to analyze and present data in a more meaningful way, consider giving these tools a try. Whether you’re a seasoned data analyst or just getting started, they can help you unlock the full potential of your data.
In the very small BI community, who hasn’t heard of Power BI, Power Pivot, Power View. But outside?
Knows Power Pivot or Power BI!
Data analysis is a critical aspect of modern-day businesses, and the tools used for this purpose play a significant role in the success of organizations. In this context, it’s important to understand the capabilities and benefits of Power Pivot and Power View, two powerful data analysis tools from Microsoft.
Power Pivot is an Excel add-in that enables users to import and manage large data sets from various sources and create pivot tables with ease. It’s an in-memory data engine that works behind the scenes to enable fast data analysis. The add-in provides a user-friendly interface that makes it simple to create relationships between data tables, define calculated columns and measures, and perform complex data analysis tasks.
BI talks to BI
(By the way, BI means Business Intelligence, but what does Business Intelligence mean?)
Business Intelligence means nothing for a majority of VSE/SME managers and for those who know this term, it is assimilated to needs and solutions for large accounts.
Why would they be interested in something that is completely unknown to them or does not concern them.
When I tell them management control, budget analysis, forecasting, sales analysis, dashboards, everyone understands because in all companies, from VSEs to SMEs, we produce tables with Excel, on the other hand always as 10 or 15 years ago.
Why would they use Power pivot, a free add-in that revolutionizes Excel, or the components of the Power BI suite that would save them time, analytical power, ease of updating, simplified and secure distribution accessible via the internet, limitation error rates to name a few benefits.
They don’t know that Power Pivot or Power BI exists.
Microsoft has however made a major effort to facilitate its adoption, since Power Pivot is free, but directly after this very good initiative, it has complicated everything.
Why isn’t Power Pivot available in all versions of Excel?
Do you know Power Pivot & Power View?
Not everyone will use Power Pivot, so why offer it to everyone?
So on the same principle, as 80% of Excel users do not use the Look up V, Sum. If functions, we could remove them from the basic versions of Excel.
Why isn’t the Power Pivot menu enabled by default?
At least it would appeal to users, and those who don’t want to use it could possibly turn it off.
For the democratization or the wide adoption of the Power BI decision-making suite, we have similar obstacles.
Why isn’t everyone viewing Power View dashboards published on a Power BI site free of charge?
Some will say to me, but in this case why would we subscribe to Power BI?
I have many prospects and customers who find Power View super sexy, but aren’t willing to pay around $40 per month per user just to enable access to a few Power View dashboards.
They will either continue to send Excel by email, or go through OneDrive with which I can publish dashboards for free, based on Excel graphics. I can easily make them accessible to everyone, by integrating them into my website for example, or into my blog like here.
Distribution of Power View and Power Pivot
In this case, the distribution of Power View views could spread like wildfire, in websites, in blogs, in Share Point pages. This would democratize the Power BI suite very quickly, because everyone who finds a Power View dashboard cool will seek information to find out which products are needed to achieve it, thus generalizing the use of Power Pivot and Power BI subscriptions.
In addition, if I create many Power View dashboards, very quickly I have to manage them, secure them, and of course design them. The Power BI subscription for designers and for management needs becomes obvious.
And among all these Power Pivot models that will then be created, companies will want to migrate to SSAS for reasons of volume, security, etc. for any benefit for Self-Service or corporate BI players.
Conclusion
Power BI is exceptional, and a priori many new features are expected soon, which motivate me even more to share my Power BI experience so that its adoption is greater. Power Pivot and Power View are powerful tools that can help organizations make better decisions based on data.
If you’re looking to analyze and present data in a more meaningful way, consider giving these tools a try. Whether you’re a seasoned data analyst or just getting started, they can help you unlock the full potential of your data.
