
SQL Server 2016 Reporting Services
In the 1990s a data explosion began that continues to intensify today. Data is the single most valuable asset a business owns. Accessing the data has given rise to the latest computing buzz word: Business Intelligence.rn The ability to access data securely, efficiently and intuitively across various organizational levels has become a requirement for modern business. Microsoft's SQL Server Reporting Services provides a robust solution to an organizations data delivery requirements and challenges. Data reports are made available over private and public networks and can be downloaded in various popular data formats like .pdf, .xlsx, .ppt, .xml, and more while being secured using efficient role-based security.rn Since its debut in the early 2000s, SSRS has become an extremly popular report development and delivery solution. SQL Server Reporting Services 2016 is a major release introducing many new features, most of which are paving the way to more integrated and interactive business intelligence solutions in the near future. rn In this course, Microsoft technology veteran Mark Long teaches you how to put SSRS 2016 to work. You'll see many new features including the web portal, Report Designer, Report Builder, Mobile Report Publisher, new charts, and more. You will also gain an understanding of one of the foundational aspects of Microsoft's continuously developing, and extremely popular, business intelligence platform.
Course content
Welcome/Intro10 lessons
- Welcome/Intro1:41Free
- Course Overview4:35Free
- Business Intelligence Basics7:03Free
- Reporting Services Overview6:53Free
- Data Storage Evolution pt. 15:58Free
- Data Storage Evolution pt. 25:34Free
- Transact-SQL and SSRS6:41Free
- Database Types7:10Free
- Microsoft Certifications4:44Free
- SSRS and Certification3:55Free
SQL Server 2016 Essentials4 lessons
Installing SQL Server15 lessons
- Getting SQL Server 2016 pt. 14:381 credit or ad
- Getting SQL Server 2016 pt. 24:111 credit or ad
- Installing SQL Server 2016 pt. 16:451 credit or ad
- Installing SQL Server 2016 pt. 26:061 credit or ad
- Getting SQL Server Management Studio3:531 credit or ad
- Verifying the Installation5:371 credit or ad
- Attaching the Sample dB pt. 14:031 credit or ad
- Attaching the Sample dB pt. 25:091 credit or ad
- SQL Server Data Tools5:241 credit or ad
- Installing SSDT2:381 credit or ad
- Management Tools Tour6:591 credit or ad
- Reporting Services Configuration Manager3:561 credit or ad
- Database Diagrams pt. 16:531 credit or ad
- Database Diagrams pt. 24:231 credit or ad
- Example Code Files1:361 credit or ad
Reporting Services Architecture8 lessons
- Reporting Services Concepts pt. 16:461 credit or ad
- Reporting Services Concepts pt. 26:521 credit or ad
- Reporting Services Concepts pt. 33:121 credit or ad
- Reports pt. 15:551 credit or ad
- Reports pt. 27:011 credit or ad
- Web Portal pt. 16:531 credit or ad
- Web Portal pt. 22:131 credit or ad
- Browser Support3:031 credit or ad
Basic Reporting20 lessons
- Creating a Report Project5:161 credit or ad
- Report Designer Tour6:571 credit or ad
- Working with Data Sources pt. 16:331 credit or ad
- Working with Data Sources pt. 24:331 credit or ad
- Creating a Data Source6:391 credit or ad
- Working with DataSets pt. 16:201 credit or ad
- Working with DataSets pt. 24:431 credit or ad
- Using the Report Designer6:551 credit or ad
- Report Formatting7:041 credit or ad
- Understanding Grouping pt. 17:001 credit or ad
- Understanding Grouping pt. 25:531 credit or ad
- Using a Matrix pt. 16:341 credit or ad
- Using a Matrix pt. 24:401 credit or ad
- Using Drilldowns pt. 16:571 credit or ad
- Using Drilldowns pt. 26:541 credit or ad
- Using Drilldowns pt. 37:071 credit or ad
- Using Drilldowns pt. 44:221 credit or ad
- Report Parameters pt. 16:421 credit or ad
- Report Parameters pt. 26:281 credit or ad
- Deploying Reports5:191 credit or ad
Graphical Reporting13 lessons
- Graphical Reporting Basics6:191 credit or ad
- Basic Charting Report pt. 16:301 credit or ad
- Basic Charting Report pt. 23:421 credit or ad
- Formatting the Chart pt. 16:581 credit or ad
- Formatting the Chart pt. 25:381 credit or ad
- Using a Tree Map Chart pt. 16:451 credit or ad
- Using a Tree Map Chart pt. 26:531 credit or ad
- Using a Tree Map Chart pt. 37:091 credit or ad
- Web Portal KPIs4:581 credit or ad
- Installing Report Builder5:131 credit or ad
- Creating a Web Portal KPI pt. 16:391 credit or ad
- Creating a Web Portal KPI pt. 26:321 credit or ad
- Creating a Web Portal KPI pt. 36:171 credit or ad
Map Reports6 lessons
Mobile Reporting7 lessons
- Mobile Reporting Basics pt. 15:381 credit or ad
- Mobile Reporting Basics pt. 26:361 credit or ad
- Creating a Mobile Report pt. 16:221 credit or ad
- Creating a Mobile Report pt.6:071 credit or ad
- Creating a Mobile Report pt. 36:501 credit or ad
- Creating a Mobile Report pt. 43:431 credit or ad
- Deploying a Mobile Report4:361 credit or ad