Microsoft Fabric Lakehouse Security Explained | SQL Analytics Endpoint (Part 4) | Episode 9
Understanding data security is not optional anymore — it’s a must-have skill for every Data Engineer & Analyst. As part of my Microsoft Fabric Learning Series, I’ve published Episode 9, where I explored Lakehouse Security (OneLake Security) in Microsoft Fabric. In this video, I explained how to secure your data at multiple levels inside the SQL Analytics Endpoint. --> Key concepts covered: -Column Level Security (CLS) – Restrict access to specific columns -Object Level Security (OLS) – Control access to tables/folders -Row Level Security (RLS) – Filter data based on user access Let me know in the comments Have you implemented RLS/CLS/OLS in your projects? Follow for more content on: Data Engineering | Microsoft Fabric | SQL | Power BI | Analytics Happy Learning! watch?v=2VGNNobKwsk?si=oXjwmAuGlqX1cO8vData Agents and Copilot in Microsoft Fabric | Amit Chandak
Data Agents and Copilot in Microsoft Fabric Discover how Microsoft Fabric and Microsoft Copilot can transform the way you build data solutions. In this session, you’ll learn how to use Copilot to quickly create reports, generate DAX, and design data models in Power BI. We’ll also explore how to build Data Agents that enable users to interact with data through natural language. 💡 Learn how to: Accelerate report and model creation Use AI to simplify analytics workflows Build and deliver agent-driven data experiences Perfect for anyone looking to move into AI-powered analytics. watch?v=i6lIUtGIbvQ?utm_source=chatgpt.comMicrosoft Fabric SQL Analytics Endpoint Part 3 | Cross Workspace Querying Explained | Episode 8
Welcome to Episode 8 of the Microsoft Fabric Learning Series on the NDAC YouTube Channel! 🚀 This is Part 3 of SQL Analytics Endpoint, where we explore one of the most powerful real-world capabilities in Microsoft Fabric — Cross Workspace Querying. In modern data platforms, data is often distributed across multiple workspaces and Lakehouses. In this video, you will learn how to access and query data across different workspaces using SQL and Shortcuts. 🎯 In this video, you will learn: 🔹 What is Cross Workspace Querying in Microsoft Fabric 🔹 How to access data from different Lakehouses & Workspaces 🔹 How to use Shortcuts to bring external tables into your Lakehouse 🔹 How to query cross-workspace data using SQL Analytics Endpoint (T-SQL) 🔹 How to join datasets from multiple sources If you find this helpful, please Like, Share, and Subscribe to the NDAC Channel (NextGen Data Aspirants Community) for more tutorials on Microsoft Fabric, Data Engineering, SQL, and Analytics. •Follow our WhatsApp Channel : https://whatsapp.com/channel/0029VbB2EH33AzNVJEyA6L0r •Join our WhatsApp Group : https://chat.whatsapp.com/GsFHmy20g7GA7c7xzEWBVB •Follow us at LinkedIn : https://www.linkedin.com/company/nextgen-data-aspirants-community/ •Join at Meetup: https://www.meetup.com/nextgen-data-aspirants-community/ watch?v=McNiEEucjQISQL Analytics Endpoint Part 2 | Stored Procedures & Functions | Microsoft Fabric | Episode 7
Welcome to Episode 7 of the Microsoft Fabric Learning Series on the NDAC YouTube Channel! This is Part 2 of the SQL Analytics Endpoint series in Microsoft Fabric, where we go deeper into advanced SQL capabilities for analyzing Lakehouse data. In this episode, we move beyond basic queries and explore how to build aggregations, reusable logic, and parameterized solutions using SQL. 📊 This episode focuses on real-world SQL use cases, helping you understand how to build reusable and dynamic data logic inside the Lakehouse SQL Analytics Endpoint. 💡 If you are preparing for Data Engineering or SQL interviews, this video will be very useful as it covers GROUP BY, Stored Procedures, and Functions with practical examples. 👍 If you find this video helpful, please Like, Share, and Subscribe to the NDAC Channel (NextGen Data Aspirants Community) for more tutorials on Microsoft Fabric, SQL, Data Engineering, and Analytics. •Follow our WhatsApp Channel : https://whatsapp.com/channel/0029VbB2EH33AzNVJEyA6L0r •Join our WhatsApp Group : https://chat.whatsapp.com/GsFHmy20g7GA7c7xzEWBVB •Follow us at LinkedIn : https://www.linkedin.com/company/nextgen-data-aspirants-community/ •Join at Meetup: https://www.meetup.com/nextgen-data-aspirants-community/ watch?v=dlAFzYsffHMSQL Analytics Endpoint in Microsoft Fabric (Part 1) | Views vs Tables Explained | Episode 6
In this episode, we begin exploring the SQL Analytics Endpoint in Microsoft Fabric, which is a powerful feature for querying and analyzing Lakehouse data using SQL. Since this is a broad topic, this video is Part 1, where we focus on understanding how querying works and the limitations when working with Lakehouse tables. 🎯 In this video, you will learn: 🔹 How to query Lakehouse data using SQL (SELECT * FROM) 🔹 Understanding the SQL Analytics Endpoint environment 🔹 Why DML/ALTER operations are not allowed on Lakehouse tables via SQL endpoint 🔹 How to handle this limitation using Views 🔹 How to create a View to add calculated columns (Sales, Cost, Profit) 🔹 How to query the View and use it for analysis 💡 This is a key concept in Microsoft Fabric — understanding when to use Tables vs Views while working in the SQL Analytics Endpoint. •Follow our WhatsApp Channel : https://whatsapp.com/channel/0029VbB2EH33AzNVJEyA6L0r •Join our WhatsApp Group : https://chat.whatsapp.com/GsFHmy20g7GA7c7xzEWBVB •Follow us at LinkedIn : https://www.linkedin.com/company/nextgen-data-aspirants-community/ •Join at Meetup: https://www.meetup.com/nextgen-data-aspirants-community/ #MicrosoftFabric #SQLAnalyticsEndpoint #FabricLakehouse #SQLTutorial #DataEngineering #ViewsInSQL #FabricTutorial #NDAC #NextGenDataAspirants #LearnMicrosoftFabric watch?v=bjjXOKjXslQGetting the Best out of Excel Data Sources | Meetup Recap
We recently hosted an insightful session in the Azerbaijan AI & Data Community, where Bernat Agulló Roselló delivered a fantastic talk on how to truly unlock the power of Excel as a data source. From structuring files effectively to applying best practices in naming conventions, tables, and cleanup rules — the session was packed with practical insights that can make your data models faster, cleaner, and more reliable. watch?v=PG5jzlMJr_AMicrosoft Fabric Lakehouse Shortcuts Explained | Connect ADLS Gen2 & GCS Buckets | Episode 4
Welcome to Episode 4 of the Microsoft Fabric Learning Series on the NDAC YouTube Channel! In this episode, we explore an important feature in the Lakehouse called Shortcuts, which allows us to access data stored in external storage systems without physically copying the data. Using shortcuts in Microsoft Fabric helps organizations build efficient and scalable data architectures by directly connecting to external data sources. 🎯 In this video, you will learn: 🔹 What Shortcuts in Lakehouse are and why they are useful 🔹 How to create a Shortcut to external storage 🔹 How to connect Azure Data Lake Storage Gen2 using Lakehouse Shortcuts 🔹 How to access data from a Google Cloud Storage bucket using shortcuts 🔹 How shortcut data can be used in downstream analytics and reporting 🔹 Advantages and limitations (Pros & Cons) of the Shortcut approach This feature is very powerful because it enables cross-cloud data access and unified analytics without moving large volumes of data. 📊 If you are learning Data Engineering, Microsoft Fabric, or modern data platforms, this video will help you understand how to integrate multiple cloud storage systems into a single analytics platform. 👍 If you find this video helpful, please Like, Share, and Subscribe to the NDAC Channel (NextGen Data Aspirants Community) for more tutorials on Microsoft Fabric, Data Engineering, SQL, and Analytics. #MicrosoftFabric #FabricLakehouse #LakehouseShortcuts #ADLSGen2 #GoogleCloudStorage #DataEngineering #CrossCloudData #FabricTutorial #NDAC #NextGenDataAspirants #LearnMicrosoftFabric watch?v=uCENBGJm8yMLakehouse Schemas in Microsoft Fabric | Organizing Tables & Data Efficiently | Episode 5
In this episode, we explore Lakehouse Schemas, an important feature that helps organize and manage data more effectively inside the Lakehouse. Using schemas in Microsoft Fabric allows data engineers and analysts to structure tables logically, making data easier to manage, query, and maintain. 🎯 In this video, you will learn: 🔹 What Lakehouse Schemas are and why they are useful 🔹 How to create a Lakehouse with schema support enabled 🔹 How to upload folders and files directly into the Lakehouse Files section 🔹 How to load datasets into the Tables section under the default dbo schema 🔹 How to create new schemas such as hospitality and healthcare 🔹 How to move tables from dbo schema into domain-based schemas 👍 If you find this video helpful, please Like, Share, and Subscribe to the NDAC Channel (NextGen Data Aspirants Community) for more tutorials on Microsoft Fabric, Data Engineering, SQL, and Power BI. •Follow our WhatsApp Channel : https://whatsapp.com/channel/0029VbB2EH33AzNVJEyA6L0r •Join our WhatsApp Group : https://chat.whatsapp.com/GsFHmy20g7GA7c7xzEWBVB •Follow us at LinkedIn : https://www.linkedin.com/company/nextgen-data-aspirants-community/ •Join at Meetup: https://www.meetup.com/nextgen-data-aspirants-community/ #MicrosoftFabric #FabricLakehouse #LakehouseSchemas #DataEngineering #DataArchitecture #FabricTutorial #BigData #NDAC #NextGenDataAspirants #LearnMicrosoftFabric watch?v=oHqrpCLIhuUMicrosoft Fabric Semantic Model & Power BI Reports | From Lakehouse View to Dashboard | Episode 3
Welcome to Episode 3 of the Microsoft Fabric Learning Series on the NDAC YouTube Channel! In the previous episode, we created a Visual Query in the SQL Analytics Endpoint and saved the cleaned data as a View in the Lakehouse. In today’s episode, we continue the journey by building analytics on top of that data using Semantic Models and Power BI reports in Microsoft Fabric. This video demonstrates how to move from data preparation to data modeling and reporting inside the Fabric ecosystem. 🎯 In this video, you will learn: 🔹 How to create a Semantic Model on top of a Lakehouse View 🔹 How to define DAX measures inside the Semantic Model 🔹 How to generate an Auto-created Power BI Report from the semantic model 🔹 How to build a Manual Power BI Report for customized analysis 🔹 Understanding how data modeling connects Lakehouse and reporting This episode shows how data prepared in Lakehouse can directly power interactive reports and dashboards. 📌Download the dataset here: https://github.com/SuparnaBabu7/Datasets/blob/main/Fabric%20YouTube/Bike_Sales_Data.csv 👍 If you find this helpful, please Like, Share, and Subscribe to the NDAC Channel (NextGen Data Aspirants Community) for more tutorials on Data Engineering, Microsoft Fabric, SQL, and Power BI. #MicrosoftFabric #SemanticModel #PowerBI #FabricLakehouse #DataModeling #DAX #DataAnalytics #FabricTutorial #NDAC #NextGenDataAspirants #LearnMicrosoftFabric watch?v=mI7M8wGXTkwMicrosoft Fabric Visual Query Tutorial | SQL Analytics Endpoint | Episode 2
Welcome to Episode 2 of the Microsoft Fabric Learning Series on the NDAC YouTube Channel! 🚀 In this video, we continue our journey with the Lakehouse and explore how to work with Visual Query inside the SQL Analytics Endpoint in Microsoft Fabric. This video demonstrates how you can transform and analyze Lakehouse data using visual query tools without writing complex SQL. 🎯 In this video, you will learn: 🔹 How to use Visual Query in SQL Analytics Endpoint 🔹 How to create calculated columns using Visual Query 🔹 How to extract the Year from a Date column for better analysis 🔹 How to clean and transform data using visual query features 🔹 How to save the transformed result as a View in the Lakehouse 👍 If you find this video helpful, please Like, Share, and Subscribe to the NDAC Channel for more learning content. 📌Download the dataset here: https://github.com/SuparnaBabu7/Datasets/blob/main/Fabric%20YouTube/Bike_Sales_Data.csv #MicrosoftFabric #FabricLakehouse #VisualQuery #SQLAnalyticsEndpoint #DataEngineering #DataAnalytics #FabricTutorial #LearnMicrosoftFabric #NDAC #NextGenDataAspirants watch?v=yNgyLtJuZSk
