BI Reporting Strategies
SQL Server 2014
| 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 reportdesign a data movement strategy and profile source datacreate a shared or embedded data sourcecreate stored credentials to determine who can access the data in the reportdesign for data retentioncustomize data acquisition using DAX with reporting services data sourcescreate a data set using query parametersmanage datasets using store procedures
-
create appropriate DAX queries for an applicationextract data from analysis services by using MDX queriesmanage data rights and security for a data setdesign and create a report template to ensure report consistencydesign and create linked reports, including sub-reportsdesign and create a drill-through reportdesign 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.