https://i124.fastpic.org/big/2024/1210/a6/8da061d7dcd4258d13369a849411e0a6.jpg
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.
https://images2.imgbox.com/32/8e/ky3qaf9G_o.jpg
Download
Fikper
https://filecrypt.cc/Container/8BA005CE74.html
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
NitroFlare
https://filecrypt.cc/Container/22DD1A4564.html
Видео
