Understanding Data Marts in Information Technology Services at Humboldt State University
Explore how Humboldt State University organizes its data marts, focusing on the granular levels of detail within different subject areas such as finance, human resources, and student data. Discover the significance of cross-mart analyses in bringing together information from diverse sources for comprehensive insights.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
THE STEPS TO CROSSMART ANALYSES EDM Group Informational Technology Services Humboldt State University 2/24/2014
HSU Data Marts Enterprise Data Organized into 3 areas: Finance Human Resources Student Data presented as Subject Areas Folder structure Field Selection Granularity 2
WHATIS GRAIN? Specifying the Level of Detail If more detail is included, the level of granularity is lower. If less detail is included, the level of granularity is higher. This applies both to the fact and to the dimensions 3
HSU Data Marts Subject Area Grain Finance - General ledger Transaction Event (payment, receipt, AJE) HR - Job Events Employee/Job/Event HR - Job History Employee/Job/Day HR - Labor Cost Paycheck HSU - Census Student/Term 4
Data Marts how information is organized in the Data Warehouse 5
HSU Data Marts Student EPM Subject Area Grain CSW Admission Application Student/Career/Application/Plan CSW Admission Application Status Student/Career/Application/Plan/Action Date CSW Stdnt Fin Award Disbursement Student/Career/FinAid item/Disbursement CSW Student Financials Acctg Line Accounting Line detail CSW Student Financials Pmt Detail Student/Payment CSW Student Financials Trans Detail Student/Transaction CSW Student Records Acad Plan Summary Student/Career/Plan CSW Student Records Acad Prog Detail Student/Career/Acad Program/Effective Date CSW Student Records Class Class CSW Student Records Class Enrollment Person/Class/Session CSW Student Records Class Instructor Course/Class/Session/Section/Mtg/Instructor CSW Student Records Class Meeting Pattern Course/Session/Section/Mtg/Instructor CSW Student Records Student Degrees Person/Degree#/Acad Plan/SubPlan 6 CSW Student Records Term Enrollment Person / Term
Cross Mart what does it mean? Bringing information together from different subject areas Ask questions like: What are the graduation rates of student workers compared to the rest of their cohort? What were the fees collected for students here at census? OR, limiting the results of one Subject area based on the outcome of another 7
How do we do this? Choose Subject areas with the same grain Use Conformed Dimensions to be able to drill across subject areas Work collaboratively to identify new subject areas 8
CrossMart Example SPF Percent of Effort Mandatory reporting for federally funded grants Uses Labor Cost Data with population limits based on Job History 9
CrossMart Example Student Fee Reconcilication Work in progress to combine Student Financials with Census Data Displays Finance G/L data on the dashboard for verification 10
![[PDF⚡READ❤ONLINE] Gemini 4: An Astronaut Steps into the Void (Springer Praxis B](/thumb/21620/pdf-read-online-gemini-4-an-astronaut-steps-into-the-void-springer-praxis-b.jpg)
