Data Analytics with Microsoft Fabric course image

Data Analytics with Microsoft Fabric

Build an end-to-end analytics solution in Microsoft Fabric with a lakehouse, dataflows, pipelines, a notebook, a warehouse, and a Direct Lake semantic model.

$900.00

Description

Build an end-to-end analytics solution in Microsoft Fabric with a lakehouse, dataflows, pipelines, a notebook, a warehouse, and a Direct Lake semantic model.

Price$900Per person
Time9 course hoursOn-demand video and labs, plus 1 hour of coaching
DeliveryOn-demand asynchronous trainingWith online support and 1 hour of coaching
CredentialCertificate of completionFrom We Can Code IT

About this course

This introductory certificate course adds the Microsoft Fabric data platform to the Power BI skills you already have, and it is not preparation for the DP-600 exam. You will land data in a lakehouse with Dataflows Gen2, schedule it with a pipeline, clean it with a guided notebook, and query it through the warehouse and SQL analytics endpoint, finishing with a Direct Lake semantic model and a report built on your own Fabric data.

Who it is for

This course suits Power BI analysts moving into analytics engineering, and data staff whose employer has bought or is trialing Microsoft Fabric.

Prerequisites

Working Power BI skills, such as building models and measures

Ability to read basic SQL queries

Access to a Fabric capacity or a Fabric trial that your tenant administrator allows

Requirements

Requires a Windows PC

Microsoft Fabric runs in a web browser, but the Power BI Desktop parts of the course are Windows only

A paid Fabric capacity or a free Fabric trial (60 days); your tenant administrator may need to allow the trial

The Fabric trial does not include Copilot or other AI experiences, and the course does not use them

A Microsoft work account in your employer's tenant

What you will be able to do

  • You will be able to explain how OneLake, workspaces, and capacities fit together and start a Fabric trial.
  • You will be able to build a lakehouse and load data into it with Dataflows Gen2.
  • You will be able to create a pipeline that orchestrates a load and runs on a schedule.
  • You will be able to transform raw data into a clean table using a guided notebook.
  • You will be able to query lakehouse and warehouse data through the SQL analytics endpoint.
  • You will be able to build a Direct Lake semantic model and a report on top of your Fabric data.

Syllabus

1

Fabric Foundations 1 hour

OneLake, Workspaces, Capacities, Starting a Fabric trial.

Lab: You will set up a Fabric workspace and confirm it is assigned to a capacity or trial.
2

Build a Lakehouse and Ingest with Dataflows Gen2 2 hours

Creating a lakehouse, Dataflows Gen2, Loading tables, Files and tables in OneLake.

Lab: You will create a lakehouse and load a set of source files into it with a dataflow.
3

Orchestrate with a Pipeline 1.5 hours

Pipeline activities, Running a dataflow from a pipeline, Scheduling a load.

Lab: You will build a pipeline that runs your dataflow and schedule it to load new data.
4

Transform with a Notebook 1.5 hours

Notebook basics, Reading lakehouse tables, Cleaning data, Writing a clean table.

Lab: You will follow a guided notebook to turn a raw table into a clean table, with no prior Spark experience needed.
5

Query Through the Warehouse and SQL Analytics Endpoint 1 hour

SQL analytics endpoint, Fabric data warehouse, Writing queries.

Lab: You will query your clean tables with SQL and save a view for reporting.
6

Semantic Model and Report with Direct Lake 2 hours

Direct Lake mode, Star schema on Fabric data, Building a report.

Lab: You will build a Direct Lake semantic model on your lakehouse and publish one report from it.
+

Coaching sessions 1 hour

One-on-one or small-group coaching, scheduled with your coach.

How it is delivered

How you learn

On-demand asynchronous training with online support, plus 1 hour of coaching.

Live or in person

Live online or in-person sessions are available for an additional fee. Email admissions@wecancodeit.org for details.

TechCred

Eligible credential

Data Analytics with Microsoft Fabric

Reimbursement applies only to the credential approved in your TechCred application, so use the exact credential name shown on this page.

Funding

Ohio's TechCred program may reimburse eligible Ohio employers up to $1,000 per person, per credential, and up to $30,000 per application, for eligible costs such as tuition and certification costs.

This price is within TechCred's maximum of $1,000 per person, per credential.

Timeline

The current application period opens at 9:00 a.m. on October 1, 2026 and closes at 3:00 p.m. on October 30, 2026.

Training must start no earlier than the first day of the application period and be completed within 12 months of the award date.

What we provide

For each learner, We Can Code IT provides an itemized per-person invoice that shows the exact credential name, and a certificate that shows the learner's name, the credential and the date earned (or the vendor's exam record for certifications). We can also send a written quote to include with your TechCred application.

Pricing is the same for all customers, whether or not you use TechCred.

We Can Code IT is an independent training provider. Being listed as an eligible TechCred provider is not an endorsement by the State of Ohio and does not guarantee funding. The Ohio Department of Development makes all TechCred decisions, so check the state's current program guidelines before you apply. Program details: the State of Ohio’s TechCred page.

Enroll your team

One or a few learners

Choose the number of seats, add the course to your cart and check out.

A group, or a written quote

Send the form below for group enrollment or a written quote to include with your TechCred application. We reply within one business day. You can also email admissions@wecancodeit.org.

Request group enrollment or a written quote

Tell us about your team and we will reply within one business day.

← Back

Thank you for your response. ✨

We Can Code IT, LLC, 26300 Cedar Rd, Suite 1105, Beachwood, OH 44122. Registered with the Ohio State Board of Career Colleges and Schools, Registration No. 15-03-2064T.

Syllabus