| 001 Applications of Data Mining.mp4 | 12.2 MB | ||
| 001 Attaching Data Warehouse.mp4 | 11.8 MB | ||
| 001 Building a Relational Data Mining Model and Data Mining Structure.mp4 | 29.1 MB | ||
| 001 Business Intelligence Solution Components Overview.mp4 | 14.4 MB | ||
| 001 Course Wrapup.mp4 | 6.8 MB | ||
| 001 Developing Tables, Relationships, and Hierarchies.mp4 | 36.4 MB | ||
| 001 Fine tuning and Multi-lingual Support.mp4 | 27.6 MB | ||
| 001 Installing OLAP database.mp4 | 11.6 MB | ||
| 001 Installing SQL Server and SSAS.mp4 | 19.5 MB | ||
| 001 Introduction to SSAS - Tabular Mode, Vertipaq Engine & Data Analysis Expressions.html | 2.9 KB | ||
| 001 Introduction, Why to learn SSAS and MDX, What you'll need.mp4 | 22 MB | ||
| 001 Processing Dimensions, Measurses and Cubes.mp4 | 23.2 MB | ||
| 001 Query interception and analysis.mp4 | 16.6 MB | ||
| 002 Aggregation Design.mp4 | 24.3 MB | ||
| 002 Analyzing Dimensional Model.mp4 | 33.5 MB | ||
| 002 Analyzing and Testing a Relational Data Mining Model.mp4 | 35 MB | ||
| 002 Backup and Restore.mp4 | 8.5 MB | ||
| 002 Basics and Terminologies of SSAS Tabular Modeling and Data Analysis Expressions.html | 7.1 KB | ||
| 002 Bonus Lecture - Discount Coupons.html | 3.4 KB | ||
| 002 Configuring SSAS.mp4 | 18.6 MB | ||
| 002 Data Source and Data Source Views.mp4 | 19 MB | ||
| 002 Fundamentals of MDX Query.mp4 | 23.5 MB | ||
| 002 Installing Tabular SSAS.mp4 | 13.7 MB | ||
| 002 Problem Definition for Data Mining with SSAS.mp4 | 8.9 MB | ||
| 002 Usage based performance optimization.mp4 | 10.9 MB | ||
| 003 Applying a Data Mining Model for Prediction.mp4 | 10.3 MB | ||
| 003 Data Preparation for Data Mining with SSAS.mp4 | 4.7 MB | ||
| 003 Developing Calculated Columns and Measures using DAX.mp4 | 20.3 MB | ||
| 003 Developing Cube using Cube wizard.mp4 | 14.5 MB | ||
| 003 Partitioning and Storage Modes.mp4 | 26.9 MB | ||
| 003 Performance Counters.mp4 | 14.7 MB | ||
| 003 Query Logging, Exception Logging and Flight Recorder.mp4 | 17.2 MB | ||
| 003 Querying Object hiearchy - Dimensions, Attributes and Members.mp4 | 21.7 MB | ||
| 003 Resources and FAQ for SSAS Installation and Configuration.html | 3.8 KB | ||
| 003 Resources for downloading and analyzing sample Data Warehouse and OLTP database.html | 1.1 KB | ||
| 003 Setting up a sample SSAS Tabular database, data warehouse & SSAS Tabular Project.mp4 | 17.3 MB | ||
| 004 Business Intelligence Semantic Model Overview.mp4 | 14 MB | ||
| 004 Cube Design.mp4 | 17.3 MB | ||
| 004 Data Exploration for Data Mining with SSAS.mp4 | 7.7 MB | ||
| 004 Developing Key Performance Indicators using DAX.mp4 | 13.9 MB | ||
| 004 Navigating and Sorting data.mp4 | 26.1 MB | ||
| 004 Resources for SSAS Advance Techniques.html | 819.2 B | ||
| 004 Resources for SSAS Performance Tuning.html | 614.4 B | ||
| 004 Resources for SSAS Tabular Installation.html | 1.1 KB | ||
| 004 Reusing a Data Mining Structure.mp4 | 16.8 MB | ||
| 004 Scripting and Synchronizing Databases.mp4 | 7.3 MB | ||
| 005 Building an OLAP Data Mining Model.mp4 | 22.2 MB | ||
| 005 Building and Training Models for Data Mining with SSAS.mp4 | 9.5 MB | ||
| 005 Configuring Perspectives in Tabular SSAS.mp4 | 9.9 MB | ||
| 005 Dimension Design.mp4 | 26 MB | ||
| 005 Filtering Data.mp4 | 25.4 MB | ||
| 005 SSAS Overview.mp4 | 28.8 MB | ||
| 005 SSAS Security.mp4 | 16.4 MB | ||
| 006 Analyzing Cube with Data Mining Dimension.mp4 | 20.5 MB | ||
| 006 Difference between In-Memory and DirectQuery query modes.html | 2.9 KB | ||
| 006 Hierarchy Design.mp4 | 7.5 MB | ||
| 006 Multidimensional Expressions Overview.mp4 | 23.4 MB | ||
| 006 Named Sets and Subcubes.mp4 | 14.5 MB | ||
| 006 Resources for SSAS Administration.html | 1.2 KB | ||
| 006 Validating model for Data Mining with SSAS.mp4 | 9.8 MB | ||
| 007 Calculated Measures and KPIs.mp4 | 25.7 MB | ||
| 007 Comparison of SSAS Multidimensional, Tabular and Data Mining modes.html | 1.7 KB | ||
| 007 Deploying models for Data Mining with SSAS.mp4 | 6.4 MB | ||
| 007 Developing Data Mining Reports using Microsoft Office.mp4 | 21.1 MB | ||
| 007 Querying SSAS Tabular Data Model using DAX.mp4 | 32.7 MB | ||
| 007 SSAS Deployment.mp4 | 18.4 MB | ||
| 008 Data Mining Algorithms.mp4 | 16.8 MB | ||
| 008 Ready to use DAX Queries.html | 2.3 KB | ||
| 008 Resources for Design and Development of SSAS Cube, Dimension, Measures.html | 1.6 KB | ||
| 008 Resources for SSAS Data Mining Model Development.html | 1.2 KB | ||
| 008 SQL Server 2016 Ebook Download Link and Glossary of SSAS Terminologies.html | 3.9 KB | ||
| 008 SSRS with MDX.mp4 | 17.7 MB | ||
| 009 50+ Ready-to-use MDX Queries.html | 11.8 KB | ||
| 009 Resources for Data Mining Algorithms in SQL Server 2016 and SSAS.html | 1.9 KB | ||
| 009 Security in SSAS Tabular.html | 2.9 KB | ||
| 010 Developing PowerView Reports from SSAS Tabular Data Model using Microsoft Office.mp4 | 12.4 MB | ||
| 010 Glossary of MDX Terms.html | 2.8 KB | ||
| 011 Resources for SSAS Tabular Model Development.html | 1.9 KB | ||
| 6697468-MDWToolkit-Datamodel-4.0-MDWT-2008R2-DB.xlsm | 204.3 KB | ||
| 6863972-DMAddins-SampleData.xlsx | 2.2 MB | ||
| AdventureWorksDW2014.bak | 21.4 MB | ||
| AdventureWorksDW2014Multidimensional-EE.abf | 31.4 MB | ||
| AdventureWorksDW2014Multidimensional-SE.abf | 25.7 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Dim Currency.dim | 4.2 KB | ||
| Dim Customer.dim | 37 KB | ||
| Dim Date.dim | 4.2 KB | ||
| Dim Product.dim | 9.2 KB | ||
| Dim Promotion.dim | 4.2 KB | ||
| Dim Sales Territory.dim | 10.4 KB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| IncrementalShapshot.xml | 4.8 KB | ||
| LastBuilt.xml | 5.1 KB | ||
| MDX 1.mdx | 1.8 KB | ||
| MDX 2.mdx | 1.6 KB | ||
| MDX 3.mdx | 2.3 KB | ||
| MDX 4.mdx | 2.4 KB | ||
| MDX 5.mdx | 1.2 KB | ||
| MDX 6.mdx | 307.2 B | ||
| MyCubes.asdatabase | 286 KB | ||
| MyCubes.configsettings | 3.2 KB | ||
| MyCubes.database | 5 KB | ||
| MyCubes.deploymentoptions | 1.6 KB | ||
| MyCubes.deploymenttargets | 1.2 KB | ||
| MyCubes.dwproj | 5 KB | ||
| MyCubes.dwproj.user | 1.5 KB | ||
| MyCubes.sln | 921.6 B | ||
| Role.role | 1.3 KB | ||
| cubeAdv.cube | 73.8 KB | ||
| cubeAdv.partitions | 4.1 KB | ||
| dsAdventureWorks.ds | 1.8 KB | ||
| dsvAdventureworksDW2016CTP3.dsv | 149 KB | ||
| suo | 29 KB | ||
| ▲ 113 total files | |||
SQL Server Analysis Services - SSAS, Data Mining & Analytics
https://DevCourseWeb.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.07 GB | Duration: 7h 54m
Develop SSAS cubes from data warehouse on Multidimensional & Tabular modes with Dimensional & Data Mining Models
What you'll learn
Downloadable Course Content - FREE SQL Server 2016 EBook, 150+ Interview Questions, 100+ curated reference material links, 70+ MDX / DAX Queries, Links to 1 Sample OLTP Database and 1 Sample Data Warehouse with sample data - schema diagrams - documentation - dimensional modeling workbook, 1 Sample Multidimensional OLAP Database + 1 Sample Tabular OLAP Database containing fully functional cube with sample data, and Full project developed in the course.
By end of this course, you should be able to work with actual clients, technology architects, or team leads on a large scale SQL Server Analysis Services / MDX / Data Mining Project
Learn SQL Server Analysis Services ( SSAS ) Multi-dimensional as well as Tabular, Multidimensional Data Expressions ( MDX ) query language, Data Analysis Expressions (DAX) expression language and Data Mining on latest version of SQL Server - 2016 on a fast track with more practicals and limited theory necessary for fundamentals.
Develop Data Mining Models on algorithms like Decision Trees, Naive Bayes, Clustering, Neural Network, Time Series, Linear Regression and Sequence Clustering
Test your knowledge with more than 150 SSAS, MDX, DAX and Data Mining interview or Microsoft BI certification practice test questions. Every few weeks, new interview questions are added to the course.
Design, Model and Build SSAS database, data warehouse or data mart, and database objects like facts, dimensions, cubes, measures, perspectives, etc
Deploy SSAS solutions and learn SSAS administration tasks like backup and restore, processing dimensions and measures, building aggregations, etc
Develop MDX and DAX code with confidence
Develop SSRS Reports using MDX as query language and SSAS as data source
Debug issues and performance tune SSAS solutions for optimal performance
Learn about Microsoft Business Intelligence Architecture, and understand how SSAS fits in this architecture along with other tools like SSIS, SSRS, Master Data Services ( MDS ), Data Quality Services ( DQS ), Powerpivot, PowerView, SQL Server Database Engine, SSMS, SSDT and other tools.
Requirements
No prior knowledge of SSAS, MDX, Dimensional modeling or Data Mining is required.
Basic working knowledge of SQL Server like working with tables, views, stored procedures etc is required.
Description
Top 4 Reasons to take this course
| 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