Dhyanendra Singh Rathore
bits 2 BI | Power BI Technical Lead at Autoliv
Stockholm, Sweden
Actions
Dhyan is a Microsoft BI Architect based in the vibrant city of Stockholm, Sweden. With nearly a decade of experience in various Microsoft technologies, including Power BI, Fabric, Databricks, Azure Data Platform, Power Platform, and Azure, he brings a wealth of knowledge and expertise to his work.
Dhyan enjoys guiding and inspiring his analytics teams and is committed to sharing his knowledge with the community through his blog posts. Recently, he has begun speaking at community events, connecting with other BI enthusiasts, and sharing insights on Fabric and Power BI. He is passionate about making complex data concepts accessible and exciting for everyone.
Area of Expertise
Topics
Automated Data Validation in Power BI with Power Automate
Ensuring the accuracy of data refreshes in Power BI is a critical challenge that every BI team faces. The trouble increases manifold if your data sources are unreliable and data changes often unpredictably, such as manual files or a non-cooperative data source team. These scenarios demand data validation before your reports are refreshed. The manual validation process can be time-consuming and prone to errors, leading to unreliable insights and a loss of trust from users.
In this session, discover how leveraging Power Automate can revolutionize your data validation process. We will discuss and demonstrate an automated solution to validate and assess the impact of data refresh on your report. At the end of this session, you'll have the foundational understanding and technical insights necessary to build a solution for your data validation goals. We will cover the following topics:
• Why a manual and SQL-based validation process doesn’t always work in Power BI
• Why do we need an automated validation solution
• How do we build an automated solution: Power Automate and Power BI components
• Technical architecture
• Demo
Target audience: Power BI Developers, Data Analysts, QA Analysts
Session duration: 40 - 50 minutes
Session Level: Intermediate (200)
Supercharging Power BI Development with game changing tools and tricks
As a Power BI developer, you're familiar with the fact that your work goes beyond modeling and validating data, writing DAX, and creating visuals. Many tasks are done manually, consuming your valuable time and effort. For instance, ensuring you're not overwriting your teammates' changes, updating and renaming DAX measures across models and reports, and ensuring best practices. The Power BI landscape is rapidly evolving, with new features and 3rd party tools emerging almost every other day. This workshop is specifically designed to address these challenges, equipping you with the tools and knowledge to optimize your productivity and collaboration.
During this session, we will delve into some lesser-known tricks to maximize the potential of popular tools like Tabular Editor, less popular 3rd party tools like ALM Toolkit and PBI Explorer, and new out-of-the-box Power BI features like PBIP and TMDL. We'll show you when and how to use them to significantly reduce your manual workload. By the end of this session, you'll have practical tools and knowledge to enhance your productivity and foster better collaboration within your teams.
Target audience: Power BI Developers
Session duration: 40 - 60 minutes
Session Level: Introductory (100)
Enforcing Power BI Best Practices with Azure DevOps
One of the major issues Power BI Developers faced was synchronizing their efforts while working on the same report and model. This was critical so they didn't overwrite each other's changes. Thanks to Fabric and recent DevOps developments, those issues are almost a thing of the past now. Fortunately, introducing DevOps capabilities to Power BI has opened up new possibilities like integration, automation, and quality control. For instance, we can now automate the deployment of Power BI reports and models, ensuring that the latest version is always available.
In this session, we will discuss why and demonstrate how to integrate Power BI best practices in an Azure DevOps build pipeline. This integration, which guarantees best practices for all semantic models and reports within a Fabric workspace, can prevent common mistakes and enhance team efficiency. By enforcing these best practices, you can play a crucial role in improving the overall quality of your Power BI reports.
Target audience: Power BI Developers, DevOps Professionals
Session duration: 40 - 50 minutes
Session Level: Intermediate (200)
Insights and actions into Power BI best practices with Semantic Link Labs
Power BI best practices offer a quick and reliable method for finding and addressing potential errors and common pitfalls. These practices have helped developers maintain quality, consistency, and performance in their data models and reports. With the advent of community tools, evaluating the best practices for a semantic model and report became relatively straightforward. Most of these tools require manually scanning the model and reports individually.
However, there's a new hero on the scene now, Semantic Link Labs for Fabric notebooks. In this session, we will discuss and demonstrate the capabilities of Semantic Link Labs to evaluate and visualize best practices for semantic models and reports. After this session, you will be able to:
• define semantic link labs' best practice analyzer capabilities
• evaluate best practices for individual workspaces and across the workspaces
• visualize and derive insights out of your best practices analysis
• address the findings with your teams
Target audience: Power BI Developers, Data Analysts, QA Analysts
Session duration: 40 - 50 minutes
Session Level: Introductory (100)
Data Saturday #49 - Denmark - 2025 Sessionize Event Upcoming
Data Community Day Austria 2025 Sessionize Event Upcoming
DATA BASH '24 Sessionize Event
Microsoft Fabric Global Online Conference Sessionize Event
Microsoft Fabric Cafe User group Sessionize Event
Data Saturday Stockholm 2024 Sessionize Event
AI42 Conference Sessionize Event
PASSMN Monthly Meeting 2024 User group Sessionize Event
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