In this blog post, I share my experience preparing for and passing the DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric exam. I discuss the study resources I used, including the official study guide, Microsoft Learn modules, and a Study Tracker I built in Power BI to monitor my progress. I also provide insights into navigating Microsoft Learn during the open-book exam and tips for effective exam preparation. If you're planning to take DP-700, this post will help you structure your study approach and maximize your chances of success.
Power Apps with Microsoft Fabric SQL Database: Standalone applications or enabling writeback in Power BI
In this post, I will first share how to create a standalone Power Apps application that works with Microsoft Fabric SQL Database and then show embedding options for enabling writeback in Power BI and automatic page refresh to see results in near real time.
Updating Microsoft Fabric Warehouse with Power Apps visual in Power BI
Writeback to Microsoft Fabric Warehouse using Power Apps and Power BI
Getting ready for and taking Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric
Microsoft Fabric has introduced the DP-600 certification for "Fabric Analytics Engineer Associate". This post provides insights regarding the exam process and experience as well as preparations tips for the exam.
Microsoft Fabric: Workspace access, Item level access, SQL policy and object level security
In this post, I explore various sharing options that Microsoft Fabric provides, from workspace level to item level to object level with SQL policy.
Slides from my “Intro to Power Apps and Power BI” session at DataWeekender
Here are my slides from my presentation at DataWeekender on 11/4/2023 are posted here. Beginners-Guide-to-Power-Apps-and-Power-BI-DataWeekender-CU6.5-2023Download https://www.dataweekender.com/schedule
Slides for Intro to Lakehouse in Microsoft Fabric
Here are the slides for my Intro to Lakehouse in Microsoft fabric. If you are new to Microsoft Fabric, check out my post here for an intro. Introdcution-to-Lakehouse-in-Fabric-2023-09-11-Shabnam-Watson-2Download I will upload sample notebooks later today and update this post.
Microsoft Fabric
An introduction to the new Microsoft Fabric: Brings together the best of data integration, data warehousing, data science, data analytics and reporting, and more!
Starting with Azure Synapse Analytics: Part 1: Create a Workspace and Analyze Sample Data with Serverless SQL Pool
In this blog post, I show you how easy it is to start an Azure Synapse Analytics workspace (instance) and use its Serverless SQL Pool engine to analyze sample publicly available data. As you will read shortly, Azure Synapse Analytics provides many compute engines for different use cases. The easiest one to get started with … Continue reading Starting with Azure Synapse Analytics: Part 1: Create a Workspace and Analyze Sample Data with Serverless SQL Pool
Incremental Refresh for Power BI datasets based on a numeric column (Year): Working with Parquet/Delta files in Azure Synapse Analytics
The most common scenario for setting up the out of the box incremental refresh in Power BI is to base it off of a datetime column; however, there are cases when you may want to set up incremental refresh based off of a column with a data type other than datetime. Examples are when you … Continue reading Incremental Refresh for Power BI datasets based on a numeric column (Year): Working with Parquet/Delta files in Azure Synapse Analytics