Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Server Reporting Services Part 2 (SSRS)
Rating: 4.3 out of 5(1,085 ratings)
7,643 students
Created byRaphael Asghar
Last updated 7/2019
English

What you'll learn

  • At the end of this course, the student will be able to understand how to configure, design, manage and deploy SSRS report to the Web Portal for users to view reports. He will be versed in managing and configuring the Report Builder for end users, design and create technically advanced Mobile Reports Publisher and initiate the security measures needed to secure the SSRS environment and much more

Course content

1 section • 35 lectures • 6h 36m total length

  • Introduction14:41
  • INSTALLING DATA TOOLS7:05
  • INSTALLING DATA TOOLS PART 25:29
  • REPORT SERVER CONFIGURATION PART 110:00
  • REPORT SERVER CONFIGURATION PART 210:23
  • WHAT ARE THE SSRS DATABASES8:52
  • USING THE WEB PORTAL TO VIEW REPORTS PART 113:00

    Discover how to view and deploy ssrs reports from Visual Studio and how end users access reports through the reporting services web portal.

  • USING THE WEB PORTAL TO VIEW REPORTS PART 213:07
  • FOLDER MANAGEMENT11:28
  • SSRS SECURITY PART 112:00
  • SSRS SECURITY PART 212:43
  • CREATING YOUR OWN ROLE7:05
  • SYSTEM ADMIN AND SYSTEM USER ACCOUNTS5:16
  • SUBSCRIPTION PART 110:00
  • SUBSCRIPTION PART 210:04
  • DEPLOY SUBSCRIPTION15:38
  • BACKUP REPORTSERVER9:27
  • REPORT BUILDER DOWNLOAD14:53

    Download, install, and use the SSRS report builder to create and upload reports to the report server, while comparing it to the report designer in Visual Studio.

  • REPORT BUILDER USING WIZARD9:41

    Learn to build a basic report with the report builder wizard, connect to the report server, create a data set from continents, and publish the report.

  • REPORT BUILDER FROM SCRATCH6:01
  • WHAT ARE KPIS?19:23

    Define KPIs in SSRS by linking a data source and dataset, compute status with green, red, and neutral, and embed the KPI in the web portal for quick sales visuals.

  • KPI CACHING6:27

    Learn how to cache and refresh KPIs in SSRS by creating a SQL cache plan, scheduling refreshes, and updating KPI status (green, red, amber) to reflect current sales data.

  • KPI: VIEWING A JOB2:43
  • SQL SSRS MOBILE REPORT PART 110:00
  • SQL SSRS MOBILE REPORT PART 212:42
  • REAL LIFE DEMO7:30
  • FROM DATA TO MOBILE PUBLISHER PART 110:00

    Learn the end-to-end workflow from a front-end Microsoft Access database to SQL Server for SSRS reporting by building an SSIS package.

  • FROM DATA TO MOBILE PUBLISHER PART 217:08

    Automate data import from Access to SQL Server using SSIS packages, fix 32-bit vs 64-bit runtime issues, and schedule recurring jobs for a mobile publisher workflow.

  • IMPORTING DATA FROM ACCESS DATABASE PART 115:00
  • IMPORTING DATA FROM ACCESS DATABASE PART 212:08
  • CREATING A MOBILE REPORT17:55

    Create a country population mobile report and a paginated report in SSRS by building a shared data source and dataset, then deploy to the server.

  • CREATING A PAGINATED REPORT FROM SCRATCH PART 110:00
  • CREATING A PAGINATED REPORT FROM SCRATCH PART 211:36
  • CREATE A REPORT FOR USA UNIVERSITY PART 118:00
  • CREATE A REPORT FOR USA UNIVERSITY PART 218:41

    Create a mobile sql server reporting services report featuring a gradient heat map of tuition by state, a population funnel, and a university data set pie chart; publish and automate.

Requirements

  • It is highly recommended that the student take SSRS part 1 and SSIS before taking this course as it is built upon those two courses. Additionally, it is suggested to take Learn T-SQL, SQL admin part 1, 2, 3 as those courses build the foundation to SQL Server administration. All software and appropriate SQL scripts and documents will be provided by the instructor via zip file to emails that request the files

Description

The following course SQL Server Reporting Services (SSRS) part 2 is designed for those individual that are in the IT industry, SQL DBAs, developers, or want to learn how to design, manage, and deploy rich interactive reports for their business needs.  This course is a follow up course to SQL Server Reporting Services (SSRS part 1), which is a requisite along with SQL Server Integration Services (SSIS) course.  The student at the end of this course will be able to deploy SSSR reports to the web portal for end users to view and interact with, build the easy to use report builder for the non techie individuals in the company to interact with, create and design complicated mobile reports that can be viewed not only on the PC computer but also on tablets and the phone. 


Who this course is for:

  • This course is designed for SQL dbas, developers, IT professionals, and anyone who want to learn how to configure, design manage, deploy and secure an SSRS reporting environment. It is built upon SSRS part 1 course, which is a pre requisite to this course. It is highly recommended that the student take both SSRS part 1 and SSIS course before embarking on this course.

Report abuse