50555-Visualizing Data with SQL 2008 R2 and Report Builder 3.0
About This Course
Audience Profile
At Course Completion
- Decide whether to use Business Intelligence Development Studio or Report Builder 3.0 to develop reports.
- Understand and be able to articulate the difference between classifications of graphs and which type of graph is best utilized and targeted to the type of data to be represented. Fully develop reports with graphics and understand the methodology of working with the end users in the development of these reports.
- Add gauges to reports and understand the variances between linear and radial gauges and the limitations of those gauges.
- Deploy reports that contain graphics.
Course OutlineModule 1: Overview of VisualizationsLessons
- Goals of reporting
- Types of reports
- Audiences
- Attack of the images
Lab : Overview of Visualizations
- Using Business Intelligence Design Studio
- Using Report Builder 3.0
Module 2: ChartsLessons
- Matching the chart to the data
- Choosing a type of chart to display the data New SQL 2008 Charts
- Chart Properties
- Sparklines Databars and Indicators Advanced Techniques
- Formatting
Lab : Charts
- Create each of the major types
- Sparklines, Databars, Indicators
- Formatting
Module 3: GaugesLessons
- Matching gauges to the data
- Variations of gauges
- Selecting a gauge type
- Linear gauges
- Radial Gauges
Lab : Gauges
- Linear Gauges
- Radial Gauges
- Multiple Gauges
Module 4: MapsLessons
- Spatial Data
- Basic maps
- Analyzing with color
- Geography display
- Color points
Lab : Maps
- Mapping
- Bing Maps
- Properties