Data Analytics Consultant; Project Sponsor: Amcon Distributing Company
• Constructed a sales item dashboard using PowerBI for Account Manager’s to relate to Retail Partners’ and explore market opportunities to increase profit margins and sales transactions• Built a data pipeline applying Python to clean excel files given from the sponsor and transformed the files to a Pandas Data Frame where it can be administered to SQL• Utilized MySQL workbench to create tables, load the data, and query new sales metrics to upload into PowerBI dashboard• Engaged with a team of six student teammates and project sponsor in weekly meetings to revise dashboard prototypes, celebrate accomplishments and plan for upcoming tasks