Dhyanendra Singh Rathore
bits to BI
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
Files to SQL Tables with Datamarts in Power BI
Every once in a while, we have to analyze data outside the cozy realm of a database. Dealing with a small Excel sheet? Easy peasy. But what about those massive files, JSON jumbles, SharePoint lists, or the mystical OData feeds? Wouldn't life be easier if you could magically turn these files into SQL tables and flaunt your SQL skills? But reality check – who just casually has an SQL server lying around? And how much time would you spend to convert those files to tables?
Imagine you have a fully managed and optimized Azure SQL database at your disposal where you can toss in data from any file or source without writing a single line of code. There is no need to tweak or optimize. You can create or obliterate it whenever you feel like it. And the best part is it's free with the right license. Datamarts in Power BI is your data daydream come true.
In this session, we will talk about Datamarts in Power BI and how to use them to convert data files to SQL tables in minutes. We will also discuss how Datamarts are backed by a fully managed Azure SQL Database and provide SQL endpoints for analysis. This session is perfect for anyone who wants to learn how to convert data files to database tables to speed up your analysis.
Target audience: Power BI Developers, Data Analysts, QA Analysts
Session duration: 30 - 40 minutes
Session Level: Introductory (100)
Integrating and Enforcing Power BI Best Practices with Azure DevOps pipelines
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)
Towards Data Mesh: All about data-mesh with Microsoft Fabric
A solid foundation is pivotal in successfully adopting a data mesh framework. Microsoft Fabric can serve as the foundation to enable robust data mesh patterns. Fabric provides a unified data-sharing layer that effortlessly transcends departmental boundaries, eliminating the risk of data silo-ing.
This session will walk you through a seemingly simple yet extraordinarily effective process of setting up data mesh patterns across your data teams. Discover how Fabric's powerful concepts pave the way for an out-of-the-box data mesh experience with built-in governance and management. I will cover the following topics:
• Introduction to data mesh and key principles for a successful implementation
• How Microsoft Fabric can serve as the foundation for robust data mesh implementation
• Out-of-the-box features in Fabric to enable data mesh
• How Fabric complements the key data mesh principles with built-in governance and management
Target audience: Data professionals, IT managers, and tech leaders
Session duration: 40 - 50 minutes
Session Level: Introductory (100)
Automated Data Validation in Power BI - Using Power Automate to validate data refresh
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 validation of data 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)
Data Saturday Stockholm 2024 Sessionize Event
AI42 Conference 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