In this chapter, you are now going to create a coherent and intelligent data model by creating the necessary relationships to bring those data sources together. The topics detailed in this chapter are as follows:

Building relationships
Working with complex relationships
Usability enhancements

Self Service BI would not be possible without a functional data model. Historically, BI projects focused on building data models could take months and even years to develop when working within the rigid structure and constraints of a corporate business intelligence environment. Unfortunately, studies show that about fifty percent of all BI projects fail, and that these projects either do not complete or don't deliver on promised deliverables at the completion of the project.

Fortunately, Power BI Desktop provides you with a much more agile approach to building your data model, and instead of months or years, you can now build your data model in hours or days.