seamacke

seamacke t1_jbubl55 wrote

You can learn with lower cards. I still use a GTX1050Ti for training on some models. Works great. The important thing is learning how to use resources efficiently. If you can use Collab or a lower card well, then you’ll know the moment you really, actually need a better card (or cards).

2

seamacke OP t1_j88xwik wrote

That’s pretty cool, I didn’t know that you could just pull from the web in Power BI. I don’t do much direct from html stuff. I did try Excel first by just pasting the table in, but it changed the formatting (and the values!!) of the lap times, and the lap dates fields. I went back to what I know (old VBA programmer haha) and just did the cleaning in Access and then put it in Power BI. Definitely gonna try that direct from web import, that sounds cool.

1

seamacke OP t1_j8540pv wrote

A (possible) ranking issue for one of the Porsche cars was uncovered during the creation of this visual. This visual is shown with the correction (sorry, Corvette!). If you're interested, you can see more information about the issue, and how I made this visual by watching this video: https://youtu.be/t4LbjlYuMAs

To make this visual, I looked at the source page and then copied the html table containing race results into Notepad++. I saved it as an html file and then imported it into Microsoft Access, added some fields for custom calculations, and then coded the new fields in VBA. The time format provided did not translate nicely so I parsed it and converted the times to decimal format so they could be more easily compared. The table was imported into Power BI. I retained the original time format and show it in the "hover over" tooltips in the visualization, along with each car's driver. You can see this demonstrated in the YouTube video linked above.

This started off as, "this will just be a simple ranking bar chart exercise".. lol!

So, I am wondering, where is BMW? I expected to see one of the M cars in the top 30.

Data Source: Wikipedia

https://en.wikipedia.org/wiki/List_of_N%C3%BCrburgring_Nordschleife_lap_times

1