Data Warehousing & Business Intelligence Implementation

SQL Server 2014    |    Intermediate
  • 15 Videos | 1h 4m 43s
  • Earns a Badge
Likes 93 Likes 93
Data warehousing and business intelligence have become fundamental to maintaining business competitiveness. Examine what is involved in creating a SQL Server data warehouse, and how to create and deploy an SSIS package.

WHAT YOU WILL LEARN

  • describe data warehousing
    recognize the key concepts of business intelligence
    recognize the function of normalization in OLTP databases and denormalization in OLAP databases
    describe dimension and fact tables in OLAP databases
    recognize the star and snowflake schemas in data warehouse databases, and the role of KPIs in business intelligence
    create a fact table in a data warehouse database in SQL Server
    create a dimension table in a data warehouse database in SQL Server
    create a columnstore index in a data warehouse database in SQL Server
  • create a table and index partition in a data warehouse database in SQL Server
    implement data compression in a data warehouse database in SQL Server
    create a simple SSIS package in SQL Server using SQL Server Data Tools
    create a control flow in SQL Server using SQL Server Data Tools
    create a data flow in SQL Server using SQL Server Data Tools
    create a transform in SQL Server using SQL Server Data Tools
    deploy an SSIS package in SQL Server

IN THIS COURSE

  • Playable
    1. 
    Data Warehousing Overview
    5m
    UP NEXT
  • Playable
    2. 
    Business Intelligence Overview
    4m 18s
  • Locked
    3. 
    Normalization and Denormalization
    4m 39s
  • Locked
    4. 
    Fact and Dimension Tables
    3m 48s
  • Locked
    5. 
    Data Warehouse Schemas
    3m 35s
  • Locked
    6. 
    Creating a Fact Table
    4m 20s
  • Locked
    7. 
    Creating a Dimension Table
    3m 2s
  • Locked
    8. 
    Create a Columnstore Index in SQL Server
    3m 39s
  • Locked
    9. 
    Table and Index Partitioning
    5m 26s
  • Locked
    10. 
    Implementing Data Compression
    3m 37s
  • Locked
    11. 
    Creating a Simple SSIS Package
    3m 53s
  • Locked
    12. 
    Creating a Control Flow
    3m 28s
  • Locked
    13. 
    Creating a Data Flow
    3m 20s
  • Locked
    14. 
    Creating a Transform
    3m 43s
  • Locked
    15. 
    Deploying an SSIS Package
    3m 55s

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 29 Likes 29  
Likes 250 Likes 250  
Likes 1176 Likes 1176