Learn Data Warehousing and Analysis with Microsoft BI Tools
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 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
Requirements
- Basic knowledge of SQL
Description
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.
Who this course is for:
- Anyone wants to learn data warehousing, data analysis, and ETL from scratch using Microsoft BI
Course content
- Preview03:42
- Preview02:13
- Preview00:54
- 1 questionWhich of the following steps is not part of data warehousing
- Preview02:55
- 1 questionWhich of the following is not a characteristic of OLAP
- 01:28What is ETL
- 1 questionWhich of the following two is correct
- 01:03What is Data Management
- 1 questionWhich of the following is not part of data management
- 00:16Course Rating
Instructor
![Data Science Guide](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 1,601 Reviews
- 3,680 Students
- 5 Courses
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 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.