Data analysis using Microsoft Power Bi and Power Pivot for Excel
Please sign in so that we can notify you about a reply
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
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
Cover:
Cover:Soft
Category:
- Category:Computer & Technology
ISBN:
ISBN:978-5-97060-858-6
No reviews found