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

Back to top button