Digital Dashboards - PowerPoint PPT Presentation

Loading...

PPT – Digital Dashboards PowerPoint presentation | free to download - id: 427234-YmI4M



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Digital Dashboards

Description:

Digital Dashboard An information system user interface that organizes and presents information in an easy to read format. – PowerPoint PPT presentation

Number of Views:152
Avg rating:3.0/5.0
Slides: 36
Provided by: Ian9155
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Digital Dashboards


1
Digital Dashboards Data Repository
2010 MUSE International Session 385 June 3,
1000-1100
Presenter Ian Proffer
2
Todays 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

3
Image courtesy of www.wordle.net
4
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.

5
DR Data Presentation
  • Microsoft Access
  • Web browsers
  • Crystal Reports
  • SQL Server Reporting Services
  • Microsoft Sharepoint
  • Dundas Controls/Dashboard
  • Other Applications

6
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
  • Its a database, not a report presentation tool
  • Inefficient when working with SQL databases
  • No central report distribution or viewing function

7
Web Browsers
  • Installedeverywhere!
  • 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

8
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

9
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

10
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 doesnt
    already rely on it

11
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

12
Other Platforms Applications
  • IBM Cognos 8 Business Intelligence
  • Oracle Hyperion
  • SAP BusinessObjects Crystal
  • ClickView
  • Smaller Vendors

13
Crystal Reports Demo
14
A Basic Report Patient Census
15
Crystal Gauges
16
Gauge Properties Somewhat Limited
17
SSRS 2005 Demo
18
The Basics SSRS 2005
19
Dundas Gauge with SSRS 2005
20
Dundas Gauge Embedded in Matrix
21
Linear Gauge in Matrix
22
Dundas Chart
23
Variety of Gauges
24
Dundas Dashboard Example
25
Dundas Dashboard Example
26
Dundas Dashboard Example
27
SSRS 2008 R2 Demo
28
Gauges in SSRS 2008
29
Linear Gauges in SSRS 2008
30
Whats a Sparkline?
  • Edward Tufte coined this term to describe
    intense, simple, word-sized graphics.
  • From Beautiful Evidence, 2006
  • www.edwardtufte.com

31
(No Transcript)
32
SSRS 2008 R2 Sparklines
33
Napoleon's March to Moscow The War of 1812
Graphic by Charles Joseph Minard
34
Discussion, Q A
35
Thank You and See You Next Year!
  • Other Acmeware Sessions
  • 805 DR Reporting Made Easy with SQL Server BI
    Tools Tuesday 100pm (Jamie McDonald)
  • 385 Digital Dashboards and Data Repository -
    Thursday 1000am (Ian Proffer)
  • 382 Report Development in a MEDITECH 6.0
    Environment Thursday 130pm (Glen DAbate)
  • 384 Security Audits using DR and SQL Tools
    Friday 930am (Jamie McDonald)
  • 383 SQL Server Upgrade Issues and Version
    Questions for DR Friday 330pm (Ian Proffer)
About PowerShow.com