Expert Data Modeling with Power BI: Get the best out of Power BI by building optimized data models for reporting and business needs

Price: [price_with_discount]
(as of [price_update_date] – Details)

[ad_1]

Manage and work with business data effectively by learning data modeling techniques and leveraging the latest features of Power BI

Key FeaturesUnderstand data modeling techniques to get the best out of data using Power BIDefine the relationships between data to extract valuable insightsSolve a wide variety of business challenges by building optimal data modelsBook Description

This book is a comprehensive guide to understanding the ins and outs of data modeling and how to create data models using Power BI confidently.

You’ll learn how to connect data from multiple sources, understand data, define and manage relationships between data, and shape data models to gain deep and detailed insights about your organization.

In this book, you’ll explore how to use data modeling and navigation techniques to define relationships and create a data model before defining new metrics and performing custom calculations using modeling features. As you advance through the chapters, the book will demonstrate how to create full-fledged data models, enabling you to create efficient data models and simpler DAX code with new data modeling features. With the help of examples, you’ll discover how you can solve business challenges by building optimal data models and changing your existing data models to meet evolving business requirements. Finally, you’ll learn how to use some new and advanced modeling features to enhance your data models to carry out a wide variety of complex tasks.

By the end of this Power BI book, you’ll have gained the skills you need to structure data coming from multiple sources in different ways to create optimized data models that support reporting and data analytics.

What you will learnImplement virtual tables and time intelligence functionalities in DAX to build a powerful modelIdentify Dimension and Fact tables and implement them in Power Query EditorDeal with advanced data preparation scenarios while building Star SchemaExplore best practices for data preparation and modelingDiscover different hierarchies and their common pitfallsUnderstand complex data models and how to decrease the level of model complexity with different approachesLearn advanced data modeling techniques such as aggregations, incremental refresh, and RLS/OLSWho this book is for

This MS Power BI book is for BI users, data analysts, and analysis developers who want to become well-versed with data modeling techniques to make the most of Power BI. You’ll need a solid grasp on basic use cases and functionalities of Power BI and Star Schema functionality before you can dive in.

Table of ContentsIntroduction to data modelling in Power BI Data Analysis eXpressions and Data ModelingData Preparation in Power Query EditorGetting data from various sources Common data preparation steps Star Schema preparation in Power Query Editor Data preparation common best practices Data Modeling ComponentsStar Shema and Data Modeling Common Best PracticesAdvanced Data Modeling TechniquesRow Level SecurityExtra Options and Features Available for Data Modeling

From the Publisher

Data modeling is one the most crucial parts of Power BI which is usually undermined, misunderstood or completely ignored by many developers. The consequence is having unnecessarily large models, complex DAX code, and underperforming reports. In some cases, poorly designed data models incur surplus cost to organisations. The reports are so slow that the organizations decide to get more process power by buying Power BI Premium or upgrading their existing Premium license to higher and more expensive tiers, while all those costs could be potentially avoided by having better designed data models.

What makes Expert Data Modeling with Power BI different from other books on data modeling with Power BI?

The main focus of other books is to teach readers how to write DAX or resolve complex scenarios with DAX in the data model layer itself. With this book, I’ve focused on explaining the importance of data preparation as well as writing better DAX expressions. I want to help readers mitigate the risks associated with writing complex DAX expressions and take care of the heavy lifting in the data preparation layer within the Power Query Editor.

You’ll also discover many best practices in Power Query, data modeling and DAX that will be useful.

I’d also recommend this book if you’ve been looking for something that covers all the new features of Power BI, which are missing in other books such as object-level security, calculation groups, and composite models.

How has your background and experience helped you to write this book?

I come from a programming background with extensive experience in database design and implementation. Throughout my career, I’ve worked with relational data models – and Power BI is no different. Power BI also follows relational data modeling. To be able to design and implement a well-performing report, you also need to have a well-designed data model with the Star Schema approach. Having a concrete background in designing and implementing relational databases with Star Schema helped me significantly in writing this book.

What are your favorite parts in the book and why?

Data Preparation in Power Query Editor: I love this chapter as it explains the importance of data preparation while having Star Schema and data modeling in mind. It is super important to get the data preparation right which leads to having a well-designed data model that is clear, less complex and makes it easier to deal with the required DAX expression.Advanced Data Modeling Techniques: This chapter provides invaluable techniques for more advanced users working on enterprise-grade projects by explaining aggregations, incremental data loading, parent-child hierarchies, and more. Without knowledge of the techniques explained in this chapter, you won’t be able to support large models in an enterprise.Extra Features for Data Modeling: This chapter is great because it explains new features in Power BI which are either revolutionary, such as composite models, or are helpful in decreasing development effort and taking the user experience to the next level such as calculation groups.

ASIN ‏ : ‎ B08X4FRQXQ
Publisher ‏ : ‎ Packt Publishing; 1st edition (June 11, 2021)
Publication date ‏ : ‎ June 11, 2021
Language ‏ : ‎ English
File size ‏ : ‎ 102577 KB
Text-to-Speech ‏ : ‎ Enabled
Screen Reader ‏ : ‎ Supported
Enhanced typesetting ‏ : ‎ Enabled
X-Ray ‏ : ‎ Not Enabled
Word Wise ‏ : ‎ Not Enabled
Print length ‏ : ‎ 612 pages

[ad_2]