Digital dashboards data repository
Sponsored Links
This presentation is the property of its rightful owner.
1 / 35

Digital Dashboards & Data Repository PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

Digital Dashboards & Data Repository. 2010 MUSE International Session 385 June 3, 10:00-11:00. Presenter : Ian Proffer. Today’s Agenda. What is a “digital dashboard?” Presenting data from your DR What tools can I use to build a dashboard? Crystal Reports

Download Presentation

Digital Dashboards & Data Repository

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

Digital dashboards data repository

Digital Dashboards & Data Repository

2010 MUSE International

Session 385

June 3, 10:00-11:00

Presenter: Ian Proffer

Today s agenda

Today’s Agenda

  • What is a “digital dashboard?”

  • Presenting data from your DR

  • What tools can I use to build a dashboard?

    • Crystal Reports

    • SQL Server Reporting Services 2005

    • Dundas Controls for SSRS

    • SSRS 2008

    • Dundas Dashboard

  • Questions & discussion

Digital dashboards data repository

Image courtesy of

Some definitions

Some Definitions…

  • Business Intelligence

    Skills, processes, technologies, applications and practices used to support decision making

  • Data Mining

    The process of discovering patterns within data, analyzing it from different perspectives and then summarizing it in a useful way.

  • Digital Dashboard

    An information system user interface that organizes and presents information in an easy to read format.

Dr data presentation

DR Data Presentation

  • Microsoft Access

  • Web browsers

  • Crystal Reports

  • SQL Server Reporting Services

  • Microsoft Sharepoint

  • Dundas Controls/Dashboard

  • Other Applications

Microsoft access

Microsoft Access

  • A great starting point for storing and working with relational data

  • Easy to use, especially for non-IT users

  • Widely available and inexpensive

  • It’s a database, not a report presentation tool

  • Inefficient when working with SQL databases

  • No central report distribution or viewing function

Web browsers

Web Browsers

  • Installed…everywhere!

  • No training necessary

  • Completely customizable (the good)

    • Develop any type of application or report, using any tool you want

  • Completely customizable (the bad)

    • Building your own applications from the ground up requires substantial investment

Crystal reports

Crystal Reports

  • The industry standard report writing application

  • Integrated with Visual Studio

  • Powerful and flexible, yet easy to use

  • Crystal Solutions Server for enterprise-wide delivery can get expensive

Sql server reporting services

SQL Server Reporting Services

  • A single platform for authoring, presenting and delivering reports

  • Included with SQL Server starting with SQL 2000

  • Low cost – leverages existing Windows Server features (SQL, IIS, Active Directory)

  • Integrated with Visual Studio

  • Fairly steep learning curve

Microsoft sharepoint

Microsoft SharePoint

  • An web portal for collaboration, information and document sharing

  • Integrated with all things Microsoft: Office, Windows Server, Exchange

  • An alternative to using SSRS Report Manager

  • May not make sense if your organization doesn’t already rely on it

Dundas data visualization

Dundas Data Visualization

  • Components for SSRS

    • Dundas Gauge, Chart, Map

  • Also available for .NET, Sharepoint

  • Dundas Dashboard

    • Complete platform for dashboard development, display and user consumption

    • Requires additional investment, infrastructure

Other platforms applications

Other Platforms & Applications

  • IBM Cognos 8 Business Intelligence

  • Oracle Hyperion

  • SAP BusinessObjects Crystal

  • ClickView

  • Smaller Vendors

Crystal reports demo

Crystal Reports Demo

A basic report patient census

A Basic Report – Patient Census

Crystal gauges

Crystal Gauges

Gauge properties somewhat limited

Gauge Properties – Somewhat Limited

Ssrs 2005 demo

SSRS 2005: Demo

The basics ssrs 2005

The Basics: SSRS 2005

Dundas gauge with ssrs 2005

Dundas Gauge with SSRS 2005

Dundas gauge embedded in matrix

Dundas Gauge Embedded in Matrix

Linear gauge in matrix

Linear Gauge in Matrix

Dundas chart

Dundas Chart

Variety of gauges

Variety of Gauges

Dundas dashboard example

Dundas Dashboard Example

Dundas dashboard example1

Dundas Dashboard Example

Dundas dashboard example2

Dundas Dashboard Example

Ssrs 2008 r2 demo

SSRS 2008 R2: Demo

Gauges in ssrs 2008

Gauges in SSRS 2008

Linear gauges in ssrs 2008

Linear Gauges in SSRS 2008

What s a sparkline

What’s a “Sparkline?”

  • Edward Tufte coined this term to describe “intense, simple, word-sized graphics.”

  • From Beautiful Evidence, 2006


Ssrs 2008 r2 sparklines

SSRS 2008 R2: Sparklines

Digital dashboards data repository

Napoleon's March to Moscow: The War of 1812

Graphic by Charles Joseph Minard

Discussion q a

Discussion, Q & A

Thank you and see you next year

Thank You and See You Next Year!

  • Other Acmeware Sessions

    • 805 DR Reporting Made Easy with SQL Server BI Tools – Tuesday 1:00pm (Jamie McDonald)

    • 385 Digital Dashboards and Data Repository - Thursday 10:00am (Ian Proffer)

    • 382 Report Development in a MEDITECH 6.0+ Environment – Thursday 1:30pm (Glen D’Abate)

    • 384 Security Audits using DR and SQL Tools– Friday 9:30am (Jamie McDonald)

    • 383 SQL Server Upgrade Issues and Version Questions for DR – Friday 3:30pm (Ian Proffer)

  • Login