Designing Reports & Creating Data Sources

SQL Server 2014
  • 13 Videos | 1h 15m 33s
  • Earns a Badge
Likes 23 Likes 23
You can access SQL Server Reporting Services (SSRS) reports from a variety of sources. Learn how to install and configure the Reporting Services topologies, plan and create reports, and create the data sources for data retrieval.

WHAT YOU WILL LEARN

  • describe how a report server is interacted with depending on the deployment topology and configuration
    describe what needs to be considered during planning to create a report, including the format, structure, data, calculations, and delivery among others
    describe the different report components for planning a report, including crosstab, Tablix, design chart, and data visualization components
    choose and create a new Reporting Services project in SSDT
    install Reporting Services using different topologies
    configure Reporting Services
    create a shared data source
  • create a shared data source that connects to Microsoft Azure Database
    create a shared data source that connects to a non-relational database
    use custom expressions in a data source
    create an embedded data source
    configure a parameterized connection string to connect to a database
    connect to Microsoft Azure Marketplace in a data source

IN THIS COURSE

  • Playable
    1. 
    Reporting Services Topologies and Configurations
    5m 42s
    UP NEXT
  • Playable
    2. 
    Planning a Report
    5m 31s
  • Locked
    3. 
    Identifying Report Components
    6m 29s
  • Locked
    4. 
    Creating a Reporting Services Project
    6m 3s
  • Locked
    5. 
    Installing Reporting Services
    6m 59s
  • Locked
    6. 
    Configuring Reporting Services
    7m 35s
  • Locked
    7. 
    Creating a Shared Data Source
    7m 10s
  • Locked
    8. 
    Creating a Connection to Azure SQL Database
    5m 1s
  • Locked
    9. 
    Creating a Data Source to a Non-Relational Database
    4m
  • Locked
    10. 
    Using Custom Expressions in a Data Source
    3m 41s
  • Locked
    11. 
    Creating an Embedded Data Source
    5m
  • Locked
    12. 
    Configuring a Parameterized Connection String
    4m 49s
  • Locked
    13. 
    Connection to Azure Marketplace
    3m 33s

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

Likes 26 Likes 26  
Likes 78 Likes 78