March 2011
Beginner to intermediate
302 pages
6h 57m
English
Using the data from the BTS site, you can create a calculated column using DAX. To begin, download the data files from the BTS site at the following URL:
Figure 4-2 shows the download page.
Figure 4-2. BTS download site
From the BTS download site, ensure you choose the Prezipped option, and download the file to your development computer. Uncompressing the file will result in a file in the name form On_Time_On_Time_Performance_YYYY_MM.csv, where YYYY is the year of the data and MM is the month number. Import this file into PowerPivot for ...