Power BI vs Excel Dashboards - And the winner is... - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
tikie
I noticed myself only using PowerBI if the data source doesn't need further massaging. I just add it to a model and I am running. On the other hand, Excel is king if you need to -build- your data. If the requester wants a certain view but gives me data clearer than mud, then Excel it is. I can build and adjust data that I trust, and I can apply changes anytime the requirements change. Sometimes, when the data becomes too big, I might mirror my Excel dashboard in PowerBI. The only thing I really appreciate with PowerBI is that when using the desktop version, the users can actually drill and see records associated to the graph elements. In Excel your users pretty much need to know how to filter the data or calculate the measures themselves to get to the list you are presenting. And if they are not Excel savvy enough, you might be called on to find a way to present the data that represent the graph elements because they -cannot click to see-...
reply
I noticed myself only using PowerBI if the data source doesn't need further massaging. I just add it to a model and I am running. On the other hand, Excel is king if you need to -build- your data. If the requester wants a certain view but gives me data clearer than mud, then Excel it is. I can build and adjust data that I trust, and I can apply changes anytime the requirements change. Sometimes, when the data becomes too big, I might mirror my Excel dashboard in PowerBI. The only thing I really appreciate with PowerBI is that when using the desktop version, the users can actually drill and see records associated to the graph elements. In Excel your users pretty much need to know how to filter the data or calculate the measures themselves to get to the list you are presenting. And if they are not Excel savvy enough, you might be called on to find a way to present the data that represent the graph elements because they -cannot click to see-...
reply
Shasha
I have learned so much from your videos...thank you. I want to prevent the bar graphs in my Excel dashboard from moving. I tried protecting the dashboard sheet. But the expand/collapse button - 4:44 becomes useable after protecting the dashboard. How can i protect the dashboard but still use +/- buttons for drilling? I thought about disabling moving and resizing the bar graph (just like a slicer) but this function is not an option for graphs (or objects). I hope you have tips for me...thank you for the help!
reply
I have learned so much from your videos...thank you. I want to prevent the bar graphs in my Excel dashboard from moving. I tried protecting the dashboard sheet. But the expand/collapse button - 4:44 becomes useable after protecting the dashboard. How can i protect the dashboard but still use +/- buttons for drilling? I thought about disabling moving and resizing the bar graph (just like a slicer) but this function is not an option for graphs (or objects). I hope you have tips for me...thank you for the help!
reply
xMastJedi
I am sorry but I will discuss with this -huge selection of charts- in Power BI. Since 3 years I am using ONLY default one. Why? Because I used to use the customised one and I lost all of them with new version of PBI. Creators didnt support it anymore. So I had to rebuild my reports which cost time and money ofc.
For me Visuals Excel >>>>> Power BI.
reply
I am sorry but I will discuss with this -huge selection of charts- in Power BI. Since 3 years I am using ONLY default one. Why? Because I used to use the customised one and I lost all of them with new version of PBI. Creators didnt support it anymore. So I had to rebuild my reports which cost time and money ofc.
For me Visuals Excel >>>>> Power BI.
reply
Mahathma
Hello Madam I had this intresting doubt.
I am currently working on a transactional data so the data has duplicate records. This time instead of removing the records in power query . I want to see all the duplicate records data of a company in a single row.
Example:
1-A
1-B
2-A
1-C
2-B
Output: 1-A-B-C
2-A-B.
reply
Hello Madam I had this intresting doubt.
I am currently working on a transactional data so the data has duplicate records. This time instead of removing the records in power query . I want to see all the duplicate records data of a company in a single row.
Example:
1-A
1-B
2-A
1-C
2-B
Output: 1-A-B-C
2-A-B.
reply
Mohan
Hello, I have query, if possible can you please help me.
I have project is converting excel dashboard to Power BI. I stuck in adding time in secondary Y axis. I want time as it is. Whenever i tried adding in the line value, it's converting to count or average etc.. i need no calculation.
reply
Hello, I have query, if possible can you please help me.
I have project is converting excel dashboard to Power BI. I stuck in adding time in secondary Y axis. I want time as it is. Whenever i tried adding in the line value, it's converting to count or average etc.. i need no calculation.
reply
Tam-s
Can I sync and share some kind of Excel dashboard without One drive Bussiness, Share Point (companies have) and Power BI as a personal excel user? I want to share it with just my friend and don't want to use bussiness apps
reply
Can I sync and share some kind of Excel dashboard without One drive Bussiness, Share Point (companies have) and Power BI as a personal excel user? I want to share it with just my friend and don't want to use bussiness apps
reply
Fourth's
Indeed another great video of yours Mynda! Have you also run to -Call to Excel Services failed- error? would you mind to share any workaround please? I'm using Office365. Thanks for all your videos! I'm learning a lot!
reply
Indeed another great video of yours Mynda! Have you also run to -Call to Excel Services failed- error? would you mind to share any workaround please? I'm using Office365. Thanks for all your videos! I'm learning a lot!
reply
ChubbyChub
There's not a monthly subscription cost with PBI when you use PBIRS. Excel doesn't compare to PBI IMO. Security alone is reason enough to only use PBI if you're making enterprise level reports or dashboards.
reply
There's not a monthly subscription cost with PBI when you use PBIRS. Excel doesn't compare to PBI IMO. Security alone is reason enough to only use PBI if you're making enterprise level reports or dashboards.
reply
ufoubo
What is the roadmap for Excel? I would think that the Excel team different from the PowerBI team and usually Excel would introduce some new features for visualization as they have done in the past.
reply
What is the roadmap for Excel? I would think that the Excel team different from the PowerBI team and usually Excel would introduce some new features for visualization as they have done in the past.
reply
xMastJedi
I can create much more powerfull Dashboard in excel than PowerBI.
Question is - what next? How I can share it with management/customer?
And in this matter answer is only one - Power BI.
reply
I can create much more powerfull Dashboard in excel than PowerBI.
Question is - what next? How I can share it with management/customer?
And in this matter answer is only one - Power BI.
reply
Add a review, comment
Other channel videos
