SQL Server Reporting Services Part 2 (SSRS)

Explore how to manage SQL Server Reporting Services security and permissions, deploy reports, and enable end users to view them in the web portal, with manual SSRS configuration.

Install sql management studio to provide a graphical user interface for your server, then install sql data tools and Visual Studio to enable the reporting services interface and bi environment.

Install sql server data tools and visual studio to enable ssrs reporting in part 2. Reboot after each step and create a report while beginning to manage the ssrs environment.

Configure the reporting services in native mode using the configuration manager, set the report server URL, create the report server database, and manage service accounts and credentials.

Configure the SQL Server Reporting Services environment with email settings, encryption key backup, and subscriptions, then set up domain accounts and verify correct server connections and databases.

Explore the SSRS report server databases, including the report server and report server temp databases, and learn to back up, restore, and manage metadata, security, subscriptions, and execution logs.

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

Learn to deploy SSRS reports via the web portal, building and deploying data sources, datasets, and reports, and manage administrator versus end-user access.

Create and manage nested folders and subfolders in the front end portal, deploy reports, move or delete folders, and hide items while organizing data sources and data sets.

Learn how to configure security and permissions in SSRS by granting a domain user access to the report server, database, and specific reports through SQL logins and roles.

Explore SSRS security by creating SQL logins and users, granting report server access, and applying folder and report permissions with inheritance and disinherit options, including world database access.

Create a custom role in SSRS, hide sensitive folders and data sources, and assign the new role to users to control viewing and managing reports and folders.

Explore the system admin and system user roles in SSRS, including predefined roles and access controls for the report server. Learn how to assign them carefully and understand their responsibilities.

Learn to create and manage SSRS subscriptions that deliver reports by email or shared folder on a schedule. Configure SMTP, file share, and data source credentials for automated delivery.

Configure the SSRS environment, set up data sources and credentials, deploy a report, and create subscriptions, including the standard subscription and file share delivery.

Set up and deploy SSRS subscriptions to a file share by creating a destination folder, sharing it with read-write permissions, and configuring a network path for reports.

Back up and restore the report server and its temp database, establish a maintenance plan and high availability, and automate backups with SQL Server Agent.

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.

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.

Learn to build SSRS reports from scratch using the report builder, connect to a database, design queries with the query designer, drag and drop fields, and preview and save reports.

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.

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.

Learn to manage KPI cache jobs in SQL Server Agent, using a script to retrieve cache information and adjust schedules for caches like Sales.

Learn to design and deploy SQL Server mobile reports 2016, building mobile dashboards with category chart, total charts, funnel chart, and sample grid data chart for PC and mobile.

Learn to design, preview, and deploy SSRS mobile reports to the server, using simulated and live data, with charts, gauges, and tablet and phone views.

Demonstrates a real-life end-to-end SSRS workflow from front-end data entry to SQL Server reporting, integrating SSIS packages and mobile report publisher for web portal delivery.

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

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.

Create a Microsoft Access front-end database and design an SSIS data flow to import data into SQL Server, including mapping, testing connections, and scheduling a job.

Demonstrates configuring and running a data integration package to import access data into SSRS. Shows scheduling, troubleshooting 32-bit runtime and connectivity, and producing reports for the web portal.

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.

Create a workflow to import flat files from the C drive into SQL via SSIS, build a paginated SSRS report, and archive old files using batch file and task scheduler.

Explore end-to-end data flow with ssrs by deploying a products report from updated sql data, archiving daily flat files with a batch file, and scheduling data movement using task scheduler.

Learn to build a complete ssrs paginated report from an excel source, migrate data with ssis, and design a mobile map report for usa university costs by state.

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.