| 001 Congratulations.mp4 | 22.4 MB | ||
| 001 Congratulations_en.vtt | 1.8 KB | ||
| 001 Congratulations_es.vtt | 1.9 KB | ||
| 001 Creating our first project.mp4 | 24 MB | ||
| 001 Creating our first project_en.vtt | 5 KB | ||
| 001 Creating our first project_es.vtt | 5.3 KB | ||
| 001 Downloading SQL Server Developer 2019.mp4 | 46.8 MB | ||
| 001 Downloading SQL Server Developer 2019_en.vtt | 9.3 KB | ||
| 001 Downloading SQL Server Developer 2019_es.vtt | 8.2 KB | ||
| 001 Getting YTD and MTD to work.mp4 | 67.5 MB | ||
| 001 Getting YTD and MTD to work_en.vtt | 10.2 KB | ||
| 001 Getting YTD and MTD to work_es.vtt | 10.9 KB | ||
| 001 Introduction to KPIs.mp4 | 19.2 MB | ||
| 001 Introduction to KPIs_en.vtt | 9 KB | ||
| 001 Introduction to KPIs_es.vtt | 9.6 KB | ||
| 001 Introduction.mp4 | 22.6 MB | ||
| 001 Introduction_en.vtt | 4.3 KB | ||
| 001 Introduction_es.vtt | 4.7 KB | ||
| 001 MDX Resources.html | 307.2 B | ||
| 001 Opening a cube in Excel, both through Visual Studio and making a connection.mp4 | 62.4 MB | ||
| 001 Opening a cube in Excel, both through Visual Studio and making a connection_en.vtt | 12.3 KB | ||
| 001 Opening a cube in Excel, both through Visual Studio and making a connection_es.vtt | 13 KB | ||
| 001 Parents and children.mp4 | 35.5 MB | ||
| 001 Parents and children_en.vtt | 6.1 KB | ||
| 001 Parents and children_es.vtt | 6.5 KB | ||
| 001 Practice Activity - Let's do it again!.mp4 | 29.5 MB | ||
| 001 Practice Activity - Let's do it again!_en.vtt | 9.4 KB | ||
| 001 Practice Activity - Let's do it again!_es.vtt | 10 KB | ||
| 001 Referring to Dimensions, Hierarchies, Levels and Members.mp4 | 45.2 MB | ||
| 001 Referring to Dimensions, Hierarchies, Levels and Members_en.vtt | 11.9 KB | ||
| 001 Referring to Dimensions, Hierarchies, Levels and Members_es.vtt | 12.7 KB | ||
| 001 Subcubes.mp4 | 24.3 MB | ||
| 001 Subcubes_en.vtt | 9.9 KB | ||
| 001 Subcubes_es.vtt | 10.6 KB | ||
| 001 topcount, toppercent, bottomcount, bottompercent.mp4 | 31.3 MB | ||
| 001 topcount, toppercent, bottomcount, bottompercent_en.vtt | 8.2 KB | ||
| 001 topcount, toppercent, bottomcount, bottompercent_es.vtt | 9.1 KB | ||
| 002 Ancestors and Ascendants.mp4 | 18.9 MB | ||
| 002 Ancestors and Ascendants_en.vtt | 6.3 KB | ||
| 002 Ancestors and Ascendants_es.vtt | 6.7 KB | ||
| 002 Bonus - An overview of SQL Server.mp4 | 12.4 MB | ||
| 002 Bonus - An overview of SQL Server_en.vtt | 4.9 KB | ||
| 002 Bonus - An overview of SQL Server_es.vtt | 5 KB | ||
| 002 Creating sets.mp4 | 51.5 MB | ||
| 002 Creating sets_en.vtt | 8.6 KB | ||
| 002 Creating sets_es.vtt | 9.3 KB | ||
| 002 Default measure, and using the WHERE clause for measures.mp4 | 64 MB | ||
| 002 Default measure, and using the WHERE clause for measures_en.vtt | 13.1 KB | ||
| 002 Default measure, and using the WHERE clause for measures_es.vtt | 14.1 KB | ||
| 002 Hierarchize.mp4 | 47.7 MB | ||
| 002 Hierarchize_en.vtt | 8.9 KB | ||
| 002 Hierarchize_es.vtt | 9.4 KB | ||
| 002 Installing SQL Server Developer 2019.mp4 | 47.1 MB | ||
| 002 Installing SQL Server Developer 2019_en.vtt | 12.7 KB | ||
| 002 Installing SQL Server Developer 2019_es.vtt | 12.9 KB | ||
| 002 LastPeriods - going into the past.mp4 | 18.9 MB | ||
| 002 LastPeriods - going into the past_en.vtt | 5.8 KB | ||
| 002 LastPeriods - going into the past_es.vtt | 6.2 KB | ||
| 002 Looking at our working environment, and Facts, Measures, Dimensions and Cubes.mp4 | 23.8 MB | ||
| 002 Looking at our working environment, and Facts, Measures, Dimensions and Cubes_en.vtt | 11.3 KB | ||
| 002 Looking at our working environment, and Facts, Measures, Dimensions and Cubes_es.vtt | 12.1 KB | ||
| 002 More SSAS PivotTable functionality.mp4 | 34.3 MB | ||
| 002 More SSAS PivotTable functionality_en.vtt | 9 KB | ||
| 002 More SSAS PivotTable functionality_es.vtt | 9.6 KB | ||
| 002 Practice Activity - your instructions.html | 716.8 B | ||
| 002 Quiz - referring to Dim Date dimensions, hierarchy, levels and members.mp4 | 11.5 MB | ||
| 002 Quiz - referring to Dim Date dimensions, hierarchy, levels and members_en.vtt | 5.1 KB | ||
| 002 Quiz - referring to Dim Date dimensions, hierarchy, levels and members_es.vtt | 5.3 KB | ||
| 002 Revisiting parallelperiod.mp4 | 23.6 MB | ||
| 002 Revisiting parallelperiod_en.vtt | 6.3 KB | ||
| 002 Revisiting parallelperiod_es.vtt | 6.7 KB | ||
| 002 Welcome to Udemy.html | 921.6 B | ||
| 003 Adding measures onto the Column axis, and creating a Set of measures.mp4 | 28 MB | ||
| 003 Adding measures onto the Column axis, and creating a Set of measures_en.vtt | 9.5 KB | ||
| 003 Adding measures onto the Column axis, and creating a Set of measures_es.vtt | 10.2 KB | ||
| 003 Creating a Data Connection.mp4 | 17.8 MB | ||
| 003 Creating a Data Connection_en.vtt | 7.7 KB | ||
| 003 Creating a Data Connection_es.vtt | 9.4 KB | ||
| 003 Descendants, firstchild and lastchild.mp4 | 12.1 MB | ||
| 003 Descendants, firstchild and lastchild_en.vtt | 4.6 KB | ||
| 003 Descendants, firstchild and lastchild_es.vtt | 4.9 KB | ||
| 003 Installing SQL Server Management Studio.mp4 | 37.9 MB | ||
| 003 Installing SQL Server Management Studio_en.vtt | 7.5 KB | ||
| 003 Installing SQL Server Management Studio_es.vtt | 7.9 KB | ||
| 003 Introduction to Udemy.mp4 | 9.8 MB | ||
| 003 Introduction to Udemy_en.vtt | 3.5 KB | ||
| 003 Introduction to Udemy_es.vtt | 3.6 KB | ||
| 003 Order.mp4 | 22.1 MB | ||
| 003 Order_en.vtt | 9.8 KB | ||
| 003 Order_es.vtt | 10.5 KB | ||
| 003 ParallelPeriod, and combining with YTD.mp4 | 19.4 MB | ||
| 003 ParallelPeriod, and combining with YTD_en.vtt | 6.5 KB | ||
| 003 ParallelPeriod, and combining with YTD_es.vtt | 7.2 KB | ||
| 003 Practice Activity - The Solution.mp4 | 44.7 MB | ||
| 003 Practice Activity - The Solution_en.vtt | 8.7 KB | ||
| 003 Practice Activity - The Solution_es.vtt | 9.6 KB | ||
| 003 The CASE statement.mp4 | 24.3 MB | ||
| 003 The CASE statement_en.vtt | 6.7 KB | ||
| 003 The CASE statement_es.vtt | 7 KB | ||
| 003 UNION and RANK.mp4 | 20.9 MB | ||
| 003 UNION and RANK_en.vtt | 5.7 KB | ||
| 003 UNION and RANK_es.vtt | 6.3 KB | ||
| 003 Using MDX queries in SSRS.mp4 | 52 MB | ||
| 003 Using MDX queries in SSRS_en.vtt | 11.9 KB | ||
| 003 Using MDX queries in SSRS_es.vtt | 12.9 KB | ||
| 003 Visual Studio - changing the appearance and order of months of the year.mp4 | 77 MB | ||
| 003 Visual Studio - changing the appearance and order of months of the year_en.vtt | 13.3 KB | ||
| 003 Visual Studio - changing the appearance and order of months of the year_es.vtt | 14.2 KB | ||
| 004 Creating a Data Source View.mp4 | 22.1 MB | ||
| 004 Creating a Data Source View_en.vtt | 9.7 KB | ||
| 004 Creating a Data Source View_es.vtt | 10.5 KB | ||
| 004 Do you want auto-translated subtitles in more languages.html | 2.2 KB | ||
| 004 Filter.mp4 | 17.9 MB | ||
| 004 Filter_en.vtt | 7.7 KB | ||
| 004 Filter_es.vtt | 8.2 KB | ||
| 004 Go.html | 307.2 B | ||
| 004 IIF - an alternative to CASE.mp4 | 12.3 MB | ||
| 004 IIF - an alternative to CASE_en.vtt | 3.6 KB | ||
| 004 IIF - an alternative to CASE_es.vtt | 3.7 KB | ||
| 004 Installing Visual Studio 2019.mp4 | 33.3 MB | ||
| 004 Installing Visual Studio 2019_en.vtt | 6.7 KB | ||
| 004 Installing Visual Studio 2019_es.vtt | 6.6 KB | ||
| 004 Intersect and Except.mp4 | 13.3 MB | ||
| 004 Intersect and Except_en.vtt | 5.6 KB | ||
| 004 Intersect and Except_es.vtt | 6.2 KB | ||
| 004 Practice Activity Number 7.html | 512 B | ||
| 004 Referring to multiple members and Using the Range operator.mp4 | 30.6 MB | ||
| 004 Referring to multiple members and Using the Range operator_en.vtt | 9.9 KB | ||
| 004 Referring to multiple members and Using the Range operator_es.vtt | 10.4 KB | ||
| 004 Siblings functions.mp4 | 38.6 MB | ||
| 004 Siblings functions_en.vtt | 11.6 KB | ||
| 004 Siblings functions_es.vtt | 12.4 KB | ||
| 004 Updating dimensions, and creating translations.mp4 | 87.4 MB | ||
| 004 Updating dimensions, and creating translations_en.vtt | 16.5 KB | ||
| 004 Updating dimensions, and creating translations_es.vtt | 18 KB | ||
| 005 Adding a new table into the Data Source View, and replacing it with a query.mp4 | 42 MB | ||
| 005 Adding a new table into the Data Source View, and replacing it with a query_en.vtt | 8.1 KB | ||
| 005 Adding a new table into the Data Source View, and replacing it with a query_es.vtt | 8.7 KB | ||
| 005 Creating a Cube.mp4 | 21.1 MB | ||
| 005 Creating a Cube_en.vtt | 9.3 KB | ||
| 005 Creating a Cube_es.vtt | 9.9 KB | ||
| 005 Creating a temporary measure using MDX.mp4 | 23.7 MB | ||
| 005 Creating a temporary measure using MDX_en.vtt | 11.5 KB | ||
| 005 Creating a temporary measure using MDX_es.vtt | 12.3 KB | ||
| 005 Getting rid of NULLs - using Non Empty.mp4 | 42.9 MB | ||
| 005 Getting rid of NULLs - using Non Empty_en.vtt | 5.4 KB | ||
| 005 Getting rid of NULLs - using Non Empty_es.vtt | 5.7 KB | ||
| 005 Installing SSAS in Visual Studio 2019.mp4 | 17 MB | ||
| 005 Installing SSAS in Visual Studio 2019_en.vtt | 3.2 KB | ||
| 005 Installing SSAS in Visual Studio 2019_es.vtt | 3.3 KB | ||
| 005 IsEmpty.mp4 | 16.6 MB | ||
| 005 IsEmpty_en.vtt | 4.7 KB | ||
| 005 IsEmpty_es.vtt | 5 KB | ||
| 005 Practice Activity Number 6.html | 1 KB | ||
| 005 Practice Activity Number 7 - Solution.mp4 | 35.9 MB | ||
| 005 Practice Activity Number 7 - Solution_en.vtt | 9.6 KB | ||
| 005 Practice Activity Number 7 - Solution_es.vtt | 10.3 KB | ||
| 005 Practice Activity Number 8.html | 512 B | ||
| 005 Which version of Visual Studio should I install.html | 819.2 B | ||
| 005 format_string.mp4 | 36.4 MB | ||
| 005 format_string_en.vtt | 12 KB | ||
| 005 format_string_es.vtt | 12.7 KB | ||
| 006 Adding a hierarchy - two levels.mp4 | 36.1 MB | ||
| 006 Adding a hierarchy - two levels_en.vtt | 7.5 KB | ||
| 006 Adding a hierarchy - two levels_es.vtt | 8.1 KB | ||
| 006 Creating a permanent measure using Visual Studio.mp4 | 25.6 MB | ||
| 006 Creating a permanent measure using Visual Studio_en.vtt | 7.9 KB | ||
| 006 Creating a permanent measure using Visual Studio_es.vtt | 8.4 KB | ||
| 006 Creating a role, and playing with the cube.mp4 | 18.3 MB | ||
| 006 Creating a role, and playing with the cube_en.vtt | 7.3 KB | ||
| 006 Creating a role, and playing with the cube_es.vtt | 7.9 KB | ||
| 006 Creating a tuple.mp4 | 59.5 MB | ||
| 006 Creating a tuple_en.vtt | 12.7 KB | ||
| 006 Creating a tuple_es.vtt | 13.5 KB | ||
| 006 Formatting using custom coding.mp4 | 64.8 MB | ||
| 006 Formatting using custom coding_en.vtt | 12.2 KB | ||
| 006 Introduction to Practice Activity 10.mp4 | 12.9 MB | ||
| 006 Introduction to Practice Activity 10_en.vtt | 4.1 KB | ||
| 006 Introduction to Practice Activity 10_es.vtt | 4.3 KB | ||
| 006 Is your Visual Studio a trial version No!.mp4 | 6.1 MB | ||
| 006 Is your Visual Studio a trial version No!_en.vtt | 2.2 KB | ||
| 006 Is your Visual Studio a trial version No!_es.vtt | 2.3 KB | ||
| 006 Practice Activity Number 6 - Solution.mp4 | 40.7 MB | ||
| 006 Practice Activity Number 6 - Solution_en.vtt | 7.2 KB | ||
| 006 Practice Activity Number 6 - Solution_es.vtt | 7.6 KB | ||
| 006 Practice Activity Number 8 - Solution_en.vtt | 8.7 KB | ||
| 007 Adding a hierarchy - three levels.mp4 | 31.9 MB | ||
| 007 Adding a hierarchy - three levels_en.vtt | 10.3 KB | ||
| 007 Adding a hierarchy - three levels_es.vtt | 11 KB | ||
| 007 AdventureWorks.html | 409.6 B | ||
| 007 Changing the aggregation using tuples.mp4 | 30 MB | ||
| 007 Changing the aggregation using tuples_en.vtt | 9.2 KB | ||
| 007 Changing the aggregation using tuples_es.vtt | 9.7 KB | ||
| 007 Looking at the cube using Excel.mp4 | 6.3 MB | ||
| 007 Looking at the cube using Excel_en.vtt | 3 KB | ||
| 007 Looking at the cube using Excel_es.vtt | 3.1 KB | ||
| 007 Practice Activity Number 10.html | 1.1 KB | ||
| 007 Practice Activity Number 4.html | 614.4 B | ||
| 008 Adding an extra table, and Creating a dimension.mp4 | 17.2 MB | ||
| 008 Adding an extra table, and Creating a dimension_en.vtt | 6.5 KB | ||
| 008 Adding an extra table, and Creating a dimension_es.vtt | 7 KB | ||
| 008 Downloading AdventureWorks.mp4 | 21.7 MB | ||
| 008 Downloading AdventureWorks_en.vtt | 5 KB | ||
| 008 Downloading AdventureWorks_es.vtt | 4.1 KB | ||
| 008 Introduction to Practice Activity 3.mp4 | 9.1 MB | ||
| 008 Introduction to Practice Activity 3_en.vtt | 4.4 KB | ||
| 008 Introduction to Practice Activity 3_es.vtt | 4.6 KB | ||
| 008 Practice Activity Number 10 - Solution.mp4 | 21.4 MB | ||
| 008 Practice Activity Number 10 - Solution_en.vtt | 6.9 KB | ||
| 008 Practice Activity Number 4 - Solution.mp4 | 53.6 MB | ||
| 008 Practice Activity Number 4 - Solution_en.vtt | 7.7 KB | ||
| 008 Practice Activity Number 4 - Solution_es.vtt | 8.3 KB | ||
| 008 Practice Activity Number 5.html | 614.4 B | ||
| 009 Adding KPIs into your SSAS Cube.mp4 | 27.2 MB | ||
| 009 Adding KPIs into your SSAS Cube_en.vtt | 7.7 KB | ||
| 009 Adding KPIs into your SSAS Cube_es.vtt | 8.1 KB | ||
| 009 Investigating AdventureWorks in SSMS.mp4 | 19.5 MB | ||
| 009 Investigating AdventureWorks in SSMS_en.vtt | 8.3 KB | ||
| 009 Investigating AdventureWorks in SSMS_es.vtt | 7.4 KB | ||
| 009 Practice Activity Number 3.html | 819.2 B | ||
| 009 Practice Activity Number 5 - Solution.mp4 | 16.9 MB | ||
| 009 Practice Activity Number 5 - Solution_en.vtt | 4.6 KB | ||
| 009 Practice Activity Number 5 - Solution_es.vtt | 4.8 KB | ||
| 009 Updating the cube, and using Excel again.mp4 | 29.5 MB | ||
| 009 Updating the cube, and using Excel again_en.vtt | 6.9 KB | ||
| 009 Updating the cube, and using Excel again_es.vtt | 7.8 KB | ||
| 010 How complicated can your KPI definition go.mp4 | 71.1 MB | ||
| 010 How complicated can your KPI definition go_en.vtt | 8.2 KB | ||
| 010 How complicated can your KPI definition go_es.vtt | 8.5 KB | ||
| 010 Looking at the cube using SSMS.mp4 | 35.4 MB | ||
| 010 Looking at the cube using SSMS_en.vtt | 8.8 KB | ||
| 010 Looking at the cube using SSMS_es.vtt | 9.6 KB | ||
| 010 Practice Activity Number 3 - Solution.mp4 | 58.6 MB | ||
| 010 Practice Activity Number 3 - Solution_en.vtt | 16.8 KB | ||
| 010 Practice Activity Number 3 - Solution_es.vtt | 18.1 KB | ||
| 011 Looking at the cube in SSRS.mp4 | 24 MB | ||
| 011 Looking at the cube in SSRS_en.vtt | 6 KB | ||
| 011 Looking at the cube in SSRS_es.vtt | 6.6 KB | ||
| 13350284-MDX180710.docx | 33.9 KB | ||
| 13350314-SSASSpreadsheet180620.xlsb | 186.1 KB | ||
| 6885970-SSASPracticeActivity1Instructions.docx | 14.8 KB | ||
| AdventureWorks2014.bak | 44.6 MB | ||
| AdventureWorksDW2014.bak | 21.4 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 245 total files | |||
SQL Server SSAS (Multidimensional MDX) - an Introduction
https://DevCourseWeb.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.38 GB | Duration: 7h 47m
Create cubes from databases, analyse them in Excel, SSRS etc. using SSAS MDX (a Business Intelligence tool)
What you'll learn
Create cubes in SSAS, based on fact and dimension tables.
Process the cubes, and analyse them in Excel, SSRS, and access them in SSMS.
Learn some of the more advanced items, such as translations.
Learn MDX language to query your cubes.
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 2017 for FREE. Previous versions cost $100.
Description
Reviews
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 274.1 MB | freecoursewb | 1 week | 17 | 1 | |
|
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 4 weeks | 0 | 0 |
|
Udemy - Databricks Spark Streaming, Delta Lake and SQL, AI Analytics Posted by
freecoursewb in Other
|
3.3 GB | freecoursewb | 4 weeks | 1 | 5 |
| 2.5 GB | freecoursewb | 1 month | 26 | 4 | |
| 1.6 GB | freecoursewb | 1 month | 9 | 8 |
All Comments