Home » Databases » Data Warehouse tutorial video

 
 

Data Warehouse tutorial video

 

Data Warehouse tutorial helps you learn the many features of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Excel and databases. 6 lessons, total length 1 hour 34 minutes.

A data warehouse (DW or DWH)  depending on its size and scope, is a collection of many important data, usually obtained from different sources. SQL Server Integration Services (SSIS) provides the ability to ETL (extract, load and transform) as well as maintain DW.

A DW is usually the core component of a Business Intelligence (BI) infrastructure for today’s companies.

A DW is designed for data reporting. Analytical tools such as KPI (Key Performance Indicator) dashboards, ad-hoc reporting systems and pre-defined reports will read data from either an online analytical processing (OLAP) or relational data warehouse cubes. SQL Server Analysis Services (SSAS) provides a platform to define OLAP cubes and pre-defined aggregations. Cubes are easy to navigate. Queries run with optimal performance and support complex calculations that would otherwise be difficult to perform and slow.

  1. Data Warehouse introduction (08:18)
    what is Data Warehouse, what is a cube, dimension, measure. what is OLAP, what is ETL (Extract, Load, Transform) package, what is BI (Business Intelligence)
    buy single lesson
  2. Creating a database (11:00)
    creating databese, creating tables, inserting a sample data, database schema
    buy single lesson
  3. Creating an OLAP cube (15:53)
    creating an AS (Analysis Services) project, creating a data source, creating a data source view, creatng a dimensions, adding measures, creating an OLAP cube, processing a cube
    buy single lesson
  4. Creating an ETL process (49:48)
    viewing source data, creating an SSIS (Integration Servces) project, loading data from other database, loading data from textfiles, loading data from Excel file, transform data, loading dimension tables by using SSIS package, inserting data into facts table, adding an Analysis Services Processing Task
    buy single lesson
  5. Working with jobs (03:40)
    creating a job, creating a new step, scheduling a job
    buy single lesson
  6. Using a Pivot Table (05:10)
    creating a pivot table in Excel, using a pivot table, create a pivot chart in Excel, using a pivot chart
    buy single lesson

Price 37.00 USD

  • save your time
  • learn Data Warehouses in the fastest and most effective way
  • get instant access and download your video tutorial

Frequently Asked Questions

Free lesson:

Tags: , , , ,