Course Introduction (30 hrs.)
The main purpose of this program is to give audiences the ability to analyze their business data using BI techniques. The program goes beyond the capabilities of tables and charts and uses Pivot tables, Pivot Charts, Excel Data Model and Power BI. Much of the impetus behind this is the need for organizations to cope with ever-increasing datasets. It is now normal to have databases that contain millions of rows, requiring gigabytes, terabytes, or even petabytes, of storage space. Data is no longer confined to an on-premises server room—it is hosted in the cloud. Finally, this course helps you save time by preparing the underlying data correctly without needing an IT department to prepare it for you.
Program Added Value
After completing this program, audiences will be able to:
- Explain how to use data from the data warehouse.
- Enforce Data Quality
- Extract and load data
- Deploy SSIS
- Build a data warehouse.
- Analyze and clean data.
- Develop an ETL solution.
After completing this program, audiences will be able pass the following exams:
- Exam DP-300: Administering Microsoft Azure SQL Solutions
Program Prerequisites
Working knowledge of relational databases, including:
- Building a normalized database.
- It is preferable to be aware of essential company goals such as revenue, and financial accounting.
- Some familiarity with fundamental programming elements
- Transact-SQL querying.
- Establishing tables and relationships.
Program Topics
SQL server setup
Visual studio setup SSIS | SSRS | SSAS
Introduction to Data warehousing
Designing a data warehousing
Big data concepts
Creating ETL solutions with SSIS
Debugging and troubleshooting SSIS Packages
Implementing an incremental ETL process
Deploying and configure SSIS
Enforcing Data quality
Consuming data in a data warehouse
Attendees Required Resources:
Personal Laptop with at least Windows 10 & Office 2016 is required to access course LAB.