In today's data-driven business environment, the significance of data warehouses cannot be overstated. These powerful tools not only consolidate data from diverse sources but also enhance decision-making and strategic planning processes. Dr. Michael Salé, a seasoned expert in information technology management and a dedicated educator at Stonehill College, invites you to delve into the world of data warehousing using SAS. With a career spanning decades in IT management/consulting and a proven track record in leveraging IT systems for strategic advantages, Dr. Salé brings a wealth of knowledge and practical insights to this session. This webinar is designed to equip participants with the skills to construct a data warehouse by querying data from multiple sources, including databases (using SQL), flat files, and web services. Attendees will be guided through an ETL (Extract, Transform, Load) process that transforms this diverse data into a star schema, making it easily queryable for end-users. This session will not only cover the technical aspects of building a data warehouse using SAS but will also emphasize the strategic importance of data warehouses in today's competitive business landscape.

BIO:

Michael Salé is an Associate Professor of Management Information Systems at Stonehill College. He has vast experience in information technology management/consulting and multiple successes in helping organizations leverage IT systems to meet their strategic goals. He is also an Agile software development coach. Dr. Salé began his career as a Senior Project Manager in the higher education software industry where he led the implementation of enterprise-level administrative software at hundreds of colleges and universities in the United States and overseas. He also owns his own consulting firm, Portico Consulting Group, which specializes in providing services to college and university information technology teams. His main teaching areas include management information systems, data analytics, and software engineering. He has been a SAS user for 24 years.