{"id":1525,"date":"2025-02-06T06:59:53","date_gmt":"2025-02-06T11:59:53","guid":{"rendered":"https:\/\/www.marshall.edu\/irp\/?p=1525"},"modified":"2025-12-16T16:42:18","modified_gmt":"2025-12-16T21:42:18","slug":"seasonoftransformation","status":"publish","type":"post","link":"https:\/\/www.marshall.edu\/irp\/2025\/02\/06\/seasonoftransformation\/","title":{"rendered":"Institutional Research Update: A Season of Transformation"},"content":{"rendered":"<p>The past couple of months have seen a whirlwind of progress in Institutional Research at Marshall University. As we continue to refine our data processes and improve transparency, the transformation of our workflows has been nothing short of significant. Here are some key updates on what we have accomplished and what is on the horizon.<\/p>\n<h2>The SAS to SQL Conversion: A Major Milestone<\/h2>\n<p>One of the biggest achievements over the past quarter was converting all SAS scripts used for official state reporting to SQL. This was a painstaking and meticulous process, which I have actually referred to as sadistically fun, but the benefits of standardization, efficiency, and long-term sustainability made it worth the effort. A huge shout-out to my colleague <strong>Gordon Mitchell<\/strong> at Mountwest Community and Technical College for his support in making this transition possible as he shared insights from his scripts with me and I was able to combine that with knowledge of our home grown data warehouse to push these over the top. This conversion not only modernizes our data processing but also improves accessibility and adaptability for future reporting.<\/p>\n<h2>IPEDS Winter Collection Submission: A First-Time Oversight<\/h2>\n<p>For the first time, I had the opportunity to oversee the Integrated Postsecondary Education Data System (<strong>IPEDS<\/strong> &#8211; <strong>NCES<\/strong>) winter collection submission. This experience involved writing several new SQL scripts, reviewing and refining existing ones, and identifying inconsistencies that need to be addressed moving forward. None of this could have been accomplished without the dedicated efforts of our team in IT, Financial Aid, and, of course, Jessica Lowman.<\/p>\n<h2>Welcoming Jessica Lowman to the IR Team<\/h2>\n<p>Speaking of Jessica, please join me in welcoming her \u201cback\u201d to the team! Jess, a faculty member at Marshall University, now also serves as Director of Institutional Research (and Assistant Professor \/ Archivist &amp; Digital Stewardship Librarian). With previous experience in IR, Jess brings an incredible depth of knowledge and expertise to the team. We are excited to have her on board and look forward to her contributions in shaping the future of our data operations and Marshall University as a whole as her insights will be invaluable to our university\u2019s future.<\/p>\n<h2>New Faculty Dashboards and Validation Tools<\/h2>\n<p>Over the past couple of months, we have also introduced <strong>new faculty dashboards<\/strong> in PowerBI to track average faculty pay and status. These dashboards provide clear and actionable insights, ensuring that faculty data is managed efficiently and transparently and most importantly, up to date as deans and business managers now have a clear picture of the various faculty data points in a single location that are stored throughout Banner.<\/p>\n<p>Additionally, we have rolled out a suite of <strong>data validation tools in Python and SQL<\/strong>, aptly named <strong>Automagic<\/strong> and <strong>Cleanslate<\/strong>. These tools have been game-changers in ensuring data accuracy and integrity, reinforcing our commitment to strong <strong>data governance<\/strong>.<\/p>\n<p>A special mention to <strong>Sam Aretz<\/strong> from the IR team for developing a <strong>new validation dashboard<\/strong>, further solidifying our efforts in ensuring data quality so that our data stewards are aware of data cleaning needs long before those allnighters we all just pulled when reports were due.<\/p>\n<h2>Academic Analytics for Deans<\/h2>\n<p>Deans now have access to a brand-new <strong>Academic Analytics tool<\/strong> in PowerBI. This tool is designed to provide deans with a clear, concise view of academic performance, student outcomes, and faculty-related insights. This initiative aims to enhance decision-making at the academic leadership level through comprehensive, real-time analytics on class sizes, student credit hour generation and more.\u00a0 Coupled with our comprehensive budget model scripts, there is definitely not a lack of data available.<\/p>\n<h2>Transparency and Documentation: A New Era for IR<\/h2>\n<p>One of the most significant improvements we have made is in <strong>documenting and cataloging<\/strong> our nightly and weekly cron processes. For the first time in nearly three decades, all of these scripts are available to the entire team, and everyone has visibility into where our data comes from and how it is processed. This move toward <strong>openness, transparency, and data governance<\/strong> is a huge step forward in institutional research at Marshall.<\/p>\n<h2>What\u2019s Next?<\/h2>\n<p>The momentum will not stop here. Over the next few months, we will focus on:<\/p>\n<ul>\n<li><strong>Creating a Data Lake in PowerBI<\/strong> to streamline data storage and retrieval.<\/li>\n<li><strong>Updating the remaining SAS scripts<\/strong> in-house to <strong>pure SQL<\/strong> to complete our transition.<\/li>\n<li><strong>Developing additional validation tools<\/strong> to further enhance data accuracy.<\/li>\n<li><strong>Creating efficiencies<\/strong> for our next <strong>IPEDS submission<\/strong> to make the process smoother and more consistent.<\/li>\n<li><strong>Transforming<\/strong><strong> our internal data books to powerBI<\/strong><\/li>\n<\/ul>\n<p>We are excited about the progress we have made and even more thrilled about what is to come. A huge thank you to everyone who has contributed to these improvements\u2014your dedication to institutional research is shaping a more data-informed and transparent future for Marshall University.<\/p>\n<p>Driving all decisions, with data!<\/p>\n<p>Brian M. Morgan<br \/>\nChief Data Officer, Marshall University<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The past couple of months have seen a whirlwind of progress in Institutional Research at Marshall University. As we continue to refine our data processes and improve transparency, the transformation of our workflows has been nothing short of significant. Here are some key updates on what we have accomplished and what is on the horizon.<\/p>\n","protected":false},"author":78,"featured_media":1524,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[70],"tags":[],"class_list":["post-1525","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data2decisions"],"acf":[],"fimg_url":"https:\/\/www.marshall.edu\/irp\/files\/0206.jpg","_links":{"self":[{"href":"https:\/\/www.marshall.edu\/irp\/wp-json\/wp\/v2\/posts\/1525","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.marshall.edu\/irp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.marshall.edu\/irp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.marshall.edu\/irp\/wp-json\/wp\/v2\/users\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/www.marshall.edu\/irp\/wp-json\/wp\/v2\/comments?post=1525"}],"version-history":[{"count":4,"href":"https:\/\/www.marshall.edu\/irp\/wp-json\/wp\/v2\/posts\/1525\/revisions"}],"predecessor-version":[{"id":1646,"href":"https:\/\/www.marshall.edu\/irp\/wp-json\/wp\/v2\/posts\/1525\/revisions\/1646"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.marshall.edu\/irp\/wp-json\/wp\/v2\/media\/1524"}],"wp:attachment":[{"href":"https:\/\/www.marshall.edu\/irp\/wp-json\/wp\/v2\/media?parent=1525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.marshall.edu\/irp\/wp-json\/wp\/v2\/categories?post=1525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.marshall.edu\/irp\/wp-json\/wp\/v2\/tags?post=1525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}