Skip to navigation
Skip to navigation
Skip to search form
Skip to login form
Skip to footer
Skip to main content
MVP189
LEO777
LEO777
LEO777
LEO777
LEO777
LEO777
LEO777
LEO777
LEO777
PAREPOS
JAVABET99
KONTAN88
PEWE128
LAGA88
SKY99IDN
BUANA88
BOXING55
DEWISRI88
DEWISRI88
DEWISRI88
MVP189
slot mania
MVP189
situs tergacor
pg slot wallet
Accessibility options
Accessibility profiles
Visual impairment
Seizure and epileptic
Color vision deficiency
ADHD
Learning
Content adjustments
Readable font
Highlight titles
Highlight links
Stop animations
Text size
+
+ +
+ + +
Line height
+
+ +
+ + +
Text spacing
+
+ +
+ + +
Color adjustments
Dark contrast
Light contrast
High contrast
High saturation
Low saturation
Monochrome
Orientation adjustments
Reading guide
Reading Mask
Big black cursor
Big white cursor
Email: it@huph.edu.vn
Email: it@huph.edu.vn
Các khóa học
Link list
Đổi giao diện
Giao diện cũ
Giao diện mới
Learning AI
Machine Learning cơ bản
en
English
Technology
Database
SQL Server Analysis Services - SSAS, Data Mining & Analytics
0 students
Last updated
Feb 2024
Enrol now
Overview
Course content
Instructors
About the course
Show more...
Course content
Sections:
13
•
Activities:
0
•
Resources:
58
Expand all
Section 1
Introduction
001-Introduction Why to learn SSAS and MDX What you ll need
Section 2
Fundamentals and Technology Overview
002-Business Intelligence Solution Components Overview
003-Analyzing Dimensional Model
005-Business Intelligence Semantic Model Overview
006-SSAS Overview
007-Multidimensional Expressions Overview
Section 3
SQL Server Analysis Services (SSAS) Installation
011-Installing SQL Server and SSAS
012-Configuring SSAS-
Section 4
Cube Design and Development
015-Attaching Data Warehouse
016-Data Source and Data Source Views
017-Developing Cube using Cube wizard
018-Cube Design
019-Dimension Design
020-Hierarchy Design
021-SSAS Deployment
Section 5
Multidimensional Expressions - Practical code development
024-Installing OLAP database
025-Fundamentals of MDX Query
026-Querying Object hiearchy Dimensions Attributes and Members
027-Navigating and Sorting data
028-Filtering Data
029-Named Sets and Subcubes
030-Calculated Measures and KPIs
031-SSRS with MDX
Section 6
Administration
035-Processing Dimensions Measurses and Cubes
036-Backup and Restore
037-Query Logging Exception Logging and Flight Recorder
038-Scripting and Synchronizing Databases
039-SSAS Security
Section 7
Advance Techniques
042-Fine tuning and Multi lingual Support
043-Aggregation Design
044-Partitioning and Storage Modes
Section 8
Performance Tuning
047-Query interception and analysis
048-Usage based performance optimization
049-Performance Counters
Section 9
Basics of Data Mining Concepts and Data Mining Algorithms
052-Applications of Data Mining
053-Problem Definition for Data Mining with SSAS
054-Data Preparation for Data Mining with SSAS
055-Data Exploration for Data Mining with SSAS
056-Building and Training Models for Data Mining with SSAS
057-Validating model for Data Mining with SSAS
058-Deploying models for Data Mining with SSAS
059-Data Mining Algorithms
Section 10
Developing Data Mining Models using SQL Server and SSAS
062-Building a Relational Data Mining Model and Data Mining Structure
063-Analyzing and Testing a Relational Data Mining Model
064-Applying a Data Mining Model for Prediction
065-Reusing a Data Mining Structure
066-Building an OLAP Data Mining Model
067-Analyzing Cube with Data Mining Dimension
068-Developing Data Mining Reports using Microsoft Office
Section 11
Tabular SSAS - Installation and Setup
072-Installing Tabular SSAS
073-Setting up a sample SSAS Tabular database data warehouse SSAS Tabular Project
Section 12
SSAS Tabular Data Model - Design and Development
076-Developing Tables Relationships and Hierarchies
078-Developing Calculated Columns and Measures using DAX
079-Developing Key Performance Indicators using DAX
080-Configuring Perspectives in Tabular SSAS
082-Querying SSAS Tabular Data Model using DAX
085-Developing PowerView Reports from SSAS Tabular Data Model using Microsoft Office
Section 13
Conclusion
088-Course Wrapup
Instructors
Enrolment options
SQL Server Analysis Services - SSAS, Data Mining & Analytics
Course modified date:
13 Feb 2024
Enrolled students:
There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Continue
Enrol now
This course includes
Resources
Share this course
Scroll to top
×
Close
×
Close