Sales Analysis in Miner3D

The following Miner3D solution demos are focused on analysis of sales data. The goal is to provide a comprehensive information on sales performance at various levels of the organization's sales channels. In general, Miner3D can provide answers to the following type of questions:

• What products are profitable?
• Who are our customers, and what and how are they buying?
• What is the performance of each distribution channel?
• What accounts are most profitable?
• Is there any seasonal variance to the business?
• What are the trends in our sales?

Miner3D generates ad-hoc in-memory and online queries and visualizes complex 2-, 3- or even higher-dimensional information structured by products (category, sub-category, items), territories (country, region, town), or by time (total, fiscal years, quarters, months). This information is handled as-needed, directly from the user's PC and delivered in seconds in a all-visual form.

Used technologies:

• Analytics: Miner3D Enterprise 7.2 (or Miner3D Infinity)
• Data: AdventureWorks 2008
• Server: Microsoft SQL Server 2008

As data source has been used "AdventureWorks", the demo data warehouse of a virtual company. This database is freely available for download as a standard demo content for Microsoft SQL Server.

At the bottom of this page you can download the original M3D files for each of the models. Versions for an OLAP database or one for a local data are available. In this demo we use a database hosted on server "corsair32", please make necessary adjustments when connecting to your own servers (set the real server name at your site and check user privileges).

Top Line Analysis This visualization provides a complex information on the performance of main sales channels and main product categories. After a successful connect, we have got an OLAP catalog with a set of Cubes, Dimensions and Measures. Now drag "Product" and "Sales Channel" dimensions and drop them on the chart, on its X and Y axis respectively. Drag "Sales Amount" from Measures section and drop it on the target representing the Height (Size) of data objects. Finally, drag "Gross Profit" and drop on the Color target.
Global Sales Analysis This visualization provides a high-level information on performance of basic product categories in market countries. From the previous "Top Line Analysis", remove "Sales Channel" dimension and insert "Customer" dimension into the OLAP query. Add more measures into the OLAP query, se we can have available more of useful data.
Drill-down into Product Categories Use right-click on product accessories and choose category "Tires and Tubes" to see the sub-category and compare its sales performance on different countries. This visualization provides a medium-level information on performance of a specific product category. Various "Internet Sales ..." data is used as measures.
Sub-Category/Regions Analysis This visualization provides a medium-level information on performance of a specific product category ("Accesories") in various regions in the selected country. In one of the previous models, drill-down to medium-level sales performance data. Do a right-click on an object and select Product->Accessories, then drill-down to States/Regions.
Micro-sales Analysis This visualization provides a detailed information on product items of a selected category and its sales performance in towns of a selected region. In the previous "Sub-Category/Regions View", drill-down to "Customer->California" and "Product->Road Bikes" to get a low-level detailed sales performance information.
Global Sales Analysis (Fiscal Years) This visualization provides a high-level information on performance of selected product categories on world markets between 2002 and 2007. Time dimension is visualized as a series of Fiscal Years mapped onto the chart's axis. Object's Size and Color represent the Sales Profit. Exact sales information is attached to every data object.
Global Sales Analysis (Fiscal Quarters) Drill-down to Product->Bikes and Date->Fiscal Quarters to see a medium level information on performance of selected product sub-categories on world markets. Time dimension is visualized as a series of Fiscal Quartes between 2002 and 2007. Its is mapped on one of chart's axes. Object's Size and Color represent Sales Profit.
Categories/Regions Analysis (Fiscal Quarters) This visualization provides a medium-level information on performance of selected product sub-categories on regional (state) markets. Time dimension is visualized as one of chart's axis. Object's Size and Color represent Sales Profit.
Micros-sales Analysis (Fiscal Months) This visualization provides a low-level information on performance of selected product items in towns of a selected region. Time dimension is visualized as one of chart's axis. Object's Size and Color represents Sales Profit.
Country/Years Analytical Trellis This visualization shows how different markets performed in last couple of years. On the base axis is mapped time (Fiscal Years), while the charts show sales performance in countries where AdventureWorks ship. Object's Size and Color represent Sales Amount.
Markets Time Analysis (Bars) This visualization gives a top-level information on markets sales performance in various years. Bars represent Sales Amount in specific markets in various years.
Markets Time Analysis (Animated Movie) This visualization gives a top-level information on markets sales performance in various years. Bars represent Sales Amount in specific markets in various years. Now go to Filter and drag the Date->ItemFilter from left to right to animate the time. You will then see how the sales performance is changing in years. Or use right-click the Date->ItemFilter and choose Play option to let the movie play indefinitely.

Download (OLAP): sales_analysis_demo_olap.zip
Download (local data): sales_analysis_demo_local.zip