Perfection, as usual ! I couldn't find such great tutorials anywhere, thanks for your great job !
@MyOnlineTrainingHub3 жыл бұрын
Thanks so much, Anais!
@zzzzzzzzzzzzzzzz92 жыл бұрын
Love the passion you display in your video's. Extremely knowledgeable and clear
@MyOnlineTrainingHub2 жыл бұрын
Glad you like them!
@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 Жыл бұрын
That's wonderful to hear, Steve!
@FabioGambaro3 жыл бұрын
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...
@MyOnlineTrainingHub3 жыл бұрын
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 :-)
@shoppersdream3 жыл бұрын
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
@MyOnlineTrainingHub3 жыл бұрын
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.
@shoppersdream3 жыл бұрын
@@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
@MyOnlineTrainingHub3 жыл бұрын
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.
@edwardwagner37122 жыл бұрын
Thank you, I track training and your instructions are always clear and concise.
@MyOnlineTrainingHub2 жыл бұрын
Great to hear, Edward!
@grahamparker77293 жыл бұрын
That was a great video Mynda, made better by not being based on financials 👏🏻👏🏻👏🏻
@MyOnlineTrainingHub3 жыл бұрын
Thanks so much, Graham!
@sbiguddi3 жыл бұрын
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 😊
@MyOnlineTrainingHub3 жыл бұрын
So glad it was helpful, Saba!
@franks81303 жыл бұрын
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:)
@MyOnlineTrainingHub3 жыл бұрын
:-) glad you found some useful ideas, Frank!
@hougrel95142 жыл бұрын
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?)
@hougrel95142 жыл бұрын
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.
@MyOnlineTrainingHub2 жыл бұрын
Great to hear!
@arbazahmad71772 жыл бұрын
Interesting... Many new things to learn with this Dashboard. Thanks.
@MyOnlineTrainingHub2 жыл бұрын
Glad it was helpful!
@johncatsicas1013 жыл бұрын
Mynda stand up and take a bow again for the excellent series - you certainly know how to take rabbits out of your hat
@MyOnlineTrainingHub3 жыл бұрын
Aw, thanks so much!
@georgemuyunda79253 жыл бұрын
Awesomely awesome Mynda. Great Job. So inspiring for me as I embark on a Dashboard assignment. Very useful techniques. Cheers!!!
@MyOnlineTrainingHub3 жыл бұрын
Glad it was helpful, George!
@JustMe-sh8nd3 жыл бұрын
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!
@MyOnlineTrainingHub3 жыл бұрын
So pleased to hear that! Best of luck with your dashboard!
@KimzCraftz3 жыл бұрын
Another great example - thank you Mynda
@MyOnlineTrainingHub3 жыл бұрын
Thanks, Kim!😊
@ImeLoto3 жыл бұрын
This is so great. Your tutorias enlighten me! Thank you so much and hope a lot of good things will come on your way!
@MyOnlineTrainingHub3 жыл бұрын
Thank you so much!
@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 Жыл бұрын
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
@TheAjukumar3 жыл бұрын
Every time I see your excel video, I wonder if you were really born here on earth! :)
@MyOnlineTrainingHub3 жыл бұрын
Aw, you're too kind :-)
@chesapeake93913 жыл бұрын
Use format painter, align and group function. Much easier than fiddling around with formatting.
@shoppersdream9 ай бұрын
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
@MyOnlineTrainingHub9 ай бұрын
Aw, that's wonderful to hear. So glad you found this helpful 🥰
@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 Жыл бұрын
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 Жыл бұрын
Hola Mynda. Muchas gracias por la respuesta y su prontitud. Te seguiré viendo, siempre.
@ftmagicart3 жыл бұрын
An useful tutorial. Thank you very much Mynda
@MyOnlineTrainingHub3 жыл бұрын
My pleasure 😊
@mehdihammadi61453 жыл бұрын
As always, informative and impressive. Thank you for sharing Mynda
@MyOnlineTrainingHub3 жыл бұрын
Thanks for watching, Medhi!
@adenikeolatunde53337 ай бұрын
Thanks a million Mynda 😆
@MyOnlineTrainingHub7 ай бұрын
Pleasure 😊
@dlvileno2 жыл бұрын
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?
@MyOnlineTrainingHub2 жыл бұрын
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.
@patmckeown65613 жыл бұрын
Hi Mynda, Great video as usual, lots of information and great tips to take in.
@MyOnlineTrainingHub3 жыл бұрын
Glad you enjoyed it, Pat!
@deirdreleigh44843 жыл бұрын
Fantastic Mynda, love the summary bar, must look at adding those to my dashboards.
@MyOnlineTrainingHub3 жыл бұрын
Thanks, Deirdre!
@tolulopejayeoba24483 жыл бұрын
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.
@ricos14973 жыл бұрын
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.
@shubhamajmera54943 жыл бұрын
We want dashboard for wind energy Forecasting. If possible would love to learn the same.
@MyOnlineTrainingHub3 жыл бұрын
If you have some data I can use then maybe I can build it as one of my demos.
@shubhamajmera54943 жыл бұрын
@@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.
@MyOnlineTrainingHub3 жыл бұрын
You can email it to website at MyOnlineTrainingHub.com
@PavlosAlexiou-s1v Жыл бұрын
You are just amazing! Many thanks !
@MyOnlineTrainingHub Жыл бұрын
Thanks so much!
@allie6123 жыл бұрын
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 😊
@MyOnlineTrainingHub3 жыл бұрын
Thanks, Allie! I don't have any tutorials on Microsoft Planner or dashboards using that data.
@Luciano_mp3 жыл бұрын
Brilliant, congratulations. Amazing Dashboard! Thank you Mynda!
@MyOnlineTrainingHub3 жыл бұрын
Thanks, Luciano!
@chowa36863 жыл бұрын
Thanks for your presentation ! ! !
@MyOnlineTrainingHub3 жыл бұрын
My pleasure!
@eZfRuNgkLuNg3 жыл бұрын
Always helpful videos!!! Keep it up pls! 🙂
@MyOnlineTrainingHub3 жыл бұрын
Thank you! Will do!
@Harziona3 жыл бұрын
Thanks so much for a wonderful tutorial.
@MyOnlineTrainingHub3 жыл бұрын
My pleasure 😊
@AlterMind643 жыл бұрын
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 :-)
@MyOnlineTrainingHub3 жыл бұрын
Thanks so much!
@markhill98363 жыл бұрын
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.
@MyOnlineTrainingHub3 жыл бұрын
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.
@houcineb41393 жыл бұрын
Thank you for your time
@MyOnlineTrainingHub3 жыл бұрын
My pleasure :-)
@JawadJawad-qm5dw3 жыл бұрын
Thank you very much Mynda for sharing with us🙏
@MyOnlineTrainingHub3 жыл бұрын
You are so welcome, Jawad!
@kiliev20073 жыл бұрын
Your work gives pleasure!
@MyOnlineTrainingHub3 жыл бұрын
So thankful for that, Kalin!
@dexxxxxxxx2 жыл бұрын
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 🙏🏻
@MyOnlineTrainingHub2 жыл бұрын
You can learn DAX in my Power Pivot and DAX course here: www.myonlinetraininghub.com/power-pivot-course
@wayneedmondson10653 жыл бұрын
Awesome tutorial Mynda! So many great tips and techniques. Will study it in depth for further insights. Thanks for sharing :)) Thumbs up!!
@MyOnlineTrainingHub3 жыл бұрын
Glad you enjoyed it, Wayne :-)
@chrism90373 жыл бұрын
Outstanding Mynda!
@MyOnlineTrainingHub3 жыл бұрын
Cheers, Chris 😊
@sininv12 жыл бұрын
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
@MyOnlineTrainingHub2 жыл бұрын
Glad you liked my video 😊 I don't have any calendar examples, sorry.
@MarwanAlMasri3 жыл бұрын
Thank you for all your efforts 🙏🏻
@MyOnlineTrainingHub3 жыл бұрын
My pleasure!
@wekawekacekakak12683 жыл бұрын
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..
@MyOnlineTrainingHub3 жыл бұрын
No, I haven't used GDS.
@swimfast80763 жыл бұрын
How do you use dashboards to show comparisons between different samples, including ANOVA statistics?
@MyOnlineTrainingHub3 жыл бұрын
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 Жыл бұрын
Can Excel do features from Intime software which is time series database. What is that?
@MyOnlineTrainingHub Жыл бұрын
I'm not familiar with that software, so can't say.
@khasini23543 жыл бұрын
Hi this is uma Ur video are understanding easily Can u do videos on dax functions
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked them, Priya! If you'd like to learn DAX, please consider my Power Pivot course: www.myonlinetraininghub.com/power-pivot-course
@garytan19123 жыл бұрын
May I know what is the reason to link the relationship between the tables in power query?
@MyOnlineTrainingHub3 жыл бұрын
The relationships in Power Pivot enable you to use fields from multiple tables when building the PivotTables.
@darrylmorgan3 жыл бұрын
Hi Mynda!Great Tutorial,Really Cool Dashboard And Helpful Tips...Thank You :)
@MyOnlineTrainingHub3 жыл бұрын
Thanks for watching, Darryl!
@chriscolbran40412 жыл бұрын
Always Great!
@MyOnlineTrainingHub2 жыл бұрын
Thanks, Chris 😊
@zubairmalik27573 жыл бұрын
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]))
@MyOnlineTrainingHub3 жыл бұрын
Sounds like you didn't set your data types to numbers for the Spacecraft column when you imported the data with Power Query.
@ajsabes7302 жыл бұрын
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!!!!
@MyOnlineTrainingHub2 жыл бұрын
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
@kdoffek3 жыл бұрын
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!!!
@kdoffek3 жыл бұрын
I figured it out ...it all came down to making sure date formats were set correctly !
@jimfitch3 жыл бұрын
Great tips, Mynda! Lots of gems in here that will be put to good use in both non-financial & financial dashboards. 😃 Thanks!
@MyOnlineTrainingHub3 жыл бұрын
Great to hear, Jim :-)
@mohammedaltaf48773 жыл бұрын
Excellent Job
@MyOnlineTrainingHub3 жыл бұрын
Many thanks :-)
@simonmassen3 жыл бұрын
Great as ever, is it possible to do a Map for just one country, Britain for instance?
@MyOnlineTrainingHub3 жыл бұрын
Thanks, Simon. Yes you can create maps for a single country as explained here: www.myonlinetraininghub.com/excel-map-charts
@simonmassen3 жыл бұрын
Excellent, thank you, will it work with data gathered via a VLOOKUP?
@MyOnlineTrainingHub3 жыл бұрын
Yes, the chart doesn't care what the underlying formulas are.
@prasunray19903 жыл бұрын
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
@MyOnlineTrainingHub3 жыл бұрын
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
@prasunray19903 жыл бұрын
@@MyOnlineTrainingHub Any email id for attaching the excel file, I don't get it at the forum where to attached the .XLS.
@MyOnlineTrainingHub3 жыл бұрын
there's a button on the forum to add attachments below where you type your question.
@prasunray19903 жыл бұрын
@@MyOnlineTrainingHub Ma'am I have posted in the forum, id : rayprasu
@aminmojab2 жыл бұрын
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.
@MyOnlineTrainingHub2 жыл бұрын
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.
@mohammedaltaf48773 жыл бұрын
As usual Smart work
@MyOnlineTrainingHub3 жыл бұрын
Thanks again, Mohammed!
@shoppersdream3 жыл бұрын
Do you sell your courses on UDEMY or any other website? Thanks
@MyOnlineTrainingHub3 жыл бұрын
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.
@shoppersdream3 жыл бұрын
@@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.
@MyOnlineTrainingHub3 жыл бұрын
Glad you're enjoying the video.
@garyseymour63193 жыл бұрын
There's quite a useful button called 'Format Painter' 😃
@MyOnlineTrainingHub3 жыл бұрын
Thanks for sharing, Gary!
@iankr3 жыл бұрын
Fantastic video, with lots of techniques covered. 😊👏🙏
@MyOnlineTrainingHub3 жыл бұрын
Glad you enjoyed it, Ian!
@trucmuche15453 жыл бұрын
Great video!
@MyOnlineTrainingHub3 жыл бұрын
Glad you enjoyed it :-)
@argokusumandani97733 жыл бұрын
Thank you👍
@MyOnlineTrainingHub3 жыл бұрын
You're welcome :-)
@chengcheng72632 жыл бұрын
I really like your video
@MyOnlineTrainingHub2 жыл бұрын
Great to hear!
@analyticsadda60803 жыл бұрын
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.
@MyOnlineTrainingHub3 жыл бұрын
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.
@apamwamba3 жыл бұрын
@@MyOnlineTrainingHub Excellent Explanation
@robertalavezzari69703 жыл бұрын
you are the best, always
@MyOnlineTrainingHub3 жыл бұрын
Thanks, Roberta!
@shoppersdream3 жыл бұрын
Can't complete this course. Some steps are missing.
@MyOnlineTrainingHub3 жыл бұрын
You see every step in the video. What steps do you think are missing?
@shoppersdream3 жыл бұрын
@@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
@MyOnlineTrainingHub3 жыл бұрын
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.
@alexrosen87623 жыл бұрын
Very impressive
@MyOnlineTrainingHub3 жыл бұрын
Thanks, Alex!
@ymoatassimbillah3 жыл бұрын
Very useful
@MyOnlineTrainingHub3 жыл бұрын
Great to hear 😊
@andrewbarkham83573 жыл бұрын
"To infinity, and beyond!!!" - Awesome :)
@MyOnlineTrainingHub3 жыл бұрын
😊 thanks, Andrew!
@ricos14973 жыл бұрын
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.
@MyOnlineTrainingHub3 жыл бұрын
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.
@liquidapathy823 жыл бұрын
Loved it
@MyOnlineTrainingHub3 жыл бұрын
Great to hear!
@tolulopejayeoba24483 жыл бұрын
Please what is a dimension table??🙈
@MyOnlineTrainingHub3 жыл бұрын
:-) 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-dm2wl6 ай бұрын
Hii this is amezing dashboard can you please give me a file of this dashboard
@MyOnlineTrainingHub6 ай бұрын
Thank you. The link is in the video description.
@jeremiahimissaj68492 жыл бұрын
please add me to you training participants, thanks for sharing knowledge
@MyOnlineTrainingHub2 жыл бұрын
My pleasure 😊
@orthodoxsophia3 жыл бұрын
Wow!
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it 😊
@innocentknight12 жыл бұрын
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?
@MyOnlineTrainingHub2 жыл бұрын
Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@sinhngoc84463 жыл бұрын
😍😍😍
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it 😊
@TYoung0233 жыл бұрын
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! 😄
@MyOnlineTrainingHub3 жыл бұрын
Yes, Format Painter is a nice trick. I forgot about that one :-)
@ksspqf60162 жыл бұрын
Excel dashboards are a fucking kancer I want powerbi
@MyOnlineTrainingHub2 жыл бұрын
There's no need for that language and attitude. Here's my Power BI playlist: kzbin.info/www/bejne/mKjXh3mcjtFnisU
@taahatube13 жыл бұрын
first
@MyOnlineTrainingHub3 жыл бұрын
Hope you enjoyed it ;-)
@taahatube13 жыл бұрын
@@MyOnlineTrainingHub yes my father is a fan dad
@mutazelsadig40063 жыл бұрын
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))}
@MyOnlineTrainingHub3 жыл бұрын
the function is #date with a lower case 'd'. Also, it should be year, month, day. e.g. #date(1960,1,1)