Documents

33 views

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. What is a “digital dashboard?” Presenting data from your DR What tools can I use to build a dashboard? Crystal Reports
of 34

Please download to get full document.

View again

All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Transcript
Digital Dashboards & Data Repository2010 MUSE International Session 385June 3, 10:00-11:00Presenter: Ian ProfferToday’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
  • Image courtesy of www.wordle.netSome 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
  • Microsoft Access
  • Web browsers
  • Crystal Reports
  • SQL Server Reporting Services
  • Microsoft Sharepoint
  • Dundas Controls/Dashboard
  • Other Applications
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • IBM Cognos 8 Business Intelligence
  • Oracle Hyperion
  • SAP BusinessObjects Crystal
  • ClickView
  • Smaller Vendors
  • Crystal Reports DemoA Basic Report – Patient CensusCrystal GaugesGauge Properties – Somewhat LimitedSSRS 2005: DemoThe Basics: SSRS 2005Dundas Gauge with SSRS 2005Dundas Gauge Embedded in MatrixLinear Gauge in MatrixDundas ChartVariety of GaugesDundas Dashboard ExampleDundas Dashboard ExampleDundas Dashboard ExampleSSRS 2008 R2: DemoGauges in SSRS 2008Linear Gauges in SSRS 2008What’s a “Sparkline?”
  • Edward Tufte coined this term to describe “intense, simple, word-sized graphics.”
  • From Beautiful Evidence, 2006
  • www.edwardtufte.com
  • SSRS 2008 R2: SparklinesNapoleon's March to Moscow: The War of 1812Graphic by Charles Joseph MinardDiscussion, Q & AThank 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)
  • We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks