Cleaning and Presenting Big Data with Python and Power BI

Teams Meeting: Link

Abstract:
In the world of pharmaceutical benefits, harnessing the power of big data is important for informed decision-making. This presentation will explain the process of wrangling large datasets from disparate Pharmaceutical Benefit Managers (PBMs). Using Python, specifically the Pandas library, we navigate the process of data cleaning and normalization to ensure consistency across varied PBM datasets.
Additionally, we will demonstrate the visualization tools of Power BI in rendering complex pharmaceutical benefit data into intuitive and insightful reports. These visualizations are designed to meet the needs of both clients and consultants, ensuring accessibility and understanding of the complex realm of pharmaceutical benefits. Attendees will gain insights into the practical application of Python for data transformation, the nuances of handling large data, and the process of creating compelling visual narratives using Power BI.

Speakers:
Allison Harris is a Business Intelligence Analyst at NFP Rx Solutions, with a specialization in Python development. She successfully graduated from Launch Code in 2022, where she pursued the Data Analytics track, equipping her with a robust set of skills in data manipulation, analysis, and interpretation.
Prior to her transition into the tech industry, Allison had a career as a Herpetologist, studying amphibians and reptiles.
Matt McKeever is a Business Intelligence Analyst at Rx Solutions in Chesterfield, MO. In his time there, Matt has focused primarily on Microsoft Power Platform, such as Power BI and Power Automate, as well as Python development. Matt received his training through LaunchCode, where he graduated in 2023. Prior to working in business intelligence, Matt was a middle school and high school band instructor. He performs regularly in a number of St. Louis-based bands