Home Analyzing Data with Power Bi and Power Pivot for Excel by Alberto Ferrari; Marco Russo (ISBN: 9781509302765)

Stock photo: cover may vary

Analyzing Data with Power Bi and Power Pivot for Excel Paperback - 2017

Name: Analyzing Data with Power BI and Power Pivot for Excel
Price: 12.30 USD
Availability: InStock
Author: Ferrari, Alberto, Russo, Marco
ISBN: 9781509302765

by Alberto Ferrari; Marco Russo

Add to wish list

Browse more copies for sale ↓

Reader reviews for Analyzing Data with Power Bi and Power Pivot for Excel

Write a review for this book

Important Terms and Guidelines

Please focus on the book’s content and context. Also, add any personal comments as to how you enjoyed the book. Substantiate your likes and dislikes. You may make comparisons to other books.
Reviews must be at least 140 characters in length.
Please do not reveal critical plot elements.
This is not a help line. Contact customer support if you need help.

Your review must not include:

Obscenities, discriminatory language, or other insulting language not suitable for public domain
Advertisements, “spam” content, or references to other products, offers or websites.
Email addresses, URLs, phone numbers, physical addresses or other contact information.
Overly critical comments about other reviews or reviewers
Time-sensitive material (i.e. promotional tours, seminars, lectures, etc.)
Availability, price, or alternative ordering/shipping information

From the publisher

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

Details

Title Analyzing Data with Power Bi and Power Pivot for Excel
Author Alberto Ferrari; Marco Russo
Binding Paperback
Edition Paperback
Pages 256
Volumes 1
Language ENG
Publisher Microsoft Press
Publication date 2017-04-19
Features Index
ISBN 9781509302765 / 150930276X
Weight 1 lbs (0.45 kg)
Dimensions 8.9 x 7.3 x 0.6 in (22.61 x 18.54 x 1.52 cm)
Category Computers - Spreadsheets
Library of Congress subjects Business intelligence, Commercial statistics - Computer programs
Library of Congress Catalogue Number 2016931116
Dewey Decimal Code 005.743

About the author

Alberto Ferrari and Marco Russo are the founders of sqlbi.com, where they regularly publish articles about Microsoft Power Pivot, Power BI, DAX, and SQL Server Analysis Services. Both Ferrari and Russo provide consultancy and mentoring on business intelligence (BI). They are also frequent speakers at major international conferences, including Microsoft Ignite, PASS Summit, and SQLBits.

More Copies for Sale

Show all copies

Stock photo: cover may vary

Analyzing Data with Power BI and Power Pivot for Excel

by Ferrari, Alberto, Russo, Marco

Used

Condition: Used
ISBN 10 / ISBN 13: 9781509302765 / 150930276x
Quantity available: 1
Seller: Better World Books

Biblio Top Seller
Item price: A$17.60

Free Delivery to USA

Show details

Description:

Pearson Education. Used - Good. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good.

Add to wish list

Item price

A$17.60

Free Delivery to USA

More photos

Analyzing Data with Power BI and Power Pivot for Excel (Business Skills)

by Ferrari, Alberto; Russo, Marco

Used
Very good
Paperback

Condition: Very good
Binding: Paperback
ISBN 10 / ISBN 13: 9781509302765 / 150930276X
Quantity available: 1
Seller: Once Upon A Time Books

Biblio Top Seller
Item price: A$26.62A$18.64

Save A$7.99

A$9.30 Delivery to USA

Show details

Description:

Microsoft Press, 2017-04-19. paperback. Very Good. 7x0x8. Lightly used, text and pages clean and unmarked, slight cover wearI ship Worldwide from Puerto Rico, USA. Listing Includes Books Image . Please email me if you need to see more pictures! The orders are processed promptly, carefully packaged and shipped within 1 day of purchase. PLEASE NOTE! if you need the book quickly, please Purchase Priority Shipping. Media will not show updates in mail confirmation till reaches continental U.S.