Digital dashboards data repository
1 / 35

Digital Dashboards & Data Repository - PowerPoint PPT Presentation

  • Uploaded on

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

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Digital Dashboards & Data Repository' - arich

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

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

What s a sparkline
What’s a “Sparkline?”

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

  • From Beautiful Evidence, 2006


Napoleon's March to Moscow: The War of 1812

Graphic by Charles Joseph Minard

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)