BI Reporting Strategies

SQL Server 2014    |    Expert
  • 15 Videos | 1h 29m 56s
  • Includes Assessment
  • Earns a Badge
Likes 26 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 2s
    UP NEXT
  • Playable
    2. 
    Designing a Data Acquisition Strategy
    6m 49s
  • Locked
    3. 
    Creating Shared and Embedded Data Sources
    5m 26s
    FREE ACCESS
  • Locked
    4. 
    Creating Stored Credentials
    3m 47s
    FREE ACCESS
  • Locked
    5. 
    Designing Data Retention
    4m 58s
    FREE ACCESS
  • Locked
    6. 
    Customizing Data Acquisition Using DAX
    3m 21s
    FREE ACCESS
  • Locked
    7. 
    Creating Datasets Using Query Parameters
    5m 20s
    FREE ACCESS
  • Locked
    8. 
    Managing Datasets Using Stored Procedures
    5m 12s
    FREE ACCESS
  • Locked
    9. 
    Using DAX Queries in Datasets
    6m 58s
    FREE ACCESS
  • Locked
    10. 
    Using MDX to Extract Data
    5m 6s
    FREE ACCESS
  • Locked
    11. 
    Managing Data Rights and Security for a Data Set
    5m 35s
    FREE ACCESS
  • Locked
    12. 
    Designing and Creating Report Templates
    5m 30s
    FREE ACCESS
  • Locked
    13. 
    Designing and Creating Linked Reports
    4m 50s
    FREE ACCESS
  • Locked
    14. 
    Designing and Creating a Drill-through Report
    6m 42s
    FREE ACCESS
  • Locked
    15. 
    Designing and Creating a Report with a Map
    7m 49s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Creating Reports
Likes 12 Likes 12  
CHANNEL MySQL
Likes 206 Likes 206  
COURSE Implementing BI Infrastructure
Likes 44 Likes 44