Secrets to Building Excel Dashboards based on Non-financial Data

  Рет қаралды 123,925

MyOnlineTrainingHub

MyOnlineTrainingHub

Күн бұрын

Пікірлер: 188
@anaismartin7384
@anaismartin7384 3 жыл бұрын
Perfection, as usual ! I couldn't find such great tutorials anywhere, thanks for your great job !
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks so much, Anais!
@zzzzzzzzzzzzzzzz9
@zzzzzzzzzzzzzzzz9 2 жыл бұрын
Love the passion you display in your video's. Extremely knowledgeable and clear
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you like them!
@stevenbrazel5262
@stevenbrazel5262 Жыл бұрын
Brilliant tutorial, I have learned more in a few weeks from your videos than 3 years of fumbling about by myself. I will definitely be taking a couple of your on-line courses
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
That's wonderful to hear, Steve!
@FabioGambaro
@FabioGambaro 3 жыл бұрын
Thank you very much for the tutorial! I used to copy/paste the pivot tables instead of creating new ones to riduce the size, but, as you mention, given the amount of data that Power Pivot can handle, and its efficiency, probably it's not worth... A trick I use to format the text box after updating the reference is the format painter, which I find faster than change all setting from scratch...
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Hi Fabio, copying and pasting PivotTables doesn't reduce the size, what it does is avoid the chance of you accidentally creating another Pivot Cache, which is a copy of your source data held in memory that the PivotTable references. With regular PivotTables it's possible to create multiple Pivot Caches and be unaware of it. With Power Pivot the data model is the Pivot Cache, and it's not possible to duplicate it. Thanks for the format painter tip! I'll try that :-)
@shoppersdream
@shoppersdream 3 жыл бұрын
Mynda, I got stuck at 45:42 video time. In my case after I wrote that measure, it populates 0 for every column for Male and Female. In your case I noticed that there are other values also. What mistake do you think that I must have made? It is wonderful but, in my case, it didn't take an hour to make, it take entire day as I was making some mistakes. Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Great to see you're giving it a go. The best thing to do is copy and paste my measure into a text editor like notepad and then paste your measure there and compare them character by character. It's probably something simple.
@shoppersdream
@shoppersdream 3 жыл бұрын
@@MyOnlineTrainingHub Thank you, Mynda! I tried to paste your code also, but it still populates '0' and there are some steps we are missing. I noticed which is weird Grand Total is shown like this 144 1,147. Where did these numbers come from? your numbers are also the same except in my case all values are 0 but Total is showing 144 1,147. These Totals are coming out of Blank and if uncheck blank then these values go away. Same issue with the next Chart. Some step is surely missing. My Code is IF(ISBLANK( CALCULATE([Count of Crew Name], USERELATIONSHIP(DimDestinations[Destination],Missions[Destination]))),0, CALCULATE([Count of Crew Name], USERELATIONSHIP(DimDestinations[Destination],Missions[Destination]))) I didn't see any difference between your code and my code. I am missing something. Can you please see what the issue is? I had used the name as DimDestinations and you used DimDestination. That is the only difference. Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
I'd say your relationships are back to front. If you're still stuck, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum Note: I probably won't see any follow up replies to this thread as I get tons of comments every day and this one will end up being buried.
@edwardwagner3712
@edwardwagner3712 2 жыл бұрын
Thank you, I track training and your instructions are always clear and concise.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Great to hear, Edward!
@grahamparker7729
@grahamparker7729 3 жыл бұрын
That was a great video Mynda, made better by not being based on financials 👏🏻👏🏻👏🏻
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks so much, Graham!
@sbiguddi
@sbiguddi 3 жыл бұрын
That's just awesome, I never found someone explaining so beautifully to make dashboards in non-financial data, for me it is life saver for qualitative data. Thanks 😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
So glad it was helpful, Saba!
@franks8130
@franks8130 3 жыл бұрын
Absolutely loved it. A ton of different techniques used in one amazing presentation. Looks like I now have to go back to the drawing board and redo just about every file I'm sharing. Thanks for the extra work:)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
:-) glad you found some useful ideas, Frank!
@hougrel9514
@hougrel9514 2 жыл бұрын
I am having to completely re-educate myself. 15 years ago the majority of my logic,formatting and processing was achieved via events and VBA code. Granted some of this functionality is new but I suspect much of it I just ignored because I could code it. I pretty much kept up with video but now will watch again and note the bits I need to know more about and then dive into your other brilliant videos to re-enforce what I learnt today. Thank you so much (Note to self - use a measure to fill in missing weekend data for stock prices?)
@hougrel9514
@hougrel9514 2 жыл бұрын
Already watched the playlist 16 vids for beginners just to remove the top layer of rust on my Excel "skills". And a Power Query one.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Great to hear!
@arbazahmad7177
@arbazahmad7177 2 жыл бұрын
Interesting... Many new things to learn with this Dashboard. Thanks.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad it was helpful!
@johncatsicas101
@johncatsicas101 3 жыл бұрын
Mynda stand up and take a bow again for the excellent series - you certainly know how to take rabbits out of your hat
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Aw, thanks so much!
@georgemuyunda7925
@georgemuyunda7925 3 жыл бұрын
Awesomely awesome Mynda. Great Job. So inspiring for me as I embark on a Dashboard assignment. Very useful techniques. Cheers!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Glad it was helpful, George!
@JustMe-sh8nd
@JustMe-sh8nd 3 жыл бұрын
Sooo many thanks for this tutorial and all other video's from you. it's just...wow.. Currently i am creating a big dashboard for the company with your help. I will blow them away i guess.. thank you so much!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
So pleased to hear that! Best of luck with your dashboard!
@KimzCraftz
@KimzCraftz 3 жыл бұрын
Another great example - thank you Mynda
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks, Kim!😊
@ImeLoto
@ImeLoto 3 жыл бұрын
This is so great. Your tutorias enlighten me! Thank you so much and hope a lot of good things will come on your way!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thank you so much!
@aidanstow2084
@aidanstow2084 Жыл бұрын
Question would this be sufficient for a document control dashboard where we would need live access so we know what documents are live and require review? and also would this update as we updated the tables or does it require to be manually updated. if so would you have any tutorials for creating of a dashboard for qualitative data with review dates etc
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Any reports built with PivotTables require refreshing to update them. If you build your reports using formulas, then they update automatically and are visible to all users when co-authoring as explained here: kzbin.info/www/bejne/jpfKdZmLertjnK8
@TheAjukumar
@TheAjukumar 3 жыл бұрын
Every time I see your excel video, I wonder if you were really born here on earth! :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Aw, you're too kind :-)
@chesapeake9391
@chesapeake9391 3 жыл бұрын
Use format painter, align and group function. Much easier than fiddling around with formatting.
@shoppersdream
@shoppersdream 9 ай бұрын
Mynda, this is so beautiful and I returned after 2 years to try it again. I want to make a similar Header above my Pivot Table. I do not see any timestamps for a Header. Thank you for always giving us the Exercise File to Download. I always come to your Videos First before I go to any other video. Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub 9 ай бұрын
Aw, that's wonderful to hear. So glad you found this helpful 🥰
@nazarenoman
@nazarenoman Жыл бұрын
Hola Mynda. Fabuloso, como siempre. Pero tengo una consulta. Yo hago a veces tableros en los que tengo los datos cargados en Power Pivot. Después, los trabajo directamente en la hoja de Excel con gráficos dinámicos. No inserto previamente una tabla dinámica y después, sobre ésta, inserto el gráfico. Veo que, habitualmente, siempre utilizas una tabla dinámica para después insertar el gráfico. ¿Es mejor esta manera que insertar directamente el gráfico dinámico, como hago yo? Muchas gracias.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
You can go straight to Pivot Chart if you prefer. I find it clearer to build the PivotTable and then the chart for teaching, as I think it's easier to see the data in a Table first, but there is no efficiency gained either way, so please do whatever is easiest for you 😊
@nazarenoman
@nazarenoman Жыл бұрын
Hola Mynda. Muchas gracias por la respuesta y su prontitud. Te seguiré viendo, siempre.
@ftmagicart
@ftmagicart 3 жыл бұрын
An useful tutorial. Thank you very much Mynda
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
My pleasure 😊
@mehdihammadi6145
@mehdihammadi6145 3 жыл бұрын
As always, informative and impressive. Thank you for sharing Mynda
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks for watching, Medhi!
@adenikeolatunde5333
@adenikeolatunde5333 7 ай бұрын
Thanks a million Mynda 😆
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 ай бұрын
Pleasure 😊
@dlvileno
@dlvileno 2 жыл бұрын
Hi - thank you - your trainings are FANTASTIC. I do have one question - I am using 365. I have created a dashboard that has a bar chart with @100 values. The problem I am having is when a slicer is selected the chart does not reduce in size based on the filtered data. So I end up with bars that are huge. How do I have the chart resize based on the filtered data?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks for your kind words, Danielle. There's no built-in way to auto resize the chart as you describe. They're designed not to resize because then your dashboard would be adjusting all over the place with each click of a Slicer. If you want to do this then you'd need to write some VBA code to do it, but I'd recommend leaving it as is.
@patmckeown6561
@patmckeown6561 3 жыл бұрын
Hi Mynda, Great video as usual, lots of information and great tips to take in.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Glad you enjoyed it, Pat!
@deirdreleigh4484
@deirdreleigh4484 3 жыл бұрын
Fantastic Mynda, love the summary bar, must look at adding those to my dashboards.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks, Deirdre!
@tolulopejayeoba2448
@tolulopejayeoba2448 3 жыл бұрын
Many thanks for this great tutorial as always...I just want to ask if it is a MUST for the data files to be in CSV. format before power query can be used to set up the processes.
@ricos1497
@ricos1497 3 жыл бұрын
No, it can be text file, excel file, excel table in the same sheet or a named range, SQL database etc. Lots of options. Go to data menu and get data from file, folder etc you'll see all the options.
@shubhamajmera5494
@shubhamajmera5494 3 жыл бұрын
We want dashboard for wind energy Forecasting. If possible would love to learn the same.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
If you have some data I can use then maybe I can build it as one of my demos.
@shubhamajmera5494
@shubhamajmera5494 3 жыл бұрын
@@MyOnlineTrainingHub Yes...I work on this technology only which is Globally a very new technology. What is the way to communicate to you plz drop me yr address. Let's work on this, it will be a learning lesson for me and for Yu a new zone.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
You can email it to website at MyOnlineTrainingHub.com
@PavlosAlexiou-s1v
@PavlosAlexiou-s1v Жыл бұрын
You are just amazing! Many thanks !
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
Thanks so much!
@allie612
@allie612 3 жыл бұрын
Great tutorial!!! Thank you I have a question, it is related to Microsoft planner and the ability to use excel to create a dashboard for the projects. I know power BI can be used to get visuals by downloading the data using excel. I would like to know if you have a tutorial on how to use excel dashboards using the data downloaded from planner. Thanks again for your videos and tutorials 😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks, Allie! I don't have any tutorials on Microsoft Planner or dashboards using that data.
@Luciano_mp
@Luciano_mp 3 жыл бұрын
Brilliant, congratulations. Amazing Dashboard! Thank you Mynda!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks, Luciano!
@chowa3686
@chowa3686 3 жыл бұрын
Thanks for your presentation ! ! !
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
My pleasure!
@eZfRuNgkLuNg
@eZfRuNgkLuNg 3 жыл бұрын
Always helpful videos!!! Keep it up pls! 🙂
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thank you! Will do!
@Harziona
@Harziona 3 жыл бұрын
Thanks so much for a wonderful tutorial.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
My pleasure 😊
@AlterMind64
@AlterMind64 3 жыл бұрын
Yet another incredibly efficient and effective video, with great and clear explanation, and brilliant result ! Always a real pleasure and learning experience combined. Thank you Mynda :-)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks so much!
@markhill9836
@markhill9836 3 жыл бұрын
Very good video and very useful. I was always instructed to add all formatting after the data was prepared and presented, though the header was useful to have headline data added to after, so understand the rationale for that. Thank you. I can use a lot of this for my work.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Cheers, Mark! Yes, I agree, better to leave formatting to the end, but I knew what the end result was ;-) The reason for formatting at the end is because you can waste a lot of time with formatting constantly changing as you finalise the design of your report, so it's best to wait until you have all the charts in place before you format.
@houcineb4139
@houcineb4139 3 жыл бұрын
Thank you for your time
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
My pleasure :-)
@JawadJawad-qm5dw
@JawadJawad-qm5dw 3 жыл бұрын
Thank you very much Mynda for sharing with us🙏
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
You are so welcome, Jawad!
@kiliev2007
@kiliev2007 3 жыл бұрын
Your work gives pleasure!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
So thankful for that, Kalin!
@dexxxxxxxx
@dexxxxxxxx 2 жыл бұрын
With all respect you're amazing teacher and I made dashboard with you. But I'm unable to understand that coding you did to establish relations in NEW MEASURES and why you connected that table initially. I want to learn that everything. From where should I start. I know basics and formulas. But power pivot and dax is totally new for me... Please share playlist where I can learn it from basic 🙏🏻
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
You can learn DAX in my Power Pivot and DAX course here: www.myonlinetraininghub.com/power-pivot-course
@wayneedmondson1065
@wayneedmondson1065 3 жыл бұрын
Awesome tutorial Mynda! So many great tips and techniques. Will study it in depth for further insights. Thanks for sharing :)) Thumbs up!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Glad you enjoyed it, Wayne :-)
@chrism9037
@chrism9037 3 жыл бұрын
Outstanding Mynda!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Cheers, Chris 😊
@sininv1
@sininv1 2 жыл бұрын
HI I love to watch your youtube it's always so amazing how you create the dashboard. Can you show how to have a calendar dashboard with event title and it's cost? Thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you liked my video 😊 I don't have any calendar examples, sorry.
@MarwanAlMasri
@MarwanAlMasri 3 жыл бұрын
Thank you for all your efforts 🙏🏻
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
My pleasure!
@wekawekacekakak1268
@wekawekacekakak1268 3 жыл бұрын
Mynda, have you create a dashboard with Google Data Studio (GDS) ? Whether GDS is not complete enough of features than Excel and what are the pluses and minuses of the two applications..
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
No, I haven't used GDS.
@swimfast8076
@swimfast8076 3 жыл бұрын
How do you use dashboards to show comparisons between different samples, including ANOVA statistics?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Often column charts with error bars are used to visualise ANOVA statistics. With dashboards you could integrate Slicers to allow filtering of the data based on different groups etc.
@tutsecret499
@tutsecret499 Жыл бұрын
Can Excel do features from Intime software which is time series database. What is that?
@MyOnlineTrainingHub
@MyOnlineTrainingHub Жыл бұрын
I'm not familiar with that software, so can't say.
@khasini2354
@khasini2354 3 жыл бұрын
Hi this is uma Ur video are understanding easily Can u do videos on dax functions
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Glad you liked them, Priya! If you'd like to learn DAX, please consider my Power Pivot course: www.myonlinetraininghub.com/power-pivot-course
@garytan1912
@garytan1912 3 жыл бұрын
May I know what is the reason to link the relationship between the tables in power query?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
The relationships in Power Pivot enable you to use fields from multiple tables when building the PivotTables.
@darrylmorgan
@darrylmorgan 3 жыл бұрын
Hi Mynda!Great Tutorial,Really Cool Dashboard And Helpful Tips...Thank You :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks for watching, Darryl!
@chriscolbran4041
@chriscolbran4041 2 жыл бұрын
Always Great!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Thanks, Chris 😊
@zubairmalik2757
@zubairmalik2757 3 жыл бұрын
Hi Mynda, thanks for the video, great stuff. I got stuck on calculating measure for Spacecraft Mission. I am using exact formula, but still getting below error message, kindly can you help "Calculation error in measure 'CrewedMissions'[Calculated field 1]: The function COUNT takes an argument that evaluates to numbers or dates and cannot work with values of type String" formula = IF(ISBLANK(COUNT(CrewedMissions[Spacecraft])),0, COUNT(CrewedMissions[Spacecraft]))
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Sounds like you didn't set your data types to numbers for the Spacecraft column when you imported the data with Power Query.
@ajsabes730
@ajsabes730 2 жыл бұрын
I need help with a formula: in a pivot table I would like to get the value (# of staff) of the Office, but the cell keeps changing because each year it adds a center. How can I create a formula for that... I used IF function but not sure what else to add with that. Am I using the right function? Please advise. thanks! 2019 Center #of Staff NCTR 14 OCC 9 OC-IO 1 OCS 4 OEA 3 OES 2 7 2020 #of Staff Center 6 NCTR 2 OCC 23 OCE 7 OC-IO 1 OCPP 1 OCS 1 Thank you!!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Hi Jean, Please post your question and sample Excel file on our forum that illustrates what cell you're trying to get and we can help you further: www.myonlinetraininghub.com/excel-forum
@kdoffek
@kdoffek 3 жыл бұрын
Followed this perfectly until the crewed mission table. When I use the calendar for the rows the years show up but as soon as I add the other field s the years disappear what am I doing wrong!!!
@kdoffek
@kdoffek 3 жыл бұрын
I figured it out ...it all came down to making sure date formats were set correctly !
@jimfitch
@jimfitch 3 жыл бұрын
Great tips, Mynda! Lots of gems in here that will be put to good use in both non-financial & financial dashboards. 😃 Thanks!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Great to hear, Jim :-)
@mohammedaltaf4877
@mohammedaltaf4877 3 жыл бұрын
Excellent Job
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Many thanks :-)
@simonmassen
@simonmassen 3 жыл бұрын
Great as ever, is it possible to do a Map for just one country, Britain for instance?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks, Simon. Yes you can create maps for a single country as explained here: www.myonlinetraininghub.com/excel-map-charts
@simonmassen
@simonmassen 3 жыл бұрын
Excellent, thank you, will it work with data gathered via a VLOOKUP?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Yes, the chart doesn't care what the underlying formulas are.
@prasunray1990
@prasunray1990 3 жыл бұрын
Hello, Mynda I have been watching your guidance and it's really great to understand. My request is to kindly guide me how to create dynamic links of various rows in a sheet to another sheet? Example: in Sheet 1, Row 1: 24(col1), 29(col2), 37(col3), 58(col4) #(shape) Row 2: 65(col1), 31(col2), 35(col3), 54(col4) #(shape) Now while clicking on # of each row, it will automatically fill up the corresponding data of that row into another sheet under concerned column title. And it will changes automatically while clicking # of another row of sheet 1. Can we solve this without using VBA, please guide... Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Glad you enjoyed my video, Prasun! Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@prasunray1990
@prasunray1990 3 жыл бұрын
@@MyOnlineTrainingHub Any email id for attaching the excel file, I don't get it at the forum where to attached the .XLS.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
there's a button on the forum to add attachments below where you type your question.
@prasunray1990
@prasunray1990 3 жыл бұрын
@@MyOnlineTrainingHub Ma'am I have posted in the forum, id : rayprasu
@aminmojab
@aminmojab 2 жыл бұрын
Hi, very useful videos. Thank you. Is it possible to create a project management dashboard which is linked to primavera p6 database? It would be very helpful and also new amazing topic.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you found them helpful! I'm not familiar with Primavera, but I suspect you may be able to connect to it, or at least a download of the data with Power Query.
@mohammedaltaf4877
@mohammedaltaf4877 3 жыл бұрын
As usual Smart work
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks again, Mohammed!
@shoppersdream
@shoppersdream 3 жыл бұрын
Do you sell your courses on UDEMY or any other website? Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
No. You can get my courses from my own site. That's where I have my course members' support forum where you can ask me questions and get help when implementing the techniques in your own work.
@shoppersdream
@shoppersdream 3 жыл бұрын
@@MyOnlineTrainingHub Thank you, Mynda! On your site, they are expensive. BTW, I just started following this video so far, I have watched 16 minutes and it is so good. Thank you for sharing this.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Glad you're enjoying the video.
@garyseymour6319
@garyseymour6319 3 жыл бұрын
There's quite a useful button called 'Format Painter' 😃
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks for sharing, Gary!
@iankr
@iankr 3 жыл бұрын
Fantastic video, with lots of techniques covered. 😊👏🙏
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Glad you enjoyed it, Ian!
@trucmuche1545
@trucmuche1545 3 жыл бұрын
Great video!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Glad you enjoyed it :-)
@argokusumandani9773
@argokusumandani9773 3 жыл бұрын
Thank you👍
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
You're welcome :-)
@chengcheng7263
@chengcheng7263 2 жыл бұрын
I really like your video
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Great to hear!
@analyticsadda6080
@analyticsadda6080 3 жыл бұрын
Online training hub team. You have used many pivot tables this will increase fuel size. How the file size is reduced for big data sets.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
The PivotTables don't make a material effect on the file size when working with big datasets. The cells the PivotTables occupy are typically insignificant. Power Pivot has a sophisticated compression algorithm that stores the data in Excel much more efficiently than loading it to an Excel worksheet. This is why it's able to work with millions of rows of data.
@apamwamba
@apamwamba 3 жыл бұрын
@@MyOnlineTrainingHub Excellent Explanation
@robertalavezzari6970
@robertalavezzari6970 3 жыл бұрын
you are the best, always
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks, Roberta!
@shoppersdream
@shoppersdream 3 жыл бұрын
Can't complete this course. Some steps are missing.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
You see every step in the video. What steps do you think are missing?
@shoppersdream
@shoppersdream 3 жыл бұрын
@@MyOnlineTrainingHub Mynda, Is it possible that the file you used is different than the file I used since I spent 2 days and I kept getting zero. I tried it at least 6 to 8 times but nothing worked. Please look at the code I put in the reply to your previous comment. I tried with your code also, but it didn't work. The file size is so big that I could not even upload it on your Forum. I just gave up. Thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Please post your question in the forum where you can also share screenshots that show the relationships in your model, the PivotTable and field list and your measure. From there I can help you further.
@alexrosen8762
@alexrosen8762 3 жыл бұрын
Very impressive
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks, Alex!
@ymoatassimbillah
@ymoatassimbillah 3 жыл бұрын
Very useful
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Great to hear 😊
@andrewbarkham8357
@andrewbarkham8357 3 жыл бұрын
"To infinity, and beyond!!!" - Awesome :)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
😊 thanks, Andrew!
@ricos1497
@ricos1497 3 жыл бұрын
Awesome dashboard. Beautiful, some would say (me)! Not sure if you just did it to save explaining another function but you can use variables when creating measures. Rather than copying the formula twice, just assign to a variable and then use: if(isblank(variable),0, variable). Believe it makes a marginal difference on calculation times. Also, is there a reason that some of these graphs can't go direct to chart rather than creating the associated tables? Or is it just for illustration in the video? Finally, how frustrating that the cube functions don't operate properly: GETTING_DATA!. They'd be so much better than having to create tables for every text box. Even better would be the ability to create a data label that accesses the data model. I've created a function for doing it in VBA using adodb, with a connection string of the workbook data model which works great, but would be much better if Excel provided us this.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Thanks, Rico! In regards to VAR, when I teach DAX I start out with examples that look a lot like Excel formulas to help people feel comfortable with them before moving on to things like VAR. I was already concerned that there were a lot of techniques in that video that people new to PQ and PP wouldn't be familiar with. Not all versions of Excel can go straight from data model to chart, so for now I tend to build the PivotTable first so that everyone can benefit from the video. I agree, it would be great if a text box could support a formula. I suppose you could use CUBE functions for the header values and then reference those cells in the text box, instead of building PivotTables, but again, CUBE functions are even less relatable than PivotTables :-) That doesn't mean you should stop using them though. However, from a teaching point of view I try to take people on a journey, so the content on our KZbin channel is more likely to be targeted at a beginner/intermediate level.
@liquidapathy82
@liquidapathy82 3 жыл бұрын
Loved it
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Great to hear!
@tolulopejayeoba2448
@tolulopejayeoba2448 3 жыл бұрын
Please what is a dimension table??🙈
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
:-) there's a level of assumed knowledge with Power Pivot because I wanted to keep the video under 1 hour. A dimension table contains the values that you want to summarise your data (facts/fact table) by. An example in this file is the DimCrew table which contains further information about the astronauts, like their country and region, which I used to create the map chart i.e. I summarised the count of crew names by country.
@Ankit-dm2wl
@Ankit-dm2wl 6 ай бұрын
Hii this is amezing dashboard can you please give me a file of this dashboard
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Thank you. The link is in the video description.
@jeremiahimissaj6849
@jeremiahimissaj6849 2 жыл бұрын
please add me to you training participants, thanks for sharing knowledge
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
My pleasure 😊
@orthodoxsophia
@orthodoxsophia 3 жыл бұрын
Wow!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Glad you liked it 😊
@innocentknight1
@innocentknight1 2 жыл бұрын
I can't make formula people in space I get in cell male & female = 0 , not like your video I can't know what is wrong?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@sinhngoc8446
@sinhngoc8446 3 жыл бұрын
😍😍😍
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Glad you liked it 😊
@TYoung023
@TYoung023 3 жыл бұрын
Going to watch all your dashboard videos. 👍🏻 Very informative. This video was right at my level of learning in Excel. I like dabbling in VBA, so I probably would have recorded a macro on my first text format change on the dashboard then made a temp button to apply it as needed. That’s just me though! PS. Come to think of it... the format paintbrush does the same thing! 😄
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Yes, Format Painter is a nice trick. I forgot about that one :-)
@ksspqf6016
@ksspqf6016 2 жыл бұрын
Excel dashboards are a fucking kancer I want powerbi
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
There's no need for that language and attitude. Here's my Power BI playlist: kzbin.info/www/bejne/mKjXh3mcjtFnisU
@taahatube1
@taahatube1 3 жыл бұрын
first
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
Hope you enjoyed it ;-)
@taahatube1
@taahatube1 3 жыл бұрын
@@MyOnlineTrainingHub yes my father is a fan dad
@mutazelsadig4006
@mutazelsadig4006 3 жыл бұрын
Thanks for the perfect Video. I have this error Expression.SyntaxError: Invalid literal. ={Number.From(#Date(01,01,1960))..Number.From(#Date(12,31,2020))}
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 жыл бұрын
the function is #date with a lower case 'd'. Also, it should be year, month, day. e.g. #date(1960,1,1)
@scottfabyanic3546
@scottfabyanic3546 2 жыл бұрын
Such a clear thinker. Great Vid!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 жыл бұрын
Glad you think so!
7 Advanced PivotTable Techniques That Feel Like Cheating
16:07
MyOnlineTrainingHub
Рет қаралды 98 М.
Interactive Dashboard Step by Step + FREE File Download
41:23
MyOnlineTrainingHub
Рет қаралды 102 М.
$1 vs $500,000 Plane Ticket!
12:20
MrBeast
Рет қаралды 122 МЛН
Jaidarman TOP / Жоғары лига-2023 / Жекпе-жек 1-ТУР / 1-топ
1:30:54
Counter-Strike 2 - Новый кс. Cтарый я
13:10
Marmok
Рет қаралды 2,8 МЛН
She wanted to set me up #shorts by Tsuriki Show
0:56
Tsuriki Show
Рет қаралды 8 МЛН
10 Excel Things You Should NEVER Do and What to do Instead
12:34
MyOnlineTrainingHub
Рет қаралды 592 М.
Interactive Excel Dashboard Tutorial in 3 Steps (+ FREE Template)
18:57
MyOnlineTrainingHub
Рет қаралды 152 М.
12 Dashboard design tips for better data visualization
9:51
Geckoboard
Рет қаралды 204 М.
5 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 268 М.
The Excel Tool That Does What PivotTables Can’t (File Included)
13:59
MyOnlineTrainingHub
Рет қаралды 177 М.
Build Awesome Excel Visuals to Grab Anyone's Attention
18:11
Kenji Explains
Рет қаралды 430 М.
How to easily automate boring Excel tasks with Power Query!
17:10
MyOnlineTrainingHub
Рет қаралды 1,6 МЛН
How to Build Power BI Reports from Start to Finish
41:07
MyOnlineTrainingHub
Рет қаралды 1,4 МЛН
The Excel Functions Almost Everyone Overlooks (Better Than SUMIFS)
10:29
MyOnlineTrainingHub
Рет қаралды 114 М.
$1 vs $500,000 Plane Ticket!
12:20
MrBeast
Рет қаралды 122 МЛН