Mihiranga N. Power BI Data Modeling. Build Interactive...2022

Textbook in PDF format

Creating data models has never been straightforward. This book demonstrates how to formulate a complete business analytics model that combines several data sources, executes numerous computations, and scales across hundreds of BI users.
To begin, you'll learn about the Microsoft Power BI ecosystem by downloading the Power BI desktop and exploring all of its features and capabilities. Through examples, you'll learn how to connect to databases of Excel; and SQL Server, shaping the data with Power Query, and then transforming the data into actionable information. You will gain knowledge of the DAX language by exploring it, writing DAX functions, and creating hierarchies. You will be trained to develop effective business intelligence models by studying numerous data modeling topics