Skills Business Intelligence: Difference between revisions

From MillerSql.com
NeilM (talk | contribs)
NeilM (talk | contribs)
No edit summary
 
(9 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


== Type 2 slowly changing dimensions ==
== Type 2 slowly changing dimensions ==
<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
  <div>''Used at:...''</div>
  <div class="mw-collapsible-content">
  ''Used at: ''
  ''[[Role_MUFG_Securities|MUFG Securities]]''
  </div>
</div>
Type 2 Slowly changing dimensions
Type 2 Slowly changing dimensions


Line 8: Line 20:
   <div>''Used at:...''</div>
   <div>''Used at:...''</div>
   <div class="mw-collapsible-content">
   <div class="mw-collapsible-content">
   ''Used at [[Role_MUFG_Securities#BIML|MUFG Securities]]''
   ''Used at: ''
  ''[[Role_MUFG_Securities#BIML|MUFG Securities]]''
  ''[[Role_SSE_Energy_GDPR#|SSE Energy GDPR]]''
   </div>
   </div>
</div>
</div>
Visual Studio 2019
Visual Studio 2019
BIDS - Business Intelligence Development Studio
SSDT - SQL Server Data Tools


== SSRS ==
== SSRS ==
<div class="mw-collapsible mw-collapsed" style="width:400px; overflow:auto;">
  <div>''Used at:...''</div>
  <div class="mw-collapsible-content">
  ''Used at: ''
  ''[[Role_MUFG_Securities|MUFG Securities]]''
  </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