GK4399A Developing SQL Data Models (20768_B)

0% of 24 hours and 47 minutes completed.

In this course, you will learn about business intelligence (BI) solutions that implement multidimensional databases and create tabular semantic data models for analysis using SQL Server Analysis Services (SSAS).

This course incorporates material from the Official Microsoft Learning Product 20768: Developing SQL Data Models and can assist you in preparing for the 70-768: Developing SQL Data Models exam

After completing this course, you will be able to:

  • 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
There are no resources available.
0 attachments
0%
Introduction to Business Intelligence and Data Modeling
2 hours 4 minutes 18 Activities: Article  (0)  |  Lab  (6)  |  Video  (12)
0%
Creating Multidimensional Databases
2 hours 46 minutes 33 Activities: Article  (0)  |  Lab  (6)  |  Video  (27)
0%
Working with Cubes and Dimensions
3 hours 43 minutes 25 Activities: Article  (0)  |  Lab  (6)  |  Video  (19)
0%
Working with Measures and Measure Groups
2 hours 30 minutes 19 Activities: Article  (0)  |  Lab  (6)  |  Video  (13)
0%
Introduction to MDX
2 hours 7 minutes 23 Activities: Article  (0)  |  Lab  (6)  |  Video  (17)
0%
Customizing Cube Functionality
1 hour 58 minutes 20 Activities: Article  (0)  |  Lab  (6)  |  Video  (14)
0%
Implementing a Tabular Data Model by Using SQL Server Analysis Services
3 hours 3 minutes 27 Activities: Article  (0)  |  Lab  (6)  |  Video  (21)
0%
Introduction to Data Analysis Expressions (DAX)
3 hours 14 minutes 24 Activities: Article  (0)  |  Lab  (6)  |  Video  (18)
0%
Performing Predictive Analysis with Data Mining
2 hours 48 minutes 24 Activities: Article  (0)  |  Lab  (6)  |  Video  (18)
0%
Course Conclusion: GK4399A Developing SQL Data Models
1 minute 1 Activity: Article  (0)  |  Lab  (0)  |  Video  (1)
0%
End of Course Questions
25 minutes 25 Activities: Article  (0)  |  Lab  (25)  |  Video  (0)
0%
Survey
5 minutes 1 Activity: Article  (1)  |  Lab  (0)  |  Video  (0)