Data Warehousing & Business Intelligence Implementation

SQL Server 2014
  • 15 Videos | 1h 27s
  • Earns a Badge
Likes 62 Likes 62
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 3s
    UP NEXT
  • Playable
    2. 
    Business Intelligence Overview
    4m 21s
  • Locked
    3. 
    Normalization and Denormalization
    4m 42s
  • Locked
    4. 
    Fact and Dimension Tables
    3m 51s
  • Locked
    5. 
    Data Warehouse Schemas
    3m 38s
  • Locked
    6. 
    Creating a Fact Table
    4m 23s
  • Locked
    7. 
    Creating a Dimension Table
    3m 5s
  • Locked
    8. 
    Create a Columnstore Index in SQL Server
    3m 42s
  • Locked
    9. 
    Table and Index Partitioning
    5m 29s
  • Locked
    10. 
    Implementing Data Compression
    3m 40s
  • Locked
    11. 
    Creating a Simple SSIS Package
    3m 56s
  • Locked
    12. 
    Creating a Control Flow
    3m 31s
  • Locked
    13. 
    Creating a Data Flow
    3m 23s
  • Locked
    14. 
    Creating a Transform
    3m 46s
  • Locked
    15. 
    Deploying an SSIS Package
    3m 58s

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

Likes 0 Likes 0  
Likes 11 Likes 11  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SSIS Packages
Likes 36 Likes 36  
Likes 52 Likes 52