Card Set Information
MS Desktop's 3 Types of Uses
Desktop (Designer or Analyst)
OLTP vs OLAP differences
: By Application - By Business Subject
: Short Term - Long Term (2+ years)
: Minimal - High (ETL)
: GB - TB
: RealTime, Write - Batch Load, Read
Data Warehouse - OnLine Analytical Processing System
Source Systems - OnLine Transaction Processing System
What does MSBI Archtitecture look like?
ETL - Extraction, Transformation, Loading
Benefits of MS Designer/Analyst?
Complete BI Console
Delivering the Enterprise Mandate
Benefits of MS Architect?
Flexible Application Design
Make Data Accessible
Simplified, Rapid Development
Reduced System Maintenance
Benefits of MS Administration?
Comprehensive Security Model
Intelligence Server Administration
What's a Project Source?
Highlest level Object in MS.
Connection to MetaData or Intelligent Server
Through the Connection, you create, manipulate, and admin projects.
What is a Project?
The intersection of a Data Warehouse, MetaData, and User Community.
5 Typical Folders of a Project?
My Personal Objects
Three types of MS Objects?
Types of Schema Objects?
Types of Application Objects?
3 Areas on Desktop Interface?
What is a Report?
Request for Specific, Formatted Data from the Data Warehouse. Made up of Template and Filter.
CrossTab vs Tabular Layout?
CrossTab has Metrics in Rows, Tabular has Metrics in Columns.
What is Consolidation?
Virtual Attributes, which are created as groups of existing attributes.
Can also use Custom Groups (row level filter conditions).
What is Drilling?
Enables you to see data at levels other than the level of the original report.
Drilling to a Template?
Lets you move to a different Template with the same filter.
What objects can you page by?
Object Prompt (all of the above)
Types of Data Pivoting?
Move objects from Row to Column (vice versa)
Change order of Row or Column Objects
Move objects to and from Page field
Swap Row and Columns
Enables Indented grouping of related attributes.
6 types of Exporting of reports?
Schedule Delivery to?
What is a Threshold and its four types?
Conditional Formatting -
one of four types:
(you can also copy and paste these thresholds)
What is Banding?
It's a method of organizing the appearance of results by a certain criteria or pattern.
Properties of Graphs?
Undo/Redo is allowed.
Nested Labels and Brackets help to reduce labels.
Set maximum number of categories for either axis.