文档介绍：Building a Dynamic OLAP Environment
Building a
Dynamic OLAP
Environment
Dr1>. John
Tunnicliffe
Independent BI Architect
Mobile
: 07771 818770
******@
.
Talk
about products and features of the Microsoft technology with a focus on BI. Lot’s of demos and a few Sparks from the Anvil.
Not talking about SQL relational database or SSIS
Just want to know who is in my audience. So let’s have a show of hands by all of those people who considers themselves to be
DBA
Developer
BI consultant?
An introduction to Microsoft BI Technology
Sparks from the Anvil
Blog URL
http
://
sqlblogcasts3>/blogs/drjohn
See speaker profile on
.SQLBits
Tiny URLs in presentation to specific blog entries
.
tinyurl/6>4yolm6k
Agenda
Why build an dynamic OLAP environment?
Technical architecture
The build sequence
Tools & techniques deep dive:
SSIS
infrastructure
Creating the relational database structure
Handling extension tables
OLAP cube deployment
Modifying cube attributes
Dealing with unnatural hierarchies
Warning!!!
400
level session
An introduction to Microsoft BI Technology
Introducing the
OLAP data mart
Data Mart =
s
ubset of data to meet specific business needs
OLAP =
specific technology allowing users to access data
OLAP data mart
= specific subset of data to
meet specific business
needs
+ presented using correct
business
terminology and attributes
+ delivered using OLAP: allows data to be analysed using familiar tools such as Excel or 70
+
other client tools
(
see
.ssas-info
: client tools)
KIS – keep it simple!
Why build a
Dynamic OLAP Environment?
Market Data / Market Research Providers
Sell data specific to each client or research group
Require cube to support analysis by special attributes
Add value
to data by
providing better analysis tools
.
IMS Health
Portfolio Analysis in
Financial
Services
Institutional investors
Private clients / worth