Havens Consulting
Video by: Reid Havens
Learn about a technique to to rename columns containing either CamelCase or underscore (_) title formatting in Power Query. This technique was originally posted by Jani Zajc (links below) who collaborated with Gil Raviv to create this technique, and which was inspired by a post by Chris Webb (so many people!). Tune in to learn more!
CamelCase Renaming
DataChant
Chris Webb's Post
FourMoo Other Renaming Technique
Video by: Reid Havens
Learn how to write simpler M-Code which maintains Query Folding. Features like Column from Example can be very powerful in helping you create new columns in Power Query, but the code it writes might not always fold! You can fix this with a bit of light M code edits, and maintain your Query Folding. Tune in to learn more!
Video by: Reid Havens
Learn an improved way to merge or append queries (as new) by adding an additional source applied step. Ken Puls will walk you through this, and why it'll benefit your query logic moving forward. Tune in to learn more!
Ken Puls is the president of Excelguru Consulting Inc, a company dedicated to helping users get the most from their data. A blogger, software developer, author and trainer with over 20 years of accounting and IT experience, Ken's passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. Learn more about Ken at the links below!
Ken's Twitter
Ken's LinkedIn
Company Website
Company Blog
MonkeyTools
Join Chris Wagner and Reid Havens as they talk about BI Solution Algebra, a framework for designing business intelligence solutions that are scalable, efficient, and cost-effective. They will share their insights and tips on how to choose the right mix of front-end, model, ETL, and other components to optimize your data analytics efforts. Whether you are a beginner or an expert, you will learn something new and useful from this lively and engaging conversation. Don’t miss this opportunity to learn from two of the best in the field!
Christopher Wagner is a passionate data evangelist and a leader in data solutions. He is the Director of Data Solutions for Baker Tilly, a leading digital solutions, advisory, tax and assurance firm. He is also the founder of KratosBI.com, a website that provides resources, tutorials and insights on data and analytics. He hosts the Data Gods YouTube channel, where he shares his knowledge and experience with data enthusiasts and professionals.
Christopher has over two decades of experience in the data and analytics field, working with various technologies, platforms and tools. He has helped many organizations transform their data into valuable insights and actionable outcomes. He believes that data is the most powerful asset in the digital age, and he strives to make it accessible and understandable to everyone.
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.