SQL Server Analysis Services: Developing a Tabular Data Model

Provided by:
9/10 stars
based on  1 review
Provided by:
Cost FREE , Add a Verified Certificate for $49
Start Date TBA
SQL Server Analysis Services: Developing a Tabular Data Model

Course Details

Cost

FREE,
Add a Verified Certificate for $49

Upcoming Schedule

  • TBA

Course Provider

edX online courses
Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with edX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be tau...
Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with edX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be taught by David J. Malan, a senior lecturer on computer science at Harvard University for the School of Engineering and Applied Sciences. But there's not just one professor - you have access to the entire teaching staff, allowing you to receive feedback on assignments straight from the experts. Pursue a Verified Certificate to document your achievements and use your coursework for job and school applications, promotions, and more. EdX also works with top universities to conduct research, allowing them to learn more about learning. Using their findings, edX is able to provide students with the best and most effective courses, constantly enhancing the student experience.

Provider Subject Specialization
Sciences & Technology
Business & Management
22043 reviews

Course Description

If you need intuitive, interactive and high-performance access to your data—and especially if you have large volumes of data—then this course is for you.

Whether you're new to Analysis Services or are experienced with earlier versions, this course will teach you all the information you need to develop a tabular data model. You will learn how to import tables of data from different sources and relate them to form the foundation of your model. You will then learn how to enhance your model with usability features, such as hierarchies.

Next, you will learn how to enhance your model with business logic. You will learn how to create calculated columns, tables and measures using DAX, the language of tabular models.

Additional topics include how to manage a tabular database -- including table storage, processing, permissions and deployment -- and  how to deploy your tabular model to the cloud with Azure Analysis Services.

Fi...

If you need intuitive, interactive and high-performance access to your data—and especially if you have large volumes of data—then this course is for you.

Whether you're new to Analysis Services or are experienced with earlier versions, this course will teach you all the information you need to develop a tabular data model. You will learn how to import tables of data from different sources and relate them to form the foundation of your model. You will then learn how to enhance your model with usability features, such as hierarchies.

Next, you will learn how to enhance your model with business logic. You will learn how to create calculated columns, tables and measures using DAX, the language of tabular models.

Additional topics include how to manage a tabular database -- including table storage, processing, permissions and deployment -- and  how to deploy your tabular model to the cloud with Azure Analysis Services.

Finally, this course will teach you how to compare the two types of Analysis Services models: tabular and multidimensional. This will help you to determine the appropriate data model for your project.

By the end of the course, you will have designed, developed and deployed a tabular model, and you will be ready to deliver high-performance business user experiences.

The course includes comprehensive hands-on exercises that enable you to directly apply the lessons with sample data.

Note: To complete the hands-on elements in this course, you will require an Azure subscription. You can sign up for a free Azure trial subscription (a valid credit card is required for verification, but you will not be charged for Azure services). Note that the free trial is not available in all regions. It is possible to complete the course and earn a certificate without completing the hands-on practices.

SQL Server Analysis Services: Developing a Tabular Data Model course image
Reviews 9/10 stars
1 Review for SQL Server Analysis Services: Developing a Tabular Data Model

Ratings details

  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.

Sort By
Daniel Bierza profile image
Daniel Bierza profile image

Daniel Bierza

10/10 starsCompleted
1 year, 10 months ago
Thanks Peter. It was a nice course about Tabular. Excellent overview. I can recommend this course. Good!
Was this review helpful? Yes0
 Flag

Rating Details


  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.