Microsoft Sql Server Analysis Services - Ssas (Tabular Dax)

[kingers]

Microsoft Sql Server Analysis Services - Ssas (Tabular Dax)
Published 11/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.92 GB | Duration: 5h 8m

Visualise Data in SQL Server Analysis Services (SSAS) with DAX. Business Intelligence PowerPivot tool.

What you'll learn

Extract data from multiple tables.

Create connections between the tables.

Develop the model using DAX functions.

Create analyses in Excel.

Requirements

You don't need to know or do anything before starting this course.

I'll show you have to download the Developer Edition of SQL Server 2022 for FREE. Previous versions cost $100.

Description

This course covers the Tabular model in SQL Server Analytical Services.We'll install SQL Server Developer onto your computer, which previously used to cost $100, together with the SSAS extension.We'll then create our first analysis using SQL Server in just a matter of minutes.After this introduction, we'll go into some detail into how to create your analyses in Excel, including advanced Pivot Table options that most people don't even know about, but which are very useful. This includes slicers, timelines, and non-Visual Totals.Then we'll develop DAX formulas, to further extend the model. A lot of the formulas are based on Excel formulas, but there are several additional things too. We'll create calculated columns, which are replicated in each row, and measures, which are summary calculations. We'll have a look at logical, aggregations, statistical, mathematical, text, information, filter and value, and time intelligence functions.Finally, I'll show you how you can do similar things in Microsoft Excel.By the end of this course, you will be able to create reliable analyses in Visual Studio, deploy them into SQL Server Analytical Services, drilled down the results quickly in Excel, and you'll be able to help others with their data analysis.

Overview

Section 1: Introduction

Lecture 1 Welcome

Lecture 2 Welcome to Udemy

Lecture 3 Introduction to Udemy

Lecture 4 Do you want auto-translated subtitles in more languages?

Lecture 5 Curriculum

Lecture 6 Resources

Section 2: Installing SQL Server and Visual Studio 2022

Lecture 7 Downloading SQL Server Developer 2022

Lecture 8 Installing SQL Server Developer 2022

Lecture 9 Installing SQL Server Management Studio (SSMS)

Lecture 10 Installing Visual Studio 2022

Lecture 11 Installing SSAS in Visual Studio 2022

Lecture 12 Is your Visual Studio a trial version? No!

Section 3: Creating our first model

Lecture 13 Downloading and Attaching AdventureWorksDW

Lecture 14 Creating our first model in SSAS

Lecture 15 Creating a PivotTable analysis from our first SSAS model

Lecture 16 Adding additional tables

Lecture 17 Importing data from other data sources

Lecture 18 Practice Activity Number 1

Lecture 19 Practice Activity Number 1 - The Solution

Lecture 20 Deploying our model and querying in SSMS

Section 4: Developing the Data Model

Lecture 21 Filtering, sorting and formatting fields

Lecture 22 Hiding columns from Client Tools, and other column tools

Lecture 23 Refreshing (or processing) data

Lecture 24 Creating quick measures

Lecture 25 Perspectives

Lecture 26 Hierarchies

Lecture 27 Practice Activity Number 2

Lecture 28 Practice Activity Number 2 - The Solution

Lecture 29 Practice Activity Number 3

Lecture 30 Practice Activity Number 3 - The Solution

Section 5: Pivot Tables functionality

Lecture 31 PivotTable structure, and non-Visual Totals

Lecture 32 Show no data in rows and columns

Lecture 33 Create running totals

Lecture 34 Filters and Slicers

Lecture 35 Using formulas to query Data Model (Advanced)

Lecture 36 Practice Activity Number 4

Lecture 37 Practice Activity Number 4 - The Solution

Section 6: An introduction to DAX functions, including Logical functions

Lecture 38 Calculated columns and Basic Operators

Lecture 39 DAX functions and the IF function

Lecture 40 BLANK and ISBLANK

Lecture 41 AND, OR and NOT

Lecture 42 SWITCH

Lecture 43 Other functions

Lecture 44 Practice Activity Number 5

Section 7: Statistical functions

Lecture 45 Measures as Aggregation of columns

Lecture 46 Measures as Aggregation of calculations

Lecture 47 DISTINCTCOUNT

Lecture 48 Practice Activity Number 6

Section 8: Mathematical functions

Lecture 49 Rounding functions

Lecture 50 Division functions - MOD and QUOTIENT

Lecture 51 SIGN (and use with SWITCH) and ABS

Lecture 52 Exponential functions

Lecture 53 Other functions

Lecture 54 Practice Activity Number 7

Section 9: Text functions

Lecture 55 Text searching

Lecture 56 Text extraction and substitution

Lecture 57 Text conversion

Lecture 58 Other functions

Lecture 59 Practice Activity Number 8

Section 10: Information Functions

Lecture 60 ISERROR and LOOKUPVALUE

Lecture 61 Other functions

Lecture 62 Practice Activity Number 9

Section 11: Filter and Value Functions

Lecture 63 RELATED

Lecture 64 RELATEDTABLE and COUNTROWS

Lecture 65 Context

Lecture 66 FILTER

Lecture 67 ALL

Lecture 68 CALCULATE

Lecture 69 ALLEXCEPT

Lecture 70 ALLSELECTED

Lecture 71 Other functions

Lecture 72 Practice Activity Number 10

Section 12: Date Functions

Lecture 73 Date and Time Functions

Section 13: Time Intelligence Functions

Lecture 74 FIRSTDATE, LASTDATE

Lecture 75 Start of. and End of.

Lecture 76 Previous. and Next.

Lecture 77 DATESINPERIOD

Lecture 78 DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD

Lecture 79 Opening Balance and Closing Balance

Lecture 80 SAMEPERIODLASTYEAR and PARALLELPERIOD

Lecture 81 Other Functions

Lecture 82 Practice Activity Number 12

Section 14: Conclusion

Lecture 83 Thank you for watching.

This course is for people who want to create analyses.,You either want to do learn about SQL Server Analytical Services (Tabular edition).,This course isn't for you if you want to learn SSAS (MDX version) - there are other courses for this.


[center]Download
Fikper

https://fikper.com/KwrcsNsmow/Udemy_Microsoft_SQL_Server_Analysis_Services_SSAS_Tabular_DAX.part1.rar.html
https://fikper.com/JEMGiyHwyR/Udemy_Microsoft_SQL_Server_Analysis_Services_SSAS_Tabular_DAX.part2.rar.html

RapidGator

https://rapidgator.net/file/b55ed1c17b38898a332e511e153e71c5/Udemy_Microsoft_SQL_Server_Analysis_Services_SSAS_Tabular_DAX.part1.rar
https://rapidgator.net/file/3afffafae6acc6047feee9743fd4288c/Udemy_Microsoft_SQL_Server_Analysis_Services_SSAS_Tabular_DAX.part2.rar

NitroFlare

https://nitroflare.com/view/15B808D604BD4BB/Udemy_Microsoft_SQL_Server_Analysis_Services_SSAS_Tabular_DAX.part1.rar
https://nitroflare.com/view/EFCA8F28C7E51C6/Udemy_Microsoft_SQL_Server_Analysis_Services_SSAS_Tabular_DAX.part2.rar[/center]