Skills Business Intelligence: Difference between revisions

From MillerSql.com
NeilM (talk | contribs)
No edit summary
NeilM (talk | contribs)
No edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Data Warehouse ==
Data Warehouse
Fact/Dimension tables
Slowly changing dimensions
Slowly changing dimensions


Line 23: Line 28:


BIDS - Business Intelligence Development Studio
BIDS - Business Intelligence Development Studio
SSDT - SQL Server Data Tools


== SSRS ==
== SSRS ==
Line 33: Line 40:
</div>
</div>
SQL Server Reporting Services
SQL Server Reporting Services
== Other ==
Informatica Powercentre

Latest revision as of 09:55, 7 October 2024

Data Warehouse

Data Warehouse

Fact/Dimension tables

Slowly changing dimensions

Type 2 slowly changing dimensions

Used at:...
  Used at: 
  MUFG Securities

Type 2 Slowly changing dimensions

Visual Studio

Used at:...

Visual Studio 2019

BIDS - Business Intelligence Development Studio

SSDT - SQL Server Data Tools

SSRS

Used at:...
  Used at: 
  MUFG Securities

SQL Server Reporting Services

Other

Informatica Powercentre