Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Done By :
- Elham Alawad Suliman
- Fatima Sayed Alsheikh
- Omnia Yassir Izzeldin
- Rasha Osman Ahmed
Accumulating snapshots:
are appropriate for short-lived processes that have a defined beginning and end, with standard intermediate milestones.
Surrogate key:
is any column or set of columns that can be declared as the primary key instead of a "real" or natural key.
Factless fact table:
is a fact table that does not have any measures. It is essentially an intersection of dimensions (it contains nothing but dimensional keys).
Bus matrix:
is a data Warehouse planning tool and model and one of high abstraction and visionary planning on the Data Warehouse architectural level.
In this presention we will go through the following concepts:
-attracting high qualified students
-talented faculty/staff .
Universities are simultaneously :
The bus matrix a small piece covers several core processes within an educational institution:
The distinguishing characteristics of an accumulating snapshot fact table:
such as initial inquiry, campus visit, application submitted, application file completed, admissions decision notification, and enrolled or withdrawn.
- At any point in time:
- how many applicants are at each stage in the pipeline??
The process is much like a funnel, where many inquiries enter the pipeline.
analyze the applicant pool by a variety of characteristics.
You can envision/plan a factless fact table to track each prospective student’s attendance at an admission event: such as a high school visit, college fair, alumni interview or campus overnight
Similarly, you can track student course registrations by term using a factless fact table.
The grain would be one row for each registered course by student and term
Term Dimension:
- In this fact table, the data is at the term level rather than at the more typical calendar day, week, or month granularity.
each date in the daily calendar dimension should identify the term (for example, Fall), term and academic year (for example, Fall 2013), and academic year (for example, 2013-2014).
-The column labels and values must be identical for the attributes common to both the calendar date and term dimensions.
Student Dimension and Change Tracking:
The student dimension is an expanded version of the applicant dimension that previously discussed.
- The grain would include additional dimensions to further describe the research grant
there is a strong need to better understand and manage the budgeted and actual spending associated with each research project.
-The objective is to optimize the spending so a surplus or deficit situation is avoided, and funds are deployed where they will be most productive.
-understanding research spending rolled up by various dimensions is necessary to ensure proper institutional control of such monies.
-Improved access to a broad range of attributes about the alumni population would allow the institution to better target messages and allocate resources.
-sIn addition to alumni contributions, alumni relationships can be leveraged for potential recruiting, job placement, and research opportunities.
Second; we explored several examples of factless fact tables. These fact tables capture the relationship between dimensions in the case of an event or coverage, but are unique in that no measurements are collected to serve as actual facts
-We also discussed the handling of situations in which you want to track events that didn’t occur.