In this course, you'll learn to provide attractive, insightful dashboards for your organization that can go anywhere with SSRS Mobile Reports. This course covers all charts, gauges, and maps in depth to make designing your dashboards a breeze.
Since its original release in 2004, SQL Server Reporting Services has been synonymous with on premises, paginated reports. Skilled report developers have taken advantage of features such as parameters, click-through reports, and expressions to build interactive solutions. In this course, Build and Deploy SSRS Mobile Reports, you'll learn how to create dashboards that work on mobile devices and can go anywhere. First, you'll explore how to set up the learning lab. Next, you'll discover how to convey business metrics and trends with KPIs. Then, you'll cover providing dashboards that go anywhere with mobile reports. Finally, you'll learn about securing mobile reports. By the end of this course, you'll have the knowledge to quickly build your mobile solutions to provide key metrics and insights for your company.
Kathi Kellenberger is a SQL Server MVP and a Teammate with Linchpin People. She is the author or co-author of several SQL Server books, including Beginning T-SQL from Apress, and frequently speaks at community events such as PASS Summit and SQL Saturday.
Course Overview Welcome to Pluralsight. My name is Kathi Kellenberger. I'm a SQL Server database professional with almost 20 years of experience. I'm really excited to tell you about the biggest news in Reporting Services functionality since it was introduced over a dozen years ago. You can now create dashboards that will go anywhere and that are supported on Apple, Android, and Windows devices, as well as all modern browsers. This course, Build and Deploy SSRS Mobile Reports, will teach you what you need to know to quickly build attractive and insightful dashboards with SSRS 2016 mobile reports. Some of the topics we will cover include setting up the learning lab, conveying business metrics and trends with KPIs, providing dashboards that go anywhere with mobile reports, and securing mobile reports. By the end of this course, you will understand the differences between the many controls you can use on mobile reports and how to configure them for on-premises reports, tablets, and smartphones. Instead of spending hours trying to figure out these features, you'll be ready to build informative and attractive dashboards that will go wherever your company's business users and executives go. I hope you'll join me on this journey to learn how to build dashboards with SSRS mobile reports.
Providing Dashboards That Go Anywhere with Mobile Reports Now that you have seen how to build the foundation for your reports, it's time to learn how to add the content. In this module, you will learn how to configure the data controls. There are gauges, charts, maps, and grids. The properties can be divided into two categories--visual and data. The first decision to make is which type of control to use. Gauge controls are used to compare two numbers. This might be the sales compared to a quote for example. The chart controls allow you to compare a series. You may have several categories or several time periods. If you have data that can be represented geographically, such as by country or by state, you may want to select a map control. You can also display detail data with a grid.
Securing Mobile Reports You now understand how to build mobile report dashboards. A critical aspect of SSRS that must be right from day one is security. This is important for traditional paginated reports that are possibly available only on-premises. But it's even more critical for mobile reports that will be viewed on mobile devices outside the company. This module will cover what you need to know to secure your mobile reports. There are several things to configure that you will probably expect. But there're also some surprises. I'll tell you about these gotchas first. Just like traditional SSRS reports, you must secure the mobile reports within the web portal. You may need to configure data sources in a specific way depending on your architecture. Since these reports are going to be viewed off-premises, SSL should be used. Actually, it's a good idea to use SSL inside the enterprise as well. You will need to open the firewall for the port that is used, and I'll show you how to use a non-traditional port. Finally, while this course was being created, Microsoft released service pack 1 for SQL Server 2016. So I'll cover the changes affecting SSRS in mobile reports.