Data Dynamics Analysis makes XY charts extremely easy to create which enables users to find correlations between two or more values.

This walkthrough illustrates how to perform the correlation analysis against relational data from a Microsoft Access database.

The walkthrough is split into the following activities:

• Connect to a relational data source using the Data Dynamics Analysis Viewer sample application
• Apply additional encodings to your data points
• Analyze your data by the lowest priced Product Category
• View a separate detailed XY chart for each Customer Country
• Select a range of cells and analyze the results even further

To use this walkthrough, you will need access to the Data Dynamics Analysis Viewer sample application that is included with the installation.

Connect to a relational data source using the Data Dynamics Analysis Viewer sample application

1. Open Data Dynamics Analysis Viewer Sample application from your Start menu:

   

2. Using the Data menu navigate to Establish Connection...

   

3. Connect to the NWindMDB-SalesProductsSuppliers schema.

   

4. Set the Marking Type to Circle:

   

5. Drop Order count measure to the Row shelf.

   

6. Drop Average Unit Price measure to the Column shelf.

   

7. Expand the Customer dimension and drop the Customer Geography hierarchy to the Level of Detail shelf.

   

8. Your view should look similar to the following:

   

   This view shows us that the most expensive products are selling the least in Norway.

Apply additional encodings to your data points

1. Change the Marking Type to Shape:

   

2. Expand the Date dimension and drop Year to the Shape encoding shelf:

   

3. Drop Total Product Cost to the Size encoding shelf:

   

4. Your view should now look like this:

   

   This view shows us that the most orders were placed in USA during 2005, but the products they were buying were the most expensive products for the company to sell.

Analyze your data by the lowest priced Product Category

1. Click the Swap axis toolbar button.

   

2. Drop the Product dimension to the Rows shelf to the left of Average Unit Price.

   

3. Using the Category level drop down navigate to the Sort > More sort options... menu item:

   

4. Using the sort dialog, sort all Categories ascending on Average Unit Price:

   

   1. Sort order = Ascending
   2. Sort by = Field
   3. Sort field = Average Unit Price
   4. Press OK
5. Your display should look like this now:

   

   This view shows us that Seafood generated a lot of orders in 1995.

View a separate detailed XY chart for each Customer Country

1. Click on the Undo toolbar button or press [CTRL]+[Z] to undo the sort operation.

   

2. Move Category from the Row shelf to the Color shelf.

   

3. Move the Country field from the Level of Detail shelf to the Page shelf.

   

4. Expand the Products dimension and drop the Product attribute onto the Level of Detail shelf.

   

5. Grab the page slider in the Current page shelf and move it to the right:

   

6. Sliding the page controller allows you to see the results for each country, one page at a time.
   Your view should look like this:

   

This view shows us that Cote de Blaye has the highest Average Unit Price in 1996 for USA and also costs the company a lot of money in order to sell it.

Select a range of cells and analyze the results even further

1. Click on the Cards toolbar button and ensure that the Summary card is checked:

   

2. Finally, select a range of data points and analyze the values in the Summary card.

   

   

3. Right click on your selection and choose the View aggregated data menu option:

   

4. The resulting dialog allows you to select any of the values and copy the results to the clipboard and paste into Excel for further analysis.

   

See Also