MDX Questions and Answers 2011
Question 1
GetInternetSalesOrderQuantityforthedifferentcombinationofDueDatesyearsandBikesProductSubcategoryalong
withallpossibleCustomersYearlyIncome.
Answer 1
Possible to use children or members or descendants
Select cfw_Cr
Cairo University
Faculty of Computers and Information
Information Systems Department
Introduction to DTS (SSIS)
Lab objective:
Introduce Students to DTS (SQL Server Integration Services 'SSIS') to prepare them in the next lab to
make actual start schema a
Cairo University
Faculty of Computers and Information
Information Systems Department
Introduction
1-Introduction for labs course:
Attendance
Class exercise
Project on 2 phases
Lab exam on MDX
2- Learning expectations:
Understand the purpose and architectu
1- Levels of Data:
Operational
data
Detailed
Application
Oriented
Current valued
High freq.
usage
Day to day
Data
Departmental
warehouse
Summarized
Derived
Subject
Department
Oriented
oriented
Historical
Historical
Low freq.
usage
Time variant
Individual
Chapter 1
#
1
2
3
Concept
Decision
Decision
support
system
Relational
Database
Definition
A choice among alternatives
A programming system that support the
manager to take a suitable decision
A collection of data items organized
together as a set of forma
Data Warehouses
Lecture 3
Dr. Hoda Mokhtar
Outline
Review
What is a DW?
DW design issues
Partitioning
Granularity
DW Architecture
Structure of data in the data
warehouse
Goals of a DW
Components of a DW
Levels of Data Modeling
Snapshots
Structure
Data Warehouses
Lecture 5
Dr. Hoda Mokhtar
Outline
Review
Goals of data warehouses
Staging Area (ETL)
Snapshots
Dimensional modeling
Facts
Dimensions
Dimensional modeling activities
Dimensional modeling design steps
Retail store case study
Snapshots i
Data Warehouses
Lecture 7
Dr. Hoda Mokhtar
Fact Table - I
A fact table is the primary table in a dimensional model where
the numerical performance measurements are stored
We use the term fact to represent a business measure.
A measurement is taken at the
1- Why is it difficult to make a decision?
Trial and error techniques are not suitable for
every thing.
We have to take a quick decision.
New tools and concepts appear in existence
alternatives.
Hard to achieve the optimal solution.
2- What is the mai
Data Warehouses
Lecture 6
Dr. Hoda Mokhtar
Outline
Review
Snapshots
Data Modeling
Dimensional modeling
Facts
Dimensions
Dimensional modeling activities
Dimensional modeling design steps
Retail store case study
Why data modeling?
A model is an abstractio
Outline
Review
Data warehouse schemas
Data growth in DW
Inventory case study
Value Chain
Types of Fact Table
Data Warehouse Bus Architecture
Data Warehouse Bus Matrix
Inventory Case Study
Retailer Value Chain
Consisting of organizations key
business
Data Warehouses
Lecture 8
Dr. Hoda Mokhtar
Outline
Retail case study (cont)
Data warehouse schemas:
1. Star Schema
2. Snowflake Schema
Profile records
4-Steps Dimension Design Process
1.
Select the business process to model
2.
Declare the grain of the bus
Data Warehouses
Dr. Hoda Mokhtar
Data Warehouse
Dr. Hoda Mokhtar
TAs
Labs
Office hours: will be posted
Text books and References
Building the Data Warehouse
Willian H. Inmon, 4th edition
Data Warehousing toolkit: The Complete Guide to
Dimensional Model
Cairo University
Faculty of Computers and Information
Information Systems Department
SSIS package Example
How to transform your data from source database to data warehouse?
Consider the example of Sales process in AdventureWorks database:
Product( Product
Detailed Instructions of Installing MS SQL Server 2008 Enterprise Edition
Installation Tab: New SQL server stand-alone or add features to an existing
.installation
(1)
Perform a new installation of SQL Server 2008
(2)
Enter the product key: This should b
DW MDX Lab Exam 2007
1. On Budget cube, calculate a new dimension member in the time dimension to
represent all years (1997 and 1998).Then display the new member along with year
level members on columns and all store cities in USA on rows, for only curren
MDX Lab Exam 2006
Q1.
On sales cube, calculate a new education level [University Graduate] where
[University Graduate] = ([Graduate Degree] + [Bachelors Degree]). Display profit
for the new education level along with all education levels on columns, and t
MDX Questions and Answers 2012
Question 1
GetInternetSalesOrderQuantityforthedifferentcombinationofDueDatesyearsandBikessSubcategoriesforall
CustomersYearlyIncome.
Note:BikeisaProductCategory
Answer 1
Possible to use children or members or descendants
Sel
Third Year
Data Warehouse Term Project
Date: 3 April 2011
A team of 3-5 students should be formed to develop a data warehouse term project.
Project phases:
Phase 1: Proposal and star/snowflake schema
In the first phase of the project you have to choose bu
DW MDX Lab Exam 2008
On Adventure works cube, calculate a new dimension member in the time
dimension to represent all years (1997 and 1998).Then display the new member
along with year level members on columns and all store cities in USA on rows, for
only
UsingtheSalescubeoftheFoodmartdatabasesample,writetheMDXquerythatreturns:
1. StoressalesduringPromotions:WalletSaversandSaveItSale,andfromstoresin
USA.
Solution:
Selectcfw_[Promotions].[AllPromotions].[WalletSavers],[Promotions].[AllPromotions].[SaveIt
Sa
MDX Exam 2011
Name:
:
ID:
Question 1
Get Internet Sales Order Quantity for the different combination of Due Dates years and Bikes Product Subcategory along
with all possible Customers Yearly Income.
Answer
MDX Exam 2011
Name:
:
ID:
Question 2
For Customer
1. On sales cube, calculate a new measure (store-profit) as (store sales store cost) then
display the store-profit for all store states ins USA in all quarters on columns and all
store types on rows, for only drink product family.
2. On Sales cube, create
Data Warehouse
MDX Lab Exam Questions and Answers
1- On sales cube, calculate a new measure (store-profit) as (store sales store cost) then
display the store-profit for all store states ins USA in all quarters on columns and all store
types on rows, for o
1. On sales cube, calculate a new measure (store-profit) as (store sales store cost) then
display the store-profit for all store states ins USA in all quarters on columns and all
store types on rows, for only drink product family.
2. On Sales cube, create
MDX Exam Questions and Answers 20112
Model Exam No. 1
:
Name:
ID:
Question
Get Internet Sales Order Quantity for the different combination of Due Dates years and Bikess Subcategories for all
Customers Yearly Income.
Note: Bike is a Product Category
1
Get
Data Warehouse Lab Exam 2006
MDX Lab Exam Questions and Answers
1. On sales cube, calculate a new education level [University Graduate] where
[University Graduate] = ([Graduate Degree] + [Bachelors Degree]). Display profit
for the new education level alon