Viewing a single comment thread. View all comments

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

Monkey_King24 t1_j87wy9c wrote

You know right, that you can directly import tables and data from the web directly into power bi. There is an option called web while importing data into power bi

Clean it with power query and do any calculation needed using DAX and still make the same visual.

OR a simpler process would be directly importing the table in Excel or Google sheets, clean it and download it as CSV. To be used in Power BI

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

Monkey_King24 t1_j89930o wrote

Yes a lot of people don't know this. Power BI can pull data from a lot of sources.

Here is an article that might help you for Power BI "https://www.c-sharpcorner.com/article/use-wikipedia-as-a-data-source-to-prepare-power-bi-report/"

For Excel you can use this method instead

"https://www.google.com/amp/s/www.aevotec.com/amp/training-in-a-minute-how-to-import-a-wikipedia-table-into-excel"

Also while pasting you can select the option of only the values not the format

2