SQL Server Analysis Services

Focused View

Ginger Grant

2:22:17

155 View

01 - Introduction

01 - Scalable data modeling with Analysis Services Tabular.mp4

00:50

02 - Background skills.mp4

00:39

02 - 1. Introducing Analysis Service Tabular

01 - Analysis Services Tabular.mp4

01:03

02 - Installing SQL Server and Analysis Services.mp4

06:34

03 - Installing SQL Server Management Studio.mp4

01:34

04 - Restoring data.mp4

02:08

05 - Installing Visual Studio and testing with Excel.mp4

05:24

03 - 2. Creating a Data Model

01 - Introduction to data modeling in Analysis Services Tabular.mp4

01:06

02 - Creating your first Analysis Services project.mp4

02:10

03 - Create a data source to SQL Server.mp4

03:08

04 - Adding other data sources.mp4

04:13

05 - Challenge Create and test your model.mp4

04:17

06 - Solution Create and test your model.mp4

05:10

04 - 3. Creating Measures with DAX

01 - Providing business insight with DAX measures.mp4

02:25

02 - Creating tables in DAX.mp4

02:43

03 - Developing calculated measures.mp4

07:01

04 - Using the CALCULATE function.mp4

11:04

05 - Challenge Calculate measures.mp4

01:57

06 - Solution Calculate measures.mp4

02:22

05 - 4. Time Intelligence Calculations

01 - Incorporating time intelligence.mp4

02:56

02 - All about the date table.mp4

04:38

03 - Examining three popular DAX time intelligence functions SAMEPERIODLASTYEAR, PARALLELPERIOD, and TOTALYTD.mp4

09:22

04 - Writing DATESBETWEEN measures.mp4

07:14

05 - Challenge Time intelligence measures.mp4

03:18

06 - Solution Time intelligence measures.mp4

02:32

06 - 5. Advanced Modeling

01 - Examining different modeling relationships.mp4

04:23

02 - Active and inactive relationships.mp4

05:31

03 - Resolving issues with inactive relationships with USERELATIONSHIP.mp4

03:17

04 - Challenge USERELATIONSHIP measures.mp4

02:23

05 - Solution USERELATIONSHIP measures.mp4

01:39

07 - 6. Row-Level Security

01 - Restricting data for different users.mp4

03:18

02 - Modifications to the model to support row-level security.mp4

04:10

03 - Implementing roles in your model to restrict data.mp4

03:29

04 - Challenge Implement model security.mp4

02:45

05 - Solution Implement model security.mp4

02:23

08 - 7. Deploying the Model

01 - Review of deployment steps.mp4

03:18

02 - Troubleshooting potential deployment issues.mp4

04:13

03 - Review of how to test the model in SQL Server Management Studio.mp4

03:58

09 - Conclusion

01 - Learn more about Analysis Services.mp4

01:42

Description

SQL Server Analysis Services Tabular can help you analyze your data more effectively—even if you have a large volume of data to sort through—organizing and storing your data so that you can find trends by looking at data summaries. In this course, Ginger Grant provides high-level overview SQL Server Analysis Services Tabular, with real-world examples, to help you gain insights from your data and plan for the future. Ginger shows you how to install the required complex development environment outside of SQL Server Management studio and explains the benefits of creating a data model in Analysis Services. Advanced topics include how to extend the analysis using DAX, an in-depth look at the model components, and how the different relationships change the way the data is displayed.

Join Ginger in this course to learn how to organize and store your data in a way that makes it easier to find trends and draw conclusions—and move beyond spreadsheets!

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Data Analysis

Database Programming

Microsoft SQL

Ginger Grant

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.