In this course, students will embark on an exploratory journey into the Microsoft Fabric OneLake and LakeHouse, gaining hands-on experience with the Fabric portal, workspaces, and the creation of lake houses. Manuel will guide participants through the intricacies of SQL endpoints, leveraging tools like SQL Server Management Studio to enhance understanding. The course aims to demystify the concepts of One Lake and Lake House, differentiating between the two and providing practical insights into their applications.
Overview
COURSE DIFFICULTY
COURSE DURATION
3h 36m
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Publish and share reports through Power BI Service
Integrate Python scripts for advanced analytics
Manage Power BI tenant settings and governance
BI Developers, Data Analysts, Data Engineers
Basic Python knowledge helpful
01. Class Introduction
02. Introduction (Provisioning A Cluster)
03. Introduction (Use Cases)
04. Introduction (Databricks Components Overview)
05. Introduction (Databricks Components Demo)
06. Introduction (Databricks Structure)
07. Introduction (Importing Data)
08. Notebooks (Markdown)
09. Notebooks (Code Blocks)
10. Notebooks (Visualizations)
11. Notebooks (Keyboard Shortcuts)
12. Notebooks (Dashboards)
13. Languages and Libraries (Supported Languages)
14. Languages and Libraries (Library Modes)
15. Languages and Libraries (Loading Libraries)
16. Languages and Libraries (Notebook Scoped Libraries)
17. Languages and Libraries (Importing Notebooks)
18. Languages and Libraries (Library Advice)
19. Scheduling Jobs (Scheduling Jobs From Notebooks)
20. Scheduling Jobs (Scheduling Jobs Outside Notebooks)
21. Scheduling Jobs (Running Notebooks From ADF)
22. Scheduling Jobs (Rest APIs)
23. Scheduling Jobs (PowerShell)
24. Scheduling Jobs (Power BI)
25. Administration (Admin Console)
26. Administration (Table Access Control)
27. Administration (Additional Features)
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Publish and share reports through Power BI Service
Integrate Python scripts for advanced analytics
Manage Power BI tenant settings and governance
WHO SHOULD ATTEND
BI Developers, Data Analysts, Data Engineers
PREREQUISITES
Basic Python knowledge helpful
COURSE OUTLINE
01. Class Introduction
02. Introduction (Provisioning A Cluster)
03. Introduction (Use Cases)
04. Introduction (Databricks Components Overview)
05. Introduction (Databricks Components Demo)
06. Introduction (Databricks Structure)
07. Introduction (Importing Data)
08. Notebooks (Markdown)
09. Notebooks (Code Blocks)
10. Notebooks (Visualizations)
11. Notebooks (Keyboard Shortcuts)
12. Notebooks (Dashboards)
13. Languages and Libraries (Supported Languages)
14. Languages and Libraries (Library Modes)
15. Languages and Libraries (Loading Libraries)
16. Languages and Libraries (Notebook Scoped Libraries)
17. Languages and Libraries (Importing Notebooks)
18. Languages and Libraries (Library Advice)
19. Scheduling Jobs (Scheduling Jobs From Notebooks)
20. Scheduling Jobs (Scheduling Jobs Outside Notebooks)
21. Scheduling Jobs (Running Notebooks From ADF)
22. Scheduling Jobs (Rest APIs)
23. Scheduling Jobs (PowerShell)
24. Scheduling Jobs (Power BI)
25. Administration (Admin Console)
26. Administration (Table Access Control)
27. Administration (Additional Features)
