the steps to crossmart analyses n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
The Steps To CrossMart Analyses PowerPoint Presentation
Download Presentation
The Steps To CrossMart Analyses

Loading in 2 Seconds...

play fullscreen
1 / 11

The Steps To CrossMart Analyses - PowerPoint PPT Presentation


  • 68 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'The Steps To CrossMart Analyses' - josh


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
the steps to crossmart analyses

The Steps To CrossMart Analyses

EDM Group

Informational Technology ServicesHumboldt State University

2/24/2014

hsu data marts
HSU Data Marts
  • Enterprise Data Organized into 3 areas:
    • Finance
    • Human Resources
    • Student
  • Data presented as Subject Areas
    • Folder structure
    • Field Selection
    • Granularity
what is grain
What is 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
slide7

Cross Martwhat 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
slide8

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
slide9

CrossMart Example

SPF Percent of Effort

  • Mandatory reporting for federally funded grants
  • Uses Labor Cost Data with population limits based on Job History
slide10

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