Getting Started with Microsoft Fabric

Développez vos compétences avec Coursera Plus pour 239 $/an (habituellement 399 $). Économisez maintenant.

Ce cours n'est pas disponible en Français (France)

Nous sommes actuellement en train de le traduire dans plus de langues. Consultez les langues disponibles.

Getting Started with Microsoft Fabric

Instructeur : Whizlabs Instructor

2 192 déjà inscrits

Inclus avec

5 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Débutant

Expérience recommandée

2 semaines à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

5 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Débutant

Expérience recommandée

2 semaines à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

Ce que vous apprendrez

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.

Compétences que vous acquerrez

Catégorie : Data Cleansing
Catégorie : Data Warehousing
Catégorie : Data Pipelines
Catégorie : Extract, Transform, Load
Catégorie : Data Governance
Catégorie : Data Analysis
Catégorie : Data Integration
Catégorie : Data Modeling
Catégorie : Data Analysis Expressions (DAX)
Catégorie : Data Transformation
Catégorie : Analytics

Outils que vous découvrirez

Catégorie : Power BI
Catégorie : Dashboard
Catégorie : Microsoft Azure

Détails à connaître

Certificat partageable

Ajouter à votre profil LinkedIn

Évaluations

11 devoirs

Enseigné en Anglais

Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

En savoir plus sur Coursera pour les affaires

logos de Petrobras, TATA, Danone, Capgemini, P&G et L'Oreal

Il y a 5 modules dans ce cours

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.

Inclus

8 vidéos3 lectures2 devoirs

8 vidéos 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 lectures 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 devoirs 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.

Inclus

9 vidéos1 lecture2 devoirs

9 vidéos 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 lecture Total 30 minutes

Overview of Microsoft Fabric: Introduction & Core Components 30 minutes

2 devoirs 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.

Inclus

9 vidéos1 lecture2 devoirs

9 vidéos 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 lecture Total 30 minutes

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

2 devoirs 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.

Inclus

8 vidéos1 lecture2 devoirs

8 vidéos 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 lecture Total 30 minutes

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

2 devoirs 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.

Inclus

13 vidéos3 lectures3 devoirs

13 vidéos 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 lectures 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 devoirs 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

Instructeur

Whizlabs Instructor

Whizlabs

145 Cours 113 183 apprenants

Offert par

Whizlabs

Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?

Felipe M.

Étudiant(e) depuis 2018

’Pouvoir suivre des cours à mon rythme à été une expérience extraordinaire. Je peux apprendre chaque fois que mon emploi du temps me le permet et en fonction de mon humeur.’

Jennifer J.

Étudiant(e) depuis 2020

’J'ai directement appliqué les concepts et les compétences que j'ai appris de mes cours à un nouveau projet passionnant au travail.’

Larry W.

Étudiant(e) depuis 2021

’Lorsque j'ai besoin de cours sur des sujets que mon université ne propose pas, Coursera est l'un des meilleurs endroits où se rendre.’

Chaitanya A.

’Apprendre, ce n'est pas seulement s'améliorer dans son travail : c'est bien plus que cela. Coursera me permet d'apprendre sans limites.’

Ouvrez de nouvelles portes avec Coursera Plus

Accès illimité à 10,000+ cours de niveau international, projets pratiques et programmes de certification prêts à l'emploi - tous inclus dans votre abonnement.

Faites progresser votre carrière avec un diplôme en ligne

Obtenez un diplôme auprès d’universités de renommée mondiale - 100 % en ligne

Découvrir les diplômes

Rejoignez plus de 3 400 entreprises mondiales qui ont choisi Coursera pour les affaires

Améliorez les compétences de vos employés pour exceller dans l’économie numérique

Foire Aux 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.