Data Management and Processing in Microsoft Fabric

Uncover Microsoft Fabric's power! Secure OneLake data, optimize with Apache Spark, and master lakehouse vs. warehouse structures. Elevate your data game today!

2 hours
16 videos
25 exercises
259 xp

Let’s create your free account

OR

By continuing, you accept our Enterprise DNA Terms & Conditions , our Privacy & Cookie Policy and that your data is stored.

If you have an account Login here

Trusted by 220,000+ people worldwide.

coca-cola-logouniliver-logonhs-logonestle-logoatt-logoanglo-logomackinsey-logoalbemarle-logojonson-logopanasonic-logo

An outline of this training course

This course encompasses navigating OneLake for data upload and management, securing data through authentication and authorization, leveraging shortcuts for workflow efficiency, and understanding lakehouse versus warehouse architectures. It deeply explores Apache Spark's role in data engineering, offering practical experience with notebooks in web and VS Code environments, and concludes with techniques for monitoring Spark jobs. This concise curriculum is tailored to equip learners with essential skills for effective data management and analysis within the Microsoft Fabric ecosystem.

 

What is needed to take this course 

Participants should understand cloud computing and data management basics, have programming skills in languages like Python or SQL, and access to Microsoft Fabric. Familiarity with Apache Spark, Visual Studio Code, a reliable computer with internet, and analytical skills will also enhance your learning experience.

 

Who is this course for

Designed for data engineers, data scientists, IT professionals, developers interested in data analytics, and educators or students in data-focused fields, aiming to enhance their expertise in cloud-based data management and analysis with Microsoft Fabric.

 

Details of what you will learn in this course

During this Microsoft Fabric course, participants will learn:

  1. Navigating OneLake: Understand how to upload, manage, and organize data within OneLake, Microsoft Fabric's data lake solution, including using OneLake Explorer for file management.

  2. Data Security: Master the concepts of authentication and authorization to secure data within the Microsoft Fabric environment, ensuring that sensitive information is protected and access is controlled.

  3. Workflow Optimization: Discover how to use shortcuts within Microsoft Fabric to streamline data workflows, making data processing tasks more efficient and less time-consuming.

  4. Lakehouse vs. Warehouse Architecture: Gain insights into the differences between lakehouse and warehouse architectures in data management, learning how each can be leveraged for different types of data storage and analysis needs.

  5. Apache Spark Fundamentals: Dive deep into the essentials of Apache Spark for data engineering within Microsoft Fabric, understanding its role in processing large datasets for analytics purposes.

  6. Notebook Usage: Get hands-on experience with notebooks in both web-based and Visual Studio Code environments, learning how to execute code, analyze data, and visualize results interactively.

  7. Monitoring Spark Jobs: Learn techniques for monitoring and optimizing Spark jobs to ensure efficient processing of data tasks, including using the monitoring hub and Spark UI for performance insights.

 

What you get with the course

This course will provide participants with detailed Microsoft Fabric materials, hands-on exercises, expert insights on Spark jobs, and interactive notebook sessions. Participants will earn a completion certificate and join a community for support and networking, equipping them with practical skills and knowledge in data management and analysis.

 

Program Level

Intermediate

 

Field(s) of Study

Data Engineering, Cloud Computing, Data Analytics

 

Instruction Delivery Method

QAS Self-study

 

***This course was published in March 2024***

 

Enterprise DNA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

 

What our

Students Say
Curriculum
1

Course Overview


2

Navigating and Utilizing OneLake


3

Enhancing Workflows


4

Advanced Data Processing Techniques


5

Utilizing Spark and Notebooks


6

Data Warehousing Concepts


7

Conclusion and Next Steps


Your

Instructor
Empty image or helper icon

Henry Habib

Enterprise DNA Expert

  • Improved processes and facilitated organizational change using both standard and bespoke tools (Power Platform, data analytics, custom built programs, etc.) for over 6 F500 companies spanning financial services, retail, and telecom 
  • Led training and employee-tool empowerment sessions (SharePoint, Power Apps, Power Automate) for several organization, the most recent being a large governmental organization of over 6,000 members, with advisory add-ons 
  • Accomplished Power Platform and Office 365 trainer (specializing in SharePoint, Power Apps, and Power Automate), with over 100 hours of recorded content and over 30,000 paid students on e-learning platforms 
  • Background in Accounting and Finance, with a specialization in Economics 

Frequently Asked

Questions

Recommended

Courses
Course Cover: Introduction to Python for Data Science
beginner
Total points: 272 XP 2 hours

Introduction to Python for Data Science

A comprehensive journey through the essentials of data science with Python, aimed at beginners ready to delve into data analysis and visualization.
Tools
Python
EDNA Experts
EDNA Experts
See details
Course Cover: VBA Automation Techniques for Businesses
beginner
Total points: 208 XP 1 hours

VBA Automation Techniques for Businesses

EXPERIMENTAL: This course teaches valuable Microsoft VBA automation techniques that optimize business processes, leading to increased productivity and efficiency.
Tools
Excel
Skills
Process Automation
App Development
EDNA Experts
EDNA Experts
See details
Course Cover: SQL Fundamentals for Financial Analysis
beginner
Total points: 212 XP 1 hours

SQL Fundamentals for Financial Analysis

EXPERIMENTAL: A comprehensive course providing financial professionals with the fundamentals of SQL and its application in financial analysis.
Tools
SQL
Skills
Data Analysis
EDNA Experts
EDNA Experts
See details

Get full access to unparalleled

training & skill-building resources
power-bi-custom-visuals

FOR INDIVIDUALS

Enterprise DNA

For Individuals

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.

Learn More

FOR BUSINESS

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace.

Learn More
power-bi-custom-visuals