Most Active Speaker

Pragati Jain

Pragati Jain

Microsoft MVP - Data Platform, Senior Consultant at Avanade

London, United Kingdom

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 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 recognised as a Superuser on the Microsoft Power BI 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

Awards

Area of Expertise

  • Information & Communications Technology
  • Business & Management

Topics

  • Microsoft Power BI
  • Data Platform
  • Analytics and Big Data
  • Data Science
  • Data Visualization
  • Microsoft Data Platform
  • Azure Data & AI
  • Data Analytics

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 Saturday Croatia 2023 Upcoming

June 2023 Zagreb, Croatia

SQLDay 2023 Upcoming

May 2023 Wrocław, Poland

Power BI Summit 2023 Upcoming

March 2023

Saudi Arabia Microsoft Excel & Power Platform Meetup Group

Learn to Visualise using DAX Tricks in Power BI

January 2023

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

November 2022

DATA BASH '22

September 2022

DATA:Scotland 2022

September 2022 Glasgow, United Kingdom

Baku Power BI Meetup Group

Data Perspective in Power BI

July 2022

Power BI Bootcamp

Power BI and Azure Databricks - A Magical Union

July 2022

Microsoft Build

May 2022

Power BI Show

March 2022

Power BI & Data Analytics for Enviros

Global CO2 Emissions – Power BI Story Telling

March 2022

M365UK - PnP PowerShell and Power Query in Power BI Mar 2022

Unhide the Power of Power Query in Power BI

March 2022

SQLBits 2022

March 2022 London, United Kingdom

Dataminds User Group

Conditional Formatting Tricks with Power BI

February 2022

Microsoft Cloud & Office 365 Rhein Main

Advanced Tricks with Buttons/Bookmarks in Power BI

February 2022

K21 Academy

January 2022

South Florida User Group

Unhide Power of Power Query in Power BI

January 2022

M365 Below in Chicago!

January 2022

Power BI Fest

November 2021

Stuttgart Power Platform User Group

Advanced Tricks with Buttons/Bookmarks in Power BI

October 2021

Data Saturdays Minnesota

Advanced Tricks with Buttons/Bookmarks in Power BI

October 2021

Future Data Driven

September 2021

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

September 2021

Data Platform Summit 2021

Conditional Formatting Tricks in Power BI

September 2021

Azure Summit

September 2021

Microsoft 365 Live 2021

September 2021

Data Platform WIT

Data Science Made Easier with Azure ML Studio

August 2021

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

August 2021

Dativerse #1

August 2021

Power BI & Data Analytics PH Community

Button/Bookmark Tricks in Power BI

July 2021 London, United Kingdom

Power BI Bootcamp 2020

Button Bookmarks Tricks in Power BI

July 2021 London, United Kingdom

Baku Power BI & Modern Excel User Meetup Group

Button/Bookmark Tricks in Power BI to Enrich Reports

July 2021 London, United Kingdom

Data South Wales Meetup Group

Data Analysis Using Power BI for Beginners

July 2021 London, United Kingdom

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.

July 2021 London, United Kingdom

London Business Analytics Group

Beginner Power BI session.

June 2021 London, United Kingdom

Bizz Summit ES

June 2021

Cloud Data Driven

This session is on Data Analysis using Power BI for Beginners. Details can be found on the link for the event.

May 2021 London, United Kingdom

Pragati Jain

Microsoft MVP - Data Platform, Senior Consultant at Avanade

London, United Kingdom