
Desertcart purchases this item on your behalf and handles shipping, customs, and support to UAE.
Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It’s meant for readers who are new to data modeling as well as for experienced data modelers looking for tips from the experts. If you want to use Power BI or Excel to analyze data, the many real-world examples in this book will help you look at your reports in a different way―like experienced data modelers do. As you’ll soon see, with the right data model, the correct answer is always a simple one! By reading this book, you will: • Gain an understanding of the basics of data modeling, including tables, relationships, and keys • Familiarize yourself with star schemas, snowflakes, and common modeling techniques • Learn the importance of granularity • Discover how to use multiple fact tables, like sales and purchases, in a complex data model • Manage calendar-related calculations by using date tables • Track historical attributes, like previous addresses of customers or manager assignments • Use snapshots to compute quantity on hand • Work with multiple currencies in the most efficient way • Analyze events that have durations, including overlapping durations • Learn what data model you need to answer your specific business questions About This Book • For Excel and Power BI users who want to exploit the full power of their favorite tools • For BI professionals seeking new ideas for modeling data Review: A quick guide into data modeling with Power BI - While you can import one table from an Excel file into Power BI and start adding fields into a visual, in most cases your data will be much more complicated. There will be multiple tables, you'll need to transform your data (create new tables, merge existing tables). In most cases you'll need to build a good data model before you can start writing DAX and creating visuals. You'll need to prepare right tables and establish right relationships between the tables. This book is a great introduction into data modeling with Power BI. An incorrect model will be slow, will require overcomplicated DAX measures and will give you wrong numbers at the end of the process - on your report/dashboard. This book will help you to understand what and why can go wrong and how to make things right. You need to understand your future data model while you transforming data in Power Query. You need to make sure your data model (star schema in most cases) is correct before you can start writing DAX. This is not what you can learn by yourself by just using Power BI. You can try all buttons in Power BI, you can try all visual settings and you'll learn a lot about ETL and data visualization in Power BI. But there is no magic 'build a good data model' button. Try and try until you succeed approach won't work well here. Read the book! And be ready that data modeling and DAX are much more complicated subjects than you expected. This is not a book for fast reading from the first to the last page. Keep it on your table for a while while your data models are becoming more and more complicated. Probably there is a better way to explain data modeling so everyone can understand just by reading one book, but if you know such way - you could become a famous author by yourself. And if you're serious about Power BI, then Alberto Ferrari and Marco Russo are your gods. They know everything about data modeling and DAX. You'll read other their books, you'll watch their videos and read their articles. Review: but nevertheless provides a great insight into data modelling from the masters of their ... - Not the easiest of books to read, but nevertheless provides a great insight into data modelling from the masters of their trade. Definitely recommended to anyone wanting an insight into analysing data. Other books by Alberto Ferrari, Marco Russo and also the excellent book by Rob Collie and Avi Singh would be at the top of my recommendations for anyone learning about PowerPivot, Power BI and DAX.

| Best Sellers Rank | 290,369 in Books ( See Top 100 in Books ) 40 in Beginner's Guide to Databases 80 in Business & Home Office Spreadsheets 80 in Database Management Systems (Books) |
| Customer Reviews | 4.4 out of 5 stars 428 Reviews |
A**Z
A quick guide into data modeling with Power BI
While you can import one table from an Excel file into Power BI and start adding fields into a visual, in most cases your data will be much more complicated. There will be multiple tables, you'll need to transform your data (create new tables, merge existing tables). In most cases you'll need to build a good data model before you can start writing DAX and creating visuals. You'll need to prepare right tables and establish right relationships between the tables. This book is a great introduction into data modeling with Power BI. An incorrect model will be slow, will require overcomplicated DAX measures and will give you wrong numbers at the end of the process - on your report/dashboard. This book will help you to understand what and why can go wrong and how to make things right. You need to understand your future data model while you transforming data in Power Query. You need to make sure your data model (star schema in most cases) is correct before you can start writing DAX. This is not what you can learn by yourself by just using Power BI. You can try all buttons in Power BI, you can try all visual settings and you'll learn a lot about ETL and data visualization in Power BI. But there is no magic 'build a good data model' button. Try and try until you succeed approach won't work well here. Read the book! And be ready that data modeling and DAX are much more complicated subjects than you expected. This is not a book for fast reading from the first to the last page. Keep it on your table for a while while your data models are becoming more and more complicated. Probably there is a better way to explain data modeling so everyone can understand just by reading one book, but if you know such way - you could become a famous author by yourself. And if you're serious about Power BI, then Alberto Ferrari and Marco Russo are your gods. They know everything about data modeling and DAX. You'll read other their books, you'll watch their videos and read their articles.
G**K
but nevertheless provides a great insight into data modelling from the masters of their ...
Not the easiest of books to read, but nevertheless provides a great insight into data modelling from the masters of their trade. Definitely recommended to anyone wanting an insight into analysing data. Other books by Alberto Ferrari, Marco Russo and also the excellent book by Rob Collie and Avi Singh would be at the top of my recommendations for anyone learning about PowerPivot, Power BI and DAX.
F**O
Great book
It is exactly what I was looking for, guide and instructions for data modelling in Power Bi or Power Pivot.
G**C
Five Stars
The usual quality from Ferrari & Russo. A professional book for professionals.
R**R
Five Stars
Great book
M**R
More academic than I was expecting
I bought this hoping it would help me use Power BI but actually it is quite an academic book on data structures. There's some useful stuff in here like different schema designs and the different types of table like dimension and fact which has proved useful. On the other hand the text and screenshots are so small as to be almost unreadable without my glasses, which I don't usually need for reading. Could be a sign of my age or that they have tried to cram too much in to a book of this size and format. It is worth reading if you want to be a qualified data analyst using Microsoft products but not the right book for someone looking to get some quick wins with Excel and Power BI.
K**C
Not for novices to Power BI
You need a reasonable grasp of Power BI to get the most from this book, which is excellent if a little too theory driven..
D**6
If you are already an SQL geek, this is useful.
If you are already an SQL geek, this is useful. Even if you are from an advanced Excel background - avoid it. I teach advanced Excel, and found this book poor to understand. A couple of good points in it - but overall, no good.
P**L
BON
PARFAIT.
M**A
Great insights for Newbies
Well written and easy to follow examples. Really helpful for understanding why certain methods/ data models are not working and how one can fix issues in their own data models.
S**H
Great book with in-depth and practical examples of all concepts and best practices on Data Modelling.
It’s obvious that this book covers all the concepts of data Modelling from converting from OLTP to Star schemes, Relationships, Time Dimensions, Multiple fact-tables, data granularity management, SCDs, etc... to name a few... But, the best part is that, this book is dealing with all the concepts in a very practical way and now when somebody tells me about a dashboard or report requirement, the data model is coming to my mind. It has given me the confidence that I am modeling it the right way and following the best practices. After reading this book, I am able to figure out the best method to create various datasets in PowerBI that will give the right amount of analytical power at optimum performance. One should not touch Power BI without reading this book!!!! It will definitely save time. Definitely recommended.
B**N
Excellent data modeling resource
This is a great book for those who want to understand data modeling. I bought this book hoping for a primer on Power BI, but quickly realized that that was not the book's intent -- the authors make this clear in the introduction. While I was mildly disappointed that it was not Power BI 101 or even DAX 101, I was glad that I learned what data modeling really is -- it is not SQL for Excel or Excel on steroids. As a newbie, I quickly learned that it was very easy to drag a column into a table and get a set of numbers that made no sense at all. One of the most valuable parts of this book is the recognition that nonsense data does happen, why it happens (e.g. weak relationships and bi-directional filtering) and how to build your model and relationships in a way to prevent nonsense data from creeping into your work. These lessons alone make this book worthwhile!
B**S
Great book if you are the right audience
This is a fantastic book if you are already familiar with Power BI and DAX and want to learn more about how to correctly structure data models. However if you are new to Power BI or Power Pivot this is not the book for you as the DAX will scare the pants off you. I understand that the authors only mean to use the DAX to decribe the data modelling principles, but in saying that you still wont get much out of it unless you can understand the DAX. If you are new to DAX I would first recommend Matt Arlington's "Learn to Write DAX" which is the best beginners book for DAX then move to Philip Seamark's "Beginning DAX with Power BI" then finally the "Definitive Guide to DAX". I was disappointed that the database underpinning the various pbix and excel files werent available. I contacted the authors and Marco replied promptly which was great. He informed me that the M/SQL data transformations in the example files were not the focus of the book which I understand, but I think that free access to the demo database would be helpful, especially for the data transformations in Chapter 5 "Tracking Historical Attributes". Having said that, if you are the right audience this book is great and fills a void in the marketplace. The authors are hands down the experts in their field.
Trustpilot
4 days ago
2 months ago