Learn Data Warehousing and Analysis with Microsoft BI Tools (Udemy.com)

Learn how extract, clean and load data in a database using Microsoft Excel and Business Intelligence tools

icon
What you will 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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

icon
Students also recommend

Free

Free

10.99

icon
Reviews

4.6

14 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

Concepts Are Summarized in correct words without eliminating the actual context.

Very clear step by step course.Thank you so much for sharing these amazing knowledge.

Incredible Videos. Gives Hands on experience in Data Warehousing.

Easy to follow and understand. I am learning how to clean data and export them to data warehouse.

Der Kurs ist bislang wie ich erwartet habe und hat mir ntzliche Informationen gegeben.

By Obi on

Ridha Joudah is a good instructor, for me he nailed this course.

This course is easy to understand. However, VS 2019 is completely different in how it organizes SSDT and this tutorial is not relevant to the new VS. VS 2019 utilizes extensions and so at 30% through I had to find an alternate course to explain ETL with most modern tools.

Covers the basics of loading data to a database using ETL/SSIS. But it doesn't cover data warehousing or SSAS. If it used Power BI for reporting as well, it would get a 5/5 from me.

Perfect course to learn data cleaning and data warehousing

I'm enjoying this course so far. It's very thorough!!

Le cours est trs progressif et trs clair. Cela aide m'aide structurer les connaissances acquises d'autres occasions.

Ease to understand.