Data Dynamics Analysis enables users to discover new trends in their data.
The walkthrough is split into the following activities:
- Connect to a relational data source using the Data Dynamics Analysis Viewer sample application
- Build a simple line chart
- Find the trend for each Product Category and Employee Geography
- Isolate the most drastic trend in Orders
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
- Open Data Dynamics Analysis Viewer Sample application from your Start menu:
- Using the Data menu navigate to Establish Connection...
- Connect to the NWindMDB-SalesProductsSuppliers schema.
Build a simple Line Chart
- Set the Marking Type to Line.
- Drop the Date dimension on the Columns shelf.
- Drop the Order count measure on the Rows shelf.
- Expand the Year level to show all Quarters.
- Your view should look like this:
This view shows us that orders declined for 2 straight quarters in 1995 and then had a large spike in sales during the last quarter.
Find the trend for each Product Category and Employee Geography
- Drop the Product dimension on the Row shelf:
- Drop the Employees dimension on the Color encoding shelf.
- Your view should now look like this:
This view shows us that USA employees are selling more products than UK employees. We also see that Confections had a drastic drop in orders for USA employees in 1995.
Isolate the most drastic trend in Orders
- Right click on Confections and choose Keep Only.
- Expand Quarter to show Months.
- Using the Quarter level drop down choose the Hide Level menu option:
- Drop the Order count measure onto the Label encoding shelf.
- Your final view should look like this:
This view shows us that Confections had the most orders for USA in March, 1995 and then drastically dropped the next month while UK employees continued their upward trend.