Learn Data Warehousing and Analysis with Microsoft BI Tools

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