M20768 Developing SQL Data Models -
Seminar / Kurs
von brainymotion AG
This course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. Students will learn to implement multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models.
1 - Introduction to Business Intelligence and Data ModelingIntroduction to Business IntelligenceThe Microsoft business intelligence platform2 - Creating Multidimensional DatabasesIntroduction to multidimensional analysisCreating data sources and data source viewsCreating a cubeOverview of cube security3 - Working with Cubes and DimensionsConfiguring dimensionsDefine attribute hierarchiesSorting and grouping attributes4 - Working with Measures and Measure GroupsWorking with measuresWorking with measure groups5 - Introduction to MDXMDX fundamentalsAdding calculations to a cubeUsing MDX to query a cube6 - Customizing Cube FunctionalityImplementing key performance indicatorsImplementing actionsImplementing perspectivesImplementing translations7 - Implementing a Tabular Data Model by Using Analysis ServicesIntroduction to tabular data modelsCreating a tabular data modelUsing an analysis services tabular model in an enterprise BI solution8 - Introduction to Data Analysis Expression (DAX)DAX fundamentalsUsing DAX to create calculated columns and measures in a tabular data model9 - Performing Predictive Analysis with Data MiningOverview of data miningUsing the data mining add-in for ExcelCreating a custom data mining solutionValidating a data mining modelConnecting to and consuming a data mining model