Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Data Warehousing & Visualization in Microsoft BI & Power BI

Learn ETL, Data Analysis and Visualization using Microsoft Excel, Microsoft Business Intelligence tools and Power BI
4.6
☆☆☆☆☆ 4.6/5
(398 reviews)
1,348 students
Created by
Data Science Guide

10.0

Classbaze Grade®

10.0

Freshness

10.0

Popularity

9.5

Material

Detailed Analysis »

Learn how extract
Go to course »
Platform: Udemy
Price: check current price
Video: 8h 17m
Language: English
Next start: On Demand

Best Data Warehouse classes:

Skillshare_logo_2020
Best Data Warehouse classes on Skillshare »
Coursera Logo
Best Data Warehouse classes on Coursera »
Pluralsight Logo
BestData Warehouse classes on PluralSight »
Udemy logo
Best Data Warehouse classes on Udemy »
linkedin
Best Data Warehouse classes on LinkedIn (Free trial) »

Classbaze Rating

Classbaze Grade®

10.0 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

10.0 / 10
This course was last updated on 5/2022.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

10.0 / 10
We analyzed factors such as the rating (4.6/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

9.5 / 10
Video Score: 8.8 / 10
The course includes 8h 17m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 4 hours 20 minutes of 34 Data Warehouse courses on Udemy.
Detail Score: 9.7 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.9 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

5 articles.
27 resources.
0 exercise.
0 test.

In this page

About this course

  The course will teach you this
  What you need to START the course
  Who can start this course?
General questions
  Coupons & Discounts
  Guarantees & money back
  Financial aid
Teacher
Classbaze hand picked recommendations

About the course

Data Warehousing
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. 
Power BI
Converting raw data to insightful diagrams and charts to make informative decisions is a crucial analytical skill in data science. You will learn in this course how to create insightful and powerful charts and perform data analysis. First, you will understand data visualization, and why data visualization. After that you will understand Power BI services and the use of each of them. After you became familiar with these services you will learn how to install and navigate in Power BI Desktop. After that, you will learn how to use the advanced functions in Power BI Editor in data preparation and cleaning. You will learn appending and merging datasets to create one dataset. After that you will learn how to turn your datasets into insightful charts using many powerful functions. You will learn how to filter your data according to your business requirements. You will learn how to create measures and calculated columns for your own data analysis. You will have an introduction to DAX language where you can learn how to create new tables and columns according to your needs. After that you will learn how to take your projects in the Cloud where you can work with other users. You will learn how use Power BI Pro interface to create, edit and share reports with others.

What can you learn from this course?

✓ 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

What you need to start the course?

• Basic knowledge of SQL

Who is this course is made for?

• Anyone wants to learn data warehousing, data analysis, and ETL from scratch using Microsoft BI

Are there coupons or discounts for Data Warehousing & Visualization in Microsoft BI & Power BI ? What is the current price?

The course costs $14.99. And currently there is a 25% discount on the original price of the course, which was $19.99. So you save $5 if you enroll the course now.
The average price is $16.8 of 34 Data Warehouse courses. So this course is 11% cheaper than the average Data Warehouse course on Udemy.

Will I be refunded if I'm not satisfied with the Data Warehousing & Visualization in Microsoft BI & Power BI course?

YES, Data Warehousing & Visualization in Microsoft BI & Power BI has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any financial aid for this course?

Currently we could not find a scholarship for the Data Warehousing & Visualization in Microsoft BI & Power BI course, but there is a $5 discount from the original price ($19.99). So the current price is just $14.99.

Who will teach this course? Can I trust Data Science Guide?

Data Science Guide has created 4 courses that got 1,836 reviews which are generally positive. Data Science Guide has taught 5,145 students and received a 4.6 average review out of 1,836 reviews. Depending on the information available, we think that Data Science Guide is an instructor that you can trust.

Learn everything about

Data Science Guide

Data Scientist & SQL Developer
My name is Abraham Joudah
I have worked in IT and Data Science for more than 15 years. After completed my bachelor’s in computer science, I worked as Database Administrator in one of the engineering companies. I have obtained several certificates from Microsoft like MCSE, MCDBA and MCSA. After several years of working in IT, I started focusing on Data Science field and learning SQL in depth to enhance my business data analysis skills. I also worked as Data Analyst in several companies. Over several years of working in this field I mastered several analytical tools, such as: R, SAS, SQL, Tableau, and Excel. As I enjoy working at data science field I pursued my study in this major and obtained my Master’s degree in Business Analytics from the University of North Texas.
I love teaching Data Science, So I decided to create several courses in this field to share my knowledge with others. I tried to be more practical in my classes rather than repeating the same materials and curriculums in this field. I used materials based on real business scenarios to provide practical knowledge for students. I focused on examples from real business. In other words, I created shortcuts for learners to gain practical experience while studying my courses.
Browse all courses by on Classbaze.
Data Science Guide's full profile and courses »
Go to class »

10.0

Classbaze Grade®

10.0

Freshness

10.0

Popularity

9.5

Material

Detailed Analysis »

Learn how extract
Go to course »
Platform: Udemy
Price: check current price
Video: 8h 17m
Language: English
Next start: On Demand

Classbaze recommendations for you

Other courses by ​Data Science Guide

Go to class »