Power BI vs Excel Dashboards - And the winner is...

Подписаться 629 тыс.

Просмотров 273 тыс.

50% 1

An unbiased comparison between Power BI and Excel for building dashboards, including comparisons between key features and pros and cons of each, so you can make an educated decision on which is best for your needs.
🎓 LEARN MORE
Learn Power BI here: www.MyOnlineTrainingHub.com/p...
Learn Excel Dashboards here: www.myonlinetraininghub.com/e...
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟‍♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
0:00 Introduction
0:42 Learning Curve
1:57 Chart Selection
2:33 Interactivity
2:45 Power BI Slicers
3:16 Excel Slicers
3:47 Power BI Cross Filter & Highlight
4:12 Excel Cross Filter & Highlight
4:31 Power BI Drilldown
4:42 Excel Drilldown
4:59 Drill Through
5:39 Flexible Analytics
5:58 Power BI Matrix Tables
6:07 Power BI Decomposition Tree
6:26 Power BI Insights (in Preview)
6:46 Power BI Key Influencers
7:06 Excel Pivot Tables
7:42 Excel Ideas - Natural Language Questions
7:57 Sharing & Security
9:02 Data Sources
9:33 Data Size
10:46 Cost

Наука

Опубликовано:

1 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 317

@tikiecue5677 3 года назад

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"...

@MyOnlineTrainingHub 3 года назад

Great to hear you use both Excel and Power BI. Don't forget that Power BI has the same Power Query tools so if your data is messy you can still clean it in Power BI if required.

@ferozkibria9211 3 года назад

Great Great Great Presentation. Big Big Big Thanks to Mynda Treacy for this exclusive comparison and super-duper excellent highlights.

@MyOnlineTrainingHub 3 года назад

So pleased it was helpful, Feroz :-)

@indryfitriani 3 года назад

Great! Amazing! Ive been looking for it for months. Thanks a lot Mynda! Success for you, always 🙏

@MyOnlineTrainingHub 3 года назад

Glad it was helpful, Indry!

@faisalislam8701 2 года назад

Just watched the comparison between Power BI and Excel. It saved me many hours of research and helped to make a decision right away regarding which platform to use for my project. great job!

@MyOnlineTrainingHub 2 года назад

So pleased it was helpful, Faisal!

@IvanCortinas_ES 3 года назад

Brilliant and accurate analysis Mynda. Thank you very much for sharing your professional experience.

@MyOnlineTrainingHub 3 года назад

Glad you enjoyed it, Ivan!

@cherianiype 3 года назад

@MyOnlineTrainingHub & @Mynda --- Another awesome video! This is a fair & authoritative review of both the fantastic tools - XL and PBI! Super cool that you were able to give the pros & cons of both systems, and also wear the right T-shirts! Appreciate this! Take care and stay safe!

@MyOnlineTrainingHub 3 года назад

Thanks so much, Cherian! Yes, lucky I had both t-shirts :-D

@sameerjain6726 2 года назад

Really good comparison where we actually talk about when and why to use the specific tool needed.

@MyOnlineTrainingHub 2 года назад

Glad you liked it, Sameer!

@bntenza 3 года назад

I use both excel and Power BI to create dashboards. However, I am leaning more towards the BI due to visual compared to excel and ability to create your app in BI is a huge plus. Great video and unbiased comparisons

@MyOnlineTrainingHub 3 года назад

Great to hear, Bongani! Yes, the apps for Power BI are a great feature too.

@edgargarcia209 3 года назад

You are the master and I send everyone I know with excel questions to your channel.

@MyOnlineTrainingHub 3 года назад

Wow, thanks so much!

@vijayarjunwadkar 3 года назад

Wow! I had gone through numerous comparisons between Power BI and Excel, but this video has put it succinctly! Thanks for clearing the confusion in such an easy manner and to the point! 😊👍

@MyOnlineTrainingHub 3 года назад

Glad it was helpful, Vijay!

@DrAmgadSquires 2 года назад

Very helpful and concise highlight of each tool’s features. Thank you!

@MyOnlineTrainingHub 2 года назад

Glad it was helpful!

@leorc564 3 года назад

muy claro y sencillo, por eso veo tus videos Mynda, thanks a lot, nice!

@MyOnlineTrainingHub 3 года назад

Gracias, Leonidas!

@johnsamuel1382 2 года назад

When it comes to company email and installation need IT department.. which you explained is very helpful.. saved my lot of time... thanks 👍😊

@MyOnlineTrainingHub 2 года назад

Glad it helped

@sergiohernandez9513 3 года назад

excelente analisis, soy principiante en ambas soluciones ( Power Bi, y Power Pivot) pero los videos y la forma de explicar hace mucho mas facil poder interactuar con elllo, felicitaciones y saludos desde Chile

@MyOnlineTrainingHub 3 года назад

Gracias, Sergio!

@kingamalik1505 Год назад

Porównanie możliwości i zastosowania Excel i Power Bi bardzo przydatne w podejmowaniu decyzji o wyborze programu do przedstawiania wyników. Dzięki za tak dokładne porównanie.👍

@MyOnlineTrainingHub Год назад

You're welcome 😊

@domingopedernera1038 3 года назад

Thanks once again for teaching and sharing valuable content, you make hard things easy!

@MyOnlineTrainingHub 3 года назад

Glad to hear that, Domingo!

@barttitulaerexcelbart9400 3 года назад

Very very good! one small remark: True that the visuals in Excel don't interact. But I realy like the fact that if you use multiple slicers for one table to explore the data, these slices do interact. After selecting one or more options from one slicer, you can see which options of the other slicer are available. I heard that this option is quite memory intensive by the way....

@MyOnlineTrainingHub 3 года назад

Yes, I like this feature too.

@YashuCosGaming 4 месяца назад

Your 11 min video saved my 8 hrs of learning Power BI, I have already learnt lots on Excel ranging from complex formulae, pivot & dashboards. Learning the same on a different software with much less flexibility and unfamiliarity is only going to be much frustrating, time consuming & less output. I will instead hone my skills on Excel further with VBA. Many thanks.

@MyOnlineTrainingHub 4 месяца назад

So glad it was helpful 😊

@Olu_boomie 3 года назад

Insightful as usual 👌 God bless you Mynda!

@MyOnlineTrainingHub 3 года назад

Thanks, Bunmi!

@kcizzlewilson1260 3 года назад

My thoughts are power bi is more built for corporate individuals who need to see dynamic data without opening a file or reading an email. Excel is more for the lower level deep diving type information where a person is trying to analyze a specific group of people. Both are good and worth learning both given the opportunity. Great vid.

@MyOnlineTrainingHub 3 года назад

Thank you!

@RetaxChennai 3 года назад

You covered almost everything. Great video!

@MyOnlineTrainingHub 3 года назад

Glad you liked it, Karthik!

@brenokobayashi7689 2 года назад

I just love your videos. Thank you very much for sharing your knowledge.

@MyOnlineTrainingHub 2 года назад

You are most welcome!

@jmo6688 3 года назад

The learning curve is really amazing charting. If presentation in form of slides other than video, it would save us more time to read through...

@MyOnlineTrainingHub 3 года назад

Glad it was helpful :-)

@Riri-qi2fu 3 года назад

Awesome! My manager just approved for me to go ahead with your powerBi course. I am thinking to do it during the Christmas break.

@MyOnlineTrainingHub 3 года назад

Fabulous! I look forward to teaching you all about Power BI and its wonders :-)

@777you7tube 3 года назад

How much is the course for? If like to join too.

@Riri-qi2fu 3 года назад

@@777you7tube - just Google it. The package price is vary depends on your need.

@shetkar911 10 месяцев назад

"Thank you so much, for sharing this concise and informative Power BI video. It has the potential to make a significant impact on both my personal and professional life. I truly appreciate your contribution!"

@MyOnlineTrainingHub 10 месяцев назад

So pleased it was helpful!

@hossamallam8589 3 года назад

Awesome presentation and comparison, thanks a lot.

@MyOnlineTrainingHub 3 года назад

Glad it helped, Hossam!

@wayneedmondson1065 3 года назад

Hi Mynda. Great analysis and insights! Thanks for sharing :)) Thumbs up!!

@MyOnlineTrainingHub 3 года назад

Thanks so much, Wayne!

@arielspalter7425 2 года назад

Thank you, just got hooked to your channel recently...tons of great stuff there. I have just one remark regarding the consumers of PowerBI dashboard having to have a licence too- I have been told by the IT department at my organization that if the dashboard is published (by a Pro or Premium user) into a workspace created by a Premium user, the clients don't need to have a licence. However, if a Pro user publishes into a workspace created by Pro (for example the My Space of a Pro user), then the end users will need to have a licence to be able to see the dashboard.

@MyOnlineTrainingHub 2 года назад

Correct, Premium licencing is different and quite complicated. The point is, it costs $$$ to publish dashboards.

@imconfused1237 3 года назад

Excellent comparison Mynda! I think you’ve just about nailed it: ultimately, it’s ‘horses for courses’ and it really depends on individual use case and business context. A key word you used was “adhoc” and that really describes the key differential for me: Excel is my daily driver, I’ll use it for quick analysis and tactical solutions. On the other hand, Power BI is the tool I will use to construct firmer, more strategic solutions which have a longer shelf life. From a personal perspective, I like how Power BI tidies my workspace; instead of 6 or 7 spreadsheets my data is consolidated within the engine. Clearly source files are still referenced but these can exist elsewhere and aren’t a distraction. One drawback is probably performance: Excel is rapid whereas Power BI can get a little sluggish. That can be frustrating, but again it’s about aligning the right tool for the right objective. Great vid and thank you so much for making it 😊

@MyOnlineTrainingHub 3 года назад

Thanks, D L. And thanks for sharing your perspectives on the two tools. There's a lot to be said for a tidy workspace, especially when building reports.

@kacecannon6972 2 года назад

instablaster...

@user-li7mq5hp9g 3 года назад

Thank you for your great tutorials!

@MyOnlineTrainingHub 3 года назад

Glad you like them!

@quinnyphil12 3 года назад

another great video. Would be good to see more power bi videos also some basic VBA videos would be good.

@MyOnlineTrainingHub 3 года назад

Thanks. Will keep it in mind.

@PedroHenrique-bp8ts 3 года назад

I'm diving into power bi world and it's amazing

@MyOnlineTrainingHub 3 года назад

Great to hear. Have fun with it, Pedro!

@JennTheWriter 2 года назад

That was a good comparison. Thank you. Very comprehensive. :)

@MyOnlineTrainingHub 2 года назад

Glad it was helpful 😊

@thailaazevedo9670 3 года назад

It was an amazing video You totally answered my doubts!!

@MyOnlineTrainingHub 3 года назад

So pleased it was helpful, Thaila!

@gotrektom 4 месяца назад

Once again, a perfect explanation. Thanks a lot!

@MyOnlineTrainingHub 4 месяца назад

Thanks so much!

@nicor1501 3 года назад

Excellent comparison. One remark, though : 9:37, Power Pivot in Excel 32bit can also deal with millions of rows, it depends on how you build up your model.

@MyOnlineTrainingHub 3 года назад

Yes, but I don't recommend 32-bit. I've have endless emails from people complaining that their model is slow/crashing and it's usually because they're using 32-bit.

@Muuip 2 года назад

Very useful comparison! Much appreciated!👍

@MyOnlineTrainingHub 2 года назад

Glad you enjoyed it!

@komanguy 3 года назад

Excellent comparison! Thanks a lot.

@MyOnlineTrainingHub 3 года назад

Glad you liked it, Guy!

@dexterbernard2701 3 года назад

Thank you for the comparison tutorial.

@MyOnlineTrainingHub 3 года назад

My pleasure, Dexter!

@victoroghifobibi4090 3 года назад

You got me at 0:12 secs....I've never subscribed that fast......Ever....!

@MyOnlineTrainingHub 3 года назад

Wow! Thanks so much, Victor!

@terrydouglasjayasuriya5162 2 года назад

Thanks for an excellent summary of these features.

@MyOnlineTrainingHub 2 года назад

Glad it was helpful 😊

@livings4086 3 года назад

Thanks for clear explanation. The main issue at moment with my company is pagination vs. dashboards. And as it's quite expensive in the power bi licenses we are sadly still split between BI and SSRS

@MyOnlineTrainingHub 3 года назад

My pleasure, James. The pricing options with Power BI can become a bit of a nightmare to navigate.

@samuelmundia320 3 года назад

Great tutorial....how I wish you can do a tutorial oh how to build the integrated financial statements using power bi and excel power query model...

@MyOnlineTrainingHub 3 года назад

Glad you liked it, Samuel.

@Heavieth 3 года назад

Wonderful as usual! Thank you!

@MyOnlineTrainingHub 3 года назад

Thanks, George!

@chrism9037 3 года назад

Very well done video Mynda!

@MyOnlineTrainingHub 3 года назад

Thanks so much, Chris :-)

@dsquaregroot8932 Год назад

Amazing and useful thanks soooo much !

@MyOnlineTrainingHub Год назад

Glad you liked it!!

@shakiraasfoor7599 3 года назад

Well Done Mynda, Sure, It Was Useful

@MyOnlineTrainingHub 3 года назад

Great to hear, Shakira!

@ExcelCurytec 3 года назад

Excelente comparación, saludos!

@MyOnlineTrainingHub 3 года назад

Gracias!

@crystal7799 3 года назад

Another great video. Thank you!

@MyOnlineTrainingHub 3 года назад

Glad you enjoyed it, Crystal!

@syarif-gambardata7755 2 года назад

Thanks for the explanation.

@MyOnlineTrainingHub 2 года назад

Glad you liked it 😊

@ramzifly9640 3 года назад

Great tuto 👍, very professional

@MyOnlineTrainingHub 3 года назад

Glad you think so!

@is1dre 2 года назад

Amazing video, very well done. Thank you.

@MyOnlineTrainingHub 2 года назад

Glad you liked it 😊

@ricos1497 3 года назад

Very comprehensive video, thanks. The biggest difficulty I've found with power bi is getting people to use it! I wish they'd designed it more tightly with Excel too, with new features released to both at the same time and aligned in terms of presentation and function (slicers especially!). I like the functionality of power pivot for example, but it's ugly and uninviting. In my opinion they should have integrated with power query into a single interface and made it look like the power bi experience. It would reduce the learning curve between the two. Similarly, data connections should be exactly the same whether using bi or Excel, shareable between the two. The only difference should be whether the users choose to use Excel or power bi to present their data. You're right about Excel formulae being more advanced, however without the ability to integrate with data in the data model, they're not that flexible for working with dashboards created using it. I've often found myself creating a convoluted Dax measure that would be extremely simple in Excel just to utilise the slicer.

@MyOnlineTrainingHub 3 года назад

Thanks, Rico. It's great to hear your perspective and experience. Unfortunately, because Excel is a very established program it is not as easy to update and make changes. Whereas Power BI being completely new from the ground up, is more agile and able to have new features added without breaking existing features more easily, hence why the pace of development in Power BI is rapid compared to Excel. That's not to say they can't implement some of your ideas, but goes to explain why they don't release new features at the same time.

@ricos1497 3 года назад

@@MyOnlineTrainingHub agreed. Not that changes to excel aren't happening at a pace too. It'll be interesting to see the direction of travel in the coming months and years.

@xeroxo7210 3 года назад

Very good analysis.Power BI has immense analytical capabilities but the dynamics and the flexibility excel offers will be too much to give up . I am not even talking about pivot table or VBA ,am talking about combining functions and having full determination of the grid . You can visualise multiple sets of analysis on the same graph. Volume remains a limitation ,but that depends on the kind of data one usually deal with .Many people dont require a million rows of data. But your analysis has made me realise i need to explore power BI more .Thanks

@MyOnlineTrainingHub 3 года назад

Glad this comparison video was helpful.

@oswevega2939 3 года назад

excellent info dear Mynda

@MyOnlineTrainingHub 3 года назад

Thank you, Oswe :-)

@ivantichov2023 3 года назад

Great presentation, thanks.

@MyOnlineTrainingHub 3 года назад

Cheers, Ivan!

@bzohas 3 года назад

Thanks Mynda for this! It would be good to know which versions of Excel support PowerPivot. I use Excel 2013 and cannot find PowerPivot to enable. However, I have installed PowerQuery. Thanks!

@MyOnlineTrainingHub 3 года назад

Hi George, this post explains what versions support Power Pivot: support.microsoft.com/en-us/office/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b

@mrmuranga 3 года назад

Awesome summary I still prefer using pandas to clean and manipulate data however I would really like to then have a this loaded onto power BI for visuals .Thanks for the really smart presentation 👍🏿

@MyOnlineTrainingHub 3 года назад

My pleasure!

@dafu5704 3 года назад

Great summary!

@MyOnlineTrainingHub 3 года назад

Glad you liked it!

@utubayisi 3 года назад

Great as usual. But AFAIK to be always up-to-date with excel, a time based subscription of office 365 is required like in power bi, so this extra cost maybe could also be mentioned. Regardless, it guys in my organization claim that both office 365 and power bi are now subscribed through cloud based licensing, which they say isn't secure enough in comparison with licensed hard copies. Thanks again!!

@MyOnlineTrainingHub 3 года назад

Yes, if you want to always have the latest version then the Office/Microsoft 365 subscription is the best option, but it's not more expensive than buying a perpetual license every 3 years. In fact, it is often cheaper depending on the license you choose. Either way, you've already paid for Excel, so there's no extra cost. As for the cloud based licensing not being secure, I have no idea why they would think this as there's no basis for it. There is absolutely no difference in 'security' with a perpetual license vs the 365 license.

@utubayisi 3 года назад

@@MyOnlineTrainingHub thank you very much. Extremely useful information again.

@pallaviks3890 3 года назад

great presentation.

@MyOnlineTrainingHub 3 года назад

Thanks for watching, Pallavi!

@remuslupinhp 5 месяцев назад

Summed up so well!

@MyOnlineTrainingHub 5 месяцев назад

Glad it was helpful!

@MrImaddah 3 года назад

very good thanks but i have some issues about the learning curve for example visuals i feel it is very easy to learn in Power BI, also the data preparation i can get huge value from power BI even though i do not do data preparation in power bi environment like unpivot i can do it in excel for example

@MyOnlineTrainingHub 3 года назад

Great to hear you find Power BI visuals easy. Excel Pivot charts are easy too...after all, they're based on the same logic as Power BI i.e. a PivotTable. It's just in Power BI you don't see the PivotTable, only the field list and chart areas. The exact same data preparation tools in Power BI are in Excel, so that 'huge value' you talk about is in both tools. That's one of the main points I was trying to emphasize.

@carlstiller2261 2 года назад

Excellent review!

@MyOnlineTrainingHub 2 года назад

Glad you liked it!

@litopalomeras7253 2 года назад

Thanks so much!

@MyOnlineTrainingHub 2 года назад

You're welcome!

@haroldenriquepajueloaraujo7631 3 года назад

Thanks, really good video

@MyOnlineTrainingHub 3 года назад

Glad you liked it, Harold!

@darrylmorgan 3 года назад

Hi Mynda!Great Explanation,Most Of My Reporting Lately Is With Power BI Mainly For The Interactive Visuals Clients Seem To Love But I Will Always Use Excel When Ever Possible...Thank You :)

@MyOnlineTrainingHub 3 года назад

Thanks for watching, Darryl! I agree it's hard to pass up Power BI's amazing visuals.

@Sayanbaetov 2 года назад

Thank you! Good explanation :)

@MyOnlineTrainingHub 2 года назад

Glad you liked it :-)

@clivepetty2338 3 года назад

Very usefull, i recall from last presentation on Power BI the monthly subcribtion costs, at $10 per month, does on at face value appear to be quite high if you have ad hoc users, may access 1 / 2 report dask boards only. Interestig to know what corporate take-up is and if other subcribers to channel, would invest time in learning Power BI, but are not doing so as the licence cost is barrier to adopt and use.

@MyOnlineTrainingHub 3 года назад

Yes, the licence fee can quickly add-up and isn't justified for occasional use.

@barnabastoth4648 3 года назад

One workaround on this to set up a guest account and give 'report account' credentials to users who need to see the report. Just a M365 account is enough for this, no Power BI pro license. Within your company's tenant even M365 subscription not needed. So there are alternatives:)

@ngedwin6174 3 года назад

very useful, mdm. Thanks.

@MyOnlineTrainingHub 3 года назад

Glad to hear that!

@neerajagarkar Год назад

Excellent work! This resonates with my opinion too. Power BI has a really steep learning curve and the costs for Pro subscription are somewhat prohibitive. My industry (Engineering and Construction Projects) has a bias towards Excel as most professionals already use other software tools for functions such as Project Management or Procurement or F&A etc. and prefer to use Excel to do quick analysis on a data dump. Probably this is just due to the way this Industry works and not a comment on Power BI in the Excel vs. Power BI debate.

@MyOnlineTrainingHub Год назад

Glad it was helpful 🙏

@johnborg5419 3 года назад

Thanks Mynda :) :)

@MyOnlineTrainingHub 3 года назад

My pleasure, John!

@leegregory844 2 года назад

Really great video!

@MyOnlineTrainingHub 2 года назад

Glad you liked it, Lee!

@zakincc 3 года назад

Thank you so much 😊

@MyOnlineTrainingHub 3 года назад

My pleasure 😊

@garis_lurus 2 года назад

Thank you, im from indonesia, i already subscribe, thank you

@MyOnlineTrainingHub 2 года назад

Great to hear, Garis!

@bradross3261 3 года назад

If possible, could you show a video about how you come up with the WHY. I look for metrics but have difficulty asking the question or explaining what is needed to get the info I want. Just thought you must have the analytical thinking to say "I want to see how much an employee is costing me to do "x"?" How you go about thinking of the charts and comparison to get the result. hopefully I"m making sense. PS...excellent simply to use videos.

@MyOnlineTrainingHub 3 года назад

Thanks, Brad! There are a fairly standard set of rules for which charts suit what type of data/scenario. I have a chart recipe eBook you can download from here that might help: www.myonlinetraininghub.com/workbook-downloads

@PavanKumarNarbolikar 10 месяцев назад

With work around In excel we can restrict data using VBA or Power Query for users. Ex: Fetch the Employee ID of the user at workbook open event and filter the data. If the data is in sheet it can be very hidden.

@MyOnlineTrainingHub 10 месяцев назад

Thanks for sharing, Pavan. Those are great ideas, but users need to know that VBA is not super secure and with a quick Google search you'll find a video on how to remove VBA protection.

@PavanKumarNarbolikar 10 месяцев назад

@@MyOnlineTrainingHub True that. 👍

@shashalee6364 3 года назад

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!

@MyOnlineTrainingHub 3 года назад

Hi again Shasha, I'm assuming in the Worksheet Protection you selected to allow users of this worksheet to: Use PivotTables & Pivot Charts. If that doesn't give you the desired results then try hiding the PivotTable on another sheet and then hiding the sheet tabs to make it more difficult for users to access them. More on worksheet protection here: www.myonlinetraininghub.com/excel-worksheet-protection

@arturoguzman5230 2 года назад

Mynda, Beautiful black shirt. You look great.

@MyOnlineTrainingHub 2 года назад

😁 Thanks, Arturo!

@gleysonoliveira802 2 года назад

Grato work. You got a new subscriber. :)

@MyOnlineTrainingHub 2 года назад

Thanks and welcome :-)

@md.rashedulislam5273 3 года назад

Amazing..... Well i want your T-shirts..🤷‍♂️

@MyOnlineTrainingHub 3 года назад

Thanks 😊

@mahathmasadineni2884 2 года назад

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.

@marygracesalas3522 3 года назад

Very good post! :) but just a question, if I am using 64-bit excel for power pivot, can others open/refresh the file even if they only have 32-bit office? Thanks in adv!

@MyOnlineTrainingHub 3 года назад

Thank you! Others can open and refresh the file if they only have 32-bit but if your model is large then they may have performance issues. It's recommended you have 32-bit Power BI installed. It doesn't really matter if you have 32-bit Office and 64-bit Power BI unless you're using the Excel Power BI tools.

@3pl535 2 года назад

Hi, thanks for the comparison. It's insightful, but I personally think Excel is better for dashboards 😀

@MyOnlineTrainingHub 2 года назад

You're welcome :-)

@lkumar2727 2 года назад

Excel is more better way than powerbi for create dashboard...... In fact that, excel is everywhere.

@srinivasvaranasi1645 3 года назад

a good presentation.

@MyOnlineTrainingHub 3 года назад

Thanks 😊

@ApteryxRex 3 года назад

Excel can be useful for rapid prototyping of dashboards and reports you intend to publish in Power BI in the long term

@MyOnlineTrainingHub 3 года назад

Yes, great idea, Justin.

@sgpleasure 3 года назад

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.

@MyOnlineTrainingHub 3 года назад

Yes, the teams are different but they work closely together, especially since both tools use Power Query and Power Pivot. Currently a lot of effort is going into bringing Excel online up to speed and not a lot on chart development.

@RajendraPatel. 3 года назад

Nice comparision smile 😊🙏

@MyOnlineTrainingHub 3 года назад

Glad you liked it :-)

@naseemrealfact 2 года назад

Its very useful,thanks and can u tell which is better bcz i want study so please

@MyOnlineTrainingHub 2 года назад

Great to hear 😊

@Christian-jf5ys 2 года назад

Would be nice with a summary at the end showing the results of the comparison of each aspect.

@MyOnlineTrainingHub 2 года назад

Great idea, Christian. You can see a comparison table here: www.myonlinetraininghub.com/excel-dashboards-vs-power-bi-dashboards

@Christian-jf5ys 2 года назад

@@MyOnlineTrainingHub thank you

@jime6517 3 года назад

Relevant, informative and delightfully presented! (says here...) Thank you ma'am. V/r je

@MyOnlineTrainingHub 3 года назад

Thank you kindly, Jim!

@javierpiles5833 2 года назад

You get instant Like, for those T-shirts :D

@MyOnlineTrainingHub 2 года назад

Aw, thanks, Javier!

@kerri648 Год назад

do you have a tutorial on the grpahs around the 4 minute mark where you're using the bar graph as a slicer ?

@MyOnlineTrainingHub Год назад

I think you mean this one: www.myonlinetraininghub.com/cross-highlight-excel-charts

@kerri648 Год назад

@@MyOnlineTrainingHub thann you

@onyedikachidanielboyleokwa7377 3 года назад

Hello Please should I be advanced in EXCEL before learning POWER BI? Thanks for the video

@MyOnlineTrainingHub 3 года назад

Not necessarily, but advanced Excel skills are more in demand than Power BI skills, so the choice is yours.

@Anonymous-ho1mt Год назад

Where is the merch link when you need one.

@debSilbert 9 месяцев назад

I'm trying to create a plan vs. actual from a Quickbooks Online export of data. I've got the Power Query all set up to eradicate the mess, but can't figure out how to get the plan numbers in there. The exported data is actual transactions. The plan data is independent of it. If I were to add the column during the Power Query set up and manually enter the plan numbers, it would be overwritten the next time I update the file. I'm on a Mac so can't use the Window Folder update method. Is there any other way to get the plan data to play nicely with the transaction data?

@MyOnlineTrainingHub 9 месяцев назад

Hi Deb, great to hear you're working with Power Query to get your data. You can merge the actual and budget tables together in Power Query: www.myonlinetraininghub.com/excel-power-query-vlookup

@rlshultz5841 3 года назад

Excel wins for a high number of applications. Most common dashboards it’s much easier and the cost and common knowledge is even more reason.

@pupshel 3 года назад

Hi Mynda! After watching your great videos I build in Excel a dashboard. I created the data in Query, that results in a table. From the table I created Pivot tables. I have noticed that my pivot tables do not refresh with the most recent data even if I refresh the table, refresh the powerpivot, or refresh all data. I also tried unchecking Enable background refresh and still it does not work. Do you have any idea on how to solve this? Thanks a lot!

@MyOnlineTrainingHub 3 года назад

Congratulations on building your own dashboard! If your data from Power Query is loaded into an Excel Table in the worksheet and from there you built PivotTables then you need to refresh twice, once for the query to load the data into the Table and a second time to update the PivotTables. It's better to keep the query as connection only and build the PivotTable directly from the query. This resolves the double refresh requirement.

@pupshel 3 года назад

@@MyOnlineTrainingHub Thank you so much for such a quick reply. I took your advice and kept it as connection only and now is ok. All the best!

@harbime 2 года назад

One important pros for Excel is that you have full access to update the filtered data (i.e. add tags, Bulk update), while Power BI is read only.

@MyOnlineTrainingHub 2 года назад

Indeed :-)

@user-gy7uu9gt8n Год назад

The personalized visual feature for power bi is making it more flexible for users now.

@Chris-yv6xy 3 года назад

Amazing video! What do you think about tableau?

@MyOnlineTrainingHub 3 года назад

Thanks, Chris! I've not used Tableau so I can't comment first hand. However, the Gartner review puts Power BI above Tableau. You can read more of the review here: powerbi.microsoft.com/en-us/blog/microsoft-named-a-leader-in-gartners-2020-magic-quadrant-for-analytics-and-bi-platforms/

@Chris-yv6xy 3 года назад

@@MyOnlineTrainingHub Thanks! Appreciate the reply. Love your videos