BI Reporting Strategies

SQL Server 2014
  • 15 Videos | 1h 23m 10s
  • Includes Assessment
  • Earns a Badge
Likes 26
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

  • Playable
    1. 
    Designing Data Sources and Data Sets
    5m 5s
    UP NEXT
  • Playable
    2. 
    Designing a Data Acquisition Strategy
    6m 52s
  • Locked
    3. 
    Creating Shared and Embedded Data Sources
    5m 29s
  • Locked
    4. 
    Creating Stored Credentials
    3m 50s
  • Locked
    5. 
    Designing Data Retention
    5m 1s
  • Locked
    6. 
    Customizing Data Acquisition Using DAX
    3m 24s
  • Locked
    7. 
    Creating Datasets Using Query Parameters
    5m 23s
  • Locked
    8. 
    Managing Datasets Using Stored Procedures
    5m 15s
  • Locked
    9. 
    Using DAX Queries in Datasets
    7m 1s
  • Locked
    10. 
    Using MDX to Extract Data
    5m 9s
  • Locked
    11. 
    Managing Data Rights and Security for a Data Set
    5m 38s
  • Locked
    12. 
    Designing and Creating Report Templates
    5m 33s
  • Locked
    13. 
    Designing and Creating Linked Reports
    4m 53s
  • Locked
    14. 
    Designing and Creating a Drill-through Report
    6m 45s
  • Locked
    15. 
    Designing and Creating a Report with a Map
    7m 52s

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE