Data Analysis with SQL Server Analysis Server - SSAS
https://CourseHulu.com
Instructors: Bluelime Learning Solutions
2 sections • 27 lectures • 1h 59m
Video: MP4 1280x720 44 KHz | English + Sub
Updated 1/2022 | Size: 779 MB
Connect to data source and analyse data with SSAS
What you'll learn
Install SQL Server
Install SQL Server Analysis Services
Install Visual Studio
Install SQL Server Data Tools
Create a tabular model
Create a connection to data source
Transform and import data
Create relationships
Create measures
Create key performance indicators - KPI
Requirements
Basic database concepts advised.
Description
Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.
SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack, to develop Online Analytical Processing (OLAP) solutions. In simple terms, you can use SSAS to create cubes using data from data marts / data warehouse for deeper and faster data analysis.