Home

All courses

Data Warehousing & Visualization in Microsoft BI & Power BI

Business

Data Warehouse

Business Analytics & Intelligence

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.3

(526)

1929 enrolled on this course

Last updated 11/2021

None

₹ 3099.0

₹ 4599.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

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.
Who this course is for:
Anyone wants to learn data warehousing, data analysis, and ETL from scratch using Microsoft BI

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 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

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction

1.1-Introduction to course

1.2-Course contents

1.3-Control the pace of a video

1.4-What is Data Warehousing

1.5-Which of the following steps is not part of data warehousing

1.6-OLTP and OLAP

1.7-Which of the following is not a characteristic of OLAP

1.8-What is ETL

1.9-Which of the following two is correct

1.10-What is Data Management

1.11-Which of the following is not part of data management

1.12-Course Rating

2-Database Management System

2.1-What is Relational Database Management System (RDBMS)

2.2-Which one of the following is not a database management system

2.3-Install MS SQL Server and Management Studio

2.4-Introduction to SQL Server Management Studio (SSMS)

3-Introduction to Microsoft Business Intelligence

3.1-Introduction to Microsoft Business Intelligence

3.2-Install MS Business Intelligence package

4-ETL Project 1 (Companies Expenses and Profits)

4.1-Data types in MS SQL Server

4.2-Overview on the data file

4.3-Clean the data in MS Excel

4.4-Create the database in SSMS

4.5-Create the SSIS project in MS Visual Studio Shell for the ETL process - Part 1

4.6-Create the SSIS project in MS Visual Studio Shell for the ETL process - Part 2

4.7-Create the working table in SSMS for data analysis

4.8-Course Rating

5-ETL Project 2 (Car Sales)

5.1-Overview on the data file

5.2-Clean the data file in MS Excel

5.3-Create the database in SSMS

5.4-Create the SSIS project in MS Visual Studio Shell for the ETL process

5.5-Create the working table in SSMS for data analysis

5.6-Course Rating

6-ETL Project 3 (Boston Crimes)

6.1-Clean the data file in MS Excel

6.2-Create the warehouse database in SSMS

6.3-Create the SSIS project in MS Visual Studio Shell - Part 1

6.4-Check the anomalies rows

6.5-Create the working table in SSMS for data analysis

6.6-Homework

6.7-Homework Solution

7-ETL Project 4 (Movies Data)

7.1-Clean the data file in MS Excel

7.2-Create the warehouse database in SSMS and ETL SSIS project

7.3-Create the working table in SSMS for data analysis

8-ETL Project 5 (Bank Customers Complaints)

8.1-Clean the data file in MS Excel

8.2-Create the warehouse database in SSMS and ETL SSIS project

8.3-Create the working table in SSMS for data analysis - Part 1

8.4-Create the working table in SSMS for data analysis - Part 2

9-ETL Homework Project

9.1-Introduction to homework

10-SSRS Project1 (Companies Expenses and Profits)

10.1-Create SSRS Project and Report

10.2-Create Datasource, Dataset, and Table

10.3-Add formatting to report

11-SSRS Project 2 (Movies Data)

11.1-Create SSRS project and a report

11.2-Use Group by in the report

11.3-Use visibility and hidden functions in the report

11.4-Add calculated field to the report

11.5-Add parameters to the report - Part 1

11.6-Add parameters to the report - Part 2

12-SSRS Project 3 (Employee Reviews)

12.1-Create SSRS project and report

12.2-Use visibility and hidden functions in report

12.3-Use parameters to filter report data

12.4-Use matrix in report

12.5-Create a chart to visualize data

13-SSRS Project 4 (Cars Sales)

13.1-Create SSRS project and report

13.2-Create a chart to visualize data

13.3-Use matrix in report

14-SSRS Project 5 (Boston Crimes)

14.1-Create SSRS project and report

14.2-Use Group by in report - Part 1

14.3-Use Group by in report - Part 2

14.4-Use Group by in report - Part 3

14.5-Create a chart to visualize data

15-SSRS Homework Project

15.1-Introduction to homework

16-ETL Homework Project Solution

16.1-Clean dataset in MS Excel

16.2-Implement ETL prcess - Part 1

16.3-Implement ETL prcess - Part 2

16.4-Create Work Table for data analysis in SSMS

17-SSRS Homework Project Solution

17.1-Number of issues

17.2-Number of issues per year

17.3-Products have most issues

17.4-States have most issues

17.5-Number of issues per bank(company)

17.6-Number of issues that are not timely response

17.7-Issues that are not closed yet

17.8-Create a report using a matrix to address the number of issues per bank and year

17.9-Create a chart showing number of issues in every month

17.10-Final Course Rating

18-Introduction to Data Visualization

18.1-Introduction to Course

18.2-Introduction to Section 1

18.3-What is Power BI

18.4-Install Power BI Desktop

18.5-Change setting in Power BI Desktop

18.6-Start Power BI Desktop

19-Data Cleaning and Preparation

19.1-Overview on the business dataset

19.2-Connect to a data source

19.3-Remove N/A rows and use first row as headers names

19.4-Introduction to Pivot and Unpivot operators

19.5-Unpivoting columns

19.6-Split columns and change data types

19.7-Other ways to split columns

19.8-Introduction to M Language

19.9-Remove empty rows from a dataset

19.10-Identify the granular data level in the dataset

19.11-Remove duplicated rows in a dataset

19.12-Connect to another data source

19.13-Introduction to Append operator

19.14-Append queries in Power BI Query Editor

19.15-Introduction to data types in Power BI

19.16-Set proper data types in a dataset

19.17-Fix a data conversion error

19.18-Introduction to Star Schema Model

19.19-Create a Star Schema Model in Power BI

19.20-Create the Country dimension table

19.21-Create the Product and Segment dimensions tables

19.22-Create the Fact Sales table

19.23-Introduction to the Merge operator

19.24-Merge queries in Power Query Editor

19.25-Organize datasets in groups

19.26-More useful functions in Power Query Editor

19.27-Disable loading unused files into Power BI

19.28-Project 2 file in Power BI

20-Data Visualization

20.1-Introduction to Data Visualization

20.2-Create the first chart

20.3-Filter data in charts

20.4-Use top N feature in filters

20.5-Formatting charts part-1

20.6-Formatting charts part-2

20.7-Add analytical lines to charts

20.8-Fix the merging problems between queries

20.9-Create a TreeMap chart

20.10-Advanced color formatting in charts

20.11-Add Slicer to charts

20.12-Create a Map chart

20.13-Measure vs Calculated column

20.14-Create a measure in Power BI Desktop

20.15-Create a calculated column

20.16-Create a Pie chart

20.17-Prepare a time series dataset

20.18-Create a Line chart

20.19-Drilling in a Hierarchy dimensions

20.20-Change themes of reports

20.21-Introduction to DAX Language

20.22-Arithmetic functions in DAX

20.23-DAX operators

20.24-Date functions in DAX

20.25-Logical functions in DAX

20.26-Text concatenation functions in DAX

21-Work on Projects in the Cloud with Power BI Pro

21.1-Introduction to Power BI Pro

21.2-Login to Power BI Pro

21.3-Quick overview on Power BI Pro interface

21.4-Browse and edit projects in Power BI Pro

21.5-Create a Dashboard in Power BI Pro

21.6-Overview on My workspace in Power BI Pro

21.7-Install a Gateway

21.8-Overview on Workspaces in Power BI Pro

21.9-Apps in Power BI Pro

Course Categories

Popular Courses

Data Warehousing & Visualization in Microsoft BI & Power BI

Description

What you'll learn

Requirements

Course Content

You May Like