02370cam a2200313Ii 4500
34193
34193
ocn944210645
2016931116
9781509302765
UOWD
005.743 FE AN
Ferrari, Alberto,
1966-
19200
Analyzing data with Microsoft power BI and power pivot for excel
Alberto Ferrari and Marco Russo
Microsoft power BI and power pivot for excel
Washington :
Microsoft press,
c2017.
xiv, 235 p. :
ill. ;
23 cm.
Includes index.
Introduction to data modeling -- Using header/detail tables -- Using multiple fact tables -- Working with date and time -- Tracking historical attributes -- Using snapshots -- Analyzing date and time intervals -- Many-to-many relationships -- Working with different granularity -- Segmentation data models -- Working with multiple currencies -- Data modeling 101.
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!
"For intermediate to advanced users of Microsoft Excel"--Page 4 of cover.
Business intelligence
Computer programs
579
Data mining
Computer programs
19205
Commercial statistics
Computer programs
465
Information visualization
Computer programs
18096
Visual analytics
19206
Russo, Marco,
1969-
19203
https://uowd.box.com/s/emji2tyypl5bnk41qhxxpqodaug1myvj
Location Map
ddc
REGULAR
03265234
0
ddc
0
005_743000000000000_FE_AN
0
44671
UOWD
UOWD
MAIN
2018-05-30
AMAUK
19.23
1
005.743 FE AN
T0059902
2020-11-19
2020-03-24
2018-05-20
REGULAR
June2018
AMAUK#204-7914795-8960369