Building Data Models with Powerpivot: Business Skills

Autor Marco Russo, Alberto Ferrari
en Limba Engleză Paperback – 2 apr 2013
Your guide to quickly turn data into results.

Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel® 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required!
  • Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI
  • Extend your existing data-analysis skills to create your own BI solutions
  • Quickly manipulate large data sets, often in millions of rows
  • Perform simple-to-sophisticated calculations and what-if analysis
  • Create complex reporting systems with data modeling and Data Analysis Expressions
  • Share your results effortlessly across your organization using Microsoft SharePoint®
Citește tot Restrânge

Din seria Business Skills

Preț: 17340 lei

Preț vechi: 21675 lei

Puncte Express: 260

Preț estimativ în valută:
3319 3537$ 2841£

Carte disponibilă

Livrare economică 10-24 mai
Livrare express 26 aprilie-02 mai pentru 4027 lei

Preluare comenzi: 021 569.72.76


ISBN-13: 9780735676343
ISBN-10: 0735676348
Pagini: 500
Ilustrații: Illustrations
Dimensiuni: 227 x 183 x 27 mm
Greutate: 0.86 kg
Editura: Microsoft Press
Seria Business Skills


IntroductionChapter 1: Introduction to PowerPivotChapter 2: Using the unique features of PowerPivotChapter 3: Introducing DAXChapter 4: Understanding data modelsChapter 5: Publishing to SharePointChapter 6: Loading dataChapter 7: Understanding evaluation contextsChapter 8: Understanding CALCULATEChapter 9: Using hierarchiesChapter 10: Using Power ViewChapter 11: Shaping the reportsChapter 12: Performing date calculations in DAXChapter 13: Using advanced DAXChapter 14: Using DAX as a query languageChapter 15: Automating operations using VBAChapter 16: Comparing Excel and SQL Server Analysis ServicesAbout the Authors

Notă biografică

Alberto Ferrari has achieved Microsoft SQL Server Analysis Services (SSAS) Maestro status and is a consultant and trainer who specializes in developing Microsoft BI solutions. He is the coauthor of Microsoft PowerPivot for Excel 2010 and Expert Cube Development with Microsoft SQL Server 2008 Analysis Services and SQLBI Methodology.
Marco Russo is a software consultant and Microsoft Certified Trainer who focuses on Windows development and BI solutions. He has achieved Microsoft SQL Server Analysis Services (SSAS) Maestro status and has coauthored many books, including Microsoft PowerPivot for Excel 2010 and Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model.