Module 1: Introduction to Business Intelligence and Data Modeling
- Introduction to Business Intelligence
- The Microsoft business intelligence platform
Module 2: Creating Multidimensional Databases
- Introduction to Multidimensional Analysis
- Data Sources and Data Source Views
- Cubes
- Overview of Cube Security
- Configure SSAS
- Monitoring SSAS
Mobile 3: Working with Cubes and Dimensions
- Configuring Dimensions
- Defining Attribute Hierarchies
- Implementing Sorting and Grouping Attributes
- Slowly Changing Dimensions
Module 4: Working with Measures and Measure Groups
- Working with Measures
- Working with Measure Groups
Mobile 5: Introduction to MDX
- MDX fundamentals
- Adding Calculations to a Cube
- Using MDX to Query a Cube
Module 6: Customizing Cube Functionality
- Implementing Key Performance Indicators
- Implementing Actions
- Implementing Perspectives
- Implementing Translations
Module 7: Implementing a Tabular Data Model by Using Analysis Services
- Introduction to Tabular Data Models
- Creating a Tabular Data Model
- Using an Analysis Services Tabular Data Model in an Enterprise BI Solution
Module 8: Introduction to Data Analysis Expression (DAX)
- DAX Fundamentals
- Using DAX to Create Calculated Columns and Measures in a Tabular Data Model
Module 9: Performing Predictive Analysis with Data Mining
- Overview of Data Mining
- Creating a Custom Data Mining Solution
- Validating a Data Mining Model
- Connecting to and Consuming a Data-Mining Model
- Using the Data Mining add-in for Excel
Benefiti:
- Video snimak predavanja u periodu od 365 dana posle kraja obuke
- Pristup laboratorijama putem Interneta 180 dana od kraja obuke
- Materijal u elektronskom obliku
- Zvaničan Microsoft sertifikat o pohađanju kursa
- Mogućnost korišćenja Microsoft SA vaučera za plaćanje ove obuke
Poželjno predznanje:
Before attending this course, students must have:
- Experience of querying data using Transact-SQL
Dalje usavršavanje:
Analyzing Data with Excel (MS20779)
Analyzing Data with Power BI (MS20778)