Skip to content Skip to sidebar Skip to footer

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.

Highest Rated

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 SSRS reports
Requirements
  • Basic knowledge of SQL
Description

Learning how to extract, clean and load data into a SQL database warehouse are highly required skills for data analysis field. You will learn in this course how to use Microsoft Excel to clean your data before loading them into a Microsoft SQL Server database. You will learn how to use SQL Server Integration Services (SSIS) which is one of Microsoft Business Intelligence tools to perform ETL process. You will learn a simple technique that save you a lot of time and help to avoid many possible errors during the ETL process. You will learn also how to use SQL Server Reporting Services (SSRS) to create business reports and  data analysis with SQL queries. This course is designed to be more practical by putting your hands on real projects with diverse business scenarios to learn by practice.  Learning via practice is the best way to get knowledge stuck in your mind because it is similar to acquire experience through work.

Who this course is for:
  • Anyone wants to learn data warehousing, data analysis, and ETL from scratch using Microsoft BI
Online Course CoupoNED
Online Course CoupoNED I am very happy that there are bloggers who can help my business

Post a Comment for " Learn Data Warehousing and Analysis with Microsoft BI Tools"

Subscribe via Email