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

( 14 Reviews )

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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 92 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a data science course? Or looking for more detail on 's Learn Data Warehousing and Analysis with Microsoft BI Tools? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

*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

Students also recommend

The Data Scientist's Toolbox (2019)

5.0 (148 Reviews)

Provider: Coursera
Time: 8h

Free

Python for Data Science (2017)

4.4 (9 Reviews)

Provider: edX

Free

Python A-Z: Python For Data Science With Real Exercises! (2022)

4.4 (150 Reviews)

Provider: Udemy
Time: 11h

$10.44

More Courses

Reviews

4.6

14 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Juned Bagwan on

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

By Zhrhaa Zhrhaa on

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

By Rohin Mehta on

Incredible Videos. Gives Hands on experience in Data Warehousing.

By Haidar on

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

By Mohammad Rayya on

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.

By William on

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.

By Da Gamer on

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.

By Keith Wilson on