Jump to content
Sign in to follow this  

Data Modeling with Microsoft Power BI - Markus Ehrenmueller-Jensen

Recommended Posts


pdf | 19.69 MB | English | Isbn:9781098148515 | Author: Markus Ehrenmueller-Jensen | Year: 2024

About ebook: Data Modeling with Microsoft Power BI

Data modeling is the single most overlooked feature in 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 semantic 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, role-playing dimensions and slowly changing dimensions
[*]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



Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

You must be 18 to join our forum