| 1 - Introduction to Section 4.mp4 | 1.5 MB | ||
| 1 - The usage metrics report.mp4 | 19.9 MB | ||
| 1 - Welcome and Course Overview.mp4 | 18.3 MB | ||
| 1 - Welcome to Section 2 of this course.mp4 | 3.1 MB | ||
| 1 - Welcome to Section 3.mp4 | 3.6 MB | ||
| 10 - Connect to SQL server data source and import data - Method 1 Dataflow Gen 2.mp4 | 119.6 MB | ||
| 11 - Connect to and import data - Method 2 Data Factory Pipeline (Optional).mp4 | 162.9 MB | ||
| 12 - Ingest Data from Onprem Excel worksheets to Bronze Lakehouse tables.mp4 | 57.8 MB | ||
| 13 - Explore the Data in Bronze Lakehouse.mp4 | 30.5 MB | ||
| 2 - Automate data workflows, Set up triggers.mp4 | 84.4 MB | ||
| 2 - Data movement from Bronze Lakehouse to Silver DWH - Method 1 Data flow Gen 2.mp4 | 130.9 MB | ||
| 2 - Introduction to ETL ELT processes.mp4 | 20.6 MB | ||
| 2 - Introduction to Microsoft Fabric.mp4 | 19.2 MB | ||
| 3 - Connect Power BI to Semantic Model - Measure -Calculated column and Date Table.mp4 | 67 MB | ||
| 3 - Medallion architecture overview.mp4 | 18 MB | ||
| 3 - Setting Up Your Fabric Environment.mp4 | 20 MB | ||
| 3 - Transform the Data from Bronze to Silver - Method 2 Stored procedure.mp4 | 128.7 MB | ||
| 4 - Create The Silver Datawarehouse views that joins and clean the Data.mp4 | 49.3 MB | ||
| 4 - Creating Power BI Reports in Fabric.mp4 | 62.4 MB | ||
| 4 - Explain the requirements and acceptance criteria of the project.mp4 | 19.9 MB | ||
| 4 - Set up Fabric Environment without work email.mp4 | 79.6 MB | ||
| 5 - Create a power Bi report for Orders Analysis.mp4 | 52.5 MB | ||
| 5 - Explore MS Fabric Interface and create the workspace.mp4 | 34.5 MB | ||
| 5 - Explore existing Power Bi reports the Data model and the excel sheets used.mp4 | 26.3 MB | ||
| 5 - Prepare data for reporting Create GoldDWH tables.mp4 | 68.4 MB | ||
| 6 - Create the medallion architecture in Fabric using lakehouse and datawarehouses.mp4 | 81.6 MB | ||
| 6 - Prepare the Gold semantic model.mp4 | 140.3 MB | ||
| 7 - Create Data model Entities relationship.mp4 | 73.7 MB | ||
| 7 - Create a New semantic model instead of the default one.mp4 | 31.9 MB | ||
| 8 - Install SSMS, SQL Server and Restore the Adventure works Database.mp4 | 59.4 MB | ||
| 9 - Install Fabric Gateway to connect On - Prem SQL server to the cloud.mp4 | 29.5 MB | ||
| AdventureWorks+Sales.pbix | 8 MB | ||
| AdventureWorks+Sales.xlsx | 13.7 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Create+Stored+Procedure.sql | 2.7 KB | ||
| Data+quality+Framework.sql | 3.5 KB | ||
| Dataflow+Excel+files+to+Bronze+lakehouse+template+to+import.pqt | 2 KB | ||
| Dataflow+SQL+Server+to+Bronze+lakehouse.pqt | 1.4 KB | ||
| Dataflow+move+data+from+Bronze+lakehouse+to+silver+DWH.pqt | 1.4 KB | ||
| Dax+Formulas.txt | 1.3 KB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| Installations.txt | 204.8 B | ||
| Links (1).txt | 102.4 B | ||
| Links.txt | 102.4 B | ||
| Main+Pipeline.pdf | 130.6 KB | ||
| Method+2+ingest+data+using+Pipeline+Json+file+.JSON.txt | 5.1 KB | ||
| Microsoft+Fabric+udemy+course+slides.pdf | 956 KB | ||
| Microsoft+Fabric+udemy+course.pdf | 965.8 KB | ||
| SQL+query+to+get+all+table+names+in+the+schema.txt | 102.4 B | ||
| Tables.txt | 102.4 B | ||
| join+tables+and+create+views.sql | 6.2 KB | ||
| ▲ 51 total files | |||
Microsoft Fabric: Practical Hands-on Project course
https://DevCourseWeb.com
Published 8/2024
Created by Makram Amor
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 36 Lectures ( 2h 34m ) | Size: 1.7 GB
Step-by-Step BI Project-Based Course on real use case Master Data Warehousing, Processing and Integration with Fabric
What you'll learn:
Set Up Data Ingestion In Fabric using different methods Pipelines, Dataflows Gen 2 and Pyspark Notebooks
Clean and Transform Data : Set up data flows in Data Factory to clean and transform the raw data. Apply filters and remove duplicates as necessary.
Aggregate and Process Data: Create additional data flows or Stored Proc to aggregate and process the cleaned data. Store the processed data in the GoldenDWH.
Prepare Data for Reporting: Prepare the final dataset for the Power BI report, optimizing it for performance. Use the Gold Layer data to create the BI reports
Automate the Workflow: Schedule the data pipelines to run daily. Set up triggers and alerts in Data Factory to notify stakeholders via email about the pipeline
Configure Access Control Implement role-based access control (RBAC) to manage access to each layer of the medallion architecture.
Requirements:
Basic Knowledge of Fabric
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2 GB | freecoursewb | 4 weeks | 36 | 8 | |
| 2.2 GB | freecoursewb | 1 month | 25 | 9 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 1 month | 9 | 5 |
| 999.5 MB | freecoursewb | 1 month | 11 | 6 | |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 1 month | 6 | 1 |
All Comments