Parv Chana
Microsoft Data Platform MVP | BI Architect | PowerBI Consultant/Trainer | DAX/Power Query Expert
Vancouver, Canada
Actions
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.
Links
Awards
Area of Expertise
Topics
Why Power BI Developers Should Care About Microsoft Fabric : The Tools You Didn’t Know You Needed
If you’re a Power BI developer, you’re probably wondering how Microsoft’s Fabric platform can make your job easier and more efficient. In this session, I’ll share how Fabric has completely changed my approach to working with data. I’ll take you through real-life examples where Fabric helped me simplify complicated tasks, speed up my workflow, and unlock new possibilities. Whether it’s connecting data more easily, automating processes, or handling larger projects with ease, Fabric has tools that make a big difference. You don’t need to be a tech expert to benefit—Fabric helps seasoned Power BI developers like me focus on creating powerful insights without getting stuck in the details. Come see how Fabric can transform the way you work with Power BI!
Even if you're not a tech expert, you'll see how Fabric makes things more intuitive, saving time and reducing the manual effort involved in your daily development work. Whether you're managing data pipelines or improving your reporting processes, Fabric provides the flexibility and tools to help you get more done with less hassle. Join me to discover how Fabric can make your Power BI development experience faster, easier, and more impactful.
Why dataflow gen 2 in Fabric is a game changer - Should I really care about it?
With the introduction of Dataflow Gen 2 in Microsoft Fabric, data preparation and integration have taken a significant leap forward. This new generation not only enhances performance and scalability but also offers advanced features that empower users to manage large-scale data more efficiently.
Whether you're dealing with complex transformations, real-time data processing, or integrating multiple data sources, Dataflow Gen 2 brings powerful capabilities like optimized memory management, improved pipeline automation, and native integration with other Fabric tools.
But does it truly matter for your organization? This session will explore the key features of Dataflow Gen 2, how it differs from Dataflow Gen 1, and why it's positioned to be a game changer for modern data platforms.
Professional DP-600 exam guide for Fabricators
In this session we guide Fabricators through the DP-600 exam. So that you are more prepared to take the exam and gain the Microsoft Certified: Fabric Analytics Engineer Associate certification.
Based on the experiences of two MVP’s from different backgrounds who have both gained the certification. One from a Power BI background and one from a Data Engineering services background.
Which means that we can give you a more holistic overview about what is required to pass the DP-600 exam.
Topics we cover during the session include:
• DP-600 exam overview.
• Four simple facts about the exam.
• What Fabric workloads are really covered as part of the exam.
• Exam tips.
• Recommended resources.
During the session we will also show some demos.
At the end of this session, you will have a good overview about what is required for you to pass the DP-600 exam and gain the Fabric Analytics Engineer Associate certification.
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.
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
INDIA Microsoft BizApps Bootcamp 2.022 Sessionize Event
Data Insight Summit Sessionize Event
Power BI Summit 2022 Sessionize Event
Power BI Fest Sessionize Event
Power BI Summit Sessionize Event
LightUp Sessionize Event
Global Power Platform Bootcamp - Vancouver Sessionize Event
Parv Chana
Microsoft Data Platform MVP | BI Architect | PowerBI Consultant/Trainer | DAX/Power Query Expert
Vancouver, Canada
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