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
    FREE ACCESS
  • Locked
    4. 
    Creating Stored Credentials
    3m 50s
    FREE ACCESS
  • Locked
    5. 
    Designing Data Retention
    5m 1s
    FREE ACCESS
  • Locked
    6. 
    Customizing Data Acquisition Using DAX
    3m 24s
    FREE ACCESS
  • Locked
    7. 
    Creating Datasets Using Query Parameters
    5m 23s
    FREE ACCESS
  • Locked
    8. 
    Managing Datasets Using Stored Procedures
    5m 15s
    FREE ACCESS
  • Locked
    9. 
    Using DAX Queries in Datasets
    7m 1s
    FREE ACCESS
  • Locked
    10. 
    Using MDX to Extract Data
    5m 9s
    FREE ACCESS
  • Locked
    11. 
    Managing Data Rights and Security for a Data Set
    5m 38s
    FREE ACCESS
  • Locked
    12. 
    Designing and Creating Report Templates
    5m 33s
    FREE ACCESS
  • Locked
    13. 
    Designing and Creating Linked Reports
    4m 53s
    FREE ACCESS
  • Locked
    14. 
    Designing and Creating a Drill-through Report
    6m 45s
    FREE ACCESS
  • Locked
    15. 
    Designing and Creating a Report with a Map
    7m 52s
    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 Implementing BI Infrastructure
Likes  25
COURSE Designing Reports & Creating Datasets
Likes  13
COURSE Business Reporting: Getting Started with Power BI Desktop for Data Analysis
Likes  28

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Planning BI Infrastructure
Likes  41
COURSE QlikView: Data Modeling
Likes  39
COURSE Data Warehousing & Business Intelligence Implementation
Likes  62