MARK WALTER (Industrial Finishes and Systems) - Learn How to Track Errors with a Power Query Error Table
Power Query is a remarkable ETL tool within Power BI; however it is all too easy to overlook errors that might be buried within our data. In this session, Mark will demonstrate a practical solution learned from Reza Rad (PASS Summit 2019) that combines Power Query transformations, and Power BI visuals to help better track and address root causes of errors as they arise in our dataset.
Mark is an Accounting and Analytics Manager at IFS. Since 1958, Industrial Finishes and Systems, Inc. (IFS), a Nationwide distributor, has brought complete system solutions to Auto Body Shops, RV manufactures, Wood product producers, and Aerospace industries. He is originally from Honolulu Hawaii but lived much of his adult life in the Seattle area where he majored in Finance and Accounting. Mark is an long time Excel power user, and today focuses on DAX/M and promoting a data driven culture. Mark enjoys speaking locally with networking and professional groups, helping to promote and build awareness of Power BI in the workplace.
BEN LAWRENCE (DataDx) - Visualizing Anomaly Detection and Interactive Documentation in Power BI
Anomaly detection can be a confusing concept and is hard to present to users in a meaningful way. In this presentation, see how DataDx has leveraged the isolation forest anomaly detection model and markdown to make difficult concepts easy to understand.
DataDx provides cloud-based analytics tools to help medical and dental practices understand their business and make data-driven decisions. Ben Lawrence is an Associate Data Scientist at DataDx. He has a background in data analytics, informatics, and healthcare. Ben enjoys working with data both at work and at Hack Oregon, a local nonprofit where he volunteers.