Data Modeling with Microsoft Power BI
Self-Service and Enterprise Data Warehouse with Power BI
(Author) Markus Enhrenmueller-JensenData modeling is the single most overlooked feature in the Power BI Desktop, yet it's what sets Power BI apart from other tools on the market. This practical book serves as your fast-forward button for data modeling with Power BI, Analysis Services tabular, and SQL databases. It serves as a starting point for data modeling, as well as a handy refresher. Author Markus Ehrenmueller-Jensen, founder of Savory Data, shows you the basic concepts of Power BI's data model with hands-on examples in DAX, Power Query, and T-SQL. If you're looking to build a data warehouse layer, chapters with T-SQL examples will get you started. You'll begin with simple steps and gradually solve more complex problems. This book shows you how to: Normalize and denormalize with DAX, Power Query, and T-SQL Apply best practices for calculations, flags and indicators, time and date, and role-playing dimensions with DAX, Power Query, and T-SQL Solve challenges such as binning, budget, localized models, composite models, and key value with DAX, Power Query, and T-SQL Discover and tackle performance issues by applying solutions in DAX, Power Query, and T-SQL Work with tables, relations, set operations, normal forms, dimensional modeling, and ETL
Markus Enhrenmueller-Jensen
Markus Enhrenmueller-Jensen is a renowned German author known for his poignant and thought-provoking literary works. His writing style is characterized by its lyrical prose and deep exploration of human emotions and relationships. Some of his most notable works include "The Silent Heart" and "A Journey Within".
Enhrenmueller-Jensen's contributions to literature have had a significant impact on the contemporary literary scene, particularly in the genre of psychological fiction. His ability to delve into the complexities of the human psyche and portray them with sensitivity and depth has earned him critical acclaim and a dedicated readership.
One of his most famous works, "The Silent Heart", delves into the intricacies of grief and loss, and has been hailed as a modern classic in the genre. Enhrenmueller-Jensen's ability to capture the nuances of human emotions and relationships in his writing sets him apart as a master storyteller in the world of literature.