Learn SSRS SQL Reporting & Business Intelligence Essentials

BY
Udemy

Mode

Online

Fees

₹ 449 2499

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

  • 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

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books