Power BI Developer
Business Intelligence Architect
Business Intelligence Analyst
Lance has been working extensively with Power BI and complementary Microsoft Suite apps to unlock the full potential of the reporting service. From data cleansing and modeling to ultimately creating impactful visualizations he is able to leverage Power Query M and DAX to effectively wrangle, load, analyze and consume unstructured data.
University of Saint Thomas - BS, Business Management St. Paul, MN
Azure ML Studio
Azure Cognitive Services
Project: Power BI Dashboard
Client Info: Internal Beyond Impact
Project Overview: Efficiently represent Dynamics365 phone call logs, email logs, and appointments ¬while being able to identify new contacts and appointments.
Project Timeline: Three weeks
Incorporated slicers and focus view into buttons to give visuals more real estate on the canvas. Replaced visuals to better represent the data. Aligned report color scheme with business color scheme. It identified new customers and contacts and provided a better view to all visuals.
Project: Model Barnco Data
Project Overview: Shape Barnco data to be report ready
Client Info: Barnco is an experience concept and realization company
Project Timeline: Four weeks
Created dataflows to ingest and model future data sources. Identified appointments booked by Groupon and Voucher codes from unstructured data. Cleansed all ambiguous data. Significantly lightened the data model. Made it possible to measure two instances of dates from the same fact table rather than creating two fact tables.