This educational path if for those who want to acquire practical skills in the field of building professional Business Intelligence systems. This course is for you, if:
The course is recommended for business analysts, controllers and IT workers who want to be specialists in building professional Data Warehouses. Generally speaking, you will be in your element if you have already had an experience with reporting and problems related to it. Your IT knowledge doesn’t really matter.
After completing the course you will be familiar with the latest trends in designing and building Business Intelligence solutions. You will be able to:
- design and implement professional Data Warehouse from scratch, which means:
- designing and building an ETL layer (data from many different systems, from cloud, files)
- designing and building an SQL layer (staging tables, fact and dimension tables, stored procedures)
- designing and building a data analysis layer (OLAP cubes, tabular models, dynamic KPI, perspectives, translations)
- building attractive and visual reports and dashboards (Power BI, Report Builder)
- use Excel to visualize data (pivot tables and charts) and to build minor BI solutions (Power Pivot)
You will be able to develop your practical skills through implementation a project of building professional Data Warehouses on SQL Server platform. It includes a specification of users’ expectations, a functional project, building a Data Warehouse for a particular enterprise, testing and preparing post-implementation documentation.
Additionally, you will gain skills and qualifications to build professional BI solutions for the company you work for. Thanks to them creating reports will be much faster, comfortable and will contain less errors.
|Subject / Description||Number of hours|
|Introduction to programming|
You will learn about basic rules of programming (core programming) in procedural and object-oriented paradigms. We will tell you about the rules of implementation of elementary algorithms (searching, sorting…), as well as basic data structures (stack, queue, list, tree, dictionary).
The subject is in 50% a preparation for MTA 98-361 exam: Software Development Fundamentals. Other issues will be addressed in: “Introduction to databases” and “Introduction to web technologies”.
|Introduction to databases (C)|
You will learn databases structure, process of design and implementation approaches. You will learn basics of SQL and you will encounter issues related to: security of databases, indexes and normalization.
The subject is a preparation for a Microsoft 98-364 exam: Database Fundamentals exam.
|Introduction to web technologies (C)|
The subject is a preparation for a Microsoft 98-375 exam: HTML5 App Development Fundamentals exam
|Data Warehouses (C)|
You will learn to design and implement Data Warehouses with a usage of MS SQL Server tools.
The subject is a preparation for a Microsoft 70-463 exam: Implementing a Data Warehouse with Microsoft SQL Server
|Databases - T-SQL (C)|
You will learn to use advanced instructions of SQL to create and modify database objects and to maintain data (including data in XML format) but also to search them in an aggregated form.
The subject is a preparation for a Microsoft 70-461 exam: Querying Microsoft SQL Server.
|Models of data analysis (C)|
You will learn to design and implement data analysis (OLAP cube, tabular models) in MS SQL Server environment. The subject will prepare you in 80% to a Microsoft 70-466 exam: Implementing Data Models and Reports with Microsoft.
The remaining 20% is devoted to Reporting Services, included in a subject called Reporting and Data Visualisation.
|Database systems administration (C)|
You will learn to maintain databases, optimize their performance, solve problems, create backups and secure data. The practical part will encompass MS SQL Server. The subject is a preparation for a Microsoft 70-462 exam: Administering Microsoft SQL Server.
|Reporting and data visualization|
You will discover tools needed to create visually advanced reports and dashboards (MS Report Builder, MS Power BI). You will learn to administer Reporting Services (create report subscriptions, manage delivery schedule and permissions)
| BI solutions design and exploitation in Excel|
You will learn how to use Excel pivot tables and charts to visualize data gathered in a Data Warehouse. You will also create local BI solutions with a usage of a Power Pivot tool.
|Application Lifecycle Management (C)|
You will learn how to manage IT projects of different scales. You will get acquainted with core software development principles (Agile, Scrum), you will learn how to define ALM process (meetings, sprints, collaboration tools), to plan software iterations and their earned values, you will understand the system responsible for code quality maintenance (unit tests, repositories, debugging tools). You will know how to skillfully move from implementation to the maintenance phase of an application.
The subject is a preparation for a Microsoft 70-498 exam: Delivering Continuous Value with Visual Studio Application Lifecycle Management exam.
|Designing a professional Business Intelligence system (P1)|
The first part of a series, which purpose is to create and implement a professional Data Warehouse that can constitute a commercial project as well as an Engineering Thesis. The project will be realised within a group of 2-3 people.
This stage is based on creating a specification of users’ needs and the following projects: efficient data exchange interfaces with external systems, analytical dimensions and OLAP cubes, reports, drill-down data structures and efficient data-mining algorithms.
|Creating a professional Business Intelligence system (P2)|
It is the second out of the three subjects, an objective of which is to create and implement (in a small team of 2-3 people) a professional Business Intelligence system that can constitute either a commercial project or an Engineering Thesis. At this stage, the team builds a professional Data Warehouse or a Business Intelligence system using a wide variety of SQL Server: Integration Services, Analysis Services and Reporting Services. The team creates OLAP cubes, statistical reports and dashboards. The best students will have an opportunity to carry out real projects in cooperation with our business partners.
|Professional Business Intelligence System documentation and servicing (P3)|
The last one out of the three subjects, an objective of which is to create and implement (in a small team of 2-3 people) a professional Data Warehouse or a Business Intelligence system that can constitute both a commercial project and an Engineering Thesis. The third stage includes making documentation of all layers: communication with external systems, processing and mechanisms of data consistency and integrity, an analytical layer, a structure of permissions and automation processes. Additionally, the team will design procedures of a Data Warehouse maintenance and extension and will support the system during the stabilization period.
(C) A subject preparing for a certification exam