Havens Consulting
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.
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.
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!
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:
Video by: Reid Havens
Learn about five useful tips and techniques for upgrading your Power Query skills. These tips can be useful for those just getting started in Power Query, and even for those maybe a bit more familiar or intermediate with the tool. Tune in to learn more!
Referencing Other Queries
Data Profiling Tools
Using Parameters
Sharing Queries
Query Folding
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.
