{"id":"https://openalex.org/W4382658182","doi":"https://doi.org/10.1287/ited.2023.0286","title":"Introducing Prescriptive and Predictive Analytics to MBA Students with Microsoft Excel","display_name":"Introducing Prescriptive and Predictive Analytics to MBA Students with Microsoft Excel","publication_year":2023,"publication_date":"2023-05-04","ids":{"openalex":"https://openalex.org/W4382658182","doi":"https://doi.org/10.1287/ited.2023.0286"},"language":"en","primary_location":{"id":"doi:10.1287/ited.2023.0286","is_oa":true,"landing_page_url":"https://doi.org/10.1287/ited.2023.0286","pdf_url":null,"source":{"id":"https://openalex.org/S155575560","display_name":"INFORMS Transactions on Education","issn_l":"1532-0545","issn":["1532-0545"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310315699","host_organization_name":"Institute for Operations Research and the Management Sciences","host_organization_lineage":["https://openalex.org/P4310315699"],"host_organization_lineage_names":["Institute for Operations Research and the Management Sciences"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"INFORMS Transactions on Education","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://doi.org/10.1287/ited.2023.0286","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5088596644","display_name":"Adam Diamant","orcid":"https://orcid.org/0000-0002-7022-6879"},"institutions":[{"id":"https://openalex.org/I192455969","display_name":"York University","ror":"https://ror.org/05fq50484","country_code":"CA","type":"education","lineage":["https://openalex.org/I192455969"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Adam Diamant","raw_affiliation_strings":["Schulich School of Business, York University, Toronto, Ontario M3J 1P3, Canada"],"raw_orcid":"https://orcid.org/0000-0002-7022-6879","affiliations":[{"raw_affiliation_string":"Schulich School of Business, York University, Toronto, Ontario M3J 1P3, Canada","institution_ids":["https://openalex.org/I192455969"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5088596644"],"corresponding_institution_ids":["https://openalex.org/I192455969"],"apc_list":null,"apc_paid":null,"fwci":2.1456,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.92349398,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":"24","issue":"2","first_page":"152","last_page":"174"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9944999814033508,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9944999814033508,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9940999746322632,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11875","display_name":"Statistics Education and Methodologies","score":0.9932000041007996,"subfield":{"id":"https://openalex.org/subfields/2613","display_name":"Statistics and Probability"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7587355375289917},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.7371273040771484},{"id":"https://openalex.org/keywords/business-analytics","display_name":"Business analytics","score":0.6194188594818115},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.610022246837616},{"id":"https://openalex.org/keywords/microsoft-excel","display_name":"Microsoft excel","score":0.6066129207611084},{"id":"https://openalex.org/keywords/python","display_name":"Python (programming language)","score":0.6018033623695374},{"id":"https://openalex.org/keywords/predictive-analytics","display_name":"Predictive analytics","score":0.5329108238220215},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.4903876781463623},{"id":"https://openalex.org/keywords/pipeline","display_name":"Pipeline (software)","score":0.4892301559448242},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.47125935554504395},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.40304291248321533},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"Knowledge management","score":0.390716016292572},{"id":"https://openalex.org/keywords/business-model","display_name":"Business model","score":0.1849011778831482},{"id":"https://openalex.org/keywords/management","display_name":"Management","score":0.14563575387001038},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.14514422416687012},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.11461523175239563}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7587355375289917},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.7371273040771484},{"id":"https://openalex.org/C37952496","wikidata":"https://www.wikidata.org/wiki/Q5001829","display_name":"Business analytics","level":4,"score":0.6194188594818115},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.610022246837616},{"id":"https://openalex.org/C3019730874","wikidata":"https://www.wikidata.org/wiki/Q11272","display_name":"Microsoft excel","level":2,"score":0.6066129207611084},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.6018033623695374},{"id":"https://openalex.org/C83209312","wikidata":"https://www.wikidata.org/wiki/Q1053367","display_name":"Predictive analytics","level":2,"score":0.5329108238220215},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.4903876781463623},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.4892301559448242},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.47125935554504395},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.40304291248321533},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.390716016292572},{"id":"https://openalex.org/C4216890","wikidata":"https://www.wikidata.org/wiki/Q815823","display_name":"Business model","level":2,"score":0.1849011778831482},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.14563575387001038},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.14514422416687012},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.11461523175239563},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C189076506","wikidata":"https://www.wikidata.org/wiki/Q1518232","display_name":"Business analysis","level":3,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1287/ited.2023.0286","is_oa":true,"landing_page_url":"https://doi.org/10.1287/ited.2023.0286","pdf_url":null,"source":{"id":"https://openalex.org/S155575560","display_name":"INFORMS Transactions on Education","issn_l":"1532-0545","issn":["1532-0545"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310315699","host_organization_name":"Institute for Operations Research and the Management Sciences","host_organization_lineage":["https://openalex.org/P4310315699"],"host_organization_lineage_names":["Institute for Operations Research and the Management Sciences"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"INFORMS Transactions on Education","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1287/ited.2023.0286","is_oa":true,"landing_page_url":"https://doi.org/10.1287/ited.2023.0286","pdf_url":null,"source":{"id":"https://openalex.org/S155575560","display_name":"INFORMS Transactions on Education","issn_l":"1532-0545","issn":["1532-0545"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310315699","host_organization_name":"Institute for Operations Research and the Management Sciences","host_organization_lineage":["https://openalex.org/P4310315699"],"host_organization_lineage_names":["Institute for Operations Research and the Management Sciences"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"INFORMS Transactions on Education","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":53,"referenced_works":["https://openalex.org/W1534687714","https://openalex.org/W1576058466","https://openalex.org/W1967103901","https://openalex.org/W1975810327","https://openalex.org/W1977341090","https://openalex.org/W1979290264","https://openalex.org/W2004163356","https://openalex.org/W2016875621","https://openalex.org/W2093236198","https://openalex.org/W2108598243","https://openalex.org/W2114068613","https://openalex.org/W2129454140","https://openalex.org/W2154489565","https://openalex.org/W2156986666","https://openalex.org/W2199135087","https://openalex.org/W2260323921","https://openalex.org/W2282730585","https://openalex.org/W2486399946","https://openalex.org/W2577832527","https://openalex.org/W2599980125","https://openalex.org/W2604736517","https://openalex.org/W2607594251","https://openalex.org/W2764072425","https://openalex.org/W2786022849","https://openalex.org/W2793266780","https://openalex.org/W2887567850","https://openalex.org/W2909324897","https://openalex.org/W2916399584","https://openalex.org/W2924970388","https://openalex.org/W2965036048","https://openalex.org/W2978390831","https://openalex.org/W2984983445","https://openalex.org/W3005455491","https://openalex.org/W3011188055","https://openalex.org/W3013447971","https://openalex.org/W3014215822","https://openalex.org/W3041288053","https://openalex.org/W3049684724","https://openalex.org/W3084078106","https://openalex.org/W3084559672","https://openalex.org/W3091952275","https://openalex.org/W3092918180","https://openalex.org/W3100297548","https://openalex.org/W3123152138","https://openalex.org/W3143328026","https://openalex.org/W3165744357","https://openalex.org/W3175149678","https://openalex.org/W3200010478","https://openalex.org/W3203619381","https://openalex.org/W4200295987","https://openalex.org/W4205352515","https://openalex.org/W4210433482","https://openalex.org/W4244156568"],"related_works":["https://openalex.org/W4297125457","https://openalex.org/W2556754356","https://openalex.org/W4388808755","https://openalex.org/W2563093951","https://openalex.org/W2884086002","https://openalex.org/W4402837823","https://openalex.org/W4403019849","https://openalex.org/W4248530909","https://openalex.org/W2496041693","https://openalex.org/W2536328971"],"abstract_inverted_index":{"Managers":[0],"are":[1,66,147,203],"increasingly":[2],"being":[3],"tasked":[4],"with":[5,62,121],"overseeing":[6],"data-driven":[7],"projects":[8],"that":[9,49,78,110,157],"incorporate":[10],"prescriptive":[11,128],"and":[12,82,86,95,114,129,139,142,181],"predictive":[13,130],"models.":[14],"Furthermore,":[15],"basic":[16],"knowledge":[17,91],"of":[18,35,75,92,174,178],"the":[19,32,52,56,73,87,158,175],"data":[20,138,179],"analytics":[21,36],"pipeline":[22],"is":[23,42],"a":[24,43,69,102,186],"fundamental":[25],"requirement":[26],"in":[27,37,136,168],"many":[28],"modern":[29],"organizations.":[30],"Given":[31],"central":[33],"importance":[34],"today\u2019s":[38],"business":[39,152],"environment,":[40],"there":[41],"growing":[44],"demand":[45],"for":[46,89,194],"educational":[47],"pedagogies":[48],"give":[50],"students":[51,79,120,162],"opportunity":[53],"to":[54,117,124,150,185],"learn":[55],"fundamentals":[57],"while":[58],"also":[59,148],"familiarizing":[60],"them":[61,184],"how":[63],"such":[64,98],"tools":[65,125],"applied.":[67],"However,":[68],"tension":[70],"exists":[71],"between":[72],"introduction":[74],"real-world":[76,176],"problems":[77],"can":[80],"analyze":[81],"extract":[83],"insight":[84],"from":[85,126],"need":[88],"prerequisite":[90],"mathematical":[93,115],"concepts":[94],"programming":[96,116],"languages":[97],"as":[99],"Python/R.":[100],"As":[101],"consequence,":[103],"this":[104],"paper":[105],"describes":[106],"an":[107,172],"application-focused":[108],"course":[109,159],"uses":[111],"Microsoft":[112,169],"Excel":[113],"introduce":[118],"MBA":[119],"nontechnical":[122],"backgrounds":[123],"both":[127],"analytics.":[131],"While":[132],"students\u2019":[133],"gain":[134,171],"proficiency":[135],"managing":[137],"creating":[140],"optimization":[141],"machine":[143],"learning":[144],"models,":[145],"they":[146,188],"exposed":[149],"broader":[151],"concepts.":[153],"Teaching":[154],"evaluations":[155],"indicate":[156],"has":[160,182],"helped":[161],"further":[163],"develop":[164],"their":[165],"practical":[166],"skills":[167],"Excel,":[170],"appreciation":[173],"impact":[177],"analytics,":[180],"introduced":[183],"discipline":[187],"originally":[189],"believed":[190],"was":[191],"best":[192],"suited":[193],"more":[195],"technically":[196],"focused":[197],"professionals.":[198],"Supplemental":[199,201],"Material:":[200],"materials":[202],"available":[204],"at":[205],"https://doi.org/10.1287/ited.2023.0286":[206],".":[207]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":5}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}