New
Data warehousing and Business Intelligence

Data warehousing and Business Intelligence

This online course describes the concepts and methodologies involved in creating data warehouses and using them to extract business intelligence.

₦3,000

Course Description

As capabilities and capacities of modern computers continue to proliferate, data warehousing, and business intelligence more broadly, have become fundamental to maintaining business competitiveness.

Target Audience

IT and business professionals with an interest in harvesting business intelligence from SQL Server databases

Course Objectives

Microsoft SQL Server Data Warehousing and Business Intelligence Overview

  • Start the course
  • 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 column store 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.
  • 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 .
  • Create and query a data warehouse in SQL Server

Course Duration: 3 Months

Comming Soon
Copyright MAXXmarketing Webdesigner GmbH

TESTIMONIALS


OUR PARTNERS

CONTACT DETAILS