Data Warehousing & Business Intelligence Implementation

Offered bySkillsoft

Data Warehousing & Business Intelligence Implementation
at
Skillsoft
Overview

Gain hands-on experience with popular BI tools and techniques to develop impactful dashboards and reports for decision-makers

Duration	1 hour
Mode of learning	Online
Difficulty level	Intermediate
Official Website	Go to Website
Credential	Certificate
Future job roles	Manager Information Technology , Compensation and Benefits, DB AND OS Administrator , Competition Law, Company Law

Data Warehousing & Business Intelligence Implementation
at
Skillsoft
Highlights

Earn a Digital Badge after completion of course from Skillsoft

Data Warehousing & Business Intelligence Implementation
at
Skillsoft
Course details

Skills you will learn

OLAP Data analysis Data Warehousing

Who should do this course?

Data Analysts

Database Developers/Administrators

Business Intelligence Developers

Business Professionals

What are the course deliverables?

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 serve

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

More about this course

This course provides a comprehensive overview of the principles, techniques, and technologies involved in designing and implementing data warehousing and business intelligence solutions

Participants will learn how to collect, store, and analyze data from various sources to generate valuable insights for decision-making purposes