Learn Data Warehousing and Reporting Services with Microsoft BI Tools

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

Instructed by Ridha Joudah

  • Includes all Standard Features
  • Get Unlimited access to all the courses
  • No Contract. Cancel Anytime
Starting in just $19 / mo see all plans
Subscribe Now
$ 299
Annual Subscription
  • One year Unlimited Access
  • Access to all courses
    You will be able to access all the courses from any category on the platform.
  • Learning paths access
  • Access Assignments & Projects
  • Access on Mobile, PC and Tablet
  • Pause & Resume Courses Anytime
  • Offline viewing
  • Instructor Support
  • Course Completion Certificates
  • Cancel Anytime
Subscribe Now
  • 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

 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.  

  • Basic knowledge of SQL and Windows operating system
  • Anyone wants to learn data warehousing, data analysis, and ETL from scratch using Microsoft BI
View More...

Section 1 : Introduction

  • Lecture 1 :
  • Lecture 2 :
  • Course Contents
  • Lecture 3 :
  • What is Data Warehousing
  • Lecture 4 :
  • OLTP and OLAP
  • Lecture 5 :
  • What is ETL
  • Lecture 6 :
  • What is Data Management

Section 2 : Data 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)
  • Lecture 4 :
  • Possible Visual C++ error during MS SQL Installation
  • Lecture 5 :
  • Install Visual C++ if needed

Section 3 : Introduction to Microsoft Business Intelligence

  • Lecture 1 :
  • Introduction to Microsoft Business Intelligence
  • Lecture 2 :
  • Install MS Business Intelligence package

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

  • Lecture 1 :
  • Clean dataset in MS Excel
  • Lecture 2 :
  • Create database for dataset in SSMS
  • Lecture 3 :
  • Create SSIS project in MS Visual Studio Shell for ETL process - Part 1
  • Lecture 4 :
  • Create SSIS project in MS Visual Studio Shell for ETL process - Part 2
  • Lecture 5 :
  • Create Work Table for data analysis in SSMS

Section 5 : ETL Project 2 (Car Sales)

  • Lecture 1 :
  • Clean dataset in MS Excel
  • Lecture 2 :
  • Create database for the dataset in SSMS
  • Lecture 3 :
  • Create SSIS project in MS Visual Studio Shell for ETL process
  • Lecture 4 :
  • Create Work Table for data analysis in SSMS

Section 6 : ETL Project 3 (Boston Crimes)

  • Lecture 1 :
  • Clean dataset in MS Excel
  • Lecture 2 :
  • Create database for the dataset in SSMS
  • Lecture 3 :
  • Create SSIS project in MS Visual Studio Shell for ETL process - Part 1
  • Lecture 4 :
  • Create SSIS project in MS Visual Studio Shell for ETL process - Part 2
  • Lecture 5 :
  • Create Work Table for data analysis in SSMS
  • Lecture 6 :
  • Homework
  • Lecture 7 :
  • Homework Solution

Section 7 : ETL Project 4 (Movies Data)

  • Lecture 1 :
  • Clean dataset in MS Excel
  • Lecture 2 :
  • Create database for the dataset in SSMS and ETL SSIS project
  • Lecture 3 :
  • Create Work Table for data analysis in SSMS

Section 8 : ETL Project 5 (Bank Customers Complaints)

  • Lecture 1 :
  • Clean dataset in MS Excel
  • Lecture 2 :
  • Create database for the dataset in SSMS and ETL SSIS project
  • Lecture 3 :
  • Create Work Table for data analysis in SSMS - Part 1
  • Lecture 4 :
  • Create Work Table for data analysis in SSMS - Part 2

Section 9 : ETL Homework Project

  • Lecture 1 :
  • Introduction to homework

Section 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

Section 11 : SSRS Project 2 (Movies Data)

  • Lecture 1 :
  • Create SSRS project and report
  • Lecture 2 :
  • Use Group by in report
  • Lecture 3 :
  • Use visibility and hidden functions in report
  • Lecture 4 :
  • Add calculated field to report
  • Lecture 5 :
  • Add parameters to report - Part 1
  • Lecture 6 :
  • Add parameters to report - Part 2

Section 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

Section 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

Section 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

Section 15 : SSRS Homework Project

  • Lecture 1 :
  • Introduction to homework

Section 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

Section 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

Ridha Joudah,

My name is Ridha Joudah I have worked in IT and Data Science for more than 15 years. After completed my bachelor’s in computer science, I worked 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 have worked Data Analyst in several companies. Over several years of working in this field I mastered using several analytical tools, such as: R, SAS, SQL, Tableau, and Excel. As I love and enjoy working at data science I pursued my study in this major till I obtained my master’s degree in Business Analytics from 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 present something new in my classes. Instead of keep repeating same materials and curriculum which are already existing everywhere, I added materials simulate real business scenario. I included examples that based on real business cases to learn something practical rather than learning everything about basics. In other words, I tried to create shortcuts for practical learning to focus on what is really needed in the work field.
View More...
becoming-a-cloud-expert-microsoft-azure-iaas-level-1

Becoming a Cloud Expert - Microsoft...

By : Idan Gabrieli

Lecture 43

microsoft-power-bi-a-complete-hands-on-training

Microsoft Power BI-A Complete Hands...

By : Deepesh Vashistha

Lecture 39

Buy

$19

Enjoy Limitless Learning. Get Access to Unlimited Courses with Premium Subscrption Subscribe Now

Sign up and start learning
By signing up. you agree to our Terms of Use and Privacy Policy
Forget Password