Data Warehousing & Business Intelligence Deployment

SQL Server 2014    |    Intermediate
  • 10 Videos | 37m 10s
  • Earns a Badge
Likes 87 Likes 87
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

  • Playable
    1. 
    Creating an SSAS Project
    3m 44s
    UP NEXT
  • Playable
    2. 
    Creating an SSAS Data Source
    3m 25s
  • Locked
    3. 
    Creating an SSAS Cube
    3m 13s
    FREE ACCESS
  • Locked
    4. 
    Deploying SSAS
    2m 55s
    FREE ACCESS
  • Locked
    5. 
    Querying SSAS
    4m 49s
    FREE ACCESS
  • Locked
    6. 
    Connecting SSRS to a Data Source
    4m 31s
    FREE ACCESS
  • Locked
    7. 
    Creating a Report
    3m 8s
    FREE ACCESS
  • Locked
    8. 
    Creating a Report with Calculations
    3m 10s
    FREE ACCESS
  • Locked
    9. 
    Creating Reports with Interactivity
    4m 43s
    FREE ACCESS
  • Locked
    10. 
    Deploying a SQL Server Report
    3m 35s
    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

BOOK Beginning Azure Synapse Analytics: Transition from Data Warehouse to Data Lakehouse
CHANNEL SAS
Likes 74 Likes 74  
COURSE Data Warehousing with Azure: Analytics & Reporting
Likes 23 Likes 23  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Extract, Transform, & Load
Likes 103 Likes 103  
COURSE Business Reporting: Visualizing & Merging Data in Power BI
Likes 257 Likes 257  
COURSE Microsoft Azure Fundamentals: Cloud Computing
Likes 861 Likes 861