Lance Lendl

Lance Lendl

Power BI Developer

Business Intelligence Architect

Business Intelligence Analyst

 

Summary

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.

Education

University of Saint Thomas - BS, Business Management St. Paul, MN

 

Technical Experience

Power BI
Power Query
Power Apps
Dataflows

Excel
Azure
Azure ML Studio
Azure Cognitive Services
Data Factory 

SSAS
SSMS
Visual Studio
Microsoft Dynamics/CRM
Microsoft Flow

 

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.