Data Warehousing & Business Intelligence Deployment

SQL Server 2014    |    Intermediate
  • 10 videos | 37m 10s
  • Earns a Badge
Rating 4.4 of 22 users Rating 4.4 of 22 users (22)
To gain a business edge, it is vital to extract business intelligence from data warehouses. Examine how to achieve this goal using SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).

WHAT YOU WILL LEARN

  • Create a sql server analysis service project using sql server data tools
    Create a data source in sql server analysis services using sql server data tools
    Create a cube in sql server analysis services using sql server data tools
    Deploy sql server analysis services
    Query sql server analysis services using excel
  • Connect to a data source to create a report in sql server report builder
    Create a basic sql server report
    Create a sql server report with calculations
    Create a sql server report with end user interactive elements
    Deploy a sql server report

IN THIS COURSE

  • 3m 44s
    Learn how to create a SQL Server Analysis Services project using SQL Server Data Tools. FREE ACCESS
  • 3m 25s
    In this video, you will learn how to create a data source in SQL Server Analysis Services using SQL Server Data Tools. FREE ACCESS
  • Locked
    3.  Creating an SSAS Cube
    3m 13s
    During this video, you will learn how to create a cube in SQL Server Analysis Services using SQL Server Data Tools. FREE ACCESS
  • Locked
    4.  Deploying SSAS
    2m 55s
    Find out how to deploy SQL Server Analysis Services. FREE ACCESS
  • Locked
    5.  Querying SSAS
    4m 49s
    In this video, learn how to query SQL Server Analysis Services using Excel. FREE ACCESS
  • Locked
    6.  Connecting SSRS to a Data Source
    4m 31s
    To create a report in SQL Server Report Builder, you will need to connect to a data source. FREE ACCESS
  • Locked
    7.  Creating a Report
    3m 8s
    In this video, you will learn how to create a basic SQL Server Report. FREE ACCESS
  • Locked
    8.  Creating a Report with Calculations
    3m 10s
    In this video, you will learn how to create a SQL Server report with calculations. FREE ACCESS
  • Locked
    9.  Creating Reports with Interactivity
    4m 43s
    During this video, you will learn how to create a SQL Server report with interactive elements for the end user. FREE ACCESS
  • Locked
    10.  Deploying a SQL Server Report
    3m 35s
    In this video, find out how to deploy a SQL Server report. 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

Journey Data Analytics Specialist
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Be Data Analytical: How to Use Analytics to Turn Data into Value
Journey Analyze Data with SQL
Rating 4.8 of 12 users Rating 4.8 of 12 users (12)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Azure Data Scientist Associate: Azure Data Factory
Rating 4.8 of 53 users Rating 4.8 of 53 users (53)
Course Continuous Data: Ingesting Continuous Data in Snowflake
Rating 4.8 of 33 users Rating 4.8 of 33 users (33)
Course Data Warehousing & Business Intelligence Implementation
Rating 4.5 of 67 users Rating 4.5 of 67 users (67)