- Видео 38
- Просмотров 221 813
Pathfinder Analytics
Великобритания
Добавлен 16 май 2021
Informational videos and tutorials on all things data
Microsoft Fabric End to End Data Project for Data Analysts and BI Engineers
Welcome to this comprehensive Microsoft Fabric data project using New York City taxi data. This video will guide you through an end-to-end data project, focusing on Data Warehousing, Data Factory, and Power BI.
We'll use TLC Trip record data, stored in a Fabric Data Lakehouse, and transform it through staging and presentation layers using Data Factory activities, Dataflows, and Stored Procedures.
Pre-requisites ✅
- Microsoft Fabric environment,
- Basic SQL, and data warehousing knowledge
Timestamps⌚
00:00:00 Introduction
00:04:32 Downloading the NYC Taxi Data Files
00:06:39 Data Lakehouse Files for Landing Data
00:12:19 Pipeline from Landing to Staging
00:42:16 Dataflow from Staging to Presentatio...
We'll use TLC Trip record data, stored in a Fabric Data Lakehouse, and transform it through staging and presentation layers using Data Factory activities, Dataflows, and Stored Procedures.
Pre-requisites ✅
- Microsoft Fabric environment,
- Basic SQL, and data warehousing knowledge
Timestamps⌚
00:00:00 Introduction
00:04:32 Downloading the NYC Taxi Data Files
00:06:39 Data Lakehouse Files for Landing Data
00:12:19 Pipeline from Landing to Staging
00:42:16 Dataflow from Staging to Presentatio...
Просмотров: 31 574
Видео
Effortless Querying with the Visual Query Editor (Microsoft Fabric Data Warehouse)
Просмотров 4354 месяца назад
This video demonstrates how to leverage the visual query editor in the Microsoft Fabric Data Warehouse for quick and efficient query writing. The visual query editor offers a no-code experience, allowing you to create queries effortlessly. 🔗 Links and Resources - Microsoft Documentation: learn.microsoft.com/en-us/fabric/data-warehouse/visual-query-editor
Microsoft Fabric Simplified - A Technical Overview (+ Platform Demo)
Просмотров 8 тыс.4 месяца назад
Welcome to this in-depth technical overview of Microsoft Fabric! 🚀 In this video, I break down Microsoft Fabric's main components, architecture, and various experiences. You'll get a demo of the platform to help you understand what it offers and how it unifies workflows across data ingestion, processing, and visualization. 🔍 Key Topics Covered (Timestamps): 00:00 Introduction 00:52 What are the...
Databricks SQL: Group By All
Просмотров 5035 месяцев назад
Simplify your SQL with Group By All. Want to become a Databricks Data Analyst and learn SQL on the Databricks SQL platform? Check out my Udemy course: www.udemy.com/course/databricks-sql-for-data-analysts/?referralCode=78C6FFDBE3A7474B9607
End to End Data Project with Microsoft Fabric - Data Engineering, Data Factory and Power BI
Просмотров 25 тыс.6 месяцев назад
🚀Join me in this tutorial as we build an end to end data engineering and reporting solution using Microsoft Fabric. This tutorial uses the USGS Earthquake API to build an end to end data solution focusing on the Data Engineering, Data Factory and Power BI experiences. ⌚ Timestamps 00:00 Introduction to the Project and Solution Overview 03:20 Creating a Fabric Workspace and Data Lakehouse 06:48 ...
QuickVisualize in Microsoft Fabric: Embed PowerBI Reports in Jupyter Notebooks
Просмотров 7887 месяцев назад
This video shows you how you can render a Power BI report in seconds from a Spark DataFrame in Jupyter Notebook. 🔗 Links and Documentation: learn.microsoft.com/en-us/fabric/data-engineering/notebook-visualization#create-report-visuals-from-a-spark-dataframe learn.microsoft.com/en-us/power-bi/create-reports/service-interact-quick-report pypi.org/project/powerbiclient/ github.com/Microsoft/powerb...
Start a Microsoft Fabric Trial without using a work email address
Просмотров 6 тыс.7 месяцев назад
Want to get a trial of Microsoft Fabric but don’t have a company email address? In this short video I’ll show you how to bypass this requirement and set up a Fabric Trial WITHOUT needing to use a company email address. ⌚Timestamps: 00:00 Introduction 01:00 Azure Account 02:36 Creating an Azure User 04:05 Starting the Microsoft Fabric Trial 📚Check out my Udemy Course www.udemy.com/course/microso...
Query Snowflake Data on Databricks with Lakehouse Federation
Просмотров 3,7 тыс.8 месяцев назад
This video explains how to set up Lakehouse Federation to run federated queries on Snowflake data that is not managed by Azure Databricks. 🔗 Links and Documentation: Run Federation Queries on Snowflake: [learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/manage-privileges/privileges](learn.microsoft.com/en-us/azure/databricks/query-federation/snowflake) 💻 Check out my Data...
Data Access Control with Databricks Unity Catalog
Просмотров 4,8 тыс.8 месяцев назад
Welcome to this straightforward and practical guide on Privilege Management with Databricks Unity Catalog. This video explains how to control access to data and other objects in Unity Catalog. ⌚Timestamps: 00:00 Introduction 00:28 Unity Catalog Security Model 02:28 Assigning Privileges Demo 🔗 Links and Documentation: Privilege Types by Object: learn.microsoft.com/en-us/azure/databricks/data-gov...
Databricks Unity Catalog: Catalogs and Schemas
Просмотров 5 тыс.8 месяцев назад
Welcome to this straightforward and practical guide on Catalogs and Schemas in Databricks Unity Catalog. Catalog: The first layer of the object hierarchy, used to organize your data assets Schema: Also known as databases, schemas are the second layer of the object hierarchy and contain tables and views. ⌚Timestamps: 00:00 Introduction 00:30 Catalog Explorer UI 04:34 SQL Syntax 🔗 Links and Docum...
Databricks Unity Catalog: Storage Credentials and External Locations
Просмотров 10 тыс.8 месяцев назад
Welcome to this straightforward and practical guide on Unity Catalog Storage Credentials and External Locations. Unity Catalog introduces several new securable objects to grant privileges to data in cloud object storage. - A storage credential is a securable object representing an Azure managed identity or Microsoft Entra ID service principal. - Once a storage credential is created access to it...
Databricks Unity Catalog: A Technical Overview
Просмотров 32 тыс.8 месяцев назад
Welcome to the first video of my Databricks Unity Catalog Series! Unity Catalog brings a new layer of data management and security to your Databricks environment, and with this technical overview, you’ll learn about these capabilities. ⌚Timestamps: 00:00 Introduction 00:17 What is Unity Catalog? 00:30 Before vs After Unity Catalog 02:01 Key Features of Unity Catalog 02:39 Administrative Roles i...
Enabling Unity Catalog on Azure Databricks: A Step-by-Step Guide
Просмотров 22 тыс.9 месяцев назад
Enabling Unity Catalog on Azure Databricks: A Step-by-Step Guide
Understanding Databases, Warehouses, Lakes, and Lakehouses
Просмотров 2379 месяцев назад
Understanding Databases, Warehouses, Lakes, and Lakehouses
Databricks Extension for VS Code: A Hands-On Tutorial
Просмотров 8 тыс.9 месяцев назад
Databricks Extension for VS Code: A Hands-On Tutorial
Real Time Streaming with Azure Databricks and Event Hubs
Просмотров 25 тыс.10 месяцев назад
Real Time Streaming with Azure Databricks and Event Hubs
Create Azure account and Portal Overview | Episode 8 (AZ-900 Azure Fundamentals)
Просмотров 127Год назад
Create Azure account and Portal Overview | Episode 8 (AZ-900 Azure Fundamentals)
Security, governance and manageability benefits of the cloud | Episode 7 (AZ-900 Azure Fundamentals)
Просмотров 669Год назад
Security, governance and manageability benefits of the cloud | Episode 7 (AZ-900 Azure Fundamentals)
Reliability and predictability benefits of the cloud | Episode 6 (AZ-900 Azure Fundamentals)
Просмотров 724Год назад
Reliability and predictability benefits of the cloud | Episode 6 (AZ-900 Azure Fundamentals)
Scalability benefits of the cloud | Episode 5 (AZ-900 Azure Fundamentals)
Просмотров 138Год назад
Scalability benefits of the cloud | Episode 5 (AZ-900 Azure Fundamentals)
High availability benefits of the cloud | Episode 4 (AZ-900 Azure Fundamentals)
Просмотров 104Год назад
High availability benefits of the cloud | Episode 4 (AZ-900 Azure Fundamentals)
Public, private and hybrid cloud models | Episode 3 (AZ-900 Azure Fundamentals)
Просмотров 201Год назад
Public, private and hybrid cloud models | Episode 3 (AZ-900 Azure Fundamentals)
IaaS, PaaS and Saas cloud service types | Episode 2 (AZ-900 Azure Fundamentals)
Просмотров 180Год назад
IaaS, PaaS and Saas cloud service types | Episode 2 (AZ-900 Azure Fundamentals)
What is Cloud Computing? | Episode 1 (AZ-900 Azure Fundamentals)
Просмотров 379Год назад
What is Cloud Computing? | Episode 1 (AZ-900 Azure Fundamentals)
5 Not So Common Tips For Pandas Data Frames
Просмотров 1612 года назад
5 Not So Common Tips For Pandas Data Frames
Introduction to Data Analysis and Visualization Libraries in Python | TUTORIAL
Просмотров 3,4 тыс.2 года назад
Introduction to Data Analysis and Visualization Libraries in Python | TUTORIAL
Introduction to Sunburst Charts in Plotly Express (Python)
Просмотров 9372 года назад
Introduction to Sunburst Charts in Plotly Express (Python)
Introduction to Treemaps in Plotly Express (Python)
Просмотров 11 тыс.2 года назад
Introduction to Treemaps in Plotly Express (Python)
SQL Commands: Data Manipulation Language (DML)
Просмотров 2323 года назад
SQL Commands: Data Manipulation Language (DML)