Transform your skills, data, and business-with the power user’s guide to PowerPivot for Excel. Led by two business intelligence (BI) experts, you’ll learn how to create and share your own BI solutions using software you already know and love: Microsoft Excel. Discover how to extend your existing skills, using the PowerPivot add-in to quickly turn mass quantities of data into meaningful information and on-the-job results-no programming required. The book introduces you to PowerPivot functionality, then takes a pragmatic approach to understanding and working with data models, data loading, data manipulation with Data Analysis Expressions (DAX), simple-to-sophisticated calculations, what-if analysis, and PowerPivot patterns. Learn how to create your own, “self-service” BI solutions, then share your results effortlessly across your organization using Microsoft SharePoint®.
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to email@example.com.
MARCO RUSSO is a software consultant and trainer based in Italy who focuses on Windows development and Business Intelligence solutions, including data warehouse relational and multidimensional design. He is the coauthor of Introducing Microsoft LINQ and Programming Microsoft LINQ (Microsoft Press), along with several other books about Microsoft .NET and SQL Server Analysis Services.
ALBERTO FERRARI is a consultant and trainer who specializes in developing Microsoft Business Intelligence solutions, including guiding software organizations through the design of complex BI solutions. He is the coauthor of Expert Cube Development with Microsoft SQL Server 2008 Analysis Services and SQLBI Methodology (with Russo).Contenuti:
Preface; Marco Russo; Alberto Ferrari; Acknowledgments; Introduction; Who Is This Book For?; System Requirements; About the DVD; Errata & Book Support; We Want to Hear from You; Stay in Touch; Chapter 1: First Steps with PowerPivot; 1.1 Working with Classic Excel PivotTables; 1.2 Working with PivotTables in PowerPivot; 1.3 Summary; Chapter 2: PowerPivot at Work; 2.1 Using the PivotTable to Produce Reports; 2.2 Adding More Tables; 2.3 Working with Dates; 2.4 Refreshing Data; 2.5 Using Slicers; 2.6 Summary; Chapter 3: Introduction to DAX; 3.1 Understanding Calculation in DAX; 3.2 Understanding Calculated Columns and Measures; 3.3 Handling Errors in DAX Expressions; 3.4 Common DAX Functions; 3.5 Summary; Chapter 4: Data Models; 4.1 Understanding Data Models; 4.2 Understanding Physical and Logical Data Models; 4.3 Understanding How and When to Denormalize Tables; 4.4 Complex Relationships; 4.5 Understanding OLTP and Data Marts; 4.6 Discovering Advanced Types of Relationships; 4.7 Summary; Chapter 5: Loading Data and Models; 5.1 Understanding Data Sources; 5.2 Loading from a Database; 5.3 Opening Existing Connections; 5.4 Loading from Access; 5.5 Loading from Analysis Services; 5.6 Using Linked Tables; 5.7 Loading from Excel Files; 5.8 Loading from Text Files; 5.9 Loading from the Clipboard; 5.10 Loading from a Report; 5.11 Loading from a Data Feed; 5.12 Loading from SharePoint; 5.13 Summary; Chapter 6: Evaluation Context and CALCULATE; 6.1 Understanding Evaluation Context; 6.2 Understanding the CALCULATE Function; 6.3 Understanding the EARLIER Function; 6.4 Summary; Chapter 7: Date Calculations in DAX; 7.1 Working with a Dates Table; 7.2 Aggregating and Comparing over Time; 7.3 Closing Balance over Time; 7.4 Summary; Chapter 8: Mastering PivotTables; 8.1 Understanding Different Types of PivotTables; 8.2 Custom Sorting in PivotTables; 8.3 Computing Ratios and Percentage in PivotTables; 8.4 Aggregating Data Without Using Sum; 8.5 Creating Dashboards; 8.6 Using Complex Queries as Linked Tables; 8.7 Performing Analysis of Old and New Data Together; 8.8 Defining Sets; 8.9 Creating Dynamic Sets with MDX; 8.10 Creating Sets of Measures with MDX; 8.11 Summary; Chapter 9: PowerPivot DAX Patterns; 9.1 Calculating Ratio and Percentage; 9.2 Computing Standard Deviation; 9.3 Ranking over a Measure; 9.4 Computing ABC and Pareto Analyses; 9.5 Event in Progress; 9.6 Summary; Chapter 10: PowerPivot Data Model Patterns; 10.1 Banding; 10.2 Performing Courier Simulation; 10.3 Summary; Chapter 11: Publishing to SharePoint; 11.1 SharePoint 2010 and PowerPivot Integration; 11.2 Publishing an Excel Workbook; 11.3 PowerPivot Data Refresh; 11.4 Summary; DAX Functions Reference; Statistical Functions; Logical Functions; Information Functions; Mathematical Functions; Text Functions; Date and Time Functions; Filter and Value Functions; Time Intelligence Functions; Biography;
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
Descrizione libro Condizione libro: New. This is an International Edition Brand New Paperback Same Title Author and Edition as listed. ISBN and Cover design differs. Similar Contents as U.S Edition. Standard Delivery within 6-14 business days ACROSS THE GLOBE. We can ship to PO Box address in US. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" or "For sale in Asia only" or similar restrictions- printed only to discourage students from obtaining an affordable copy. US Court has asserted your right to buy and use International edition. Access code/CD may not provided with these editions. We may ship the books from multiple warehouses across the globe including Asia depending upon the availability of inventory. Printed in English. Customer satisfaction guaranteed. Codice libro della libreria RU_9788120344532
Descrizione libro Microsoft Press. Condizione libro: New. 0735640580 This is an International Edition. Brand New, Paperback, Delivery within 6-14 business days, Similar Contents as U.S Edition, ISBN and Cover design may differ, printed in Black & White. Choose Expedited shipping for delivery within 3-8 business days. We do not ship to PO Box, APO , FPO Address. In some instances, subjects such as Management, Accounting, Finance may have different end chapter case studies and exercises. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" and "Content may different from U.S. Edition" - printed only to discourage U.S. students from obtaining an affordable copy. The U.S. Supreme Court has asserted your right to purchase international editions, and ruled on this issue. Access code/CD is not provided with these editions , unless specified. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. Customer satisfaction guaranteed. Codice libro della libreria UA9780735640580
Descrizione libro Softcover. Condizione libro: New. Brand New; Shrink Wrapped; Paperback; Black & White or Color International Edition. ISBN and Cover page may differ but similar contents as US edition. GET IT FAST in 3-5 business days by DHL/FEDEX with tracking number. Books printed in English. No shipping to PO Box/APO/FPO address. In some instances the international textbooks may have different end chapter case studies and exercises. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" and "Content may different from U.S. Edition" - printed only to discourage U.S. students from obtaining an affordable copy. The U.S. Supreme Court has asserted your right to purchase international editions, and ruled on this issue. Access code or CD is not provided with these editions, unless specified. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. Customer satisfaction guaranteed. Codice libro della libreria GFI1451149
Descrizione libro PHI. PaperBack. Condizione libro: Brand New. International Edition. International Edition, Cover & ISBN may be different from US edition, PAPERBACK. Book Condition: New. Brand New,Softcover,No Access code & No context dvd, But Contents are same as US Edition. Printed in English Language, Prompt shipping by USPS/,UPS/,DHL/,FedEx. Exceptional customer Service, Satisfaction Guaranteed. We may ship the books from Asian regions for inventory purpose. "Special Note" We do provide service on APO BOX & PO BOX addresses only in usa. Codice libro della libreria Aaddi18246
Descrizione libro 2010. Soft cover. Condizione libro: New. This book is BRAND NEW Soft cover International edition with black and white printing. ISBN number & cover page may be different but contents identical to the US edition word by word. Book is in English language. Codice libro della libreria UN-PH-IN-1145
Descrizione libro Microsoft Press, 2010. Paperback. Condizione libro: New. Codice libro della libreria INGM9780735640580
Descrizione libro Microsoft Press, 2010. Condizione libro: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: This book introduces PowerPivot in Excel 2010 to power users and data analysts who want to use Excel as a business intelligence tool. Codice libro della libreria ABE_book_new_0735640580
Descrizione libro Microsoft Press, 2010. Paperback. Condizione libro: New. book. Codice libro della libreria 0735640580
Descrizione libro Microsoft Press, 2010. Paperback. Condizione libro: New. Pap/Dvdr. Codice libro della libreria DADAX0735640580
Descrizione libro Microsoft Press, 2010. Paperback. Condizione libro: New. Codice libro della libreria P110735640580