Introduction
  • Introduction
  • Quick Notes About the Course
  • Installation of All Software Needed for the Course
Database Setup
  • Exploring Our Database Schema
  • Overview of Our Main Table Data
  • Generating Sales Data
  • Populating a Date Dimension Table for Later Use
  • Generating Metric Data
  • Database Setup
SSRS
  • Creating a New Project and Datasource
  • Creating a New RDL
  • Adding a Sales Table to Get Started
  • Using a Matrix to Better Organize Our Data
  • Adding Prompts for User Interaction
  • SSRS Basics
  • Using Drill Throughs
  • Making use of SubReports
  • Adding Charts to Visualize Data
  • Displaying Many Categories with Sparklines
  • Using a Linear Trendline to Understand Data
  • Matrix Enhancement
  • Creating a Mini Bar Chart
  • Using Gauges to Spice up a Report
  • Using Standard Deviation Lines to Detect Problems
  • Using Colors as Parameters to Save Time
  • Using a User's Windows Login to Drive the Report
  • Dynamically Switching Between Revenue and Count
  • SSRS Final
Conclusion
  • Conclusion
Lectures Based on Questions from Students
  • Single Day of Sales in a Monthly Rollup
Source Code
  • Database Schema Source Code
  • Main Table Data
  • usp_Generate_DIM_Date Stored Procedure Source Code
  • usp_Generate_Metrics
  • usp_Generate_Sales Stored Procedure Source Code
  • usp_Linear_Trend