Exercise 1: Subscribe to a Microsoft Windows Azure Marketplace dataset

Task 1 – Registering for a Windows Azure Marketplace Account

In this task, you will use Internet Explorer to navigate to Windows Azure Marketplace and register for a Marketplace account.

1. Open Internet Explorer and navigate to http://datamart.azure.com.

2. Click the Sign In link in the right-top corner.

   Figure 1

   Sign In of DataMarket

3. Sign in using your Windows Live Id account.
4. Click the Register link in the upper-right corner to create a new DataMarket account.

5. Enter your account details including first name, last Name, organization name and E-mail address.

   Figure 2

   DataMarket registration

6. Click Continue.
7. Select “I accept the terms of use” check box on the bottom of the Registration page.

8. Click Register link in lower right hand corner of the page.

   Figure 3

   Register Button

Task 2 – Subscribing to the DATA.Gov Dataset

In this task, you will subscribe to the DATA.Gov dataset. If you have just finished with Task 1 are still signed into Windows Azure MarketPlace you can skip steps 2 and 3.

1. Open Internet Explorer and navigate to http://datamart.azure.com.
2. Click the Sign In link in the right-top corner.
3. Sign in using your Windows Live Id account.

4. Click Explorer the MarketPlace link.

   Figure 4

   Explore the MarketPlace link

5. Click on the DATA.Gov image.

   Figure 5

   Data.gov image

6. Click Sign Up to subscribe to the dataset.
7. Verify the subscription price on this page. Select “I have read and agree to the terms of use “ checkbox on the Subscription Dataset Terms page.
8. Click Sign Up.

Task 3 – Reviewing your My Data Pages

In this task, you will review the three My Data pages and located your Account key that is used for authentication and tracking MarketPlace requests later in this lab. If you have just finished with Task 2 are still signed into Windows Azure MarketPlace you can skip steps 2 and 3.

1. Open Internet Explorer and navigate to http://datamart.azure.com.
2. Click the Sign In link in the right-top corner.
3. Sign in using your Windows Live Id account.

4. Click My Data menu item at the top of the page.

   Figure 6

   My Data menu item

5. Click on Account Informationlink located in the left-hand navigation.

   Figure 7

   Account Information Link

6. Review the data in the Account Information Page. You can edit your account information from this page.
7. Click on Account Keys link located in the left-hand navigation.
8. Review the Account Keys page. Notice that you can create and edit keys in this page. You will use the key later in the lab for tracking and data access purposes.
9. Click on DataSets link located in the left-hand navigation.
10. Review the DataSets page. This page contains information and links to datasets subscriptions.

Task 4 – Exploring GOV.Data

In this task, you will explore the Gov.Data dataset using the Windows Azure MarketPlace explorer web page. If you have just finished with Task 3 are still signed into Windows Azure MarketPlace you can skip steps 2 and 3.

1. Open Internet Explorer and navigate to http://datamart.azure.com.
2. Click the Sign In link in the right-top corner.
3. Sign in using your Windows Live Id account.
4. Click My Data menu item at the top of the page.
5. Click on DataSets link located in the left-hand navigation.

6. Click on Use link on the left hand side of the DATA.Gov dataset information.

   Figure 8

   Use Link

7. Review the DataSet information page. This page provides links and information on how to use the dataset including accessing the data using Visual Studio and PowerPivot.

8. Click on Explore this DataSet.

   Figure 9

   Explore this DataSet Link

9. Enter Washington in the State parameter textbox.

   Figure 10

   Optional Parameters box

10. Click Run Query link to execute the query.

11. Review the results. Notice the Current query URL value. DataMarket exposes data using Restful APIs.

    Figure 11

    Current Query URL

Exercise 1 Verification

In order to verify that you have correctly performed all steps of exercise 1, proceed as follows:

Verification 1

In this verification, repeat

1. Open Internet Explorer and navigate to http://datamart.azure.com.
2. Click the Sign In link in the right-top corner.
3. Sign in using your Windows Live Id account.
4. Click My Data menu item at the top of the page.
5. Click on DataSets link located in the left-hand navigation.
6. Click on Use link on the left hand side of the DATA.Gov dataset information.
7. Click on Explore this DataSet.
8. Click Run Query link to execute the query.

9. A result without errors verifies your subscription has been created correctly.