HOT
blank

Data Warehousing & Visualization in Microsoft BI & Power BI

Business

Rating4.5
Enroll Now

Data Warehousing & Visualization in Microsoft BI & Power BI, available at $74.99, has an average rating of 4.5, with 148 lectures, 5 quizzes, based on 514 reviews, and has 1870 subscribers.

You will learn about 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 Microsoft Business Intelligence tools (SSIS and SSRS) Understand and use how to extract, transform, and load data (ETL process) with 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 This course is ideal for individuals who are Anyone wants to learn data warehousing, data analysis, and ETL from scratch using Microsoft BI It is particularly useful for Anyone wants to learn data warehousing, data analysis, and ETL from scratch using Microsoft BI.

Enroll now: Data Warehousing & Visualization in Microsoft BI & Power BI

Summary

Title: Data Warehousing & Visualization in Microsoft BI & Power BI

Price: $74.99

Average Rating: 4.5

Number of Lectures: 148

Number of Quizzes: 5

Number of Published Lectures: 148

Number of Published Quizzes: 5

Number of Curriculum Items: 153

Number of Published Curriculum Objects: 153

Original Price: $19.99

Quality Status: approved

Status: Live

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 Microsoft Business Intelligence tools (SSIS and SSRS)
  • Understand and use how to extract, transform, and load data (ETL process) with 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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to course

Lecture 2: Course contents

Lecture 3: Control the pace of a video

Lecture 4: What is Data Warehousing

Lecture 5: OLTP and OLAP

Lecture 6: What is ETL

Lecture 7: What is Data Management

Lecture 8: Course Rating

Chapter 2: Database Management System

Lecture 1: What is Relational Database Management System (RDBMS)

Lecture 2: Install MS SQL Server and Management Studio

Lecture 3: Introduction to SQL Server Management Studio (SSMS)

Chapter 3: Introduction to Microsoft Business Intelligence

Lecture 1: Introduction to Microsoft Business Intelligence

Lecture 2: Install MS Business Intelligence package

Chapter 4: ETL Project 1 (Companies Expenses and Profits)

Lecture 1: Data types in MS SQL Server

Lecture 2: Overview on the data file

Lecture 3: Clean the data in MS Excel

Lecture 4: Create the database in SSMS

Lecture 5: Create the SSIS project in MS Visual Studio Shell for the ETL process – Part 1

Lecture 6: Create the SSIS project in MS Visual Studio Shell for the ETL process – Part 2

Lecture 7: Create the working table in SSMS for data analysis

Lecture 8: Course Rating

Chapter 5: ETL Project 2 (Car Sales)

Lecture 1: Overview on the data file

Lecture 2: Clean the data file in MS Excel

Lecture 3: Create the database in SSMS

Lecture 4: Create the SSIS project in MS Visual Studio Shell for the ETL process

Lecture 5: Create the working table in SSMS for data analysis

Lecture 6: Course Rating

Chapter 6: ETL Project 3 (Boston Crimes)

Lecture 1: Clean the data file in MS Excel

Lecture 2: Create the warehouse database in SSMS

Lecture 3: Create the SSIS project in MS Visual Studio Shell – Part 1

Lecture 4: Check the anomalies rows

Lecture 5: Create the working table in SSMS for data analysis

Lecture 6: Homework

Lecture 7: Homework Solution

Chapter 7: ETL Project 4 (Movies Data)

Lecture 1: Clean the data file in MS Excel

Lecture 2: Create the warehouse database in SSMS and ETL SSIS project

Lecture 3: Create the working table in SSMS for data analysis

Chapter 8: ETL Project 5 (Bank Customers Complaints)

Lecture 1: Clean the data file in MS Excel

Lecture 2: Create the warehouse database in SSMS and ETL SSIS project

Lecture 3: Create the working table in SSMS for data analysis – Part 1

Lecture 4: Create the working table in SSMS for data analysis – Part 2

Chapter 9: ETL Homework Project

Lecture 1: Introduction to homework

Chapter 10: SSRS Project1 (Companies Expenses and Profits)

Lecture 1: Create SSRS Project and Report

Lecture 2: Create Datasource, Dataset, and Table

Lecture 3: Add formatting to report

Chapter 11: SSRS Project 2 (Movies Data)

Lecture 1: Create SSRS project and a report

Lecture 2: Use Group by in the report

Lecture 3: Use visibility and hidden functions in the report

Lecture 4: Add calculated field to the report

Lecture 5: Add parameters to the report – Part 1

Lecture 6: Add parameters to the report – Part 2

Chapter 12: SSRS Project 3 (Employee Reviews)

Lecture 1: Create SSRS project and report

Lecture 2: Use visibility and hidden functions in report

Lecture 3: Use parameters to filter report data

Lecture 4: Use matrix in report

Lecture 5: Create a chart to visualize data

Chapter 13: SSRS Project 4 (Cars Sales)

Lecture 1: Create SSRS project and report

Lecture 2: Create a chart to visualize data

Lecture 3: Use matrix in report

Chapter 14: SSRS Project 5 (Boston Crimes)

Lecture 1: Create SSRS project and report

Lecture 2: Use Group by in report – Part 1

Lecture 3: Use Group by in report – Part 2

Lecture 4: Use Group by in report – Part 3

Lecture 5: Create a chart to visualize data

Chapter 15: SSRS Homework Project

Lecture 1: Introduction to homework

Chapter 16: ETL Homework Project Solution

Lecture 1: Clean dataset in MS Excel

Lecture 2: Implement ETL prcess – Part 1

Lecture 3: Implement ETL prcess – Part 2

Lecture 4: Create Work Table for data analysis in SSMS

Chapter 17: SSRS Homework Project Solution

Lecture 1: Number of issues

Lecture 2: Number of issues per year

Lecture 3: Products have most issues

Lecture 4: States have most issues

Lecture 5: Number of issues per bank(company)

Lecture 6: Number of issues that are not timely response

Lecture 7: Issues that are not closed yet

Lecture 8: Create a report using a matrix to address the number of issues per bank and year

Lecture 9: Create a chart showing number of issues in every month

Instructors

Rating Distribution

  • 1 stars: 10 votes
  • 2 stars: 8 votes
  • 3 stars: 56 votes
  • 4 stars: 114 votes
  • 5 stars: 326 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Relationship Building Courses to Learn in November 2024

Top 10 Storytelling Courses to Learn in November 2024

Top 10 Resilience Training Courses to Learn in November 2024