Power BI Introduction – Weather Report Resources

Thank you everyone who attended my virtual session at the London Reactor on Wednesday. Here are links to resources I used for the presentation.

Weather Data

The met office very usefully provides data in a text format for stations across the UK. The first link is to the summary page that gives a map link to all the stations. The second link is to Whitby’s station data.

https://www.metoffice.gov.uk/research/climate/maps-and-data/historic-station-data

https://www.metoffice.gov.uk/pub/data/weather/uk/climate/stationdata/whitbydata.txt

I have typed up the list of station with Latitude and Longitude values into an Excel file which can be accessed here

Background

Chris Hamill has written a great post on designing backgrounds for reports that make a report load quicker and make it easier to read.

https://alluringbi.com/2019/10/21/background-concepts-for-power-bi/

Calendar

SQL BI team have a huge range of videos and blog posts on many DAX topics. The example we used in this session was creating a simple calendar using code from this page..

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

Turn Off Time Intelligence.

Another great source of educational material on Power BI is is Guy in a Cube. One recent video explains the reason to turn off the Time Intelligence.

Drill Through Button

During the presentation a question was asked regarding drill through. I mentioned the possibility of using a drill through button but I did not have enough time to demonstrate. Here is a video to explain the feature.

Resources

The final Power BI report files with the other resources can be found here.

YouTube

As soon as the Reactor posts the video the link will be added here.