BI Reporting Strategies

SQL Server    |    Expert
  • 15 videos | 1h 22m 26s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 19 users Rating 4.7 of 19 users (19)
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 2s
    After completing this video, you will be able to describe the considerations for designing data sources and data sets for a report. FREE ACCESS
  • 6m 49s
    Learn how to design a data movement strategy and profile source data. FREE ACCESS
  • Locked
    3.  Creating Shared and Embedded Data Sources
    5m 26s
    In this video, find out how to create a shared or embedded data source. FREE ACCESS
  • Locked
    4.  Creating Stored Credentials
    3m 47s
    Find out how to create stored credentials to determine who can access the data in the report. FREE ACCESS
  • Locked
    5.  Designing Data Retention
    4m 58s
    In this video, you will learn how to design for data retention. FREE ACCESS
  • Locked
    6.  Customizing Data Acquisition Using DAX
    3m 21s
    In this video, find out how to customize data acquisition using DAX with reporting services data sources. FREE ACCESS
  • Locked
    7.  Creating Datasets Using Query Parameters
    5m 20s
    Learn how to create a data set by using query parameters. FREE ACCESS
  • Locked
    8.  Managing Datasets Using Stored Procedures
    5m 12s
    In this video, learn how to manage datasets using stored procedures. FREE ACCESS
  • Locked
    9.  Using DAX Queries in Datasets
    6m 58s
    Find out how to create DAX queries that are appropriate for an application. FREE ACCESS
  • Locked
    10.  Using MDX to Extract Data
    5m 6s
    In this video, you will extract data from analysis services by using SQL queries. FREE ACCESS
  • Locked
    11.  Managing Data Rights and Security for a Data Set
    5m 35s
    Learn how to manage data rights and security for a data set. FREE ACCESS
  • Locked
    12.  Designing and Creating Report Templates
    5m 30s
    Learn how to design and create a report template to ensure reports are consistent. FREE ACCESS
  • Locked
    13.  Designing and Creating Linked Reports
    4m 50s
    Find out how to design and create linked reports, including sub-reports. FREE ACCESS
  • Locked
    14.  Designing and Creating a Drill-through Report
    6m 42s
    Learn how to design and create a report that you can drill through. FREE ACCESS
  • Locked
    15.  Designing and Creating a Report with a Map
    7m 49s
    During 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.

YOU MIGHT ALSO LIKE

Channel Analytics
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Rating 5.0 of 6 users Rating 5.0 of 6 users (6)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 5.0 of 7 users Rating 5.0 of 7 users (7)
Course MDX Queries
Rating 4.9 of 26 users Rating 4.9 of 26 users (26)
Rating 4.5 of 71 users Rating 4.5 of 71 users (71)