Brochure
Enquire
- Course Introduction
- Course Contents
- Control the Pace of a Lesson
- What is Data Warehousing
- Which of the following steps is not part of data warehousing
- OLTP and OLAP
- Which of the following is not a characteristic of OLAP
- What is ETL
- Which of the following two is correct
- What is Data Management
- Which of the following is not part of data management
- Course Rating
Quick Facts
| particular | details | |||
|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 3,099
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Introduction
Database Management System
- What is Relational Database Management System (RDBMS)
- Which one of the following is not a database management system
- Install MS SQL Server and Management Studio
- Introduction to SQL Server Management Studio (SSMS)
Introduction to Microsoft Business Intelligence
- Introduction to Microsoft Business Intelligence
- Install MS Business Intelligence package
ETL Project 1 (Companies Expenses and Profits)
- Data types in MS SQL Server
- Overview on the data file
- Clean the data in MS Excel
- Create the database in SSMS
- Create the SSIS project in MS Visual Studio Shell for the ETL process - Part 1
- Create the SSIS project in MS Visual Studio Shell for the ETL process - Part 2
- Create the working table in SSMS for data analysis
ETL Project 2 (Car Sales)
- Overview on the data file
- Clean the data file in MS Excel
- Create the database in SSMS
- Create the SSIS project in MS Visual Studio Shell for the ETL process
- Create the working table in SSMS for data analysis
- Course Rating
ETL Project 3 (Boston Crimes)
- Clean the data file in MS Excel
- Create the warehouse database in SSMS
- Create the SSIS project in MS Visual Studio Shell - Part 1
- Check the anomalies rows
- Create the working table in SSMS for data analysis
- Homework
- Homework Solution
ETL Project 4 (Movies Data)
- Clean the data file in MS Excel
- Create the warehouse database in SSMS and ETL SSIS project
- Create the working table in SSMS for data analysis
ETL Project 5 (Bank Customers Complaint)
- Clean the data file in MS Excel
- Create the warehouse database in SSMS and ETL SSIS project
- Create the working table in SSMS for data analysis - Part 1
- Create the working table in SSMS for data analysis - Part 2
ETL Homework Project
- Introduction to homework
SSRS Project 1 (Companies Expenses and Profits)
- Create SSRS Project and Report
- Create Datasource, Dataset, and Table
- Add formatting to report
SSRS Project 2 (Movies Data)
- Create SSRS project and a report
- Use Group by in the report
- Use visibility and hidden functions in the report
- Add calculated field to the report
- Add parameters to the report - Part 1
- Add parameters to the report - Part 2
SSRS Project 3 (Employees Review)
- Create SSRS project and report
- Use visibility and hidden functions in report
- Use parameters to filter report data
- Use matrix in report
- Create a chart to visualize data
SSRS Project 4 (Car Sales)
- Create SSRS project and report
- Create a chart to visualize data
- Use matrix in report
SSRS Project 5 (Boston Crimes)
- Create SSRS project and report
- Use Group by in report - Part 1
- Use Group by in report - Part 2
- Use Group by in report - Part 3
- Create a chart to visualize data
SSRS Homework Project
- Introduction to homework
ETL Homework Project Solution
- Clean dataset in MS Excel
- Implement ETL prcess - Part 1
- Implement ETL prcess - Part 2
- Create Work Table for data analysis in SSMS
SSRS Homework Project Solution
- Number of issues
- Number of issues per year
- Products have most issues
- States have most issues
- Number of issues per bank(company)
- Number of issues that are not timely response
- Issues that are not closed yet
- Create a report using a matrix to address the number of issues per bank and year
- Create a chart showing number of issues in every month
- Final Course Rating
Instructors
Articles
Popular Articles
prev
next
