Parv Chana

Parv Chana

Microsoft Data Platform MVP | BI Architect | PowerBI Consultant/Trainer | DAX/Power Query Expert

Vancouver, Canada


With over 20 years in the industry, he is a seasoned BI Architect and Consultant. Running his own consulting company, PeryTUS IT Solutions, he provides Power BI solutions to clients ranging from small to large enterprises. He has a diverse background across industries and has delivered customized solutions to meet his clients' BI needs. Holding the title of Microsoft Data Platform MVP, he has been working with Power BI since its launch in 2015.

His expertise encompasses end-to-end Power BI implementation, analysis of existing solutions, promoting best practices for scalable BI models, and training to help clients reach their BI objectives.


Area of Expertise

  • Information & Communications Technology


  • Microsoft Power BI
  • power bi
  • Power BI Dataflows
  • power bi desktop
  • power bi premium
  • power bi service

Time Intelligence in Power BI: Easy Wins and What to Watch Out For

In this session, we will dive deep into the fascinating world of Time Intelligence within Power BI. Time is a critical dimension in most data analysis scenarios, and Power BI offers powerful tools to manipulate, analyze, and visualize time-based data. However, wielding this power comes with its own set of challenges and potential pitfalls.

During this session, we will explore the capabilities of Power BI's Time Intelligence functions and features, demonstrating how they can help you gain valuable insights from your time-based data. We will cover topics such as creating custom calendars, calculating year-to-date metrics, handling multiple time zones, and more.

But it's not all about the advantages. We will also shine a light on the potential dangers of misusing Time Intelligence in Power BI. From incorrect calculations leading to misleading insights to performance bottlenecks caused by inefficient time-based queries, we will equip you with the knowledge and best practices to avoid these pitfalls.

Whether you're a beginner looking to understand the basics of Time Intelligence or an experienced Power BI user seeking to optimize your time-based data analysis, this session has something for everyone. Join us to harness the full potential of Time Intelligence in Power BI while avoiding the common traps that can derail your analysis.

Mastering Paginated Reports: Cascading Parameters and Performance Optimization

In this in-depth session, participants will embark on a journey to become proficient in creating, designing, and optimizing paginated reports. We will delve into three critical areas that are essential for report developers and designers:

Cascading Parameters: Discover the art of creating cascading parameters to bring flexibility and interactivity to your reports. Learn how to set up parameters that dynamically filter data and enable users to customize their report outputs. We'll explore best practices and real-world examples to ensure you leave with practical skills.

Performance Optimization: Uncover strategies and tactics to boost the performance of your paginated reports. We'll cover topics such as data source optimization, query efficiency, and report rendering speed. By the end of this session, you'll be equipped with the knowledge and tools to create reports that load quickly and respond seamlessly to user interactions.

This session is designed for individuals at all skill levels, from beginners to experienced report developers. Whether you're new to paginated reports or looking to refine your skills, this comprehensive workshop ensures you leave with the expertise needed to produce reports that are both informative and efficient, providing an exceptional experience for your end-users.

Join us and take your paginated reporting to the next level.

From Raw Data to Rich Insights: The Power of Data Modeling, DAX, and Disconnected Tables in Power BI

Why do I need a data model?
Do I need a data model for DAX?
Why do I need disconnected tables?

Well, if you have these questions then look no further. Power BI, a helpful tool for businesses, has three powerful things it can do: Data Modeling, DAX (a special kind of math), and Disconnected Tables. We call them the "3Ds."

This summary talks about why these three things are so important in Power BI. First, Data Modeling helps organize data, make it work faster, and connect different pieces. DAX is like a super calculator that helps you do hard math and make custom numbers. Disconnected Tables are like magic switches that let you look at data in different ways.

We'll show you how to use these 3Ds with examples and good tips. It's not too hard, and it can help businesses make better decisions and do well. So, whether you're new to Power BI or an expert, this summary will help you understand these cool tools and how they can help you get the most out of Power BI for better data insights.

Cooking Up Success with Power BI: A Recipe Book for Reporting Wizards (Top Tips and Tricks)

Join me as I embark on a journey through the flavorful world of Power BI, armed with years of expertise to bring you my juiciest tips and tricks. In this session, I'll sprinkle a dash of my hard-earned experience into your Power BI cauldron, transforming your data magic into something truly extraordinary.

We'll start with the basics and work our way up to the really cool stuff. We're going to cover everything from getting your data ready (think of it as washing and chopping your ingredients) to building amazing data models (like creating the perfect recipe), mastering DAX (our secret sauce), and making stunning visualizations (the icing on the cake).

Get ready to become a Power BI pro with my eight years of experience as your guide! In this session, I'm going to share all my top tips and tricks, and we're going to explore every nook and cranny of Power BI together.

Whether you're new to Power BI or a seasoned user looking to level up your skills, I've got you covered. Think of me as your friendly data guru, here to make your Power BI journey exciting and delicious!

So, grab your apron (or your laptop) and join me as we cook up some serious Power BI magic!

Microsoft Fabric's Gen 2 Dataflow - Where Even Data Gets a Standing Ovation

Welcome to this informative session where we will explore the powerful capabilities of Dataflow Gen2 within the Microsoft Fabric ecosystem and explore how it distinguishes itself from its predecessor, Dataflow, and how it can be used as a complete ETL tool. We will look at demos to load data to two main Microsoft Fabric workloads, Lakehouse, and Data Warehouse.

Also in this session, we delve into the world of Microsoft Fabric through the lens of Power BI and SQL developers. Microsoft Fabric offers a powerful set of tools and capabilities that can revolutionize the way developers work with data. We explore the seamless integration and unification of data workflows that Microsoft Fabric brings, enabling developers to maximize efficiency and drive insightful analytics.

Building an Easy-to-Manage, Scalable Conditional Formatting Solution in Power BI

Conditional formatting is a powerful tool in Power BI that allows users to highlight data points based on specific conditions. In this session, attendees will learn how to build an easy-to-manage, scalable conditional formatting solution in Power BI. We will start with an introduction to the concept of conditional formatting and how to store the metadata for later reuse. Next, attendees will learn how to create complex conditional formatting rules using calculated fields and DAX expressions, and how to store the metadata for those rules in a scalable manner.

The session will also cover best practices for maintaining and updating the metadata over time to ensure the solution remains flexible and scalable. By the end of the session, attendees will have a solid understanding of how to build an easy-to-manage, scalable conditional formatting solution in Power BI and will be equipped with the knowledge to start applying them to their own reports.

Maximizing Insights: Harnessing the Synergy Between Field Parameters and Calculation Groups

In this session, we will provide a comprehensive overview of Field Parameters and Calculation Groups in Power BI, including their respective strengths and weaknesses. We will explore when to use each feature, and the advantages and limitations of each approach.

Field Parameters are a feature in Power BI that allow users to create dynamic filters that can be applied to any visual in a report. This feature is particularly useful when creating reports that need to be filtered based on user input. Calculation Groups, on the other hand, are a feature that allow users to define reusable sets of calculations that can be easily applied to multiple visuals in a report. This feature is particularly useful when working with complex calculations that need to be reused across multiple reports.

We will discuss the scalability of each feature, as well as the implementation requirements for each. We will also cover best practices for using these features in real-world scenarios, and provide examples of how they can be used in tandem to achieve even more powerful reporting capabilities.

Attendees of this session will come away with a deeper understanding of the capabilities of Field Parameters and Calculation Groups in Power BI, and how to effectively use them to create impactful reports.

Understanding the Power BI Ecosystem: A Guide to its Products and Services

The Power BI ecosystem is a collection of products and services that work together to provide a comprehensive data analytics platform. In this session, attendees will be introduced to the various products that make up the Power BI ecosystem and gain an understanding of their functions and capabilities. We will explore Power BI Desktop, Power BI Service, Power BI Premium, and other Power BI product offerings including licensing.

By the end of the session, attendees will have a clear understanding of the Power BI ecosystem and the different products that they can leverage to meet their data analytics needs.

Unlock the Art of Enriching Reports using Conditional Formatting

In this session, you will learn about the various ways to utilize conditional formatting in
order to bring your reports to life. Conditional formatting is more than just a tool to
highlight data points in your visuals, it is a powerful feature that can help you create
visually stunning and informative reports.

During this session:

1. Learn about the various ways to utilize conditional formatting to bring your
reports to life.
2. Discover how to use conditional formatting for more than just highlighting data
points in your visuals.
3. Explore different techniques and strategies for effectively using conditional
formatting in your reports.
4. Be introduced to color coding cells based on their values, creating heat maps,
and using custom formulas.
5. Acquire the knowledge and skills to create impactful reports that are both
aesthetically pleasing and informative.
6. Gain a solid understanding of how to effectively use conditional formatting in your
own work.

By the end of the session, you will have a solid understanding of how to effectively use
conditional formatting in your own work and will be able to start creating reports that are
both aesthetically pleasing and informative.

Power BI - Data Prep, Data Modelling and Visualization Tool

Are you new to Power BI?
Not sure where to start?
What is Power BI Pro, Free, and Premium?
What is Power BI Service?
Want to know what Power BI is capable of doing?
Is this a visualization tool or more than that?
What are Power BI Dataflow, Datamart, and other products?

If you started your journey in the BI world and want to understand the Power BI landscape then you don't want to miss this session.

In this session, you will learn the internals of Power BI, architect, report development, sharing, and other Power BI-related technologies which will help you to start your Power BI journey on the right foot and help you to understand the various Power BI products available under its ecosystem and what these products are used for.

My Top 20 Tips and Tricks - Power BI

I'm working with Power BI since it was made available and in the last six years, I have learned a lot and made a list of items that I always do when I start a new Power BI project regardless of the size of the data.

In this session, I will share what I learned in the last six years which helped me to provide Power BI solutions to many happy customers.

Field Parameters and Calculation Groups - Better Together

Field Parameters and Calculation Groups are two very powerful features in Power BI.

These features drastically improve visualization and give control to report consumers, and change visualization completely by:

ā“ what do they want to see?
ā“ how do they want to see it?

In this session, we will explore: 👇

💡 When to use Field Parameters over Calculation Groups and vice versa?
💡 Which method is more scalable and why?
💡 What is required to implement each feature in Power BI?
💡 Which feature is easy to implement?

We will explore real-time examples and walk over which solution to use or maybe these both features can be used together to achieve the ultimate reporting needs.

Ask Anything Power BI

Generic discussion about Power BI

Calculation Group - Best Practices and avoid Pitfalls

Calculation Group in Power BI is very powerful, allows to avoid clutters by writing tons of measures, ability to mix data formatting but at the same time, if no close attention is paid, you can get unexpected results.

In this session, we will go over multiple uses of Calculation Groups and also how to avoid common mistakes when working with Calculation Groups.

Power BI Paginated Report using Power BI datasets

In this session, you will learn how to effectively use the Power BI dataset in Power Paginated Reports to use a single source of the dataset for your analytical and operational/pixel-perfect reports.

Also, we will talk about how to create cascaded parameters, date parameters, use Paginated Reports to export large data from Power BI reports, and many other tips and tricks.

Tip and Tricks to use Power BI datasets in Paginated Reports

Learn best practices on how you can use Power BI datasets to develop pixel-perfect reports using Power BI report builder aka paginated reports.

You will learn how to create cascade parameters, date parameters, and many other techniques,

Bring life to Power BI reports using conditional formatting

Conditional formatting can help to create stunning reports except just highlighting the data point in visuals. There is a lot more you can do with conditional formatting.

In this session learn about various techniques on how you can effectively use conditional formatting, and bring life to your visuals.

Best practice and power tips for Microsoft Power BI

Power BI is a great self service BI tool and can visualize a lot more than chart data; from asking questions to analyzing the data you use. You can create rich reports or embed dashboards and reports into reporting portals you already use.

This session explains best practices and tips to create scale-able Power BI model and reports. This sessions focuses on an optimization technique that Iā€™d like to touch on what I consider to be the basics of optimization when working with data modeling and DAX.

Maximizing the Potential of Power BI Datasets in Paginated Reports: Best Practices and Strategies

This session will focus on best practices for using Power BI datasets in paginated reports. Paginated reports are highly formatted, pixel-perfect reports designed for printing or generating PDFs. Power BI datasets, on the other hand, are designed to provide a centralized, reusable source of data for various Power BI reporting tools.

We will delve into the best practices for utilizing Power BI datasets to develop pixel-perfect reports through Power BI report builder, commonly known as paginated reports. This workshop will equip you with techniques such as creating cascading parameters, date parameters, and other relevant strategies to optimize your reports' overall performance.

By the end of this session, attendees will have a solid understanding of the best practices and techniques for leveraging Power BI datasets in paginated reports, allowing them to create powerful and effective reports for their organizations.

Power BI Summit 2023 Sessionize Event

March 2023

INDIA Microsoft BizApps Bootcamp 2.022 Sessionize Event

November 2022 Mumbai, India

Data Insight Summit Sessionize Event

September 2022 Chicago, Illinois, United States

Power BI Summit 2022 Sessionize Event

March 2022

Power BI Fest Sessionize Event

November 2021

Power BI Summit Sessionize Event

April 2021

LightUp Sessionize Event

July 2020

Global Power Platform Bootcamp - Vancouver Sessionize Event

February 2020

Parv Chana

Microsoft Data Platform MVP | BI Architect | PowerBI Consultant/Trainer | DAX/Power Query Expert

Vancouver, Canada


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