BI Reporting Strategies
SQL Server
| Expert
- 15 videos | 1h 22m 26s
- Includes Assessment
- Earns a Badge
SSRS helps you deliver meaningful data to the business users. Learn how to design and create an effective SSRS reporting solution, including managing the underlying data sources and datasets.
WHAT YOU WILL LEARN
-
Describe the considerations for designing data source and data sets for a report
Design a data movement strategy and profile source data
Create a shared or embedded data source
Create stored credentials to determine who can access the data in the report
Design for data retention
Customize data acquisition using dax with reporting services data sources
Create a data set using query parameters
Manage datasets using store procedures -
Create appropriate dax queries for an application
Extract data from analysis services by using mdx queries
Manage data rights and security for a data set
Design and create a report template to ensure report consistency
Design and create linked reports, including sub-reports
Design and create a drill-through report
Design map visualization and create a report with a map
IN THIS COURSE
-
5m 2sAfter completing this video, you will be able to describe the considerations for designing data sources and data sets for a report. FREE ACCESS
-
6m 49sLearn how to design a data movement strategy and profile source data. FREE ACCESS
-
3. Creating Shared and Embedded Data Sources5m 26sIn this video, find out how to create a shared or embedded data source. FREE ACCESS
-
4. Creating Stored Credentials3m 47sFind out how to create stored credentials to determine who can access the data in the report. FREE ACCESS
-
5. Designing Data Retention4m 58sIn this video, you will learn how to design for data retention. FREE ACCESS
-
6. Customizing Data Acquisition Using DAX3m 21sIn this video, find out how to customize data acquisition using DAX with reporting services data sources. FREE ACCESS
-
7. Creating Datasets Using Query Parameters5m 20sLearn how to create a data set by using query parameters. FREE ACCESS
-
8. Managing Datasets Using Stored Procedures5m 12sIn this video, learn how to manage datasets using stored procedures. FREE ACCESS
-
9. Using DAX Queries in Datasets6m 58sFind out how to create DAX queries that are appropriate for an application. FREE ACCESS
-
10. Using MDX to Extract Data5m 6sIn this video, you will extract data from analysis services by using SQL queries. FREE ACCESS
-
11. Managing Data Rights and Security for a Data Set5m 35sLearn how to manage data rights and security for a data set. FREE ACCESS
-
12. Designing and Creating Report Templates5m 30sLearn how to design and create a report template to ensure reports are consistent. FREE ACCESS
-
13. Designing and Creating Linked Reports4m 50sFind out how to design and create linked reports, including sub-reports. FREE ACCESS
-
14. Designing and Creating a Drill-through Report6m 42sLearn how to design and create a report that you can drill through. FREE ACCESS
-
15. Designing and Creating a Report with a Map7m 49sDuring this video, you will learn how to design map visualizations and create reports with maps. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
