SPEAKER
Oz du Soleil
By day, he tussles with Crap Data in Excel, blazing trails through data’s dusty badlands. By night, he’s a keen collector of kaleidoscopes. With a fiery passion for teaching and a vicious spirit in the wild west of data, Oz has taught classes for Xfinity, Northwestern University, and the World Health Organization, empowering students around the globe, from Perth, Australia; Sofia, Bulgaria, and São Paulo, Brazil.
You can catch Oz in action on YouTube at ‘Excel on Fire’ his many courses on the LinkedIn Library and books co-authored with Bill Jelen, Mr. Excel.
You’re faced with 2 datasets that need to be merged, compared, or parsed. Lots of data and you have to do it over and over again with needs like:
Bring data from dataset A and match with the records in dataset B—if there are matches
Identify the records that are in B but not also in A
Isolate the data that’s in both A and B
Power Query and the 6 joins/merges are what you need!
This session will be a thrilling and thorough odyssey through Power Query’s 6 joins, unveiling their power, and knowing when a join is preferable to the mighty XLOOKUP.
OTHER SPEAKERS
Acquisition, capital raise, project finance and corporate lending professional. Has MSc in civil engineering & construction, and project & structured finance.
An independent mining engineer and a university lecturer in Mining Engineering.
Practice Lead for Governance, Adoption and Change Management, SoftwareOne North America
Founder of The Golden Company. FMWC 2022 and 2023 Champion. Ex Wall Street quant.
Previously worked as actuary in PwC and Taylor Fry. Five times ModelOff finalist and one time bronze medalist. Two time MEWC finalist.
Worked at Operis for 2 years together with Michael Jarman. Active FMWC and MEWC participant. Part of the case design team. Currently pursuing an MSc. in Mathematics and Statistics.
Contractor with an impressive 23-year track record in the actuarial departments of leading insurance providers in Europe and the UK.
Road to Las Vegas and MEWC cases' author, Consultant at Oliver Wyman
Award-winning author in analytics, data science, and data visualization. 11-time Microsoft MVP Award winner
Founder & CEO of Financial Modeling World Cup. Financial Modeling World Championship 2-time finalist
25-time Excel MVP Award winner, author of 5 Excel books, Excel user since version 0.99
Executive Director at Financial Modeling Institute. Chartered Financial Modeler
Founder of The FP&A Guy. Providing world-class content and training for FP&A and Finance Professionals
Founder of Vertex42.com. Spreadsheet template developer since 2003
KEY PARTNERS
