In my webinars you would often hear me say that Power Pivot is the ♥heart♥ of Power BI. Below is the visual that I use: Power Pivot is the central engine that drives Power BI However, when your name is…
Our next Excel to Power BI free webinar would be on Oct 20th. Click to register. Along with Power BI basics, we’ll cover the relevant Power BI updates and as always there would be ample opportunity for Q&A. Free Webinar…
At a recent client visit, I found myself thinking of trajectories.
A small shift now can change the trajectory of the rest of your life
After the class, I was chatting with one of the attendees. Here is what I learned:
- The attendee, let’s call him ‘John’, has been working for many years at this revered institution.
- He had been using Excel, but he thanked ‘Dan’ who several years ago had introduced him to Excel Pivot Tables
- That changed his trajectory. And many years later, here he was, sitting in my Power Pivot class…
- And I wondered…how it would shift the trajectory of the rest of his life
By Avi Singh [Twitter] Boy, time flies when you’re having so much Power BI fun. Our monthly webinar is tomorrow, Tue Sep 22. You can also signup for future webinar dates if tomorrow does not work for you. Newcomers: Should…
Is this you? We have been working through the applicants who filled out our Mini-Application Form for PowerPivotPro jobs. We will soon be unveiling a “Helpdesk” model which would connect skilled Power Pivot/Power BI professionals with companies that share the…
By Avi Singh [Twitter] Friends, it was a joy again to host our free monthly webinar Excel to Power BI. As usual, we spent more than an hour on a lengthy Q&A session after the presentation. You can find the…
By Avi Singh [Twitter] Friends,We’ll be hosting our monthly “Excel to Power BI” Webinar on Aug 18. Short notice, I know. But that means you have no excuse to dally, register today! Invite your colleagues, friends, even your mum. The…
In our last webinar the #1 question and confusion seemed to be around Excel versus Power BI Desktop (formerly called Power BI Designer). The thing is, both tools are really part of an ecosystem. And the biggest confusion was around understanding how these tools fit into the overall landscape.
Here is the picture we would build to, but do read through so you understand how we arrived here and also find out how you control the future direction of Power BI (seriously, you do!).
Standalone Tool for End-to-End BI
Rob did an excellent head to head comparison of Power BI Designer versus Excel. Just read that, but I’ll add some commentary.
If you were to use a single tool for BI – getting data, building a data model and building charts/reports – we have firmly established that Excel is the world’s best data tool, period and that is primarily due to it’s internal network effect and that it is easy to adopt.
Excel is the World’s Best Data Tool, Period
Power BI Desktop is a very slick tool, with all different facets meshed together beautifully without any seams showing. Unlike Excel, where due to the “Add-In” nature Power* tools always feel a little clunky, not to mention cases where they go totally awry. But in spite of all that, it is hard, no impossible, to build a tool that can supersede Excel, or replace Excel.
However that is not quite a fair comparison. Because Power BI Desktop is primarily built for PowerBI.com.
Power BI Desktop for PowerBI.com
Power BI Desktop is primarily an accompaniment to PowerBI.com. It is essentially an “authoring tool” for PowerBI.com. Its true purpose is to build something that gets published to PowerBI.com.
You would almost never use Power BI Desktop standalone. Well you may, but understand that it is not really built for that purpose.
With these two combined – Power BI Desktop and PowerBI.com – they outshine Excel in the BI department. With the fluid development environment of Power BI desktop for authors…and the rich, easy to share, mobile ready visualization platform of PowerBI.com.
However that is not a fair comparison either, since Excel models can be published as well.
Friends, it was a joy again to host our free webinar Excel to Power BI. As usual, we spent close to two hours with a lengthy Q&A session after the presentation. You can find the the recording at the end of this post.
Remember, the Power Pivot Data Model is the engine that powers all the pretty visualizations that you see in all Power BI Demos. With a poor data model all you get is poor results; garbage in => garbage out. So join us for our next online class on Aug 3-4 and jumpstart your journey to Power Pivot/Power BI awesomeness!
Enjoy the webinar recording using links below.