Zum Hauptinhalt springen
Dekorationsartikel gehören nicht zum Leistungsumfang.
Microsoft Excel 2013 Building Data Models with PowerPivot
Taschenbuch von Alberto Ferrari (u. a.)
Sprache: Englisch

40,10 €*

inkl. MwSt.

Versandkostenfrei per Post / DHL

Lieferzeit 1-2 Wochen

Kategorien:
Beschreibung

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¿

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¿
Über den Autor

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.

Inhaltsverzeichnis
  • Introduction
  • Chapter 1: Introduction to PowerPivot
  • Chapter 2: Using the unique features of PowerPivot
  • Chapter 3: Introducing DAX
  • Chapter 4: Understanding data models
  • Chapter 5: Publishing to SharePoint
  • Chapter 6: Loading data
  • Chapter 7: Understanding evaluation contexts
  • Chapter 8: Understanding CALCULATE
  • Chapter 9: Using hierarchies
  • Chapter 10: Using Power View
  • Chapter 11: Shaping the reports
  • Chapter 12: Performing date calculations in DAX
  • Chapter 13: Using advanced DAX
  • Chapter 14: Using DAX as a query language
  • Chapter 15: Automating operations using VBA
  • Chapter 16: Comparing Excel and SQL Server Analysis Services
  • About the Authors
Details
Erscheinungsjahr: 2013
Fachbereich: Anwendungs-Software
Genre: Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Taschenbuch
Inhalt: Kartoniert / Broschiert
ISBN-13: 9780735676343
ISBN-10: 0735676348
Sprache: Englisch
Einband: Kartoniert / Broschiert
Autor: Ferrari, Alberto
Russo, Marco
Hersteller: Microsoft Press,U.S.
Maße: 228 x 189 x 30 mm
Von/Mit: Alberto Ferrari (u. a.)
Erscheinungsdatum: 15.03.2013
Gewicht: 0,853 kg
Artikel-ID: 106187299
Über den Autor

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.

Inhaltsverzeichnis
  • Introduction
  • Chapter 1: Introduction to PowerPivot
  • Chapter 2: Using the unique features of PowerPivot
  • Chapter 3: Introducing DAX
  • Chapter 4: Understanding data models
  • Chapter 5: Publishing to SharePoint
  • Chapter 6: Loading data
  • Chapter 7: Understanding evaluation contexts
  • Chapter 8: Understanding CALCULATE
  • Chapter 9: Using hierarchies
  • Chapter 10: Using Power View
  • Chapter 11: Shaping the reports
  • Chapter 12: Performing date calculations in DAX
  • Chapter 13: Using advanced DAX
  • Chapter 14: Using DAX as a query language
  • Chapter 15: Automating operations using VBA
  • Chapter 16: Comparing Excel and SQL Server Analysis Services
  • About the Authors
Details
Erscheinungsjahr: 2013
Fachbereich: Anwendungs-Software
Genre: Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Taschenbuch
Inhalt: Kartoniert / Broschiert
ISBN-13: 9780735676343
ISBN-10: 0735676348
Sprache: Englisch
Einband: Kartoniert / Broschiert
Autor: Ferrari, Alberto
Russo, Marco
Hersteller: Microsoft Press,U.S.
Maße: 228 x 189 x 30 mm
Von/Mit: Alberto Ferrari (u. a.)
Erscheinungsdatum: 15.03.2013
Gewicht: 0,853 kg
Artikel-ID: 106187299
Warnhinweis