Developing Microsoft SQL Data 2016 Models
- Overview: Developing SQL Data Models
- Overview: Introduction to Business Intelligence and Data Modeling
- Lesson 1: Overview of Business Intelligence and Data Models
- Lesson 2: Microsoft Business Intelligence Platform
- Lab 1: Exploring a Business Intelligence Solution
- Overview: Creating Multidimensional Databases
- Lesson 1: Introduction to Multidimensional Analysis
- Lesson 2: Data Sources and Data Source Views
- Lesson 3: Cubes
- Lesson 4: Overview of Cube Security
- Lesson 5: Configuring SSAS
- Lesson 6: Monitoring SSAS
- Lab 2: Creating a Multidimensional Database
- Overview: Working with Cubes and Dimensions
- Lesson 1: Configuring Dimensions
- Lesson 2: Defining Attribute Hierarchies
- Lesson 3: Implementing Sorting and Grouping for Attributes
- Lesson 4: Slowly Changing Dimensions
- Lab 3: Working with Cubes and Dimensions
- Overview: Working with Measures and Measure Groups
- Lesson 1: Working with Measures
- Lesson 2: Working with Measure Groups
- Lab 4: Configuring Measures and Measure Groups
- Overview: Introduction to MDX
- Lesson 1: MDX Fundamentals
- Lesson 2: Adding Calculations to a Cube
- Lesson 3: Using MDX to Query a Cube
- Lab 5: Using MDX
- Overview: Customizing Cube Functionality
- Lesson 1: Implementing Key Performance Indicators
- Lesson 2: Implementing Actions
- Lesson 3: Implementing Perspectives
- Lesson 4: Implementing Translations
- Lab 6: Customizing a Cube
- Overview: Implementing a Tabular Data Model by Using SQL Server Analysis Services
- Lesson 1: Introduction to Tabular Data Models in SQL Server Analysis Services
- Lesson 2: Creating a Tabular Data Model
- Lesson 3: Using a SQL Server Analysis Services Tabular Model in an Enterprise BI Solution
- Lab 7: Implementing a Tabular Data Model in SQL Server Analysis Services
- Overview: Introduction to Data Analysis Expressions (DAX)
- Lesson 1: DAX Fundamentals
- Lesson 2: Using DAX to Create Calculated Columns and Measures in a Tabular Data Model
- Lab 8: Using DAX to Enhance a Tabular Data Model
- Overview: Performing Predictive Analysis with Data Mining
- Lesson 1: Overview of Data Mining
- Lesson 2: Creating a Custom Data Mining Solution
- Lesson 3: Validating a Data Mining Model
- Lesson 4: Connecting to and Consuming a Data Mining Model
- Lab 9: Using Data Mining to Support a Marketing Campaign
Az oktatóról
Fő tématerülete az Adatbáziskezelés az MS Access-től az MS SQL Serveren át az üzleti intelligencia (BI) rendszerekig. Microsoft oktató (MCT) és szakértő (MCSE). Fő hitvallása, hogy nem elég egy témát oktatni, ki is kell a való életben próbálni. Mivel az oktatás és a szoftverfejlesztés nagyon jó szimbiózist alkot, ezért számos MS Access és SQL Server alapú szoftvere működik különféle cégeknél 2021-ben is.
