Category: Power BI & Fabric
-
New MS Learn AI Skills Challenge
A new Microsoft Learn challenge started today! It’s very similar to the previous one I posted about, but this time once you complete it, you get a FREE exam voucher. The previous challenge resulted in a 50% off voucher which is good, but free is better. 😄 Challenge Microsoft Learnpspier (Full URL: https://learn.microsoft.com/learn/challenges?id=b696c18d-7201-4aff-9c7d-d33014d93b25&WT.mc_id=DX-MVP-5002186) If you… (continue >)
-
MS Learn Fabric Analytics Engineer Challenge Part 12
This post is the last in the series specifically about the modules in this Cloud Skills challenge. Yay! The deadline to complete the challenge is February 22, 2024, so I got there with 2 days to spare! This topic is also not covered on the exam, hence it is not being included in the Learn… (continue >)
-
MS Learn Fabric Analytics Engineer Challenge Part 11
This post is about module 9 of the Cloud Challenge series. Like the previous post in this series, it is a topic not covered in the DP-600 exam based on the study guide I read at least. After this, there will be one more post to complete the modules in the challenge, just before the… (continue >)
-
MS Learn Fabric Analytics Engineer Challenge Part 10
This post is about module 8 of the Cloud Challenge series. It’s the first of my series where there was no Learn Live video session for it. It is not a topic that is listed as covered by the DP-600 exam, although it is part of Microsoft Fabric and part of the skills challenge collection.… (continue >)
-
MS Learn Fabric Analytics Engineer Challenge Part 9
This post is the last of the 9 that had a “Learn Together” live video session. The posts after this will cover the modules I missed, numbers 8, 9, and 13 to round out the rest of the challenge. The deadline for the challenge is coming up quickly (ends Feb 22, 2024), and as of… (continue >)
-
MS Learn Fabric Analytics Engineer Challenge Part 8
This post is about module 11 in the Cloud Skills challenge. Previous posts in this series: Part 1 (Introduction, Lakehouses) Part 2 (Apache Spark) Part 3 (Delta Lake tables) Part 4 (Using Data Factory pipelines) Part 5 (Ingesting data with Dataflows Gen2) Part 6 (Getting started with data warehouses) Part 7 (Administration of Microsoft Fabric)… (continue >)
-
MS Learn Fabric Analytics Engineer Challenge Part 7
This post covers module 10 in the Cloud Skills challenge. This is where the video series and the challenge modules start to diverge a bit. Modules 8, 9 and 13 were not covered in the Learn Together video series, so I will be covering those last. Modules 10, 11 & 12 were covered in a… (continue >)
-
MS Learn Fabric Analytics Engineer Challenge Part 6
This post is about module 7 in the Cloud Skills challenge. Previous posts in this series: Part 1 (Introduction, Lakehouses) Part 2 (Apache Spark) Part 3 (Delta Lake tables) Part 4 (Using Data Factory pipelines) Part 5 (Ingesting data with Dataflows Gen2) Microsoft Learn Module Get started with data warehouses in Microsoft Fabric This module… (continue >)
-
MS Learn Fabric Analytics Engineer Challenge Part 5
This post is about module 6 in the Cloud Skills challenge. Previous posts in this series: Part 1 (Introduction, Lakehouses) Part 2 (Apache Spark) Part 3 (Delta Lake tables) Part 4 (Using Data Factory pipelines) Microsoft Learn Module Ingest Data with Dataflows Gen2 in Microsoft Fabric This module is about Dataflows Gen2, a cloud-based ETL… (continue >)
-
MS Learn Fabric Analytics Engineer Challenge Part 4
This post is about module 4 in the Cloud Skills challenge. Previous posts in the series: Part 1 (Introduction, Lakehouses) Part 2 (Apache Spark) Part 3 (Delta Lake tables) Microsoft Learn Module Use Data Factory Pipelines in Microsoft Fabric This module is about Data pipelines, which will be familiar to anyone who uses Azure Data… (continue >)
-
MS Learn Fabric Analytics Engineer Challenge Part 3
This post is about module 3 in the Cloud Skills challenge. Previous posts in the series Part 1 (Introduction, Lakehouses) Part 2 (Apache Spark) Microsoft Learn Module 3 Working with Delta Lake tables in Microsoft Fabric This module is about the Delta Lake storage format in lakehouses, creating and working with delta tables in Spark.… (continue >)
-
MS Learn Fabric Analytics Engineer Challenge Part 2
In this post, I am covering module 3 of the Microsoft Learn challenge. Previous posts in the series Part 1 (Introduction, Lakehouses) Microsoft Learn Module 2 Use Apache Spark in Microsoft Fabric This module shows how to configure and use Apache Spark for data processing and analytics in Microsoft Fabric. Spark is frequently used in… (continue >)
-
MS Learn Fabric Analytics Engineer Challenge Part 1
Part 1 of the series covers the Microsoft Learn Cloud Skills challenge, modules 1 and 2: Introduction to Fabric, and Lakehouses. (continue >)
-
Microsoft Fabric Analytics Engineer challenge
If you happen to follow me on LinkedIn, you may have seen some of my posts recently about the “Learn Together” Microsoft Fabric live training series. As I watched each of the 9 sessions over the past 3 weeks, I would post a note about each with a link. Now I’m going to write a… (continue >)
-
Power BI, Excel & GP – SQL sources
Today’s post combines the topics of the previous two posts and moves into Power Query to connect to SQL directly instead of connecting to static, exported SmartLists or flat files. Previous posts in the series Introduction Starting from scratch Data Access What this post covers In this post, I am using the same context of… (continue >)
-
Power BI, Excel & GP – Data Access
The third post in the series, discussing data access considerations and options to securely handle your data in a report. (continue >)
-
Power BI, Excel & GP – Starting from scratch
The first part of my series around Power BI, Excel & Dynamics GP begins with some of the basics, and a way to start learning Power Query, starting from scratch. From my experience, an audience that is often overlooked is users who want to learn more or improve their skills but don’t know where to… (continue >)
-
Power BI, Excel & Dynamics GP
Soon I will be starting a new series of posts around Dynamics GP and how to get data out of it with Power BI or Excel via Power Query. There is no shortage of reporting options available for Dynamics GP customers, with many ISV (3rd party) products out there to augment some out-of-the-box options (Report… (continue >)
-
Clear Recent Items list in Power BI Desktop
How to clear the recently opened items list in Power BI Desktop. (continue >)
-
Power BI number formatting tips
Two tips for formatting numbers in Power BI, replacing zeroes with dashes and displaying something other than blanks. (continue >)
-
Power BI matrix column width sizing
A post with tips about managing the column width in matrix visuals in Power BI. (continue >)