English French German Italian Portuguese Russian Spanish


  • Database Training

    databaseInterSource offers live instructor-led courses on all important database programming technologies, including Crystal Reports, Microsoft Access, MySQL, Oracle, SQL, SQL Server, SSAS, SSIS, SSRS and Xcelsius.

    These live classes are offered both on client sites, at our Geneva training center, and via a Web interface.

  • About Database

    A database is a collection of data stored and maintained for one or more uses. Most modern databases are managed by a Database Management System (DBMS), a set of computer programs that controls the creation, maintenance, and the use of the database with computer as a platform or of an organization and its end users. It allows organizations to place control of organization-wide database development in the hands of database administrators (DBAs) and other specialists.

    The proper integration of databases can dramatically increase the functionality of all types of applications, whether or not Web-enabled.

    Read More
  • Course Details Database

    Classes are offered at client sites, at our Geneva training center, and via a live web conference. For detailed course outlines and scheduled classes, please see below.

    To book training, navigate to the course you need, then:

    • For scheduled online classes, register from the choices indicated.
    • If you need an alternative dates, time or location, or if you want a live classroom course, click on “request an offer for this course,” to complete the form.

    InterSource clients are active globally. Live web courses run during Eastern Standard Time (New York) business hours and are priced in US dollars.

    We also run live web conference classes during European business hours, which can be invoiced in local currencies. To discuss your requirements please contact us on +41 (22) 958 0114.

Dashboards for Monitoring, Analyzing and Managing

 PDF PrintEmail

Course duration

  • 3 Days

Course Outline

This Dashboards for Monitoring, Analyzing and Managing Training is designed to empower the students to effectively design web-based dashboards by utilizing the three main tools for dashboard building in the Microsoft tool set. Report Builder 3.0 from SQL Reporting Services, Dashboard Designer from PerformancePoint Services and SharePoint Designer. In using each of these tools you gain the best of breed to combine features and develop dashboards that are highly effective for monitoring, analyzing and managing your business.

  • Learn to utilize the dashboard development methodology.
  • Learn to optimize visual design of dashboards.
  • Learn to structure dashboards hierarchies.
  • Learn the basics of data visualizations.
  • Learn about the thirteen crucial errors in dashboard design.
  • Learn to implement user menus in scorecards.
  • Learn how to connect into multiple data sources.
  • Gain familiarity with the definitions of common Business Intelligence terms.
  • Learn the methodology for connecting into and displaying near-real-time data.
  • Learn to create parameterized reports.
  • Learn to create sub reports.
  • Learn to create map based reports.
  • Learn to use the Decomposition Tree in PerformancePoint Services.
  • Learn to connect together SharePoint components into PerformancePoint components.
  • Learn to use report parts as a library.
  • Know when to use Report Builder, Dashboard Designer and SharePoint Designer.
  • Learn to use and understand Report Builder 3.0.
  • Learn to use and understand Dashboard Designer from PerformancePoint Services.
  • Learn to use and understand SharePoint Designer for working with dashboards.
  • Learn to utilize Excel Services to share Excel workbooks.
  • Learn to design and implement KPIs.
  • Understand the scoring methodologies used with indicators to change visual displays.
  • Be able to develop proper filters for easy end-user click to detail on dashboards.
  • Learn to group scorecards into dashboards and link them together.
  • Learn to modify the web page hosting the dashboards for branding.
  • Learn to implement master pages in dashboards for consistency with company standards.
  • Learn to develop multiple-valued KPIs. For example this year actual and target and last year actual and target at the same relative point in time.
  • Learn to implement time intelligence features to query such as Year-To-Date, Last 6 Months etc.
  • Learn to develop filters for scorecards.
  • Learn the implications of where a filter is applied.
  • Learn to create effective graphs.
  • Learn to create visual reports.
  • Learn to create effective gauges.
  • Learn to utilize sparklines in reports.
  • Learn how to secure dashboards.
  • Learn to use dynamic hierarchies in dashboards.
  • Learn to implement user menus in dashboards.
  • Learn to create monitoring dashboards.
  • Learn to create analytical dashboards.
  • Learn to create management dashboards.
  • An understanding of the state of the data repository in their environment.
  1. Course overview
    1. Introduction
    2. Course materials
    3. Facilities
    4. Prerequisites
    5. What we'll be discussing
  2. The Microsoft Business Intelligence Stack toolsLessons
    1. SQL Analysis Services
    2. SQL Reporting Services
    3. SharePoint 2010 PerformancePoint Services
    4. SharePoint Business Intelligence Center
    5. Understanding the terminology of dashboards
    6. Report Builder 3.0
    7. Dashboard Designer
    8. SharePoint Designer
    9. Lab: The Business Intelligence Stack
      1. Explore SharePoint 2010 Business Intelligence Center
  3. Dashboard design principlesLessons
    1. Dashboard taxonomies
    2. Visual perception
    3. Dashboard design flaws
    4. An effective dashboard design process
    5. Dashboard hierarchy
    6. Dashboard variance
    7. Dynamic dashboards
    8. Dashboard interactivity
    9. Develop multiple dashboards
    10. Change deployed dashboards
    11. Provide interactive help for your dashboards
    12. Monitor dashboard utilization
    13. Control dashboard updates
    14. Lab: PerformancePoint Services 2010
      1. Group lab using scenarios
  4. Report Builder 3.0Lessons
    1. Report Builder interface
    2. Data connections
    3. Graphs
    4. Gauges
    5. Parameterized reports
    6. Report parts
    7. Mapping reports
    8. Lab: Report Builder 3.0
    9. Data connections
    10. Graphs
    11. Gauges
    12. Parameterized reports
    13. Report parts
    14. Mapping reports
  5. Dashboard DesignerLessons
    1. Dashboard Designer interface
    2. Key performance indicators (KPIs)
    3. Multivalued KPIs
    4. Objective KPIs
    5. Leaf KPIs
    6. Indicators
    7. Filters
    8. Scorecards (as containers)
    9. Connections
    10. Visual reports (Called graphs in Report Builder)
    11. Dashboards (Here we mean the web page)
    12. Lab: Dashboard Designer
      1. Create data connections
      2. Create multiple types of KPIs
      3. Create visual reports
      4. Create the hosting scorecard
      5. Deploy the dashboard to SharePoint
      6. Create filters
  6. SharePoint DesignerLessons
    1. SharePoint Designer interface
    2. Business Connectivity Services
    3. SharePoint Web Parts
    4. Using SharePoint Designer for dashboard refinement
    5. Lab: SharePoint Designer
      1. SharePoint Designer interface familiarization
      2. Use Business Connectivity Services in a dashboard
      3. Use SharePoint Web Parts in a dashboard
      4. Using SharePoint Designer for dashboard refinement
  7. Dashboards that monitorLessons
    1. Guidance through monitoring dashboards
    2. Characteristics of monitoring dashboards
    3. Real-time monitoring
    4. Best practices
    5. Instructor guided project as preparation for the lab
    6. Lab: Dashboards that monitor
      1. The students will walk through the creation of three dashboards based on scenarios.
      2. Scenario1
      3. Scenario 2
      4. Scenario 3
      5. Student presentation to the group
  8. Dashboards that analyzeLessons
    1. Guidance through analytical dashboards
    2. Characteristics of analytical dashboards
    3. Best practices
    4. Instructor guided project as preparation for the lab
    5. Lab: Dashboards that analyze
      1. Scenario 1
      2. Scenario 2
      3. Scenario 3
      4. Students presentation to the group
  9. Dashboards for management strategyLessons
    1. Guidance through management dashboards
    2. Characteristics of management dashboards
    3. Best practices
    4. Instructor guided project as preparation for the lab
    5. Lab: Dashboards for management strategy
      1. Scenario 1
      2. Scenario 2
      3. Scenario 3
      4. Students presentation to the group
  10. Custom reports and graphs using MDX (Optional module)Lessons
    1. What is MDX?
    2. MDX Query Editor
    3. Select statement
    4. Key concepts
    5. Sets
    6. Functions
    7. Time intelligence
    8. Lab: MDX reporting (Optional module)
      1. Examine what MDX can add to the reporting environment

InterSource Geneva, a premier Information Technology training firm, offers over 400 different courses on server, database and programming technologies, as well as end-user classes for the most popular office, graphics and design applications. We serve clients in Switzerland (Geneva, Lausanne, Bern, Basel, Zurich) and throughout Europe (France, Germany, Austria, Finland, Sweden, England, Netherlands, Spain, etc.).

InterSource offers custom, private courses at client sites, standard public courses in our Geneva classroom, and online training via live Web conference. Training is offered in English and many other languages (Francais, Deutsch, Espanol, Italiano.)

For an overall view of our offerings, please visit us at www.intersource.ch.