Brochure
Enquire
- Introduction
- Quick Notes About the Course
- Installation of All Software Needed for the Course
Learn SSRS SQL Reporting & Business Intelligence Essentials
Quick Facts
| particular | details | |||
|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 449 ₹2,499
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Introduction
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
Articles
Popular Articles
prev
next
