Enablement Session: Accelerating Data Innovation with Microsoft Fabric

Enablement – Microsoft Fabric provides a comprehensive introduction to Microsoft Fabric as a unified analytics platform that streamlines data movement, integration, engineering, real-time analytics, and business intelligence. This session will equip participants with an understanding of Fabric’s core capabilities, the medallion architecture best practices, and seamless integration with tools like Power BI, Azure SQL, and data lakes, while also showcasing practical scenarios for data ingestion, transformation, and consumption to accelerate adoption and maximize business value.

1. Microsoft Fabric
Microsoft Fabric
Enablement

2. Contents
01
Introducing Microsoft Fabric
02
Workload deep dive
03
Copilot in Fabric overview
04
OneLake overview
05
Security, governance, and
admin
06
Developer tools
07
Partner and Industry
solutions
08
Fabric and Azure Databricks
09
Product integrations
10
Customer stories
11
Licensing
12
Appendix

3. Introducing
Microsoft Fabric

4. Title
87%
of organizations believe
AI will give them a
competitive edge
Source: MIT Sloan Management Review
4 Microsoft Fabric

5. Title1
CIOs are accelerating their
efforts to bring AI to their
data estate
5 Microsoft Fabric

6. The starting line
A complex, organically evolved data estate
Business team Business team Business team
Tech team
Enterprise data sources
Vendor 1: Ingestion
Vendor 2: Storage
Vendor 4: Compute and serving
Vendor 3: Data management
Tech team
Vendor 1: Ingestion
Vendor 2: Storage
Vendor 4: Compute and serving
Vendor 3: Data management
Several
1
Data copies and infrastructure
inefficiencies
2
Limited interoperability between
vendor services
3Data exposure risks
6 Microsoft Fabric

7. Leverage everything
Microsoft has to offer
Microsoft Intelligent Data Platform
Microsoft Fabric • SQL Server • Azure SQL • Azure Cosmos DB
Azure Databricks • Microsoft Purview • Azure AI
Data governance
Analytics
Operational databases
Microsoft Cloud
Dynamics 365 • Microsoft 365
Power Platform
Leverage
everything
Microsoft has
to offer
7 Microsoft Fabric

8. Microsoft Fabric
The data platform for the era of AI
From To
Multiple analytics services Unified stack
Disconnected data sources All the data in one place
Isolated application Entire estate
Gen AI bolt on Gen AI built in
8 Microsoft Fabric

9. Microsoft Fabric
Data
Factory
Data
Engineering
Data
Warehouse
Data
Science
Real-Time
Intelligence
Power
BI
Partner &
Industry
workloads
Copilot in Fabric
OneLake
Microsoft Purview
9 Microsoft Fabric

10. Fabric sizzle video
10 Microsoft Fabric

11. Microsoft
Fabric
Capabilities
Unify your analytics on a
complete, governed platform
Reduce the cost and effort of
integration with a unified, secure,
and governed platform
Establish a trusted data
foundation
Connect to any data from a single,
multi-cloud data lake and use a
single copy of data across engines
Empower every business user
Empower everyone to uncover
insights accessible data, easy-to-
use tools, and visuals embedded
apps they use everyday
Fuel your AI innovation
Adopt a data platform infused
with AI at every layer to help you
get more done, faster
11 Microsoft Fabric

12. Empower every business user
Empower everyone to uncover insights
with the data they need, easy-to-use
tools, and visuals embedded in the
Microsoft 365 apps they use everyday
•Quickly go from data in a Lakehouse to insights
in the hands of your business users
•Save time for analysts and provide up-to-date
insights with Direct Lake mode, a blazing fast,
real-time connection to your data in OneLake
•Foster a data-driven culture by seamlessly and
securely embedded insights into Teams, Excel,
PowerPoint, Outlook, and more with native
integration
12 Microsoft Fabric

13. Understanding the top pain points of Data Professionals
Data Engineers
Complexity. Implementing
ETL can require considerable
coding, especially when
loading only modified rows.
Cost. Implementing ETL can
require an exorbitant cost of
purchasing additional tools
and licenses.
Data latency. Implementing
ETL adds a time delay for
running the analytics and
prevents fresh insights.
Data Scientists
Siloed development. Isolated
collaboration between Data
and ML teams leads to low
quality data pipelines and
unproven ML ROI. Difficulty in
stream-lining decision-making
processes.
Complex operationalization.
ML PoC purgatory. High cost of
management, scale, reliability,
RAI. Reduced trust
disconnected from data source.
Data Analysts
Bad data. Lack of access to
the right data leads to bad
insights.
Limited capacity and speed.
Struggle to keep up with the
number of reports needed to
be created and maintained,
slowed by dependencies on
other data teams.
Embedding. Finding ways to
integrate and share reports
where stakeholders work.
Business users
Finding insights. Digging
into insights requires
accessing reports from
multiple applications and
systems.
Time waste. Identifying
critical and action-orientated
insights from BI reports is time
intensive.
Data Stewards
Data sprawl. Lack of visibility and strong governance tools leads to sprawling data, excessive replication of data, and security risks.

14. Fuel your AI innovation
Adopt a data platform that’s infused
with AI at every layer to help you get
more done, faster
•Use conversational language with Copilot
in Fabric to create dataflows and pipelines,
write SQL statements, or even build machine
learning models
•Simply describe what you need—including
reports, summaries, and calculations—or ask a
question, and Copilot in Power BI does the rest
•Use LangChain and Semantic Kernel to develop
and scale custom generative AI models—right
from your Fabric Notebook
•Deliver custom generative AI experiences like
tailored Q&A on your data with AI skills
13 Microsoft Fabric

15. Fuel your journey to AI innovation by getting your data AI ready
Establish a central
repository for all data
1
Integrate disparate data sources into a
unified data platform and data lake
Prepare data for
AI innovation
2
Improve the quality of your data, to ensure
it is complete, accurate, and governed
Build generative AI experiences
on top of your data
3
Enhance the breadth and depth of
data-driven experiences by creating
an AI solution
OneLake
Microsoft Fabric data
experiences
Azure AI Studio
14 Microsoft Fabric

16. Workload
overview

17. Seven key workloads for end-to-end analytics
Workloads are designed to target specific personas and tasks, yet work together seamlessly in a unified platform
via OneLake to enable creators to collaboratively do their best work
Data
Factory
Unify your data estate with a data integration experience and 300+ data transformations to easily solve the most complex ETL
scenarios
Data
Engineering
Enable data engineers to design, build, and maintain infrastructures at scale using World-class Spark platform with great authoring
experiences to
Data
Warehouse
Provide industry-leading SQL performance and scale, fully separating compute from storage for independently scaling and natively
storing data in open Parquet/Delta Lake
Data
Science
Empower data scientists and analysts to quickly build, deploy, and operationalize sophisticated AI directly within Fabric
Real Time
Intelligence
Ingest streaming data with high granularity, dynamically transform streaming data, query data in real-time for instant insights, and
trigger actions
Power BI
Make better, data-driven decisions with the world’s leading business intelligence platform that turns unrelated sources of data into
coherent, interactive insights
16 Microsoft Fabric

18. Data Factory workload
Dataflows and data pipelines bring together low-code, AI-based experiences, multi-cloud connectivity, and
persistent data security and governance to help solve complex ETL scenarios for all developers
Data
Factory
Data
Engineering
Data
Warehouse
Data
Science
Real-Time
Intelligence
Power
BI
Partner &
Industry
workloads
Copilot in Microsoft Fabric
OneLake
Security, Governance and Administration with Purview
200+ native data source connectors
300+ data transformations in dataflows
designer to transform data more easily
Cloud-scale data movement with Data
Factory
Low-code interface for ingesting data
from hundreds of data sources using
Dataflows Gen2
Out-of-the-box rich data orchestration
capabilities to compose flexible workflows
Powerful, enterprise-grade Data Factory
workload with the best of ADF and Power
Query together
17 Microsoft Fabric

19. Data Engineering workload
Build your data estate and empower data engineers with a world-class Spark platform, fully integrated with
Data Factory, to transform and maintain infrastructures at scale
Data
Factory
Data
Engineering
Data
Warehouse
Data
Science
Real-Time
Intelligence
Power
BI
Partner &
Industry
workloads
Copilot in Microsoft Fabric
OneLake
Security, Governance and Administration with Purview
Pro and low-code authoring experience
Schedule and orchestrate data
transformations with notebooks and
Spark jobs
Use notebooks to write code for data
ingestion, preparation, and transformation
Launch clusters on demand and
dynamically scale in, scale out, pause, and
resume
Perform code-free interactive data
exploration and add to your data pipeline
18 Microsoft Fabric

20. Data Warehouse workload
Achieve data platform goals with ease and cost efficiency, while empowering your developers and engineers of
any skill level with accelerated reporting and insights
Data
Factory
Data
Engineering
Data
Warehouse
Data
Science
Real-Time
Intelligence
Power
BI
Partner &
Industry
workloads
Copilot in Microsoft Fabric
OneLake
Security, Governance and Administration with Purview
Industry-leading SQL performance and
scale
Fully separate compute storage that can
independently scale
Natively store data in open
Parquet/Delta Lake
TLS 1.2 encryption protects connections
for granular security across data platform
Cross-database querying for fast insights
and zero data duplication
19 Microsoft Fabric

21. Data Science workload
Build, deploy, and operationalize sophisticated AI and ML models with speed and at scale from your Lakehouse
Data
Factory
Data
Engineering
Data
Warehouse
Data
Science
Real-Time
Intelligence
Power
BI
Partner &
Industry
workloads
Copilot in Microsoft Fabric
OneLake
Security, Governance and Administration with Purview
Access data from multiple sources and
store data and insights in Lakehouse(s)
Leverage data science capabilities for
model prediction at scale Iterate, build,
and track machine learning experiments
using ML flow
Perform exploration, experimentation,
modeling, featurization and serving
of predictive insights by leveraging
built-in experiences
Collaborate with others via Notebook,
Power BI, and Lakehouses in real-time
20 Microsoft Fabric

22. Real-Time Intelligence workload
Explore data and turn insights into actions by performing real-time analysis across telemetry data to better
predict, optimize, and improve data applications
Data
Factory
Data
Engineering
Data
Warehouse
Data
Science
Real-Time
Intelligence
Power
BI
Partner &
Industry
workloads
Copilot in Microsoft Fabric
OneLake
Security, Governance and Administration with Purview
Ingest, transform, query, visualize, and act
on data in real time.
Simple ingestion, curation and processing
of streaming data in the Real-Time Hub, a
single data estate for data in motion.
No-, low-, and pro-code experiences
for everything from business insight
discovery to complex stream processing.
Create triggers on changing data to act
automatically when conditions are met.
Streamline analysis of event streaming
data with Copilot in Fabric.
21 Microsoft Fabric

23. Power BI workload
Uncover powerful insights with intelligence visuals, leverage data quickly and intuitively, and help achieve faster
and better, data-based decisions with the industry-leading Power BI platform
Data
Factory
Data
Engineering
Data
Warehouse
Data
Science
Real-Time
Intelligence
Power
BI
Partner &
Industry
workloads
Copilot in Microsoft Fabric
OneLake
Security, Governance and Administration with Purview
Easy-to-use drag and drop canvas and
visualizations for insightful and engaging
report-building in seconds
Native Integration with Microsoft 365
Built-in AI capabilities and visuals
illuminate hidden patterns, opportunities
and anomalies with the click of a button
Connect to, index, and certify datasets in
the Power BI data hub
Build governed databases, like data
models or data marts, in a trusted and
secure hub
22 Microsoft Fabric

24. Copilot in Microsoft Fabric
Use conversational language with Copilot in Fabric to create dataflows and pipelines, write SQL statements, build
reports, and even build machine learning models
Data
Factory
Data
Engineering
Data
Warehouse
Data
Science
Real-Time
Intelligence
Power
BI
Partner &
Industry
workloads
Copilot in Microsoft Fabric
OneLake
Security, Governance and Administration with Purview
Chat with AI assistant and request help
handling data analysis
Code more efficiently with intelligent
code completion and generated code
explanations
More quickly enrich, model, analyze, and
explore data all through natural languages
Create Power BI reports automatically and
summarize your insights for streamlined
productivity
Access industry-standard code templates
to facilitate building robust data pipelines
23 Microsoft Fabric

25. Unified data foundation with OneLake
Manage and analyze all your data across your organization in a unified, secure, and centralized SaaS data lake
for everyone with OneLake––the “OneDrive” for data
Data
Factory
Data
Engineering
Data
Warehouse
Data
Science
Real-Time
Intelligence
Power
BI
Partner &
Industry
workloads
Copilot in Microsoft Fabric
OneLake
Security, Governance and Administration with Purview
A single and open, logical SaaS lake for
the whole organization
OneLake supports any type of file,
structured or unstructured
One copy of data for use with multiple
analytical engines
Enable virtualization of data without
duplication using shortcuts
All workloads automatically store their
data in OneLake in Delta Parquet format
Data in OneLake is automatically indexed
for discovery, sharing, governance, and
compliance
24 Microsoft Fabric

26. Security, Governance and Admin in Microsoft Fabric
Manage, secure, and govern all your data in Microsoft Fabric and beyond
Data
Factory
Data
Engineering
Data
Warehouse
Data
Science
Real-Time
Intelligence
Power
BI
Partner &
Industry
workloads
Copilot in Microsoft Fabric
OneLake
Security, Governance and Administration with Purview
Reduce the effort needed to defend and
control your entire analytics platform with
out-of-the-box security and governance
Secure your network from any intrusion,
ensure only the right people have access
to the right data, and maintain compliance
with even the strictest requirements​
Enable different parts of the organization
to take ownership of their data while still
contributing to the same data lake ​
Certify datasets to promote usage of
the most accurate data across the
organization
Maintain the flexibility to use the partner
and third-party solutions you want​
25 Microsoft Fabric

27. Copilot in
Microsoft Fabric
overview

28. Copilot in Microsoft Fabric
Data Factory
Get intelligent code
generation to
transform data with
ease and code
explanations to help
you better understand
complex tasks
Data Engineering and Data Science
Quickly generate code in Notebooks to help
work with Lakehouse data and get insights.
Data
Warehouse
Write and explain
T-SQL queries, or even
make intelligent
suggestions and fixes
while you are coding
Real-Time
Intelligence
Translate questions
into KQL queries that
you can execute.
Power BI
Quickly create report
pages, natural
language summaries,
and generate
synonyms.
28 Microsoft Fabric

29. Copilot in Fabric
29 Microsoft Fabric

30. Licensing

31. Microsoft Fabric business model overview
Microsoft Fabric
COMPUTE
Data
Factory
Data
Engineering
Data
Warehouse
Data Science Real Time
Analytics
Partner &
Industry
workloads
Power
BI
Copilot in Fabric
STORAGE
Unified data foundation
OneLake
31 Microsoft Fabric

32. Microsoft Fabric simplicity
Microsoft Fabric is a unified product for all yourdata and analytics workloads. Rather than provisioning and
managing separate compute for each workload, with Microsoft Fabric, your bill is determined by two variables:
the amount of compute you provision and the amount of storage you use.
COMPUTE
A shared pool of capacity that powers all
capabilities in Microsoft Fabric.
Pay-as-you-go and 1-year Reservation.
STORAGE
A single place to store all data.
Pay-as-you-go ($ per GB/month).
32 Microsoft Fabric

33. Microsoft Fabric capacity
COMPUTE
A shared capacity that provides a set of capacity units (CUs) powering the compute for Data Warehouse, Data
Integration, Data Science, Data Engineering, Real-Time Intelligence, Power BI, and Copilot.
Simplicity of
purchasing
No need to purchase
separate compute for
each workload
Flexibility
in use
With no pre-allocation
required, the same set
of CUs can be used for
any workload
Cost
savings
All CUs are pooled together
and are not locked to an idle
workload. Smoothing on
compute usage also allows
you to size capacity closer
to the average usage than
the peaks
Value
optimization
Adjust compute capacity by
scaling up and down
Transparent
monitoring
Centralized dashboard to
monitor usage and costs in
Microsoft Fabric utilization
and metrics app
33 Microsoft Fabric

34. How it works
COMPUTE
Capacity units (CUs) = Compute power
Capacity units (CUs) are units of measure that represent a pool of compute power needed.
Compute power is required to run queries, jobs, or tasks.
CU Consumption
The CU consumption is highly correlated to the underlying compute effort needed for the tasks
performed by the capability during the processing time.
Each capability, such as Power BI, Spark, Data Warehouse, with the associated queries, jobs, or
tasks has a unique consumption rate.
Note: For additional documentation on purchasing experience and capacity models, please see here: aka.ms/fabriclicensing
34 Microsoft Fabric

35. Translation for existing Power BI Premium per
capacity Customers
COMPUTE
Today
SKU PBI vCore
P1 8
P2 16
P3 32
P4 64
P5 128
Microsoft Fabric
Generally Available
SKU CU
F 64 64
F 128 128
F 256 256
F 512 512
F 1024 1024
•Power BI Premium P SKUs get
access to the full Fabric
capabilities
•8 CUs are providing the same
compute power of 1 Power BI
Premium v-core for Power BI
workloads. That is, F64
provides the equivalent
compute power of Power BI
Premium P1
For additional documentation on Fabric licensing types, please see here: Microsoft Fabric concepts – Microsoft Fabric | Microsoft Learn
35 Microsoft Fabric

36. OneLake
STORAGE
A single unified SaaS data lake that comes automatically provisioned with every tenant without additional
infrastructure to manage
Simplicity of
purchasing
Automatically provisioned
single storage service for
all workloads
Single source
of truth
Bring in data from anywhere
and reduce costs from
data duplication by
virtualizing your cross-cloud
data in OneLake
Maximize data
investments
Allows linking your existing
third-party storage systems
natively and makes it
available to Microsoft Fabric
analytics workloads
Open
access
Open format democratizes
access to multiple analytical
engines, reducing additional
resources needed to set up
Simplified
security
Simplified security,
governance, and data
discovery in one place
to reduce maintenance
overhead
36 Microsoft Fabric

37. Copilot in Fabric pricing
Copilot in Fabric is available in all paid SKU but not included in the Fabric free account or trial or Power BI per
user licenses
You can simply count Copilot usage against your existing Fabric or Power BI Premium capacity
Copilot usage is measured by the number of tokens processed. Tokens can be thought of as pieces of words.
Approximately 1,000 tokens are about 750 words. Prices are calculated per 1,000 tokens, and input and output
tokens are consumed at different rates
Operation in Metrics AppDescription Operation Unit of MeasureConsumption rate
Copilot in Fabric The input prompt Per 1,000 Tokens 100 CU seconds
Copilot in Fabric The output completion Per 1,000 Tokens 500 CU seconds
See full details here: https://aka.ms/Copilot-Billing-Docs
37 Microsoft Fabric

38. Why Fabric

39. Microsoft Fabric
The data platform for the era of AI
End-to-end analytics platform Connectivity with other Microsoft Product
Optimize for AI usage Scale up and down with ease
Embrace different roles Easy to monitor
Less integration, less redundancy
39 Microsoft Fabric

40. Fabric Use Case
Scenario where Fabric comes in handy
Data Warehouse
Data consolidation
Summary dashboard
Data Science
Predicting wear-and-tear
Sales forecast
Cost Optimization
Real-Time
Analytics
Manufacture maintenance
Fleet management
IoT device
Use Case
40 Microsoft Fabric

41. Target Audience

42. Microsoft Fabric suited for customer who wants to …
TARGET AUDIENCE
Embrace AI
Fabric has the capability for
customer who wants to use
AI in their day-to-day
activity
Create Data
Warehouse
With more than 200
connectors Fabric can
combine all your
transactional data into a
single data warehouse
Migrate from
Premium Capacity
Premium capacity no longer
available. Customers should
migrate to Fabric
Make Report and
Dashboard
Power BI in Fabric is the
right tools to implement
report and dashboard with
its direct lake connectivity
And many more …
With its workloads Fabric
can handle as much as any
pain point that company
facing in analytics problem
42 Microsoft Fabric

43. Microsoft Fabric43
Customer Reference

44. Microsoft Data Analytics
44 Microsoft Fabric

45. Microsoft Fabric
Microsoft Fabric
Contacts :
Tito Prakasa ([email protected])
Vivi Dian Sari ([email protected])
R Bagus Iwan D S ([email protected])
Winda ([email protected])
Riana Elisabeth Swastika([email protected])