You are a God-send! I'm not lying! I've just been asked to do a dashboard and I can't think beyond the traditional Pivot. The executives want to "blown away" - I wish literally! This was the best one hour i spent on the internet in a long, long time. God bless you!
I love the speed and effectiveness. You are straight to the point which keeps my interest. I learned so much in less than an hour. I can not thank you enough and I look forward to the next videos!
Wooooooooooooow, I have worked on excel, studied, discussed and learned, but I haven't seen someone with so smooth, professional and fascinating work like you, really thanks for that great way of making it easy
I originally skipped over this looking for Power BI classes. That was a mistake. This was awesome! Can't tell you how many tips and tricks I picked up. Days like this make me wish I could spend more time learning how to make my workbooks and reports so much better. Thank you Mynda!
Thanks for your kind words, Brian! Glad watching the video was worth your time :-) I also have a Power BI video if you're still interested in that: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BsXliHbOFDM.html
I am working as an operations manager in a multinational company. Your video is so much helpful for me to do great things for my work. Good one and keep it up.
A cut above! Why? Because you kept saying "I can't go in to that right now for the sake of time" which allowed for you and your watchers to stay focused on the more important things. I have watched 100+ great power query videos, but your video gave me exactly what I needed in a one hour nut shell. You taught so many different topics/aspects on how to build a dashboard in Power Query that I know this will be my one stop shop or go to video when I run in to problems or can't remember how to do someone. I will no longer have to look through 3 or 4 videos to find the one that covers my problem. Thank you very much and you are an awesome teacher :)
Wow, thanks for your kind words, Kim. It's great to know the video is going to be useful to you. Have fun with Power Query. It's the best new thing in Excel since PivotTables :-)
Awesome to hear, Nakia! If you'd like to get up to speed with Power Query, please consider my course: www.myonlinetraininghub.com/excel-power-query-course
Thank you so much for sharing these materials. Thanks to your videos I was able to successfully get a job (I was able to create a interactive dashboards in less than 30 minutes!). Not to mention of course that I have learned and still learning a lot of new staff. Thanks again!
@@MyOnlineTrainingHub Just some additional sharing from my own experience: As I downloaded your data sample and encountered a problem which is my regional date/time is not the same as the one set in the file, which create some problems when I transformed the data. However, it was solved easily using regional locale in power query settings :)
This is such an amazing video. Thank you. I i am impressed by how you cover the advanced material while finding time to explain smaller details such as formatting and eventual "consequences". Thanks.
This tutorial is really helpful. I'm stuck when my pivot doesn't work when i'm creating the dashboard. But your video really help me out out that. Thanks
I LOVE YOU ! I've answered so much needs already thanks to you ! And I want to work on my dashboards all over again. And thank you for your accent, perfectly understandable for me (I'm french). You are wonderfull !
Hello Mynda, thanks a lot for this wonderful tutorial. Just one thought- maybe it make sense to decrease resolution when you recording this- it`s quite hard to distinguish formulas etc. - too small..
Cheers, Sergey! In my more recent videos I use the zoom function a lot more, so please check those videos out too. Here's the Dashboard video playlist: ru-vid.com/group/PLmd91OWgLVSLy87GfZCR74BG1nhO7ER0s
Wow, I've been using Power Query for some time but was afraid to dabble in Power Pivot. It turns out I could have been breezing through report creation had I just watched this video sooner. Thank you!
This was a very helpful tutorial that helped me start building reports with Power Pivot right away. Amazing work! Thank you so much. Will be sharing this with friends and colleagues.
Fantastic video! Will be watching the other videos too. Your method of teaching is natural, fluent and makes the listener very attentive. Excellent work :)
Thank you for the series of interactive dashboards. I use the steps shown in this video often in my work. Really good ideas to get dashboards with tons of data well readable and professional.
Excellent video! I really appreciate this publication. The explanations are very clear and the examples simple to understand. Much success. Greetings from Venezuela.
@@MyOnlineTrainingHub not joking :D The time flies watching your tutorials. Once again thanks a lot for empowering people around the world with this constructive material!
Thanks for the content. I want to ask that instead of doing the long Offset function formula, can't we make the same effect with simply indicating the data range in sparkling data range section? Because at the end, the thing you did is not fully dynamic. it is limited to some extent, we can specify that by indicating the range longer in sparkline date range section, can't we? Thanks in advance.
Hi Faith, I would avoid having to manually update anything. Please see this tutorial on relative dynamic named ranges if you need more flexibility: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gCo0zL3-OtE.html
Thanks, Haitham! Everything is easy once you know how ;-), but seriously, Power Query is super easy to use and you don't need to know everything about Power Pivot to start using it and benefiting from it.
Thank you for your excellent video and for the original files: essential for a perfect understanding! Around minute 20, there's a difficulty in ordering Bob, Richard and John in the "sales by category" bar chart : you only need to double click on the chart axis and "invert X axis" to set it up. I hope It helps ! bye
Thanks, Stephane! Glad you enjoyed it. Yes, indeed you can invert the axis. Sometimes I invert the axis, sometimes I sort the source data. Just depends on what takes my fancy on the day :-)
Nice - Sparkline method to reference the pivot table. This will in time full down as you have hard coded the number of column in the offset. You could use the Max formula to dynamically expand the offset columns
The only value that is hard coded is the height of the range, at 1 row high and this will never change. I've allowed for growth in the PivotTable by using COUNTA to determine the number of columns. Not sure where you think it's hard coded otherwise.
At 36min 15Sec - your highlight columns B to U for the count. if the pivot chart goes beyond this would could/would have a problem. You could increase the column selections. One of the abilities I like use a method to display the last X number of years of data
Exactly, I'm allowing for growth. You can allow for more growth when you apply it to your own work if you think it's required. For the purpose of the demonstration I think that I conveyed the point, which is use COUNTA to count the headers and extend past the end of the PivotTable to allow for growth.
Hi Mynda! So glad I found you and your resources. Just what I was looking for! Wondering if you have any expense template downloads so I can immediately set one up and start tracking. I would be more than happy to pay!
Brilliant tutorial - clear explanations and at a good pace. One thing i was hoping you would explain is how you get images in your slicer heading? At 0:33 there are icons above the delivery method slicer options - how do you get those there?
This is awesome! I want you to make a video on how to make multiple "smooth" chart line angles in excel 2016 at once. I have to select each line one after the other to make them smooth.
Thanks, Samuel! Be careful using smooth lines because they can distort the highs and lows. i.e. Sometimes the tip of the smooth line is above/below the actual point. I avoid them for this reason.
Hello Mynda, Are the first few steps done to minimize the file size? If I pull the dashboard out on a separate file will the help with the file size? The people I will be presenting the dashboard to will only need to toggle through the slicers they won't need to access the raw data. Thanks for the tutorials. They are bloody fantastic!
Yes. You can get the data from an external workbook, but it won't make any difference to the file size as you're still loading the data to the Power Pivot model.
I learned yesterday how to use the option "Pivot Column" in your video "Power Query Unpivot - fix 4 common data layouts (incl. workbook) ". I used this knowledge today at work and it worked here in Brazil. I was trying to do this but I just knew the command "Unpivot Columns" before that. I used the 2 concepts at this transformation and it was great! Thank you for your tutorial!
Thanks a lot for this video! It is the best I have found so far! Can you please tell me what is the best way to update the datasource? What if I have to add more lines into it, or modify a specific cell? would I have to upload the file again? thanks
Hi Ms. Tracee I'm working in the HSE field and I'm trying to build an excel sheet dashboard this sheet will contain as follow: 1- How many I have in my stock of (Gloves, coverall, glasses, goggles, footwear, ... etc). 2- I have 150 employees in my facility and they need for PPE continuously. How I make a dashboard shown to me the history for each employee (what he is received and which date it was). I appreciate your efforts in advance. and I'm one from your followers
Hi Ali, I don't have anything that fits your needs, sorry. It will all depend on how your data is structured etc. but it's probably a job for Power Pivot.
Hi , I learned lot of things from this video. Thank for this. It would be great if you will share the link of video which explains the OFFSET formula of excel.
Hello Mynda, great video! Quick question, when I go to insert pivot table, In the prompt window I dont see the option to select “use this workbooks data model”. I checked the steps as well
Thank you! The option to select this workbook's data model there is only available in some versions of Excel. If you have 365 you can instead select it from the Insert tab > PivotTable > Data Model
Simply - thank you, a well explained tutorial. I have one very simple question. My data is in .CSV format, however, in a few files there are extra columns which I don't need (I only found this out when I acquired more data). My work around was to open these in excel and deleted before refreshing my dashboard. Is there an option, when designing this power query, to ignore any extra columns?