2020 US Presidential Election Results | Bringing the data life using Power BI

Hiya,

Here is the demonstration of bringing the data from an internet website (2020 US Presidential Election Results) to life using Power BI.

https://youtu.be/MFFu78lUUDQ

Here is the complete demonstration of preparing the spreadsheet from an internet website (https://www.cbsnews.com/election/2020/president/) to make it ready for Power BI import. If you know of a better way, please share by leaving your comments below. Thank you in advance.

Datasets can be downloaded by providing me with the information below:

    Kindly support my YouTube channel by smashing that thumbs up button, subscribing and turning on the notifications so that you don’t miss out on my new videos. Gaining subscribers will definitely bring my morale up and will keep me motivated in encouraging myself to keep doing these educational videos.

    Any comments or suggestions, please let me know by any means. Thank you and have a great day. Happy Learning!

    Here is another polite request:

    After watching the video, please make sure you subscribe because around 90% (if my calculation is correct) of you guys who watch this video aren’t subscribed! Clicking the like button and leaving a comment would also help massively as the YouTube algorithm will pick up on your engagement and push my videos in recommended! I trust you guys find this video useful. Help me reach 1000 Subscribers this year! Thank you for your visit and support.

    Cheers!

    Revit Math Trick

    Did you know that you can quickly do the math in Revit?

    You don’t need to have a separate calculator to be able to figure out how much the difference or additional distance you would like an element to move.

    To demonstrate, suppose I have the dimension shown in Figure 1 below with a current dimension at 2833 mm and I would like to move the vertical lines in such a way that the final dimension should only be 2780 mm.

    Figure 1: Dimension showing at 2833mm

    For some who do not know this trick, the tendency will be to get a calculator and calculate the difference. In this case, 2833 – 2780 = 53. It will be an additional step for the Revit user. If you can’t find a calculator, you’ll have to use your browser to do the math where in fact you can do it within Revit by simply selecting the lines and use ‘=’ (equal) sign followed by 2833-2780 as shown in Figure 2 below.

    Figure 2: Moving element by using equal mathematical function

    Basically, we have to select the elements first to be moved, which are the vertical lines, then hit the move command or use the default shortcut ‘MV’ from your keyboard, then enter =2833-2780.

    And the result is:

    Figure 3: Dimension showing at 2780mm

    Do you know of any other tricks? Please share below and spread the knowledge.

    I hope you’ll find it useful.

    Have a great day.

    How to create a bespoke Revit Truss Family

    Hello there. I trust you are well.

    Today, I’m going to look at the truss model that have been started modelling by one of our Senior Technician and some issues I found in this model was the way it was created and not connecting at the same node.

    To make sure that intersection connects to the same node, I decided to remodel all the trusses and replace it with the Revit Truss Family.

    Here is the video demonstration of how to create a bespoke Revit Truss Family.

    Any questions, please drop it at the comments sections.

    Thank you for watching and have a great day. Keep safe.