Episode 197: Power Query in Power BI

Episode 197: Power Query in Power BI

In 1990, the group Snap! release a song called "The Power". It would take Microsoft more than 20 years, but they eventually came up with a series of 'power' tools they built into Excel. Those tools later grew into Power BI--which is kinda like Voltron if you are old enough to remember. In this episode we discuss one of the first data manipulation tools in the set: Power Query. Before you start manipulating all those fun visualizations, you might need to get your data in shape. If you have a data warehouse, you are probably in good shape; however, for the rest of us, there is Power Query. This episode takes us through an overview and discusses in what cases you might have to dive into the code, or M language, when the GUI doesn't cut it.

The show notes for today's episode can be found at http://sqldatapartners.com/2020/04/15/episode-197-power-query-in-power-bi. Have fun on the SQL Trail!

Jaksot(287)

Episode 271: Pass Summit 2023 Wrap-Up

Episode 271: Pass Summit 2023 Wrap-Up

This past November, Eugene and I attended the 2023 PASS Data Community Summit (aka PASS Summit) in Seattle, while Kevin headed down to Orlando for the Microsoft Live! 360 event in Orlando. Having no r...

29 Joulu 202338min

Episode 270: Medallion Architecture

Episode 270: Medallion Architecture

Moving up the ranks in the holy technology wars is the medallion architecture, and boy are we interested in getting your thoughts. Not since the 2008 Olympics and Michael Phelps' tenth of a second win...

21 Marras 202339min

Episode 269: Why Do I Need a Managed Service Provider?

Episode 269: Why Do I Need a Managed Service Provider?

In this Episode, Carlos talks about managed services and shares some of the benefits of working with an MSP, as well as potential cons.  The term manage services refers to the practice of outsourcing ...

19 Loka 202316min

Episode 268: AI and the Future of the Database

Episode 268: AI and the Future of the Database

We love hearing from our listeners!!! In this episode, a long-time listener asked about the future of AI in the data platform space. We thought this was a very interesting topic as Microsoft has been ...

28 Syys 202353min

Episode 267: Microsoft Fabric

Episode 267: Microsoft Fabric

All your data, all your teams—in one place. What am I? If you said Microsoft Fabric, you win! When I interned with Cisco Systems in 2000, I supported a platform called Unified Messaging. At that time,...

12 Syys 202343min

Episode 266: Working with Containers

Episode 266: Working with Containers

We're kicking off Season 7 with containers! Spinning up a VM may not be such a big deal anymore; however, most of us still have to request from another group one and wait. Even waiting on an Azure VM ...

29 Elo 202336min

Episode 265: WHY and What's Next

Episode 265: WHY and What's Next

Compañeros! In May, SQL Data Partners was acquired by Marathon Consulting.  There were many moving parts to get this done and we are excited to finally bring this news to the podcast.  In this episode...

28 Kesä 202331min

Episode 264: Verified Backups

Episode 264: Verified Backups

A backup is only helpful when you can restore the backup. This should not prove to be overly shocking; however, normally we get the satisfaction of taking a backup and feel like all is well. Ideally, ...

12 Huhti 202341min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
voi-hyvin-meditaatiot-2
psykopodiaa-podcast
rss-narsisti
adhd-podi
rahapuhetta
rss-rahamania
kesken
psykologia
rss-liian-kuuma-peruna
rss-niinku-asia-on
esa-saarinen-filosofia-ja-systeemiajattelu
rss-eron-alkemiaa
rss-luonnollinen-synnytys-podcast
rss-arkea-ja-aurinkoa-podcast-espanjasta
rss-duodecim-lehti
rss-koira-haudattuna
rss-vapaudu-voimaasi
rss-valo-minussa-2
rss-finnish-daily-dialogues