BI Reporting Strategies
SQL Server 2014
| Expert
- 15 Videos | 1h 29m 56s
- 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
-
1.Designing Data Sources and Data Sets5m 2sUP NEXT
-
2.Designing a Data Acquisition Strategy6m 49s
-
3.Creating Shared and Embedded Data Sources5m 26s
-
4.Creating Stored Credentials3m 47s
-
5.Designing Data Retention4m 58s
-
6.Customizing Data Acquisition Using DAX3m 21s
-
7.Creating Datasets Using Query Parameters5m 20s
-
8.Managing Datasets Using Stored Procedures5m 12s
-
9.Using DAX Queries in Datasets6m 58s
-
10.Using MDX to Extract Data5m 6s
-
11.Managing Data Rights and Security for a Data Set5m 35s
-
12.Designing and Creating Report Templates5m 30s
-
13.Designing and Creating Linked Reports4m 50s
-
14.Designing and Creating a Drill-through Report6m 42s
-
15.Designing and Creating a Report with a Map7m 49s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.
