Data analysis using Microsoft Power Bi and Power Pivot for Excel

If you want to use Power Bi or Excel to analyze data, real examples from this book will allow you to look differently at your reports. With a correctly designed data model, answers to all questions will be extremely simple!
Reading this book, you:
- master the basic concepts of data modeling, including tables, connections and keys,
- get acquainted with the common data schemes" Zvezda "and" Snowflake and general modeling techniques,
- learn the importance of granularity,
- learn how to use several tables of facts (for example, sales and purchases) in a single data model,
- learn to make calculations with a calendar using tables with dates, < BR />- Master the tracking of historical attributes, such as customer addresses or customer binding to managers,
- learn how to use pictures to count the number of goods in stock,
- learn to work effectively with several currencies at the same time, < Br />- You will acquire knowledge for analyzing events with a certain duration, including intersecting intervals,
- you can determine which data model better meets your specifics of work