Home   Contact        Sitemap
 
 
 

Dashboard Construction & Integration

Dashboard construction and integration involves several development and integration efforts that include: aggregating all source data into an dashboard optimized format; creating integration services to feed data to the dashboards at run-time; and finally, testing the complete solution end-to-end.




  Integrate Source Data
Most dashboard projects usually require rolling up detailed transactional business information into higher level summary information that needs to be analyzed across multiple dimensions (time, product, territory, etc..)

In this step, we either create an optimized dashboard data mart with a corresponding extraction/transformation/load (ETL) package that loads source business data into an optimized format, or we create specialized integration services that collect data directly from source systems.



  Integrate Dashboard Prototypes and Finalize Formats
Once we have automated the data feed process we then need to dynamically link this data into our dashboard designs.  This process often involves restructuring of the underling visualization mechanisms with multiple live data feeds per dashboard.  By leveraging web service technologies we are able to create flexible parameter driven data connections that allow the user to drill and slice across a variety of information for a given dashboard.



  Solution Testing
After all data feeds have been created and the dashboards integrated into those feeds, we begin system testing.  This testing involves multiple iterations of  loading real life business data in combination with dashboard functional testing.  By testing the whole solution end-to-end with real business data we can validate the accuracy of all information being presented as well as the security, performance and scalability of the solution. .


Design & Prototyping  -   Construction & Integration  -   Deployment & Maintenance

  New ! Dashboard Webinar



Free Dashboard Design Session


Register for your complimentary design session where you can work directly with a BrightPoint Dashboard Architect to focus on one of the following areas:
 
Creating KPIs and metrics
Prototyping your dashboard
Architecting your solution
 
click here to learn more

Space is limited and reservations will be accepted on a first-come first-serve basis.

 
 
  Choosing Correct Metrics & KPIs 



  Designing Dashboards: Part 1 



  Designing Dashboards: Part 2 


  ManagePoint Web Services

This .Net web service allows you create Crystal Xcelsius dashboards that pull data from Microsoft SQL Reporting Services reports in real time.
 
 

Tutorial - Creating Dashboards with SQL Reporting Services

A white paper that demonstrates how to integrate SQL Reporting Services reports into your Crystal Xcelsius dashboards leveraging the ManagePoint Web Service.

 

 
 
 
   Copyright © 2004-2008, BrightPoint Consulting Inc.   Home   Contact        Sitemap