Building End-to-End Data Analytics Solutions with Microsoft Fabric and Open Data
Proposed session for SQLBits 2026TL; DR
Discover how to create a comprehensive end-to-end data analytics solution using Microsoft Fabric that reflects real-world scenarios. In this session, we will utilise open data sources such as the World Bank and Weather Data to showcase key artifacts and techniques within Microsoft Fabric. You will gain insights into workspace architecture, naming conventions, Lakehouses, Notebooks, and more, with practical scenarios you can apply to your work.
Session Details
Discover how to create a comprehensive end-to-end data analytics solution using Microsoft Fabric that reflects real-world scenarios. In this session, we will utilise open data sources such as the World Bank and Weather Data to showcase key artifacts and techniques within Microsoft Fabric. You will gain insights into workspace architecture, naming conventions, Lakehouses, Notebooks, and more, with practical scenarios you can apply to your work.
In this session, we will cover:
Workspace Architecture and Naming Conventions: Best practices for organising your workspace and naming your resources.
Working with Lakehouses and Notebooks: How to effectively use Lakehouses for data storage and Notebooks for data ingestion and transformation, as well as how to utilise Notebook environments.
Data Factory Pipelines for Orchestration: Automating data workflows with Data Factory pipelines.
Logging and Semantic Model Development: Implementing a logging framework for monitoring and maintaining the solution.
Developing and Maintaining Semantic Models: Using Semantic Link Labs to enhance semantic model development, particularly regarding measures and calculation groups creation.
In this session, we will cover:
Workspace Architecture and Naming Conventions: Best practices for organising your workspace and naming your resources.
Working with Lakehouses and Notebooks: How to effectively use Lakehouses for data storage and Notebooks for data ingestion and transformation, as well as how to utilise Notebook environments.
Data Factory Pipelines for Orchestration: Automating data workflows with Data Factory pipelines.
Logging and Semantic Model Development: Implementing a logging framework for monitoring and maintaining the solution.
Developing and Maintaining Semantic Models: Using Semantic Link Labs to enhance semantic model development, particularly regarding measures and calculation groups creation.
3 things you'll get out of this session
Workspace Architecture and Naming Conventions: Best practices for organising your workspace and naming your resources.
Working with Lakehouses and Notebooks: How to effectively use Lakehouses for data storage and Notebooks for data ingestion and transformation, as well as how to utilise Notebook environments.
Data Factory Pipelines for Orchestration: Automating data workflows with Data Factory pipelines.
Logging and Semantic Model Development: Implementing a logging framework for monitoring and maintaining the solution.
Developing and Maintaining Semantic Models: Using Semantic Link Labs to enhance semantic model development, particularly regarding measures and calculation groups creation.
Speakers
Prathyusha(Prathy) Kamasani's other proposed sessions for 2026
Designing Power BI Templates for Adoption - 2026
Fabric BI Architecture: Patterns, Workspaces, and Trade-offs - 2026
Fabric Tenant Settings: The Decisions Behind What's Open and What's Closed - 2026
Making Sense of Fabric Capacity: Start, Monitor, Scale - 2026
Prathyusha(Prathy) Kamasani's previous sessions
One dataset and three use cases with Microsoft Fabric
Are you curious about how to leverage Open Data with Fabric? In this demo filled session, I will show you how I import World Bank Open Data into Fabric using different methods: Pipelines, Data factory Gen-II, Notebooks and a mix of all three. Then I will demonstrate how I do modelling using Warehouse, Power BI Dataset model and Notebooks. Finally, I will create stunning reports using Power BI.
By the end of the session, attendees will get an idea of how each artifact would work, why one would use one over other artifacts, and understand how to create an end-to-end solution with Microsoft Fabric
Powering Up Your Power BI Development Workflow with Microsoft Fabric Notebooks
Are you excited about Microsoft Fabric and its Notebooks feature, but also feel overwhelmed by the different languages it supports, this session is for you. You will learn the basics of Python and Spark, and how to use Notebooks to write and run code. You will also discover how to leverage tools like CoPilot to assist you with code suggestions and corrections. Moreover, you will see how to use libraries like SemPy to enrich your Power BI development with advanced analytics. Join Prathy in this session and get ready to explore the possibilities of Notebooks in Microsoft Fabric.