Pragati Jain
Microsoft MVP - Data Platform, Analytics Manager at Avanade
London, United Kingdom
Actions
Pragati is a Data Platform MVP (Microsoft Most Valuable Professional).
Currently, she is working as a Manager at Avanade in UK and works towards generating and delivering data insights to various customers. She holds a Master’s degree in Data Science and Analytics from Royal Holloway University of London.
She is skilled in various tools and technologies like Microsoft Fabric, Microsoft Power BI, Tableau, Microsoft Excel, Azure ML Studio, Azure Databricks Pyspark and SQL.
She has been using Power BI for few years now and is recognized as a Superuser on the Microsoft Fabric Community.
Outside work she enjoys photography, loves hiking, she is a trained Indian classical singer and has a passion for painting. She even has her Instagram page dedicated to painting.
Microsoft MVP: https://mvp.microsoft.com/en-us/PublicProfile/5004163?fullName=Pragati%20Jain
Links
Badges
Area of Expertise
Topics
Table Talk "Data Modeling in Fabric and Power BI"
Data Modeling is the most underestimated task when it comes to performance, easy DAX and a easy-to-use semantic model in Fabric and Power BI.
In this table talk we want to publicly discuss usual problems and their solutions we see in our daily work as consultants with a broad range of customers (some import a single Excel-File into Power BI while others created near-real-time reports based on Tera bytes of data).
Feel free to bring your own question so we can make this hour as interactive as possible.
Strap In: A High-Speed Ride Through Microsoft Fabric
Microsoft Fabric has been there for sometime and many have already explored or started exploring it’s capabilities.
Pragati is a Data Platform MVP and has been working with Microsoft Fabric since starting including designing Fabric based client solutions.
Whether you come from Data Modelling or Reporting or Data Engineering or Data Science background, Microsoft Fabric has something for all. In this session Pragati will dive into multiple persona based Microsoft Fabric capabilities.
If you are interested in understanding what Microsoft Fabric has got for you, then join this session to learn more.
Revealing the Performance Crashers in Power BI
Pragati is working with Power BI for few years now and during these years she has learned some best practices with Power BI on how one can save their report from a performance crash.
In this session she will be sharing some use-cases where things can go wrong in Power BI while visualising the data can hinder the performance of the report. These use-cases will also include tips around how one can overcome these performance issues by following some best practices.
Come and join this session to understand what one should avoid while creating reports in Power BI.
Public Speaking and where it gets you
Pragati is a Microsoft Data Platform MVP and is into speaking from last few years.
She has been speaking at multiple conferences & user groups for quite sometime and has many things to share on how public speaking can impact not only your professional growth but also personal growth in a positive way.
Being a women in tech, there are certain times when you have to make your voice heard. Not everyone is been gifted with the art of speaking, but speaking is just like any other skill that improves over time. there is always a first time for everything and so as for speaking.
In this session, Pragati will share her ups and downs with public speaking and how her journey of speaking has helped her in gaining more confidence and develop her overall personality. She will also be sharing some tips around how one can start their speaking journey as a woman in this tech world.
Power Up Skills with Power BI
This is a complete training session for the audience to start their journey with Microsoft Power BI. In the end of the training, the audience will leave the room with a fully functional Power BI report created using a real-world dataset.
Agenda:
1. Introduction to Power BI
• This will include going through the Power BI eco-system – Power BI Desktop & Power BI service
2. Data Cleaning
• Import data to Power BI
• Exploring Data profiling options
• Learn about basic transformations in Power Query editor
• Basics to Advance Editor
• Best practises around naming the transformations & data-types
• Date table creation
3. Data Modelling basics
• Creating basic relationship
• Understanding the cardinality
• Hide/view capabilities
• Best practises around Comments & Naming conventions
4. DAX basics
• Measures vs columns
• Quick measures
• Basic DAX functions
• Date table using DAX
5. Data Visualisations
• Introduction to the page canvas, background & settings
• Visuals in Power BI
• Custom visuals
• What visuals to use when
• Analytics feature in visuals
• Conditional formatting in visuals
• Best practises around layout of visuals in a report
• Usage of buttons/bookmarks to create interactive reporting
• Drill down, drill up & drill throughs capabilities
• Colour schemes and themes in Power BI
• Creating a brand specific custom theme
6. Power BI report from scratch in Power BI Desktop
• By using all the learning above, a Power BI report will be created from scratch
7. Power BI Service
• Basics of Power BI Service
• Creating your first workspace
• Publish & share your first report
8. Summary
Power Up Skills with Power BI
This is a complete training session for the audience on Microsoft Power BI. In the end of the training, the audience will leave the room with a fully functional Power BI report created using a real-world data along with learning intermediate to advanced concepts to top-up their beginner-level Power BI skills.
Agenda:
1. Start with quick Introduction to Power BI
• This will include going through the Power BI eco-system – Power BI Desktop & Power BI service
2. Power Query
• Power Query transformations
• Functions in Power Query
• Query Parameters
• Advanced M code with Advanced Editor
• Data profiling options
• Date table creation
• Query Folding
• Best practices with Power Query
• Quiz
3. Data Modelling
• Relationships & Cardinalities
• Many-to-Many Relationship challenges & solutions
• Why Star Schema
• Composite model
• Aggregations
• Best practises with data modelling
• Quiz
4. DAX
• Measures vs columns
• Advanced DAX functions
• DAX context transitions
• Engine Internals (Formula Engine, Storage Engine)
• Quiz
5. Data Visualisations
• Page canvas, background & settings
• Exploring AI visuals, Custom visuals, in-house visuals
• Best practices around choosing the right visuals for reporting
• Conditional formatting tricks
• Usage of buttons/bookmarks to create interactive reporting
• Drill down, drill up & drill throughs capabilities
• Colour schemes and themes in Power BI
• Creating a brand specific custom theme
• Quiz
6. Power BI report from scratch in Power BI Desktop
• By using all the learning above, a Power BI report will be created from scratch
7. Power BI Service
• Creating your first workspace
• Publish & share your first report
• Working with Dataflows
• Quiz
8. Introduction to Gateways
• Installing personal gateway
• Configuring gateway in Power BI Service
• Quiz
9. Summary
10. Q&A Time
Navigating End-to-End Power BI Development in the Cloud
When it comes to development in Power BI, Power BI Desktop has been a go to tool for all the Power BI developers for the last few years.
But have you ever thought, with the improvements coming to Power BI product in the last few years; you can now actually think of developing your complete Power BI solution in Power BI Service.
So you think you can develop in Power BI? Let's see in this training how to step away from Power BI Desktop app and jump into a 100% cloud solution.
In this workshop we will showcase an end-to-end Power BI solution using the new/updated online Power BI Service capabilities.
The training will start from connecting to data-sources, doing some transformations on the ingested data, creating a tabular model on top of which creating DAX calculations. Finally developing and sharing a full report on the Power BI service.
The training will also focus on concepts like Dataflows Gen2, transforming data using Databricks notebooks, data model optimization by connecting model to external tools and yes we will cover more Microsoft Fabric capabilities.
At the end of the training, users will have a fully fledged end-to-end Power BI solution in Power BI Service without touching the Power BI Desktop.
Do you have a Mac, a Linux or a windows computer? Don't worry any more.
We welcome all the users to our training. No more boundaries can restrict Power BI development based on what operating system or machine you use.
My Recipe Book for Effective Storytelling
What is storytelling?
Is it just about analyzing data?
Is it just about representing the data into pretty looking visuals?
Is it just about being an expert in an visualization tool?
Many new analysts have such questions in mind while they are starting as Data Analysts in the Analytics industry. They really don't have clarity on which tool they need to build their expertise on. They are unclear about which direction should they choose to become a good data analyst.
In this session, Pragati is going to focus on what all tools & technologies can be helpful for someone starting as a data analyst. She will be focusing on key areas a data analyst should explore and build their expertise to become a successful analyst.
Pragati will also share her top tips around how storytelling can be an easy exercise if few things are kept in mind while doing analysis on the data. She will be sharing some learnings from her experience around what can lead to an effective insight generation.
In the end of this session, audience will be clear on what all root work is required for data analysis before moving to data visualization and hopefully answering all the questions that newbie data analysts have starting their journey in the industry.
Microsoft Fabric in Action - Ingesting data to Report creation
Microsoft Fabric is the current hot topic, and everyone is trying to get up to speed with this new technology. In this session, Pragati will showcase a demo on getting the data in this environment to creating a Power BI report. This is a One Slide All Demo session.
Fancy seeing some action and insights with Microsoft Fabric, join this session and take your first steps towards learning this new buzz.
Lessons Learned from my Power BI Journey
Pragati has been working in the Power BI space for the last few years. During her experience working with Power BI, she has learned alot from the mistakes she did while deploying multiple Power BI solutions. In this session, she is going to showcase some of the use-cases to demonstrate her learnings from the mistakes made during her journey.
The session will also include some of the best practices in the data ingestion, data transformation, data modelling, DAX and visualization in Power BI.
Join this session if you want to see some of the hurdles that can be turned into solutions in the Power BI space.
We learn best from the mistakes, which further becomes your experience!
Governance & Lifecycle Management of Dataflow Gen2
With the rise of citizen development and self-service data prep, Dataflow Gen2 are becoming foundational building blocks in Microsoft Fabric environments.
As more teams use Dataflow Gen2 in Microsoft Fabric to prepare and transform data, it becomes important to manage them in a consistent, secure, and organised way. In this session, we’ll focus on simple and effective strategies for governing and managing the lifecycle of your dataflows—so your environment stays clean, reliable, and easy to maintain.
We’ll walk through key topics like setting naming standards, managing user access, and organizing dataflows by environment (development, test, and production). You’ll learn how to track changes, monitor refreshes, and document your dataflows so other team members can understand and use them confidently.
Whether you’re a data engineer, analyst, or administrator, this session will give you the tools and best practices to keep your Dataflow Gen2 environment running smoothly—helping your team stay productive while maintaining control over your data processes.
DP-600 exam for Fabricators
In this session we introduce Fabricators to the DP-600 exam. Which you need to pass to gain the Microsoft Certified: Fabric Analytics Engineer Associate certification.
It is co-presented by two MVP’s who have looked into solutions for clients from different perspectives. One from a Power BI background and one from a Data Engineering services background.
So that you get a holistic overview about the main objectives for the DP-600 exam.
During the session we provide an overview about each of the main sections of the exam:
• Plan, implement and manage a solution for data analytics
• Prepare and serve data
• Implement and manage semantic models
• Explore and analyze data
During the session we will show demos. Along with some tips along the way.
At the end of this training day, you will have a good overview about what is required for the DP-600 exam.
Don’t Just Analyze—Act! Write-Back with Translytical Task Flows in Microsoft Fabric
Power BI is great for insights—but what if your report could trigger real action?
In this hands-on demo session, you’ll learn how to extend your Power BI solutions by integrating Translytical Task Flows in Microsoft Fabric to enable data write-back. You will learn how to build responsive workflows that take user input or data conditions in Power BI and push updates back to source systems—unlocking real-time decisioning, closed-loop analytics, and interactive applications.
The audience will walk away with the practical knowledge on how to trigger write-back flows from a Power BI report by building a Translytical task flow from scratch in Microsoft Fabric.
Differences between the DP-600 and DP-700 exams
Recently Microsoft the DP-700 exam. Which you must pass to gain the new Fabric Data Engineer Associate certification.
Plus, Microsoft has announced that the skills measured for the DP-600 will be updated on November 15th.
So, in this session we cover what the differences will be between the DP-600 and the DP-700 from November 15th onwards.
Along with some advice.
Feel free to bring along your questions to this session. As we have extensive experience training both colleagues and other members of the data platform community for certifications.
Demystifying Semantic Link in Microsoft Fabric
Microsoft Fabric has been around for sometime and if you have already tried it, you know what it is capable of.
- Have you heard about Semantic Link?
- Do you know how semantic link can be helpful in retrieving your metadata information easily?
- How it can be helpful in understanding and validating the underlying relationships within your semantic model?
- How it can help with detecting issues within your semantic model?
If you are looking for answers to above questions, then this session is for you.
In this session, let's explore together the capabilities of Semantic Link and get ready to witness some effective demos.
Data Modelling in Power BI
You report is slow? The DAX measure you wrote looks over-complicated? You are not sure if you should create a date table and how? You are wondering why the model view offers to create many-to-many relationships and bi-directional filters, when they should not be used?
You got a bunch of excel files and wonder how to combine them in Power BI in order to create the report you need?
You have got a data warehouse, but but you are unsure about if this is a good data model for Power BI?
You need to create non-equi join and wonder how to implement them in Power BI?
Stop by at this table talk and bring your questions - we will do the best to find an answer for you.
Data Analysis Using Power BI for Beginners
This is a beginner’s session that focuses on what Microsoft Power BI is and what this tool can do. The session is specially for developers who have started to work on building reports and dashboards using Power BI. The tool is not just for visualization, but it extends its capabilities to data cleaning and data transformations. We will start the session by opening a fresh Power BI file and making ourselves aware of the basic elements like:
• Report page, canvas, gridlines, page settings to familiarise ourselves with the tool interface.
• Available Data source connections – files, folders, azure, database, etc.
• Different types of filters – visual level, page level & report level.
• In-built data hierarchy in the data.
• Show and talk about Report, Data and Model View in Power BI.
• A walkthrough by loading a sample data csv/excel file in Power BI and start looking at few data transformations/cleaning in Query editor.
• Basic data cleaning and transformations using query editor – modifying datatypes, handling missing values, creating new custom column, adding an index column.
• Once the data is loaded, we will start by generating few basic charts.
• Basic visuals for reporting – line charts, bar charts, columns charts, pie-charts, card visual, tree-maps.
• Edit Interactions functionality to control the interactions among different visuals on the report.
• As Power BI is a very strong tool in identifying key insights in the data, we will cover few interesting data behaviours that we see on the data.
Data Analysis Using Power BI for Beginners
This is a beginner’s session that focuses on what Microsoft Power BI is and what this tool can do. The session is specially for developers who have started to work on building reports and dashboards using Power BI. The tool is not just for visualization, but it extends its capabilities to data cleaning and data transformations. We will start the session by opening a fresh Power BI file and making ourselves aware of the basic elements like:
• Report page, canvas, gridlines, page settings to familiarise ourselves with the tool interface.
• Available Data source connections – files, folders, azure, database, etc.
• Different types of filters – visual level, page level & report level.
• In-built data hierarchy in the data.
• Show and talk about Report, Data and Model View in Power BI.
• A walkthrough by loading a sample data csv/excel file in Power BI and start looking at few data transformations/cleaning in Query editor.
• Basic data cleaning and transformations using query editor – modifying datatypes, handling missing values, creating new custom column, adding an index column.
• Once the data is loaded, we will start by generating few basic charts.
• Basic visuals for reporting – line charts, bar charts, columns charts, pie-charts, card visual, tree-maps.
• Edit Interactions functionality to control the interactions among different visuals on the report.
• As Power BI is a very strong tool in identifying key insights in the data, we will cover few interesting data behaviours that we see on the data.
Data Analysis Using Power BI for Beginners
This is a beginner’s session that focuses on what Microsoft Power BI is and what this tool can do. The session is specially for developers who have started to work on building reports and dashboards using Power BI. The tool is not just for visualization, but it extends its capabilities to data cleaning and data transformations. We will start the session by opening a fresh Power BI file and making ourselves aware of the basic elements like:
• Report page, canvas, gridlines, page settings to familiarise ourselves with the tool interface.
• Available Data source connections – files, folders, azure, database, etc.
• Different types of filters – visual level, page level & report level.
• In-built data hierarchy in the data.
• Show and talk about Report, Data and Model View in Power BI.
• A walkthrough by loading a sample data csv/excel file in Power BI and start looking at few data transformations/cleaning in Query editor.
• Basic data cleaning and transformations using query editor – modifying datatypes, handling missing values, creating new custom column, adding an index column.
• Once the data is loaded, we will start by generating few basic charts.
• Basic visuals for reporting – line charts, bar charts, columns charts, pie-charts, card visual, tree-maps.
• Edit Interactions functionality to control the interactions among different visuals on the report.
• As Power BI is a very strong tool in identifying key insights in the data, we will cover few interesting data behaviours that we see on the data.
Button/Bookmark Tricks in Power BI to Enrich Reports
In this session we will see few tricks on how we can use Bookmarks/Buttons in Power BI to make reports more interactive and fascinating from user perspective.
The session will cover the following details:
• Create interactive drill-through functionality using Bookmarks/Buttons
• Create Toggle between charts functionality using Bookmarks/Buttons
• Use Bookmarks/Buttons to drill-down and drill-up information on a chart
• Create Bookmarks/Buttons using images
• Reset Filters using Bookmarks/Buttons
• Creating simple Page navigation using Buttons/Bookmarks
• Using GIFs with Buttons
Breaking (in)visible walls - how helping others may help your personal growth!
What do you do if you were a woman from a non-developed country, without equal rights for education?
What do you do if you were a woman whose parents decided what your career path is going to be?
What do you do if you're earning 300$/month and can't afford paid training to change your career?
You apply for the free Power BI Bootcamp!
Does something like this even exist?! Yes, of course! I've just run one with the helping hand of other fellow community members.
In this session, I want to share lessons learned from running this Bootcamp - not just how it changed the lives of these wonderful human beings (hopefully for the better), who didn't have a proper chance to achieve their professional goals, but also how this helped me in personal growth and to redefine the point of view based on living in a well-developed country.
After this session, you'll get nothing in terms of tech knowledge, but you will walk away with a good feeling in your soul, and understand why helping others also helps YOU in breaking many (in)visible walls!
BI Harmonics: Fusion of Power BI and Fabric
Microsoft Fabric is the current hot topic, and everyone is trying to get up to speed with this new technology. Coming from the Power BI world, the most common question I get asked is does this new platform impact the way Power BI Developers used to work?
In this session, Pragati is going to showcase how processes are still same within Fabric from a Power BI Developer perspective. She will also showcase, how Power BI developers can adopt the power of Fabric in their Power BI society along with expanding their knowledge around what Fabric has to offer.
Administration and governance tips for Microsoft Fabric
When you start working with Microsoft Fabric it opens up a world of possibilities.
Due to the fact that it is a fresh offering, just like the famous Azure Truck in Poland.
To make sure you work it safely, we highlight various administration and governance tips for Microsoft Fabric in this session.
We cover various topics including:
• Work with administration in Microsoft Fabric
• Licensing
• Purview integration
• Fulfill monitoring needs
Demos will be shown during the session.
At the end of this session you will have a better understanding on how to perform administration and governance for Microsoft Fabric.
Advanced Conditional Formatting Tricks in Power BI
In this session we will go through few advanced conditional formatting tricks in Power BI, that will take one's Power BI report to a different level.
This will be a one-slide all-demo session. Users will see practical demonstration of these tricks in Power BI Desktop. Different use-cases will be presented around these tricks.
Session pre-requisites:
- Basic experience working with Power Bi Desktop
- DAX knowledge is helpful
- basics around conditional formatting in Power BI
Data Science Made Easier with Azure ML Studio & Power BI
Description: In this session we will start with creating a simple predictive model in a no-code environment - Azure ML Studio. This will be further followed by connecting Power BI to this published prediction model and using it to generate output reports as results.
The session will cover the following details:
• Start with creating a cluster in Azure ML Studio followed by importing a dataset and exploring the dataset
• Creating an Automated Machine Learning Run
• Deploying the best model
• Connecting Azure Machine Learning model to Power BI
• Creating a report with visualizations in Power BI
• Clean up Azure resources in the end
Unhide the Power of Power Query in Power BI
Power Query in Power BI gives us a capability for data ingestion and transformation.
But have we ever thought of what all in-built data transformation capabilities in Power Query can help us with shaping and formatting our data in a better way for generating meaningful insights out of it?
In this session, I will take the audience through steps from:
• bringing in data using Power Query in Power BI
• going through basic but important data transformations
• leveraging benefits of creating custom, conditional & index columns
• learning basics around Advanced editor code
- along with scenarios where the code from Advanced Editor can be re-used in a flawless way to modify data-source type
- also, how to use existing transformation steps in a new data-source from the old data-source code with small tweaks
Storytelling with Data in Power BI
In this era, where we have a strong need to understand the data around; it is essential to have a skill where one can turn data into a story and explain it using the right tools, which can be well received by the audience.
In this session I will take you on a journey where we will try to find insights in the data by visualising it using Microsoft Power BI and then further turn this data into a story that is easy to understand by the audience.
Agenda:
• Importing Global CO2 Emissions public data in Power BI
• Overview of the data in Power Query to see the distributions
• Creating visuals using the data to get strong evidence of what is happening with CO2 emissions globally
• Summarising & visualising data at different granularities to create rich insights
• Create Drill through to the data points and understand the data better
• Best practices around choosing the right visuals
• Tips and tricks around communicating a story to your audience
• Best practices around choosing the theme colours
• Bes practices around creating consistency/uniformity in your report
• In the end, demonstrating a ready interactive Power BI report that has a story to be explained
Power BI & Azure Databricks – A Magical Union
Azure Databricks is a powerful technology that is used by both Data Engineers and Data Scientists to perform their jobs. On one hand Data Engineers use it to transform and structure data, on the other hand Data Scientists use this transformed data to do advanced analytics.
But what about the business users, who in real life need to see this data in an easier way to generate actionable insights in their day-to-day life? Apart from Data Engineers and Data Scientists, we do have a league of people who want to generate insights from this data.
Azure Databricks platform can’t be used by business users, marketing people, etc. In order to make their life easier, we can now use the data from Azure Databricks within a powerful visualization tool like Microsoft Power BI; and further help the end-users to leverage the benefit of this data and generate insights based on their requirements.
In this session today, we will see how we can quickly bring in the transformed data from Azure Databricks to Microsoft Power BI, and further generate beautiful visualizations to generate insights.
We will further explore how easy it is to drag and drop data points to different type of charts/visuals and make them pretty with few clicks.
The session will help the audience in understanding how a magic is created when Azure Databricks meets with Microsoft Power BI.
My Mantra to be a Successful Public Speaker
Do you feel nervous about getting on a stage and delivering a speech?
Do you shiver and tremble while facing a larger audience?
This was definitely me some time back when it was hard for me to talk to people and keep my point/view in front of them. I was too scared of giving client presentations where I was a centre of attraction among the audience.
But something changed in the last year and public speaking is something that I enjoy now. It has become one of my hobbies. I can now stand in front of the audience with confidence and talk to them about a topic without any hesitation.
Do you want to know what worked best for me? How did I come out of this stage-fear and stepped on the stage every time with confidence?
Trust me there is no short-cut here. All it takes is:
• Believing in yourself
• Preparing your topic well
• Practicing it as much you can before you deliver it
If I can do it, anyone can do it.
Learn to Visualise using DAX Tricks in Power BI
DAX is a language that provides integration of functions and operators to build formulas in Microsoft Power BI tool. It can be specially life-saving when it comes to adding dynamic calculations to your report. It is not easy to master DAX but there could be certain scenarios where DAX calculations can make developer’s life easier.
In today’s session, I will be showing few scenarios where using DAX calculations, has really made my job easy to add a dynamic-level to the insights in a Power BI report.
I will be taking the audience through few different use-cases, where simple DAX tricks can help with adding the next level functionality to visuals in Power BI.
Key Take-aways:
• Learning basic DAX expressions which will be use-case driven
• Adding visualisation capabilities using basic DAX expressions
• Adding formatting tricks to visuals using DAX expressions
• Problem statements to be solved using DAX expressions
• A power BI file in the end to play with
One doesn’t need to be an expert in DAX to attend this session. Anyone willing to learn about few DAX tricks in Power BI, should definitely attend this session.
Women in Tech: Keys to a Successful Career Panel Discussion
Your career is a journey that is unique to you, but that doesn't mean you don't have shared experiences. Join a panel of women data professionals for an open discussion on their winding career paths, how they got here, and where they're heading next. We'll talk about what it's like to be a woman in tech, what worked for them, and how building a strong network of people to be in your corner can help you achieve your goals.
Unhide the Power of Power Query in Power BI
Power Query in Power BI gives us a capability for data ingestion and transformation.
But have we ever thought of what all in-built data transformation capabilities in Power Query can help us with shaping and formatting our data in a better way for generating meaningful insights out of it?
In this session, I will take the audience through steps from:
• bringing in data using Power Query in Power BI
• going through basic but important data transformations
• leveraging benefits of creating custom, conditional & index columns
• learning basics around Advanced editor code
- along with scenarios where the code from Advanced Editor can be re-used in a flawless way to modify data-source type
- also, how to use existing transformation steps in a new data-source from the old data-source code with small tweaks
Data Science Made Easier with Azure ML Studio & Power BI
Description: In this session we will start with creating a simple predictive model in a no-code environment - Azure ML Studio. This will be further followed by connecting Power BI to this published prediction model and using it to generate output reports as results.
The session will cover the following details:
• Start with creating a cluster in Azure ML Studio followed by importing a dataset and exploring the dataset
• Creating an Automated Machine Learning Run
• Deploying the best model
• Connecting Azure Machine Learning model to Power BI
• Creating a report with visualizations in Power BI
• Clean up Azure resources in the end
Conditional Formatting Tricks in Power BI
In this session we will see different ways of applying conditional formatting to a Power BI reports at data level and visual level.
The session will cover the following details:
Data Level Conditional Formatting
• Explore default conditional formatting options on data in Power BI:
a. Background Color
b. Font Color
c. Data Bars
d. Icons
• Using a calculated measure to create conditional formatting
• Use custom icons for conditional formatting
Visual Level Conditional Formatting
• Conditional titles on the visuals based on the Slicer Selection
• Conditional Background color to the visuals using a measure calculation
Advanced Tricks with Buttons/Bookmarks in Power BI
In this session we will see few tricks on how we can use Bookmarks/Buttons in Power BI to make reports more interactive and fascinating from user perspective.
The session will cover the following details:
• Toggle dynamically the type of chart
• Dynamically modify the axis of the chart
• Interactive drill-through functionality using Button
• Conditional drill-through functionality based on User input
• Creating simple Page navigation using Buttons
• Conditional Page Navigation based on User Input
• Modern Visual Tooltips functionality
Data Analysis Using Power BI for Beginners
This is a beginner’s session that focuses on what Microsoft Power BI is and what this tool can do. The session is specially for developers who have started to work on building reports and dashboards using Power BI. The tool is not just for visualization, but it extends its capabilities to data cleaning and data transformations. We will start the session by opening a fresh Power BI file and making ourselves aware of the basic elements like:
• Report page, canvas, gridlines, page settings to familiarise ourselves with the tool interface.
• Available Data source connections – files, folders, azure, database, etc.
• Different types of filters – visual level, page level & report level.
• In-built data hierarchy in the data.
• Show and talk about Report, Data and Model View in Power BI.
• A walkthrough by loading a sample data csv/excel file in Power BI and start looking at few data transformations/cleaning in Query editor.
• Basic data cleaning and transformations using query editor – modifying datatypes, handling missing values, creating new custom column, adding an index column.
• Once the data is loaded, we will start by generating few basic charts.
• Basic visuals for reporting – line charts, bar charts, columns charts, pie-charts, card visual, tree-maps.
• Edit Interactions functionality to control the interactions among different visuals on the report.
• As Power BI is a very strong tool in identifying key insights in the data, we will cover few interesting data behaviours that we see on the data.
Button/Bookmark Tricks in Power BI to Enrich Reports
In this session we will see few tricks on how we can use Bookmarks/Buttons in Power BI to make reports more interactive and fascinating from user perspective.
The session will cover the following details:
• Start with importing a sample dataset
• Create interactive drill-through functionality using Bookmarks/Buttons
• Create Toggle between charts functionality using Bookmarks/Buttons
• Use Bookmarks/Buttons to drill-down and drill-up information on a chart
• Create Bookmarks/Buttons using images
Data Community Day Austria 2026 Sessionize Event Upcoming
Power Conference 2025 Sessionize Event Upcoming
Data Platform Women in Technology Virtual Group User group Sessionize Event
DATA BASH '25 Sessionize Event
Future Data Driven Summit 2025 Sessionize Event
Cloud Data Driven User Group - 2025 Virtual Sessions User group Sessionize Event
Microsoft Fabric Community Conference Sessionize Event
Power BI Gebruikersdag 2025 Sessionize Event
Power BI & Fabric Summit 2025 Sessionize Event
Fabric February 2025 Sessionize Event
Low Code/ No Code Power Platform Conference Sessionize Event
Data Toboggan - Alpine Coaster 2024 Sessionize Event
DATA BASH '24 Sessionize Event
Data Toboggan - Cool Runnings 2024 Sessionize Event
Data Céilí 2024 Sessionize Event
SQLDay 2024 Sessionize Event
New Stars of Data #7 Sessionize Event
Microsoft Fabric Community Conference
Exploring Microsoft Fabric Through Power BI Lens
Global Power Platform Bootcamp Persian Sessionize Event
PASSMN Monthly Meeting 2024 User group Sessionize Event
Power BI & Fabric Summit 2024 Sessionize Event
Fabric February 2024 Sessionize Event
Data Toboggan - Winter Edition 2024 Sessionize Event
DATA BASH '23 Sessionize Event
Data Toboggan - Alpine Coaster 2023 Sessionize Event
PASS Data Summit 2023
Delivering a full day Pre-con on - "Beyond the Basics: Elevate Your Power BI Skills"
2023 Microsoft Power Platform Conference & Dynamics 365 CE Sessionize Event
Data Saturday Croatia 2023 Sessionize Event
SQLDay 2023 Sessionize Event
SQLBits 2023 - General Sessions Sessionize Event
Power BI Summit 2023 Sessionize Event
Saudi Arabia Microsoft Excel & Power Platform Meetup Group
Learn to Visualise using DAX Tricks in Power BI
Zürich - Power BI User Group Meetup
Top Power Query Tricks:
Power Query Editor is the key part of Power BI universe, which sometimes can be challenging for few due to the amount of flexibility it provides. Most of the times when performing transformations, we go for a way that gives us the right results, rather than going for the most optimised way. In some scenarios, we end up adding more transformation steps to our query.
Pragati has been working with Power BI for some time now and in this session, she will be showing some of the top tricks that one can use while performing data transformations in Power BI using Power Query Editor. She will be sharing some of the use-cases, where tweaking the Power Query functions a bit, can help a lot with the transformation that one tries to perform on the data
Future Data Driven Summit 2022 Sessionize Event
DATA BASH '22 Sessionize Event
DATA:Scotland 2022 Sessionize Event
Baku Power BI Meetup Group
Data Perspective in Power BI
Power BI Bootcamp
Power BI and Azure Databricks - A Magical Union
Power BI & Data Analytics for Enviros
Global CO2 Emissions – Power BI Story Telling
M365UK - PnP PowerShell and Power Query in Power BI Mar 2022
Unhide the Power of Power Query in Power BI
SQLBits 2022 Sessionize Event
Dataminds User Group
Conditional Formatting Tricks with Power BI
Global Power Platform Bootcamp 2022 Harare Sessionize Event
Microsoft Cloud & Office 365 Rhein Main
Advanced Tricks with Buttons/Bookmarks in Power BI
South Florida User Group
Unhide Power of Power Query in Power BI
M365 Below in Chicago! Sessionize Event
Power BI Fest Sessionize Event
Stuttgart Power Platform User Group
Advanced Tricks with Buttons/Bookmarks in Power BI
DataSaturdays #13 - Minnesota - Oct 16 2021 Sessionize Event
Data Saturdays Minnesota
Advanced Tricks with Buttons/Bookmarks in Power BI
Future Data Driven Sessionize Event
Baku Power BI & Modern Excel User Meetup Group
Description: In this session we will see different ways of applying conditional formatting to a Power BI reports at data level and visual level.
The session will cover the following details:
Data Level Conditional Formatting
• Explore default conditional formatting options on data in Power BI:
a. Background Color
b. Font Color
c. Data Bars
d. Icons
• Using a calculated measure to create conditional formatting
• Use custom icons for conditional formatting
Visual Level Conditional Formatting
• Conditional titles on the visuals based on the Slicer Selection
• Conditional Background color to the visuals using a measure calculation
Data Platform Summit 2021
Conditional Formatting Tricks in Power BI
Azure Summit Sessionize Event
Microsoft 365 Live 2021 Sessionize Event
Data Platform WIT - Beginner Data Science Day Sessionize Event
Data Platform WIT
Data Science Made Easier with Azure ML Studio
Oklahoma Power BI User Group
In this session we will see few tricks on how we can use Bookmarks/Buttons in Power BI to make reports more interactive and fascinating from user perspective.
The session will cover the following details:
• Create interactive drill-through functionality using Bookmarks/Buttons
• Create Toggle between charts functionality using Bookmarks/Buttons
• Use Bookmarks/Buttons to drill-down and drill-up information on a chart
• Create Bookmarks/Buttons using images
• Reset Filters using Bookmarks/Buttons
• Creating simple Page navigation using Buttons/Bookmarks
• Using GIFs with Buttons
Dativerse #1 Sessionize Event
Power BI & Data Analytics PH Community
Button/Bookmark Tricks in Power BI
Power BI Bootcamp 2020
Button Bookmarks Tricks in Power BI
Baku Power BI & Modern Excel User Meetup Group
Button/Bookmark Tricks in Power BI to Enrich Reports
Data South Wales Meetup Group
Data Analysis Using Power BI for Beginners
DataWeekender
As part of the #DataWeekender Cloud Challenge (https://www.dataweekender.com/cloud-challenge),
we are hosting a once-off exam cram to help you get ready for that AI-900 AI Fundamentals exam.
Pragati Jain (Microsoft MVP - Data Platform, Data Analyst) has recently just sat the AI-900 exam and she is going to share her learning tips and notes with you.
This will be a great opportunity to get that last bit of study in before you sit that exam. Join the Challenge and Pragati.
London Business Analytics Group
Beginner Power BI session.
Bizz Summit ES Sessionize Event
A Taste of M365 Chicago! Sessionize Event
Cloud Data Driven
This session is on Data Analysis using Power BI for Beginners. Details can be found on the link for the event.
#DataWeekender v3.1 Sessionize Event
Cloud Lunch and Learn Marathon 2021 Sessionize Event
Pragati Jain
Microsoft MVP - Data Platform, Analytics Manager at Avanade
London, United Kingdom
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top