Getting Started with Microsoft Fabric

Instructor: Whizlabs Instructor

2,166 already enrolled

Included with

Learn more

5 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Validating your knowledge and understanding of Microsoft Fabric's capabilities and data analytics roles.
Demonstrating your practical skills in data ingestion, transformation, modeling, and reporting within the Microsoft ecosystem.
Enhancing your career prospects, opening doors to promotions and new job opportunities in data-driven fields.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

11 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 5 modules in this course

Data analytics, powered by robust platforms like Microsoft Fabric and Power BI, is transforming how businesses extract insights and drive decisions. Microsoft Fabric provides a unified environment for data integration, warehousing, and analytics, while Power BI enables the creation of interactive visualizations and reports. These tools streamline data workflows, foster data-driven cultures, and deliver personalized business intelligence, making them essential in today's data-centric world.

The "Getting Started with Microsoft Fabric" course is designed for individuals seeking to build a strong foundation in modern data analytics practices using Microsoft's cutting-edge technologies. This course is tailored to provide a comprehensive understanding of Microsoft Fabric and Power BI, equipping you with the skills to excel in data-related roles. Whether you are a budding data analyst, an experienced BI developer, or an IT professional aiming to leverage Microsoft's data ecosystem, this course will provide the knowledge and hands-on experience needed to thrive. This course delivers approximately 6:30-7:00 hours of video lectures, blending theoretical concepts with practical demonstrations. The curriculum is organized into five modules, each further divided into focused lessons. To reinforce learning and assess comprehension, each module includes assignments in the form of quizzes and in-video questions, ensuring an interactive and engaging learning experience. Module 1: Getting started with Microsoft Data Analytics Module 2: Microsoft Fabric: Introduction & Core Components Module 3: Microsoft Fabric: Advanced Data Management and Transformation Techniques Module 4: Microsoft Fabric: Comprehensive Data Transformation and Optimization Techniques Module 5: Microsoft Fabric: Explore, Analyze Data with DAX and Semantic Models This course aims to equip you with foundational Microsoft Fabric skills, positioning you for potential future industry-recognized certifications and demonstrating your expertise in modern data analytics. - -Some of the important benefits of gaining this knowledge. By the end of this course, you will be able to - Validating your knowledge and understanding of Microsoft Fabric's capabilities and data analytics roles. - Demonstrating your practical skills in data ingestion, transformation, modeling, and reporting within the Microsoft ecosystem. - Enhancing your career prospects, opening doors to promotions and new job opportunities in data-driven fields.

Welcome to Week 1 of the Getting Started with Microsoft Data Analytics course. In this week, we will be introduced to the foundational concepts of data analytics and begin our journey into the Microsoft ecosystem. We will explore the core requirements of data analytics, the roles and responsibilities of a data analyst, and understand the structure of a data team. We will also introduce Power BI and get started with building our first basic reports. By the end of the week, we will be able to understand the basic concepts of data analysis and start to work with Power BI.

What's included

8 videos3 readings2 assignments

8 videos Total 55 minutes

Course Introduction 7 minutes
Course Objectives 4 minutes
Introduction to Data Analytics 10 minutes
Data Analytics Requirements 7 minutes
Data Analyst (Roles and Responsibilities) 6 minutes
Roles in Data World (The Data Team) 6 minutes
Introduction to Power BI 8 minutes
Get Started Building with Power BI 8 minutes

3 readings Total 90 minutes

Welcome to the Course 30 minutes
Overview of Getting Started with Microsoft Data Analytics 30 minutes
Meet and Greet 30 minutes

2 assignments Total 65 minutes

Introduction to Microsoft Data Analytics - Knowledge Check 30 minutes
Getting started with Microsoft Data Analytics - Assessment 35 minutes

Welcome to Week 2. This week, we will be introduced to the core components and administrative functionalities of Microsoft Fabric. We will learn about the unified analytics platform, Microsoft Fabric, and how to configure its admin portal. We will explore data gateway types, manage Fabric capacity, and set workspace access controls. We will also learn to customize Power BI report themes, manage Fabric Desktop projects, utilize workspace version control, and understand OneLake security. At the end of the week, we will have a solid understanding of Microsoft Fabric's fundamental components and administrative capabilities.

What's included

9 videos1 reading2 assignments

9 videos Total 63 minutes

What is Microsoft Fabric? 7 minutes
Configuring the Fabric Admin Portal - Demo 4 minutes
Data Gateway Types - Overview 9 minutes
Managing Fabric capacity 9 minutes
Fabric-enabled workspace settings and access controls - Demo 6 minutes
Create a Custom Power BI Report Theme - Demo 8 minutes
Create and manage a Power BI Desktop Project - Demo 7 minutes
Workspace Version Control - Demo 4 minutes
OneLake security overview - Microsoft Fabric 8 minutes

1 reading Total 30 minutes

Overview of Microsoft Fabric: Introduction & Core Components 30 minutes

2 assignments Total 65 minutes

Introduction to Microsoft Fabric - Knowledge Check 30 minutes
Microsoft Fabric: Introduction & Core Components - Assessment 35 minutes

In Week 3, we will be introduced to advanced data management and pipeline orchestration within Microsoft Fabric. We will learn how to ingest data, create and manage shortcuts, and implement file partitioning for efficient analytics. We will explore the use of functions and stored procedures, and techniques to enrich data by adding new columns and tables. We will also cover data copying and the integration of stored procedures, notebooks, and dataflows into data pipelines. By the end of the week, we will be able to schedule data pipelines, dataflows, and notebooks to automate data processing and transformation within Microsoft Fabric.

What's included

9 videos1 reading2 assignments

9 videos Total 60 minutes

Data Ingestion - Demo 6 minutes
Create and manage shortcuts - Demo 5 minutes
File partitioning for analytics workloads - Demo 8 minutes
Functions, and stored procedures - Overview 8 minutes
Enrich data by adding new columns or tables - Demo 8 minutes
Data Copying 7 minutes
Adding stored procedures, notebooks, and dataflows to a data pipeline 9 minutes
Schedule data pipelines - Demo 6 minutes
Schedule dataflows and notebooks - Demo 4 minutes

1 reading Total 30 minutes

Overview of Microsoft Fabric: Advanced Data Management and Transformation Techniques 30 minutes

2 assignments Total 65 minutes

Data Management and Transformation Techniques - Knowledge Check 30 minutes
Microsoft Fabric: Advanced Data Management and Transformation Techniques - Assessment 35 minutes

Welcome to Week 4. This week, we will be introduced to data transformation and performance optimization techniques within Microsoft Fabric. We will learn to perform data cleansing, denormalize and aggregate data, and merge or join datasets. We will also cover data type conversions, data filtering, and methods to identify performance bottlenecks within SQL Server. By the end of the week, we will be able to resolve issues related to Delta table file sizes and optimize data for efficient analysis within Microsoft Fabric.

What's included

8 videos1 reading2 assignments

8 videos Total 56 minutes

Data Cleansing - Demo 10 minutes
Denormalize data - Overview 8 minutes
Aggregate or de-aggregate data - Demo 8 minutes
Merge or join data - Overview 6 minutes
Data types Conversion - Demo 3 minutes
Data Filtering - Demo 8 minutes
Identify Performance Bottlenecks - SQL Server 4 minutes
Resolve issues with Delta table file sizes 9 minutes

1 reading Total 30 minutes

Overview of Microsoft Fabric: Comprehensive Data Transformation and Optimization Techniques 30 minutes

2 assignments Total 65 minutes

Data Transformation and Optimization Techniques - Knowledge Check 30 minutes
Microsoft Fabric: Comprehensive Data Transformation and Optimization Techniques - Assessment 35 minutes

Welcome to Week 5. This week, we will be introduced to the shared responsibility model in AWS to secure AI/ML solutions. We will learn to identify and apply security and privacy considerations for AI systems. By the end of the week, we will explore AWS services and features to assist with the governance and security of AI solutions.

What's included

13 videos3 readings3 assignments

13 videos Total 88 minutes

Descriptive & Diagnostic Analytics - Overview 7 minutes
Data Profiling - Demo 7 minutes
SQL Querying - Demo 8 minutes
Datasets querying using the XMLA - Demo 6 minutes
Choose a storage mode 7 minutes
Use cases for DAX Studio and Tabular Editor 2 - Overview 6 minutes
Star schema for a semantic model - Demo 5 minutes
Implement relationships - Demo 6 minutes
DAX Calculations and Functions - Demo 5 minutes
Query Performance Improvements - Demo 6 minutes
DAX Performance Optimization - Demo 9 minutes
Semantic Model Optimization Tools - Demo 7 minutes
Incremental Refresh - Demo 9 minutes

3 readings Total 80 minutes

Overview of Microsoft Fabric: Explore, Analyze Data with DAX and Semantic Models 30 minutes
Course Conclusion and Summary 20 minutes
What’s Next and Best Practices? 30 minutes

3 assignments Total 65 minutes

Data Acquisition, Modeling, and Fundamental Analytics - Knowledge Check 15 minutes
Advanced Analytics, Performance Optimization, and Deployment - Knowledge Check 15 minutes
Microsoft Fabric: Explore, Analyze Data with DAX and Semantic Models - Assessment 35 minutes

Instructor

Whizlabs Instructor

Whizlabs

145 Courses 112,626 learners

Offered by

Whizlabs

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.