(Livestream Replay) Data Warehousing with Microsoft Fabric - with Andy Cutler

DESCRIPTION πŸ“„

With the introduction of Microsoft Fabric in 2023, the scope of data workloads available has expanded to include Power BI, Lakehouse, Warehouse, and Real-time Streaming. In this session we'll be diving into one of the workloads that Fabric offers, Data Warehousing. We'll cover a quick introduction to Fabric with a discussion on lakehouse vs warehouse. Then we'll dive into the SQL engine and look at how to create a Warehouse including objects like tables and stored procedures. We'll then look at how to load warehouses using SQL and Pipelines.

GUEST BIO πŸ‘€

Andy Cutler is an independent consultant specialising in the Azure Data Platform, working predominantly with Azure Synapse Analytics, Data Factory, SQL Server and Power BI. He holds an MSc in Business Intelligence and Data Mining, and is a current Microsoft Data Platform MVP.

RELATED CONTENT πŸ”—

LinkedIn
Blog
Company
YouTube

Posted on September 1, 2023 and filed under Livestreams, Fabric.

Simplifying [DAX] with Staging Tables & Relationships in Power BI

Video by: Reid Havens

Learn how to leverage model tables/columns, and relationships to simplify your DAX code for your Power BI datasets (models), leading to simpler measures, and potentially more efficient (faster) calculations and visual queries. Tune in to learn more!

(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.

5 Pro Tips for Getting Started with Power Query

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!

RELATED CONTENT πŸ”—

Referencing Other Queries
Data Profiling Tools
Using Parameters
Sharing Queries
Query Folding