CouseSites

Master Data Warehousing, Dimensional Modeling & ETL process

Master Data Warehousing, Dimensional Modeling & ETL process

Do you want to learn how to implement a data warehouse in a modern way?

This is the only course you need to master architecting and implementing a data warehouse end-to-end!

Data Modeling and data warehousing is one of the most important skills in Business Intelligence!

This is the most comprehensive & most modern course you can find on data warehousing.

Here is why:

Most comprehenisve course with 9 hours video lectures

Learn from a real expert - crystal clear & straight-forward

Master theory & practice - hands-on demonstrations, assignments & quizzes

We will implement a complete data warehouse - end-to-end

Understand everything step by step from the absolute basics to the advanced topics

Learn the practical steps and the important theory to upskill your career

This course will take you all the way to being able to architect and implement a data warehouse in a company in a professional manner.

Here is what you'll learn:

Data Warehouse Basics

Data Warehouse architecture

Data Warehouse infrastructure

Data Modeling

Setting up an ETL process

Dimensional Modeling: Facts & Dimensions

Implementing a comeplete data warehouse hands-on

Slowly Changing Dimensions

Understanding ETL tools

ELT vs. ETL

Advanced topics like: Columnar storage, OLAP Cubes, In-memory databases, massive parallel processing & cloud data warehouses

Optimizing a data warehouse using indexes (B-tree indexes & Bitmap indexes)

Practically using and connecting a data warehouse

By the end of this course you will be able to design & build a complete data warehouse from the ground up. You will have the knowledge, the practical skills and the confidence to implement a modern data warehouse professionally.

Everything you need to be a highly proficient data architect, data engineer, data analyst or Business Intelligence expert!

Join now to get instant & lifetime access - of course backed by the no-questions-asked 30 days money back guarantee!

Data Warehousing & Visualization in Microsoft BI & Power BI

Learn ETL, Data Analysis and Visualization using Microsoft Excel, Microsoft Business Intelligence tools and Power 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.