Posts filed under Power Query

Improving Merging & Appending Power Query (Queries) with Ken Puls

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!

GUEST BIO πŸ‘€

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!

RELATED CONTENT πŸ”—

Ken's Twitter
Ken's LinkedIn
Company Website
Company Blog
MonkeyTools

Posted on September 19, 2023 and filed under Power Query.

Extracting SQL Database/Table Names From Your Power BI Dataset!

Video by: Reid Havens

Learn how to query the XMLA end-point in a Premium (Per User or Capacity) workspace to extract all the Power Query M Code, and parse out your SQL Database names, table, names, and parameters from your queries. Tune in to learn more.

RELATED CONTENT πŸ”—

Extracting All M-Code from a Power BI Dataset

(Livestream Replay) Design Scalable BI Solutions with BI Solution Algebra - with Chris Wagner

DESCRIPTION πŸ“„

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!

GUEST BIO πŸ‘€

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.

RELATED CONTENT πŸ”—

Website
YouTube
LinkedIn
X (Twitter)
Engagement

(Livestream Replay) Leveling Up Power Query - Beyond the U/I (with Chandeep Chhabra)

DESCRIPTION πŸ“„

Learning how to solve advanced problems using the M language which are beyond the scope of Power Query User Interface. Discover the beauty of the mash-up (m) language, additional functions that you can't find using just the U/I, learn about parameters and query types, and more. Tune in to find out!

GUEST BIO πŸ‘€

Chandeep Chhabra works with clients around the world on training and consulting projects on Excel and Power BI. Prior to starting Goodly (his venture), he worked as a Financial Analyst for an Investment Bank in Mumbai, India. Follow and connect with Chandeep online:

RELATED CONTENT πŸ”—

Blog
YouTube
LinkedIn
Twitter

Posted on August 18, 2023 and filed under Livestreams, Power Query.