DATA MINING
19 Slides804.28 KB
DATA MINING
DATA SOURCES Oracle ERP Campus Solutions, Finance and HCM modules Query Viewer Query Manager Air.lonestar.edu Contact Lists Enrollment Funnel Enrollment Management
DATA SOURCES Discovery.lonestar.edu AIR-Official Template Other Sources http://www.txhigheredaccountability.org/AcctPublic/ (THECB) Lonestar.edu/air
ORACLE ERP Consists of Campus Solutions, Finance and Human Capital Management Each module has its own data structure and queries for accessing data Queries are built using query manager and can be accessed using query viewer
ORACLE ERP Some users will have access to query manager while most users should have access to query viewer Query viewer allows users to access and run any public queries Queries can be searched for by name or by record and field names Only way to know what fields are listed is to run the query Query validity can only be confirmed by creator of query
ORACLE ERP Access from main menu Users may have ability to schedule query
ORACLE ERP
ORACLE ERP HTML Good to preview what data are pulled by query
ORACLE ERP Excel Works the same as HTML but instead of listing results in webpage it will export to a file
ORACLE ERP Schedule Allows user to select times to run query Can be recurring schedule or one time Results can be delivered through email
AIR.LONESTAR.EDU Contact Lists Can download into excel or csv format Allows lists to be used easily with Power BI, Access or Excel Can be combined with other data user may have
AIR.LONESTAR.EDU
AIR.LONESTAR.EDU Reports Daily Enrollment Student Success KPI’s Download function will pull only data on page
DISCOVERY.LONESTAR.EDU AIR-Official Can export data from visuals Can use slicers to filter data on screen Template Data sets created for exploration of data Has some example visuals but was intended to be downloaded for end users to create their own visuals Used more for training purposes – Data are mostly accurate but not intended for official purposes
TEXAS HIGHER EDUCATION COORDINATING BOARD http://www.txhigheredaccountability.org/AcctPublic/ Student success measurements http://www.txhighereddata.org/reports/performance/ctcasalf/ gainful.cfm Employment placement data Can get various data elements Data are aggregated so they can’t be easily compared to iStar data
PS UTILITIES Available for Chrome Can be added through extensions Allows users to see table and fields behind screens
PS UTILITIES Will add a toolbar to iStar Screens
PS UTILITIES Click on the magnifying glass Hover over data to see table and field names
Questio ns