No 90 - Ingesting Excel Data Sources Like a Pro - Bernat Agullo

About this event

TEAMS LINK: https://teams.microsoft.com/meet/43970440298394?p=r98Ux35OWWA2t4wGbJ Details Join us for networking, drinks and a good time catching up with fellow Power BI and Microsoft Fabric enthusiasts Agenda: 5:30PM - 6:00PM Welcome and Networking 6:00PM - 7:00PM Speaker Session Topic: What is Microsoft Fabric? THE SPEAKER - Bernat Agullo Bernat Agulló (https://sessionize.com/app/organizer/speaker/24106/2a346041-f1d8-4543-81b5-053c09ffbe05) Data Platform MVP \| Organizer at Power BI & Fabric Barcelona \| Content Contributor at Tabular Editor \| Partner at Esbrina Passionate about Power BI in general and DAX in particular. Based in Barcelona, I speak Catalan, Spanish, English, Japanese and some German. [[email protected]](mailto:[email protected]) @AgulloBernat (https://twitter.com/AgulloBernat) linkedin.com/in/bernatagullo (https://www.linkedin.com/in/bernatagullo) esbrina-ba.com/blog/ (https://www.esbrina-ba.com/blog/) (blog) esbrina-ba.com (https://www.esbrina-ba.com/) (company) !https://sessionize.com/AssetsAdmin/logo-symbol.svg sessionize.com/AgulloBernat (https://sessionize.com/AgulloBernat) (public speaker profile) THE SESSION Description Excel data sources are not loved by data engineers, but that's the reality in many organizations, so what is to be done? In this session we will explain how to build bullet-proof dataflows that never fail, while catching the errors in a single Power BI Report, where we will also check for missing values in mapping tables and dimensions to ensure referential integrity of the data. This session is based on a real-world use case of an organization with more than 50 different Excel data sources across different departments. Sponsors: Vivanti A big thank you goes out to our sponsor, Vivanti, for their support of this Meetup; providing the venue as well as drinks for attendees. GET AI A big thanks to GET AI for sponsoring the food. If you are interested in an assessment to see if your data is AI ready then check out GET AI's data assessment and POV offer at https://assessment.getai.com.au