DP-700 Training: Data transformation options

Welcome to my Ted Talk, data transformation is done in T-SQL. Thank you. Well, yes once upon a time, maybe. Nowadays there are many more ways that lead to the dark side (also known as data vault) and the happy side (also known as the star schema or dimensional model). Did I lose you yet? … Continue reading DP-700 Training: Data transformation options

DP-700 Training: endorse, promote and certify your items

Now that's a long title! Luckily, this concept isn't really hard so you should be in for a smooth ride today. What is this easy thing? Well, to put it quite simple, you can add three labels to items in your Fabric workspace:- Promoted- Certified- Master Data In my view, there's an order to these … Continue reading DP-700 Training: endorse, promote and certify your items

DP-700 Training: Process data using KQL

This post can come as a shock if you're used to writing T-SQL. Because not only is there more than one useful language to process data, realtime data in this case, but it also has enough similarities to SQL to look familiar and is different enough to leave you flustered. Now, to get a complete … Continue reading DP-700 Training: Process data using KQL

DP-700 training: create windowing functions

Let's start this blog with a personal opinion: I love windowing functions. Sounds like a good start of this post? Cool, let's keep going. What is a windowing function? There's a lot you can read about it, but in short it comes down to creating a subset in your query result where you apply a … Continue reading DP-700 training: create windowing functions

DP-700 training: exploring event streams

Microsoft Fabric really is a Swiss army knife when it comes to its possibilities. Not only capable of hosting your BI information which is usually loaded at night and analysed during working hours but it can also process real time information. Let's dig into that some more! Data Fabric architecture Before we go all nerdy … Continue reading DP-700 training: exploring event streams

DP-700 training: Create and configure deployment pipelines

In one of the earlier blogs, the topic revolved around everything Git. Git is a version control system where you can leverage CI/CD. I love Git, even though it has a habit of biting me severely in the parts I use to sit on. If you're not well versed in Git or have no option … Continue reading DP-700 training: Create and configure deployment pipelines

DP-700: Configure version control

This blogpost will be introductory to version control within Microsoft Fabric. If you've got the basics of this under control, you're welcome to refresh your knowledge in this blog or check out our points of view. Alternatively, you can dig into the blogposts by Kevin Chant who has a lot of good posts on this … Continue reading DP-700: Configure version control

DP-700 Exam training: Configure OneLake workspace settings

OneLake, the OneDrive for all your data, the One Lake to rule them all or however you've heard it being described. Whatever you've heard, OneLake is the single storage on your tenant used to store all the data of your Fabric Capacities. About OneLake The core point to remember is that your tenant has just … Continue reading DP-700 Exam training: Configure OneLake workspace settings

DP-700 exam training: Configure Domain workspace settings

In the previous blog, you read about the Spark settings within the workspace. This time it's about the domain settings. So let's dig into what domains are, what you can use them for and which settings there are. What are domains? If you read (and you should) the excellent book on data architectures by James … Continue reading DP-700 exam training: Configure Domain workspace settings

DP-700 exam training: Configure Spark workspace settings

In this blog and associated video, we'll dig into the Spark workspace settings. First we'll discuss what workspaces are in relation to Spark, then we'll dig into the Spark settings to give you an overview. As with all our blogs and video's, we strongly advise you to take this material as a starting point and … Continue reading DP-700 exam training: Configure Spark workspace settings