isimSoftware OLAP for Database
Extract Business Intelligence from Microsoft Access, SQL Server and Azure database
OLAP tool to analyze your Microsoft Access, SQL Server, Azure databases in multi-dimensional view in grids, charts and graphs. Helps you to gain insight and make new discoveries.
Personal License Price: 29$ – Click here to buy this software
isimSoftware OLAP for Database
Extract Business Intelligence from Microsoft Access, SQL Server and Azure database
OLAP tool to analyze your Microsoft Access, SQL Server, Azure databases in multi-dimensional view in grids, charts and graphs. Helps you to gain insight and make new discoveries.
Product Summary
Choose your own fields from the fact/transaction table and their related tables and set them as measures or dimensions for the OLAP cube.
Supports Count, Distinct Count, Max, Min, Average, Sum on measure fields.
Supports slice and dice, drill down, roll up, and pivoting on the cube.
Supports date/time fields to be summarized or broken down to year, month, day, week, hours, minutes etc.
Create your own composite hierarchy. E.g., Country > State > City
Create your own calculated member with computational relationship. E.g., Total Sales = (UnitPrice X Quantity) + Freight
OLAP Grid and Chart with highly interactive, customizable and user-friendly UI.
Save pivot details to file (*.olapreport) to make it easy for later retrieval and use.
Support offline cube for use in disconnected mode.
Complete control over the export settings of the grid/chart reports.
Export reports as BMP, GIF, JPEG, PNG, TIFF, TXT, CSV, PDF, HTML, XML, XLS
Share pivot details, reports, offline cube, cube schema files among team members to facilitate collaboration.
Print Preview tool
Works with all versions of Microsoft SQL Server as well as Express Editions.
Works with cloud Microsoft Azure SQL databases.
Works with Microsoft Access databases (97 – 2007 *.mdb), (2007- 21*.accdb)
No requirement of Microsoft Excel®, Microsoft Access® or Analysis Server.
THE PROBLEM
Data of your business does not interpret itself
Businesses and organizations are drowning in an ocean of data. However, gaining insight from all this information has been challenging for most. Companies need to translate data into information to plan for future business strategies. For example, an online supermarket would be very interested in knowing answers to the following types of questions:
How do the total sales of all products for 2009 compare with the total sales from 2008?
How does our profitability of 2009 compare with that of 2007 and 2008?
What are the spending patterns for customers of different age groups in the last 5 years? Has that behavior changed over time?
How many products were sold per country, state and city this year as opposed to last year?
For each buyer age group, what is the breakdown of profitability (both margin percentage and total) by product category
Find top and bottom salespeople, distributors, vendors, clients, partners, or customers.
Many small and medium businesses to large companies use Microsoft Access, Microsoft SQL Server or Express, or even cloud-based Azure SQL databases for storing information about business transactions, plus other data such as employee and sales records. And these databases can contain a wealth of information that can help you make informed decisions about your business. For example, you can calculate your net profits for first quarter and compare them with the same quarter of the previous year. It can also provide other types of valuable information such as which products give the most and least sales, and the optimum levels of goods to keep in stock, and to order.
But often, you might find yourself spending a lot of time and money trying to extract business intelligence information from your database. Some organizations even use specialized data professionals and a dozen different software packages, just to produce simple reports. Worst, if the report doesn’t have the required information, you will have to start over, wasting precious time. As there is a time and expense involved in getting answers from your databases, a lot of business intelligence information often goes unused, due to that fact that, your databases are designed to store your data, and not to help you analyze it.
THE SOLUTION
OLAP app for your data
The isimSoftware OLAP tool is perfectly suited to spot new trends and discover unknown problems in your data flow. It is designed to give you a simple and yet powerful tool to let you configure OLAP cube from your database, and then analyze and create reports straightaway. Simple and affordable solution, with no requirement of expensive Analysis or OLAP server.
This tool enables you to connect to a fact table (and their related tables, if available) from Microsoft Databases (i.e., SQL Server, Access or Azure SQL) and select fields of interest, and then explore them in a multi-dimensional grid, pivot tables, filters, graph or chart view. With the capability of complex calculations, trend analysis and sophisticated data modeling, and reporting, it helps you to identify critical information on your not so obvious data.