Open SQL Server Management Studio. Note the deployment script in Lab Module 1 You should be prompted to connect to a creates the SQL Server name using the define server. If not, click the File menu -> prefix + SQL + a 4-character hash. To view Connect Object Explorer. your server name, visit your Resource Group Fill in the server name and sqlusername and created by the deployment script on . password created in Lab Module 1. Click the File Menu -> Open -> File. Browse to the Lab Module 9 folder from the downloaded Lab material and open the Module9query.sql file. You should see all the queries we will be running as part of this lab module. Highlight each query one at a time and run the query. Each step here will assume one query was run and discuss the purpose in the notes. To run use the Execute Icon or F5. This query returns a count of all the flights in Highlight and run Query 1 – Fact Count our FlightFact table. If you did not modify the package in Lab Module 2 this should contain flight data for December 2016. The contains date for all of 2016 but the SSIS package only copied data for December 2016 to the ODS. This query returns the top 100 airports by Highlight and run Query 2 – Busiest Origin originating airport on the flight. Airports This query returns the top 20 most used Highlight and run Query 3 – Most Used models by manufacturer. The Planes dimension was our original set of FAA files from the Amazon S3 account that was later merged together via Hive. This query returns the Average delay for each Highlight and run Query 4 – Average Delay day in December at MSP along with the by Day in MSP and Weather weather data source from our REST source.
Open SQL Server Management Studio. Note the deployment script in Lab Module 1 creates the SQL Server name using the define prefix + SQL + a 4-character hash. To view your server name, visit your Resource Group created by the deployment script on . You should be prompted to connect to a server. If not, click the File menu -> Connect Object Explorer. Fill in the server name and sqlusername and password created in Lab Module 1. Click the File Menu -> Open -> File. Browse to the Lab Module 9 folder from the downloaded Lab material and open the Module9query.sql file. You should see all the queries we will be running as part of this lab module. Highlight each query one at a time and run the query. Each step here will assume one query was run and discuss the purpose in the notes. To run use the Execute Icon or F5. This query returns a count of all the flights in our FlightFact table. If you did not modify the package in Lab Module 2 this should contain flight data for December 2016. The contains date for all of 2016 but the SSIS package only copied data for December 2016 to the ODS. Highlight and run Query 1 – Fact Count This query returns the top 100 airports by originating airport on the flight. Highlight and run Query 2 – Busiest Origin Airports This query returns the top 20 most used models by manufacturer. The dimension was our original set of FAA files from the Amazon S3 account that was later merged together via Hive. Highlight and run Query 3 – Most Used Planes This query returns the Average delay for each day in December at MSP along with the weather data source from our REST source. Highlight and run Query 4 – Average Delay by Day in MSP and Weather