Please enable JavaScript.
Coggle requires JavaScript to display documents.
BIG Data - Coggle Diagram
BIG Data
SQL Server Analysis
Data mining = understanding data
y= a+bx
SSAS
CUBING Technology
Data Warehouse = Source/extract
Data source of view = transformation
Cube = destination
Running the cube by deployment to SQ
Connect to data source
input credentials of VM
Data Mining Technology
Fact table = measure table
dimension table
Mult-Dimension expression Language(MDX)
Midterm exam
Week 1 - Week 5
Running the cube by deployment to SQL
attributes of fact table = fix, change, history
Data Warehouse
Normalize data, easier to retrieve
ETL
SQL Server Data Tools (SSDT) for Visual studio
Solution
Visual Studio
Project: Integration Services
Tab 1 :Control Flow - data movement
OLE DB for SQL
Native OLE DB Server Native Client 11
understanding SSIS
moving data from Source to Destination
1/27/25
Design - Visual Studio
Deploy to
SQL - Machine that run the code
Data Warehouse
Dimension and file
Data flow (SSIS)
Slowly changing Dimension
1 more item...
Creating Job
creating utility
integration service project
Lesson 9:
Lesson 10 : generate utility package
Right click - select deployment mode (ssis)
properties
deployment
create deployment utility = true
Creating a Data Cube
Connect to a Source = Data Warehouse
Data Mining in mDX
Calculate gross profit margin
Sort to Top Ten
go to calculation
select the calculated in measure group
right click, select template
SSIS = SQL Server Integration Services