SQL Server Analysis Services (SSAS) dashboard

Microsoft is heavily investing in Business Intelligence. The take-over of Proclarity in 2006 underlines this. They are gunning for market dominance and with success. The SQL Server suite offers a lot to small and medium business as well as enterprises. You can easily create your Business Intelligence solution with just the SQL Server product. Webdashboard aims at the companies that work with SQL Server or want to work with it. Webdashboard is the ideal presentation layer on top of Analysis Services or Excel local cubes.

MDX engine provides fast reporting

Webdashboard uses MultiDimensional Expressions (MDX) to connect to OLAP databases or Excel local cubes. MDX is a very powerful query language to get your management information in a fast and understandable way. More information on MDX: Wikipedia. OLAP together with MDX is one of the reasons that Webdashboard is so fast. The other one is the ASP.NET and AJAX technology in the Webdashboard software. A perfect mix of Microsoft technology and web technology.

One central storage of management information

Because your data is stored within SQL Server Analysis Services’ OLAP databases, you create one version of the truth. No more Excel sheets floating around your company, just one central management information portal to log in to: Webdashboard. In Analysis Services you can add calculations and keep your business logic stored in there. Analysis services also has data mining functionalities: get even more out of your historical data! By also adding your budget and forecasting to the cubes you get 1 set of data to steer your company on.

Excel Local cubes dashboard

Within Excel you also have the possibility to create local cubes for analysis purposes. This creates one file that you can open in Excel or Query with the Webdashboard. For people that don’t need to be able to query a lot of data this could be a good storage option. You only need Excel + Webdashboard which would save you the purchase of Microsoft SQL Server. It’s also possible to create a local cube from an OLAP cube. More information on local cubes: Visit cubeslice.

The Webdashboard is a Dashboarding tool that is meant for presenting management information to the end user. Data that is displayed in the Webdashboard orignate from an OLAP cube. The Webdashboard can display several cubes in one dashboard. Below you find a schematic outline of the Webdashboard and how it interacts with other parts of a Business Intelligence solution. By using the Webdashboard Designer you select your server and cube and then simply build up a dashboard. The following picture outlines the architecture of the Webdashboard software:
OLAP Reporting, Webdashboard connects to your OLAP environment

OLAP Reporting, Webdashboard connects to your OLAP environment

From left to right:

Sources: could be HRM/CRM/Finance data.
Data warehouse & OLAP: through ETL the data is transferred periodically so that the operational systems don’t get disrupted. The data warehouse stores all the relevant management information. OLAP provides speed and analytical possibilities to get the information out there. The naming + intelligence of your system is centrally stored here. With OLAP you also have extensive data mining possibilities. Microsoft SQL Server 2005 and higher ships with SQL Server, Analysis Services, Integration Services (ETL) and Reporting Services, making it the most affordable solution without any surprises. Webdashboard is also featured in Microsoft Solution finder.
Webdashboard server: This fully AJAX .NET application creates one portal for your employees to log in to. It’s fully Web which means that there is no client software needed: Zero-footprint. The performance of Webdashboard is great, every report is there within 1 second.
User & Administrator login: One login portal for all your employees. People simply log in and select the desired dashboard. It also includes news items and RSS feeds to keep the users up to date about the latest numbers. Through easy Webdashboard management Administrators can distribute the correct rights/dashboards to the users. Webdashboard architecture is perfect for companies with a lot of subsidiaries. You can grant specific branches access to their numbers and regional managers access to their regions.

Live Demo:

Go to the LIVE DEMO of Webdashboard 4.0 (ASP.NET)

Buy now

For only 95 Euro per user you can start working with the Webdashboard. Besides the fact that this also includes updates our partners will keep you up to date with the latest developments. Order your licenses now!

>> Register

Try now

Do you first want to try the Webdashboard? No problem, simply download the Webdashboard, you get one license for free to try it out.

>> Request download

Product overview

KPI's

TRENDS