Developing SQL Data Models (Live-Online) - Webinar von PROTRANET GmbH
Inhalte
After completing this course, students will be able to:
- Describe the components, architecture, and nature of a BI solution
- Create a multidimensional database with analysis services
- Implement dimensions in a cube
- Implement measures and measure groups in a cube
- Use MDX syntax
- Customize a cube
- Implement a tabular database
- Use DAX to query a tabular model
- Use data mining for predictive analysis
After completing this course, students will be able to:
- Describe the components, architecture, and nature of a BI solution
- Create a multidimensional database with analysis services
- Implement dim ...
Lernziele
- Introduction to Business Intelligence and Data Modeling
- Creating Multidimensional Databases
- Working with Cubes and Dimensions
- Working with Measures and Measure Groups
- Introduction to MDX
- Customizing Cube Functionality
- Implementing a Tabular Data Model by Using Analysis Services
- Introduction to Data Analysis Expression (DAX)
- Performing Predictive Analysis with Data Mining
- Introduction to Business Intelligence and Data Modeling
- Creating Multidimensional Databases
- Working with Cubes and Dimensions
- Working with Measures and Measure Groups
- Introduction to MDX ...
Zielgruppen
The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. Primary responsibilities will include:
- Implementing multidimensional databases by using SQL Server Analysis Services
- Creating tabular semantic data models for analysis by using SQL Server Analysis Services
- The secondary audiences for this course are power information workers/data analysts.
The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. Primary responsibilities will include:
- Implementing multidime ...