Pragati Jain
Microsoft MVP - Data Platform, Analytics Manager 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 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
Awards
Area of Expertise
Topics
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 Céilí 2024 Sessionize Event Upcoming
SQLDay 2024 Sessionize Event Upcoming
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
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
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