Channel Title: Learn Microsoft Fabric with Will Channel Description: I help beginner and experienced data professionals learn Microsoft Fabric. How? ✅ I publish videos here on YouTube, ✅ our free community for learning Microsoft Fabric: skool.com/microsoft-fabric ✅ I’m an Instructor at Fabric Dojo: https://skool.com/fabricdojo What do I cover? My focus for 2024 is to build a collection of lessons that help you build a really strong foundation in concepts that are important in the Microsoft Fabric world: so data [warehousing, pipelines, engineering and science] - and to have fun doing it! Who am I? I'm Will 👋 I've been working in data since 2016 when I built my first Power BI dashboard. Since then, I've worked in data science, real-time analytics, data engineering and solution architecture. Mostly within the Microsoft stack, but also worked with Elasticsearch, DBT, JS/ Front-end Data Viz <video> Using T-SQL to query data in Microsoft Fabric | DP-600 EXAM PREP (12 of 12) Description: IMPORTANT! As of 15th Nov 2024, the DP-600 study guide has CHANGED! For updated DP-600 study notes & discussion: https://www.skool.com/microsoft-fabric/about/ In this video (11 of 12 in the series), we cover the following sections of the DP-600 study guide: Implement descriptive and diagnostic analytics Integrate prescriptive and predictive analytics into a visual or report Profile data This video is part of the DP-600 Exam Preparation series: https://www.youtube.com/playlist?list=PLug2zSFKZmV05ZJcmHemXxyJjPVXeQ2qS Timeline 0:00 Intro 1:18 Ways to access the T-SQL engine in Fabric 2:43 XMLA Endpoint 3:17 T-SQL: some possible topics for the exam 4:10 Create Table As Select (CTAS) 5:47 Viewing our data 6:17 Grouping and Aggregates 7:13 WHERE & HAVING 9:40 JOINS 10:10 Common Table Expressions (CTEs) 12:49 LEAD and LAG 15:57 ROW_NUMBER() and partitions 17:36 Subqueries 18:49 T-SQL Visual Query Editor 23:10 Practice Questions 31:49 Thank YOU! #microsoftfabric #dp600 #powerbi </video> <video> Shortcuts and data ingestion in Microsoft Fabric | DP-600 EXAM PREP (5 of 12) Description: IMPORTANT! As of 15th Nov 2024, the DP-600 study guide has CHANGED! For updated DP-600 study notes & discussion: https://www.skool.com/microsoft-fabric/about/ In this video (5 of 12 in the series), we begin Section 2 of the DP-600 Study Guide: Prepare and Serve Data. We start by exploring the following topics: - Ingest data by using a data pipeline, dataflow, or notebook - Copy data by using a data pipeline, dataflow, or notebook - Choose an appropriate method for copying data from a Fabric data source to a lakehouse or warehouse - Create and manage shortcuts This video is part of the DP-600 Exam Preparation series: https://www.youtube.com/playlist?list=PLug2zSFKZmV05ZJcmHemXxyJjPVXeQ2qS Timeline 0:00 Intro 1:42 Ingestion methods overview 3:13 Dataflow for data ingestion 5:52 Data pipeline for data ingestion 8:02 Fabric notebook for data ingestion (Spark) 10:24 Shortcuts overview 12:04 Shortcuts permissions 13:05 When to use which method? 15:09 Practice Questions 19:59 Outro and next steps #microsoftfabric #dp600 #powerbi </video> <video> Transforming data | PySpark, T-SQL & Dataflows in Microsoft Fabric | DP-600 EXAM PREP (7 of 12) Description: IMPORTANT! As of 15th Nov 2024, the DP-600 study guide has CHANGED! For updated DP-600 study notes & discussion: https://www.skool.com/microsoft-fabric/about/ In this video (7 of 12 in the series), cover the following: Data cleansing: Implement a data cleansing process Identify and resolve duplicate data, missing data, or null values Convert data types by using Dataflows or PySpark Filter data Data enrichment Merge or join data Enrich data by adding new columns or tables Data modelling Implement a star schema for a lakehouse or warehouse, including Type 1 and Type 2 slowly changing dimensions Implement bridge tables for a lakehouse or a warehouse Denormalize data Aggregate or de-aggregate data This video is part of the DP-600 Exam Preparation series: https://www.youtube.com/playlist?list=PLug2zSFKZmV05ZJcmHemXxyJjPVXeQ2qS Timeline 0:00 Intro 1:29 Data cleansing process 2:26 Introduction to the dataset 3:31 Dataflow: data cleaning 6:55 T-SQL: data cleaning 10:51 PySpark: data cleaning 20:25 Star schema 22:41 Slowly-changing dimensions 23:36 Type 1 SCD 24:27 Type 2 SCD 27:53 Bridge tables 28:56 Implementing a bridge table in T-SQL 32:53 Normalized vs Denormalized data 34:53 Data aggregation (and de-aggregation) 37:54 Practice Questions 43:45 Outro and next steps #microsoftfabric #dp600 #powerbi </video> <video> Capacities, workspaces, roles in Microsoft Fabric | DP-600 EXAM PREP (3 of 12) Description: IMPORTANT! As of 15th Nov 2024, the DP-600 study guide has CHANGED! For updated DP-600 study notes & discussion: https://www.skool.com/microsoft-fabric/about/ In this video (3 of 12 in the series), we explore Implementing a Data Analytics Environment in Microsoft Fabric. We cover the following sections of the DP-600 study guide: - Implement workspace and item-level access controls for Fabric items - Implement data sharing for workspaces, warehouses, and lakehouses - Manage sensitivity labels in semantic models and lakehouses - Configure Fabric-enabled workspace settings - Manage Fabric capacity This video is part of the DP-600 Exam Preparation series: https://www.youtube.com/playlist?list=PLug2zSFKZmV05ZJcmHemXxyJjPVXeQ2qS Timeline 0:00 Intro 1:00 Scenario starts here - structuring Fabric 2:36 Three levels of Fabric administration 4:40 Capacity administration settings 9:10 Workspace administration settings 12:58 Workspace-level access control 14:30 Workspace roles 17:45 Workspace-level access example 19:35 Item-level sharing 20:30 Data warehouse sharing permissions 21:16 Lakehouse sharing permissions 21:43 OneLake Data Access Model (Preview - probably not in the exam) 23:06 Sensitivity Labeling 24:30 Practice Question 1 (Case Study) 25:55 Practice Question 2 (Case Study) 27:03 Practice Question 3 (Case Study) 28:03 Practice Question 4 30:05 Practice Question 5 31:11 Lesson summary and next steps #microsoftfabric #dp600 #powerbi </video> <video> DP-600 Exam Full Course (6+ hours) | Microsoft Fabric Analytics Engineer Description: IMPORTANT! As of 15th Nov 2024, the DP-600 study guide has CHANGED! For updated DP-600 study notes & discussion: https://www.skool.com/microsoft-fabric/about/ If you want to become a Microsoft Certified: Fabric Analytics Engineer Associate, you will need to pass the DP-600 exam. In this 6 hour course, we cover each of the elements of the study guide. You will learn through a combination of theory, practical examples, case studies and practice questions. Timeline 00:00:00 Course Introduction 00:10:47 Plan a data analytics environment 00:40:07 Implement and manage a data analytics environment 01:12:01 Manage the analytics development lifecycle 01:59:48 Getting data into Fabric 02:20:10 SQL, Data Warehouse and scheduling 02:46:41 Transforming data with Dataflows, PySpark, T-SQL 03:30:48 Optimizing performance 04:05:19 Design and build semantic models 04:33:20 Secure and optimize semantic models 04:54:44 Perform exploratory analytics 05:23:17 Query data using T-SQL 05:56:00 TOP TIPS for the exam #microsoftfabric #dp600 #powerbi </video> <video> Version control (Git) & Deployment Pipelines in Microsoft Fabric | DP-600 EXAM PREP (4 of 12) Description: IMPORTANT! As of 15th Nov 2024, the DP-600 study guide has CHANGED! For updated DP-600 study notes & discussion: https://www.skool.com/microsoft-fabric/about/ In this video (4 of 12 in the series), we explore the next part of the DP-600 Study Guide: Managing the Analytics Development Lifecycle.This includes the following: - Implement version control for a workspace - Create and manage a Power BI Desktop project (.pbip) - Plan and implement deployment solutions - Perform impact analysis of downstream dependencies from lakehouses, data warehouses, dataflows, and semantic models - Deploy and manage semantic models by using the XMLA endpoint - Create and update reusable assets, including Power BI template (.pbit) files, Power BI data source (.pbids) files, and shared semantic models This video is part of the DP-600 Exam Preparation series: https://www.youtube.com/playlist?list=PLug2zSFKZmV05ZJcmHemXxyJjPVXeQ2qS Note: this video is meant to serve as a light covering of the topics assessed as part of the exam. There is a mountain of possibilities and strategies when it comes to version control and deployment - I hope to cover more of this in the future on the channel! Timeline 0:00 Intro 1:05 Scenario starts here - Git and version control 2:18 Git and version control primer - Part 1 - Git basics 11:10 Git and version control primer - Part 2 - Branching and pull requests 17:00 Version control for Power BI projects (.pbip) 21:12 Git source control in a Fabric Workspace 26:07 Summary of version control in Fabric 28:18 Deployment solutions intro 29:35 Deployment pipelines in Fabric 34:54 Summary of deployment pipelines 36:28 Other options for deployment 37:01 Deploying semantic models using XMLA endpoint 37:56 .pbit and .pbids files 40:05 Data lineage and impact analysis 42:18 Practice Question 1 43:44 Practice Question 2 45:00 Practice Question 3 46:22 Practice Question 4 47:22 Summary and next steps #microsoftfabric #dp600 #powerbi </video> <video> Perform exploratory analytics in Microsoft Fabric | DP-600 EXAM PREP (11 of 12) Description: IMPORTANT! As of 15th Nov 2024, the DP-600 study guide has CHANGED! For updated DP-600 study notes & discussion: https://www.skool.com/microsoft-fabric/classroom/ In this video (11 of 12 in the series), we cover the following sections of the DP-600 study guide: Implement descriptive and diagnostic analytics Integrate prescriptive and predictive analytics into a visual or report Profile data This video is part of the DP-600 Exam Preparation series: https://www.youtube.com/playlist?list=PLug2zSFKZmV05ZJcmHemXxyJjPVXeQ2qS Timeline 0:00 Intro 0:52 Types of analytics 4:23 Power BI visual (and when to use them) 14:35 Power BI features to enhance analysis 19:29 Data Profiling tool 23:16 Practice questions 28:09 Outro and next steps #microsoftfabric #dp600 #powerbi </video> <video> Design and build semantic models in Microsoft Fabric | DP-600 EXAM PREP (9 of 12) Description: Free DP-600 study notes inside community: https://www.skool.com/microsoft-fabric/classroom/d154aad4?md=f049dfa104ca4b68a8908e81384ad973 In this video (9 of 12 in the series), we cover the following sections of the DP-600 study guide: Choose a storage mode, including Direct Lake Design and build composite models that include aggregations Design and build a large format dataset Write calculations that use DAX variables and functions, such as iterators, table filtering, windowing, and information functions Implement calculation groups, dynamic strings, and field parameters This video is part of the DP-600 Exam Preparation series: https://www.youtube.com/playlist?list=PLug2zSFKZmV05ZJcmHemXxyJjPVXeQ2qS Timeline 0:00 Intro 1:21 Choosing a storage mode 6:09 Composite models 7:42 Aggregations (Power BI feature) 9:07 Large format semantic models 10:38 DAX Variables 11:52 DAX Iterators 13:32 DAX Table filtering 14:21 DAX Window functions 16:32 DAX Informtion functions 17:35 Calculation Groups 18:56 Dynamic string formatting 20:20 Field parameters 22:00 Practice Questions 27:44 Outro and next steps #microsoftfabric #dp600 #powerbi </video> <video> I created 84 hands-on Microsoft Fabric tutorials Description: Join Fabric Dojo: https://skool.com/fabricdojo/about Very excited to officially launch Fabric Dojo: a new learning community dedicated to helping you build confidence and confidence in Data/ Analytics Engineering in Microsoft Fabric through hands-on tutorials and mini-projects. Here's how Fabric Dojo works: - Learn how to build robust pipelines, datasets, and solutions that people can trust (by applying engineering principles and best practices) - 100% through hands-on practice (FASTEST way to learn). - New tutorials are set each week for you to complete - All your questions answered - Supportive community Timeline 0:00 Intro 0:35 What is Fabric Dojo? 2:00 What will you learn (and how)? 3:31 Who is Fabric Dojo for? 4:15 30 new tutorials in the last 30 days 4:37 When you get stuck... 5:49 Where to sign up 6:08 Promotion & early feedback from students 6:32 Outro #microsoftfabric #dp600 #powerbi #analyticsengineering #dataengineering </video> <video> Secure and optimize semantic models in Microsoft Fabric | DP-600 EXAM PREP (10 of 12) Description: IMPORTANT! As of 15th Nov 2024, the DP-600 study guide has CHANGED! For updated DP-600 study notes & discussion: https://www.skool.com/microsoft-fabric/about/ In this video (10 of 12 in the series), we cover the following sections of the DP-600 study guide: Implement dynamic row-level security and object-level security Implement incremental refresh Implement performance improvements in queries and report visuals Identify use cases for DAX Studio and Tabular Editor 2 Improve DAX performance by using DAX Studio Optimize a semantic model by using Tabular Editor 2 This video is part of the DP-600 Exam Preparation series: https://www.youtube.com/playlist?list=PLug2zSFKZmV05ZJcmHemXxyJjPVXeQ2qS Timeline 0:00 Intro 1:24 Dynamic row-level security 3:33 Object-level security 5:12 Incremental Refresh Power BI 8:08 Monitoring semantic model performance 9:50 Performance Analyzer + DAX Studio 10:54 VertiPaq Analyzer 11:55 Trace Analysis 12:44 Best Practice Analyzer (Tabular Editor) 14:00 Use cases for DAX Studio 15:02 Use cases for Tabular Editor 15:58 Practice Questions 21:06 Outro, next steps #microsoftfabric #dp600 #powerbi </video> <video> SQL, Data Warehouse & Scheduling in Microsoft Fabric | DP-600 EXAM PREP (6 of 12) Description: IMPORTANT! As of 15th Nov 2024, the DP-600 study guide has CHANGED! For updated DP-600 study notes & discussion: https://www.skool.com/microsoft-fabric/about/ In this video (6 of 12 in the series), we continue Section 2 of the DP-600 Study Guide: Prepare and Serve Data. We cover the following topics: - Create views, functions, and stored procedures - Add stored procedures, notebooks, and dataflows to a data pipeline - Schedule data pipelines - Schedule dataflows and notebooks This video is part of the DP-600 Exam Preparation series: https://www.youtube.com/playlist?list=PLug2zSFKZmV05ZJcmHemXxyJjPVXeQ2qS Timeline 0:00 Intro 1:13 Connecting to a Data Warehouse using SSMS 2:52 SQL Views 6:15 SQL Functions 10:09 SQL Stored Procedures 13:53 Stored procedure activity in Data Pipeline 16:39 Notebook activity in Data Pipeline 17:55 Dataflow activity in Data Pipeline 18:35 Scheduling Dataflows 19:33 Scheduling Notebooks 20:36 Scheduling Data Pipelines 22:19 Practice Questions 26:14 Outro and next steps #microsoftfabric #dp600 #powerbi </video> <video> How to THRIVE as a Microsoft Fabric Analytics Engineer Description: Build hands-on skills and experience, join Fabric Dojo today! https://www.skool.com/fabricdojo Our DP-600 exam preparation course now has over 200,000 views, and we successfully helped 100's (maybe thousands!) to pass the exam. BUT, from speaking with a lot of people in the community, a lot of people are not clear on what to do next... You will need hands-on experience and to focus on the things that really move the needle in analytics engineering: - your ability to build and maintain robust systems - implementing version control and ci/cd patterns - data modelling in a Lakehouse and Data Warehouse - data validation 0:00 How this video came about 1:40 Career events that shaped my view on analytics engineering 6:26 What's important in Analytics Engineering? 9:53 Focus 1: Build & maintain robust systems 24:13 Focus 2: Making sure things don't break 30:07 Focus 3: Modelling 34:23 Focus 4: Validation & Quality 37:12 Eight BONUS tips for analytics engineers 41:33 Wrap-up #microsoftfabric #analyticsengineer </video> <video> Monitoring & optimizing performance in Microsoft Fabric | DP-600 EXAM PREP (8 of 12) Description: IMPORTANT! As of 15th Nov 2024, the DP-600 study guide has CHANGED! For updated DP-600 study notes & discussion: https://www.skool.com/microsoft-fabric/about/ In this video (8 of 12 in the series), we cover the following sections of the DP-600 study guide: - Identify and resolve data loading performance bottlenecks in dataflows, notebooks, and SQL queries - Implement performance improvements in dataflows, notebooks, and SQL queries - Identify and resolve issues with Delta table file sizes - Implement file partitioning for analytics workloads in a lakehouse Specifically, we take a look at concepts like: dataflow performance monitoring, dataflow staging, dataflow fast copy, SQL DMVs, SQL Query Insights, Spark monitoring, Spark History Server, the Capacity Metrics App, the Monitoring Hub, Delta file optimization, File Partitioning, VACUUM & OPTIMIZE. This video is part of the DP-600 Exam Preparation series: https://www.youtube.com/playlist?list=PLug2zSFKZmV05ZJcmHemXxyJjPVXeQ2qS Timeline 0:00 Intro 1:14 Framing performance optimization in Fabric 4:00 Monitoring Hub 6:13 Capacity Metrics App 9:18 Dataflow monitoring 9:55 Dataflow staging 12:06 Dataflow fast copy 12:41 SQL Dynamic Management Views (DMVs) 15:00 SQL Query Insights 16:28 Spark monitoring 17:15 Spark History Server 18:06 Delta table optimization (intro) 18:38 File partitioning 25:30 V-order optimization 27:00 Delta OPTIMIZE & VACUUM 27:36 Spark coalesce() and repartition() 29:20 Practice Questions 34:15 Outro and next steps #microsoftfabric #dp600 #powerbi </video> <video> Requirements, admin portal, gateways in Microsoft Fabric | DP-600 EXAM PREP (2 of 12) Description: IMPORTANT! As of 15th Nov 2024, the DP-600 study guide has CHANGED! For updated DP-600 study notes & discussion: https://www.skool.com/microsoft-fabric/about/ In this video we cover the first section of the DP-600 study guide: Plan your data analytics environment. We cover each of the four subsections: - Identify requirements for a solution, including components, features, performance, and capacity stock-keeping units (SKUs) - Recommend settings in the Fabric admin portal - Choose a data gateway type - Create a custom Power BI report theme This video is part of the DP-600 Exam Preparation series: https://www.youtube.com/playlist?list=PLug2zSFKZmV05ZJcmHemXxyJjPVXeQ2qS Timeline 0:00 1:14 Identify requirements 2:36 Capacity requirements 6:55 Data ingestion requirements 11:22 Data gateways 13:52 Data storage requirements 15:44 Admin portal settings 18:45 Custom Power BI report themes 21:35 Practice Question 1 23:00 Practice Question 2 24:35 Practice Question 3 25:45 Practice Question 4 27:35 Practice Question 5 28:36 Next steps #microsoftfabric #dp600 #powerbi </video> <video> TOP TIPS for passing the DP-600 exam (SERIES FINALE!) Description: IMPORTANT! As of 15th Nov 2024, the DP-600 study guide has CHANGED! For updated DP-600 study notes & discussion: https://www.skool.com/microsoft-fabric/classroom/ Other resources mentioned in this video: Cloud Skills Challenge (for the 50% off voucher): https://learn.microsoft.com/en-gb/training/challenges?id=bfb9f08c-b763-4f60-b5d7-360debaf4f8f&ocid=fabric24_30DTLI_pbidocs_card_clp%3FWT.mc_id%3Dpowerbi_landingpage-docs-link&wt.mc_id=cloudskillschallenge_bfb9f08c-b763-4f60-b5d7-360debaf4f8f_30dtli_web_wwl Official Microsoft DP-600 Practice Assessment: https://learn.microsoft.com/en-us/credentials/certifications/exams/dp-600/practice/assessment?assessment-type=practice&assessmentId=90 Microsoft Learn Together series on YouTube: https://www.youtube.com/watch?v=LhZRNm5Vjjc&list=PL1N57mwBHtN0-AJVURyfqbdmX65JMXSVv Data Mozart DP-600 content: https://data-mozart.com/dp-600-certification/ The Data Guy newsletter on LinkedIn: https://www.linkedin.com/newsletters/the-data-guy-isb-7123319093067231232/ DP-600 Skills Measured (ServerlessSQL): https://www.serverlesssql.com/dp-600-fabric-analytics-engineer-skills-measured-guide/ Timeline 0:00 Intro 0:39 Booking the exam 2:02 Preparing for the exam 4:26 During the exam 6:40 After the exam 7:19 GOOD LUCK and thank you 🙌 #microsoftfabric #dp600 #analyticsengineer </video>

Contacts and Links

Description

I help beginner and experienced data professionals learn Microsoft Fabric.

How?
✅ I publish videos here on YouTube,
✅ our free community for learning Microsoft Fabric: skool.com/microsoft-fabric
✅ I’m an Instructor at Fabric Dojo: https://skool.com/fabricdojo


What do I cover?
My focus for 2024 is to build a collection of lessons that help you build a really strong foundation in concepts that are important in the Microsoft Fabric world: so data [warehousing, pipelines, engineering and science] - and to have fun doing it!

Who am I?
I'm Will 👋 I've been working in data since 2016 when I built my first Power BI dashboard.
Since then, I've worked in data science, real-time analytics, data engineering and solution architecture. Mostly within the Microsoft stack, but also worked with Elasticsearch, DBT, JS/ Front-end Data Viz

Videos from channel