Learn Data Warehousing and Analysis with Microsoft BI Tools
Ditulis pada: June 25, 2019
Learn Data Warehousing and Analysis with Microsoft BI Tools, Learn how extract, clean and load data in a database using Microsoft Excel and Business Intelligence tools
- HOT & NEW
- Created by Data Science Guide
- English
- English [Auto-generated]
PREVIEW THIS COURSE - GET COUPON CODE
What you'll learn
- Understand Data Warehousing Terminology
- Understand the difference between OLTP and OLAP
- Install and use MS SQL Server and SQL Server Management Studio
- Install and use Business Intelligence tools (SSIS and SSRS)
- Understand and use ETL via SSIS
- Introduced to different Flat files
- Clean CSV files using Microsoft Excel
- Use simple and efficient ETL that avoid many of expecting errors
- USE SSRS to create different types of business reports
- Practice data analysis while creating SSER reports