You can configure every aspect of the development process at design time within Visual Studio 2005 or 2008. You can develop and deploy a full-blown business intelligence solution that offers visual analysis against relational or multidimensional data without ever writing a single line of code.

Learn More

Data Dynamics Analysis installs with a Windows Forms component as well as an ASP.NET Ajax web component. The web component connects to all of the data sources described above to give end users a multi-tiered analysis tool for visualizing relational and multidimensional data over the web.

Screenshot

It doesn't matter what industry you are in: financial services, software, hospitality, insurance, manufacturing, retail, or government. Data Dynamics Analysis will allow you to find new trends in your data. A single connection can generate thousands of chart variations using nothing more than a mouse. Each view gives you a different perspective on your business data. You can tell a different story using the same data simply by reorganizing your field layouts. When you see data in the right perspective, new findings appear that you may have otherwise missed.

Screenshot

Data Dynamics Analysis offers the ability to connect multiple Pivot View controls to a single data source control. Imagine having a range of views based on different fields in the same data source, all arranged into a convenient dashboard. Such a view would enable a business executive to gain deep insight to actionable data with little effort. This is absolutely possible with Data Dynamics Analysis.

Screenshot

Most analysis products on the market today provide either a pivot table solution or a charting solution. Data Dynamics Analysis goes beyond these concepts and understands data at its fundamental level to deliver a single component that offers a wide array of charting capabilities. With the click of a button, you can turn a cross-tab pivot table into a trellis display of feature-rich charts.

Screenshot | Screenshot

You can connect Data Dynamics Analysis to any data source... literally. There is no limit to the types of data you can analyze with Data Dynamics Analysis. For easy setup, there are various data source controls that help bind to some of the more common data sources such as SQL Server, MySQL, Oracle, Microsoft Access, Microsoft Excel, Xml, DB2, Microsoft SQL Server Analysis Services, and many more.

• Relational Data - Model relational data into multidimensional objects such as dimensions, measures, hierarchies, and named sets. You can model fields from any OleDb data source, a SQL Server data source, or any ODBC data source. Stored procedures are absolutely supported as well. Data Dynamics Analysis doesn't care how you get the data, as long as you can feed it to the data engine in a flat manner.
• XML Data - Transform your XML data into visual charts and pivot tables. Data Dynamics Analysis has built-in support for analyzing XML data. When you map to an XML file and, optionally, an XSL file, XML data becomes meaningful and allows business executives to analyze the data in ways that are otherwise impossible.
• Disconnected Data - Disconnect your data by saving it to a compressed format. This allows business users to analyze data away from the data source in a fully disconnected mode. Imagine analyzing data on a plane or at some remote location where the data source is not accessible. This option enables users to analyze a snapshot of the data, and then sync the layouts to live data once reconnected and get updated results instantly.
• Multidimensional Data - Connect to SQL Server Analysis Services 2005 data cubes and begin exploring the data in an exciting new way. Using simple drag and drop operations, multidimensional data is transformed into presentation-quality charts. Data Dynamics Analysis offers full support for multidimensional hierarchies, KPIs, named sets, dimensions, and measures.
• Unbound Data - Connect Data Dynamics Analysis to in-memory business objects. Some examples of unbound data include analyzing data from a web service or analyzing your computer’s processor load. Use the unbound data source for any data source that isn't supported directly.

If you can get access to your data in code, then Data Dynamics Analysis allows you to explore it visually.

Screenshot

Most of the Data Dynamics Analysis functionality is accessible using the built-in toolbar. This allows developers to get up and running with a full analysis solution in no time at all. It is useful to have all of the commands available for easy access. The toolbar can be hidden using the design-time Properties grid or at run time with a single line of code.

Screenshot

One of the most powerful features of Data Dynamics Analysis is its ability to model unstructured data into a multidimensional format. Using a single XML file, you can structure a flat set of data to support a full OLAP analysis experience. Data Dynamics Analysis ships with a utility to assist in this modeling process. When a schema configuration is not provided, the utility builds a simple schema internally using intelligent defaults.

Data Dynamics Analysis can model the following objects from unstructured data:

• Hierarchies - Organize multiple categories that are closely related to each other into separate levels. When you use hierarchies on the Pivot View, users can drill down into detail data and roll up summarized results.
• Dimensions - Group like fields together into logical collections using custom dimensions. Dimensions can contain folder groups, hierarchies, and attributes.
• Attributes - Attributes are individual fields from the underlying data source. Examples of attributes are 'FullName' or 'OrderNumber.'
• Measures - You can transform any numeric data into a measure. Measures are the key to all analysis functionality; they are the data in the view. One key aspect of a measure is the ability to plot numeric scales on the X and Y axes in the Pivot View.
• Calculated Attributes - When modeling data, Data Dynamics Analysis lets you use calculated values based on your fields. For example, OrderYear = Year (Fields!OrderDate.Value) extracts the year value from a date field, or SalesQuarter = DatePart(DateInterval.Quarter, Fields!SaleDate.Value) extracts the quarter from a date field. These are simple examples, but Data Dynamics Analysis has many built-in functions to enable all kinds of calculated attributes.
• Calculated Measures - Create custom calculations from any data source. For example, AverageSale = Fields!TotalSales.Value / Fields!OrderCount.Value.

Screenshot

When you analyze data, you are looking for undiscovered patterns, for insight. In order to support this fast analytical thinking, Data Dynamics Analysis provides the ability to undo any changes made to the view. This allows you to revisit previous results at any time. Having this built right into the component saves hours and possibly weeks of development for such support. This is one of the many features that comes right out of the box and works in both the Windows Forms control and the ASP.NET Ajax control.

Filtering data is an essential element of any data analysis experience. Data Dynamics Analysis is built to ensure that every conceivable way to filter data is available by default with no configuration necessary. Simply place the control on a Windows Form or ASP.NET Web form, and you are immediately able to begin drilling into your data and filtering your results to show only the data that are most important to your analysis goals.

• Top N Filters - You can isolate the top 10 results, the bottom 15%, or even the top results that calculate to a certain value. All Top N filters can be determined by any measure or calculated field. This enables you to isolate and highlight the values that matter most.

  Screenshot

• Conditional Member Filters - Filter data using a conditional label filter definition. You can instantly exclude all values whose data meets a certain condition. For example, you might view all products that end with "ion," or all customers between "Adams" and "Jones." This type of ad hoc filtering is available using the built-in dialogs and context menus.

  Screenshot

• Value Filters - You can filter results based on a comparison of the value with a value you select. This lets you exclude all results that fall within a conditional filter definition, such as a range of values. For example, you can show only the states where sales were greater than $400,000 during 2007.

  Screenshot

• Manual Filters - Filter out other values using the manual filter dialogs. For dimension filters, you can filter out individual members using the checked member tree. For measure filters, you can use the custom range slider control. The built-in measure range slider and hierarchical member tree allows you to isolate exact members and values. All of these filtering techniques are possible using nothing more than a mouse or track pad.

  Screenshot

• Quick Filters - Quick filters offer quick access to hierarchical and numeric filtering capabilities. You can display both types of filters on a card that sits inside the Pivot View while you analyze your data. Use the quick filter cards to filter your data without ever opening a dialog.

  Screenshot

With dockable cards, you can display, reposition, or hide any aspect of the Data Dynamics Analysis user interface. This feature not only allows for a customized experience for each user, but also fully encapsulates the UI logic within the component itself. You can save card layouts to disk or memory, and reload them at any time.

Screenshot

Highlight a selection of data points and watch them summarize into various aggregate results on the Summary Card. This feature gives detailed analysis of dynamic displays, and makes it easy to determine what values make up major outliers.

Screenshot | Screenshot

Highlight a section of data and use the built-in context menu to view the underlying data. All data sources can extract aggregate data. With an OLAP cube, you have the additional option of performing a "drill through" to retrieve detailed transaction rows. Data Dynamics Analysis also enables business users to drill down into databases to gain deep insight to their business data, and to roll values up for automatic summaries.

Screenshot | Screenshot

Using Data Dynamics Analysis schema files, you can add calculated fields to your solution with little effort. You can send calculated fields directly to the data source, or configure them to calculate in the data engine after the results are queried from the data source. Both options have their advantages depending on the type of calculation.

Analyze multiple pages of data easily using the built in Page Controller. By placing fields on the Page Shelf, you can move through pages of dynamic chart displays.

Screenshot

Using the built-in context menus, you can sort your data in many different ways. You can sort and rank members in ascending or descending order. When you apply a sorting function to a field, a sort indicator displays on the field to inform the user that a custom sort operation is set.

Screenshot

In order to get the most out of data analysis, it is paramount that you can share the results with others. Data Dynamics Analysis offers many features that promote the presentation of the analysis results in various formats:

• Title Card - Describe the overall goal of your analysis using the Title card.
• Description Card - As the user filters and drills down into data, the built-in description card describes the layout in verbal form. This lets others understand exactly what the display is showing.
• Copy Image to Clipboard - Directly from the built-in toolbar, you can copy an image of your analysis to the system clipboard and paste your results into PowerPoint or a Word document. All of the necessary information is included in the image by default.

Screenshot

Share your results with others by using the built-in print preview feature. All of the presentation data are sent to the printer as well to help describe the resulting view, including the various legends, the title, and the description text.

Screenshot

Deliver permission-based security to every aspect of the analysis solution. Easily provide a role-based security system using built-in persist flags to load custom security settings per user.

Learn More

Data Dynamics Analysis offers a robust themes engine that lets you create the look and feel that you want. Control the look of each aspect of the view using a CSS style approach. The product ships with many pre-built themes like Office 2007, Windows Classic, Windows Vista, and more. Configuring your own style is as easy as modifying an XML file, and does not require a full recompile of the hosting application.

Screenshot

Data Dynamics Analysis features royalty free deployment and a robust architecture so that you can save and load various aspects of the view. Combine flags on the Read() and Write() methods to load saved layouts, permissions, card configurations, data, and styles without ever recompiling the hosting application. This is a very powerful feature and saves a lot of time when you develop and deploy an analysis solution.

• Layouts - Save layout configurations to XML and you can load them later to refresh the view with updated results. When you save layouts, an optional flag allows you to save them with data. This lets you send layouts to business users who do not have access to the data source.
• Card Settings - The ability to save and load card layouts allows each user to customize layouts to fit their needs.
• Permissions - The ability to load permissions is a key feature of Data Dynamics Analysis and is extremely easy to do. At design time, you are presented with a checked list of various permission settings. At run time, it's as easy as loading a saved XML file.
• Styles - Every aspect of the user interface is configurable. This enables you to style the Pivot View to fit seamlessly into your existing Windows Forms and ASP.NET applications.
• Data Source - Most analysis solutions can connect to multiple data sources with the same database schema. Data Dynamics Analysis enables layout files to persist the data source information with the layout file, ensuring that the layout always uses the specified data source. Alternatively, omit the data source information to allow the current layout to run against an older version of the database for historic analysis.

Screenshot