Professional microsoft® powerpivot for excel® and sharepoint
With PowerPivot, Microsoft brings the power of Microsoft's business intelligence tools to Excel and SharePoint users. Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility.
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Newark
WILEY
2010
John Wiley & Sons, Incorporated Wrox Wiley Pub |
| Edition: | 1 |
| Subjects: | |
| ISBN: | 0470587377, 0470912413, 9780470912416, 9780470587379 |
| Online Access: | Get full text |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Abstract | With PowerPivot, Microsoft brings the power of Microsoft's business intelligence tools to Excel and SharePoint users. Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility. |
|---|---|
| AbstractList | With PowerPivot, Microsoft brings the power of Microsoft's business intelligence tools to Excel and SharePoint users. Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility. If you're a business decision-maker who uses Microsoft Office or an IT professional responsible for deploying and managing your organization's business intelligence systems, this guide will help you make the most of PowerPivot.Professional Microsoft PowerPivot for Excel and SharePoint describes all aspects of PowerPivot and shows you how to use each of its major features. By the time you are finished with this book, you will be well on your way to becoming a PowerPivot expert.This book is for people who want to learn about PowerPivot from end to end. You should have some rudimentary knowledge of databases and data analysis. Familiarity with Microsoft Excel and Microsoft SharePoint is helpful, since PowerPivot builds on those two products.This book covers the first version of PowerPivot, which ships with SQL Server 2008 R2 and enhances Microsoft Office 2010. It provides an overview of PowerPivot and a detailed look its two components: PowerPivot for Excel and PowerPivot for SharePoint. It explains the technologies that make up these two components, and gives some insight into why these components were implemented the way they were. Through an extended example, it shows how to build a PowerPivot application from end to end.The companion Web site includes all the sample applications and reports discussed.What This Book CoversAfter discussing self-service BI and the motivation for creating PowerPivot, the book presents a quick, end-to-end tutorial showing how to create and publish a simple PowerPivot application. It then drilsl into the features of PowerPivot for Excel in detail and, in the process, builds a more complex PowerPivot application based on a real-world case study. Finally, it discusses the server side of PowerPivot (PowerPivot for SharePoint) and provides detailed information about its installation and maintenance.Chapter 1, "Self-Service Business Intelligence and Microsoft PowerPivot," begins Part I of the book. This chapter describes self-service BI and introduces PowerPivot, Microsoft's first self-service BI tool. It provides a high-level look at the two components that make up PowerPivot - PowerPivot for Excel and PowerPivot for SharePoint.Chapter 2, "A First Look at PowerPivot," walks you through a simple example of creating a PowerPivot application from end to end. In the process, it shows how to set up the two components of PowerPivot, and describes the normal workflow of creating a simple PowerPivot application.Chapter 3, "Assembling Data," starts off Part II of the book, and explains how to bring data into PowerPivot from various external data sources. It also introduces the extended example that you will build in this and subsequent chapters.Chapter 4, "Enriching Data," shows how to enhance the data you brought into your application by creating relationships and using PowerPivot's expression language, Data Analysis Expressions (DAX).Chapter 5, "Self-Service Analysis," describes how to use your PowerPivot data with various Excel features, such as PivotTables, PivotCharts, and slicers to do analysis. Chapter 5 also delves further into DAX, showing how to create and use DAX measures.Chapter 6, "Self-Service Reporting," shows how to publish your PowerPivot workbook to the server side of PowerPivot (PowerPivot for SharePoint), and make use of its features to view and update PowerPivot reports. It also shows how to use the data in a PowerPivot workbook as a data source for reports created in other tools such as Report Builder 3.0 and Excel.Chapter 7, "Preparing for SharePoint 2010," is the first chapter With PowerPivot, Microsoft brings the power of Microsoft's business intelligence tools to Excel and SharePoint users. Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility. |
| Author | Pihlgren, Ron Lee, Denny Guang-Yeu Harinath, Sivakumar |
| Author_xml | – sequence: 1 fullname: Harinath, Sivakumar – sequence: 2 fullname: Pihlgren, Ron – sequence: 3 fullname: Lee, Denny Guang-Yeu |
| BookMark | eNpFkM1KAzEUhSP-YFv7DrMQwUUhk-TmZyPYUrVQ0IUoroZMmmljp5Mxmdb6Uj6ET-aUFr2by7l8HM65XXRS-coeoS5mAquUsJQe7wVIQYU4Qx0OnHIQBJ-jfozvuB1GeCpYB908BV_YGJ2vdJmsnAk--qL5-U5q_2lD7Ta-SQofErs1tmzPupolcaGDrb2rmgt0Wugy2v5h99DL3fh59DCYPt5PRrfTgQaQSgzyQpI2DGc85xyMSCU2IPMcNOYUCiFkyiGVhDAD1oLROSUAREkDeKaIpT10tTeOS1eWu4hZ7v0yErYVWb6Mu0qguGjBywOoCx3cnso2JFNC_j1F_fvVwX-sbWwyuyONrZqgy2w8HAEjStEWvN6Dbl6v89LFhavmWR3cSoev7HUyHb8NMU6pFJj-Alm0cok |
| ContentType | eBook |
| DBID | WIIVT OHILO OODEK |
| DEWEY | 005.7565 |
| DatabaseName | Wiley O'Reilly Online Learning: Corporate Edition O'Reilly Online Learning: Academic/Public Library Edition |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Computer Science Business |
| DocumentTitleAlternate | Microsoft PowerPivot for Excel and SharePoint Microsoft SharePoint (Electronic resource) Microsoft Excel (Computer file) SQL server. PowerPivot for Excel and SharePoint |
| EISBN | 0470912413 9780470912416 9780470587379 0470587377 |
| Edition | 1 |
| ExternalDocumentID | bks00045967 9780470587379 EBC542993 WILEYB0013870 |
| Genre | Electronic books |
| GroupedDBID | 089 20A 5VX 92K A4I A4J AABBV AALIM ABARN ABBFG ABIAV ABQPQ ACGYG ACLGV ACNAM ACNUM ADNEN ADVEM AERYV AFOJC AHWGJ AJFER AKHYG AKQZE ALMA_UNASSIGNED_HOLDINGS AUKZS AZZ BBABE BPBUR CZZ GEOUK HF4 J-X JJU MYL NK1 NK2 OHILO OODEK OV6 PQQKQ UZ6 WIIVT WZT |
| ID | FETCH-LOGICAL-a55897-bf82737646b665c7180c58bb5a0635f77816518224c5ee5cab3255298c50d92e3 |
| ISBN | 0470587377 0470912413 9780470912416 9780470587379 |
| IngestDate | Wed Mar 26 01:32:21 EDT 2025 Fri Dec 05 22:00:00 EST 2025 Wed Nov 26 03:02:24 EST 2025 Tue Oct 07 10:19:59 EDT 2025 |
| IsPeerReviewed | false |
| IsScholarly | false |
| LCCallNum | HF5548.4.M523 |
| LCCallNum_Ident | HF5548.4.M523 |
| Language | English |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-a55897-bf82737646b665c7180c58bb5a0635f77816518224c5ee5cab3255298c50d92e3 |
| Notes | "Wrox programmer to programmer"--Thumbnail image. Available also in a print ed. Mode of access: Internet via World Wide Web. Title from title screen. |
| OCLC | 656365720 |
| PQID | EBC542993 |
| PageCount | 388 |
| ParticipantIDs | skillsoft_books24x7_bks00045967 safari_books_v2_9780470587379 proquest_ebookcentral_EBC542993 igpublishing_primary_WILEYB0013870 |
| ProviderPackageCode | J-X |
| PublicationCentury | 2000 |
| PublicationDate | 2010. 2010 2010-06-15T00:00:00 c2010 |
| PublicationDateYYYYMMDD | 2010-01-01 2010-06-15 |
| PublicationDate_xml | – year: 2010 text: 2010. |
| PublicationDecade | 2010 |
| PublicationPlace | Newark |
| PublicationPlace_xml | – name: Newark – name: Indianapolis, Ind |
| PublicationYear | 2010 |
| Publisher | WILEY John Wiley & Sons, Incorporated Wrox Wiley Pub |
| Publisher_xml | – name: WILEY – name: John Wiley & Sons, Incorporated – name: Wrox – name: Wiley Pub |
| SSID | ssj0000426174 ssib010061099 |
| Score | 1.8431222 |
| Snippet | With PowerPivot, Microsoft brings the power of Microsoft's business intelligence tools to Excel and SharePoint users. Self-service business intelligence today... |
| SourceID | skillsoft safari proquest igpublishing |
| SourceType | Aggregation Database Publisher |
| SubjectTerms | Business intelligence Client/server computing Computer programs COMPUTERS Data Warehousing Microsoft SharePoint (Electronic resource) |
| SubjectTermsDisplay | Business intelligence -- Computer programs. Client/server computing. COMPUTERS Data Warehousing Electronic books. Microsoft Excel (Computer file) Microsoft SharePoint (Electronic resource) SQL server. |
| TableOfContents | Professional Microsoft PowerPivot for Excel and SharePoint -- About the Authors -- Contents -- Introduction -- Who This Book Is For -- What This Book Covers -- How This Book Is Structured -- What You need to uSe thIS book -- conventIonS -- Source code -- errata -- p2p.Wrox.com -- Part I: Introduction -- Chapter 1: Self-Service Business Intelligence and Microsoft PowerPivot -- SQL Server 2008 R2 -- Self-Service Business Intelligence -- Power Pivot: Microsoft's Implementation of Self-Service BI -- Summary -- Chapter 2: A First Look at PowerPivot -- PowerPivot for Excel -- Setting the Stage -- PowerPivot for SharePoInt -- Summary -- Part II: Creating Self-Service BI Applications Using PowerPivot -- Chapter 3: Assembling Data -- Importing Data -- Other Ways to Bring Data into PowerPivot -- The Healthcare Audit Application -- Assembling Data for the Healthcare Audit Application -- Summary -- Chapter 4: Enriching Data -- Exploring the PowerPivot Window -- Enriching Data for the Healthcare Audit Application -- Summary -- Chapter 5: Self-Service Analysis -- PivotTables and PivotCharts -- The PowerPivot Field List -- Slicers -- DAX Measures -- PowerPivot and Other Excel Features -- AnalysIs in the Healthcare AudIt Application -- Summary -- Chapter 6: Self-Service Reporting -- Publishing PowerPivot Workbooks -- PowerPivot for SharePoint -- Adding Reporting to the SDR Healthcare Application -- Summary -- Part III: IT PROFESSIONAL -- Chapter 7: Preparing for SharePoint 2010 -- SharePoint 2010 -- Why Not SharePoint "Lite" BI Edition? -- Excel Services -- Key Servers in PowerPivot for SharePoint -- Key Services in PowerPivot for SharePoint -- Services Architecture Workflow Scenarios -- Summary -- Chapter 8: PowerPivot for SharePoint Setup and Configuration -- Required Hardware and Software -- Setup and Configuration -- Multi-Server Farm Setup Verify the PowerPivot for SharePoint Setup -- Optional Setup Steps -- Summary -- Chapter 9: Troubleshooting, Monitoring, and Securing PowerPivot Services -- Troubleshooting Tools -- TroubleshootIng Issues -- Monitoring PowerPivot Servic s -- Security -- Summary -- Chapter 10: Diving into the PowerPivot Architecture -- PowerPivot for Excel Architecture -- PowerPivot for SharePoint Architecture -- Summary -- Chapter 11: Enterprise Considerations -- Capacity Planning -- SharePoint WFEs -- SharePoint App Servers -- Sharepoint Databases -- Upgrade and Patching Considerations -- Upload Considerations -- Summary -- Part IV: Appendix -- Appendix A: Up the SDR Healthcare Application -- Setting Up the SQL Server Audit Database -- Setting Up the Database Group Name SharePoint List -- Setting Up the Client Address to State Report -- Index |
| Title | Professional microsoft® powerpivot for excel® and sharepoint |
| URI | http://portal.igpublish.com/iglibrary/search/WILEYB0013870.html https://ebookcentral.proquest.com/lib/[SITE_ID]/detail.action?docID=542993 https://learning.oreilly.com/library/view/~/9780470587379/?ar http://www.books24x7.com/marc.asp?bookid=45967 |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV1bb9MwFLbYhoC9DMYQHRtECJ6mSG4c316QWJWBxDQiGNN4imLX6aJWadV0Vfan-BH8Mo6dS9u9IB54sRLbsZTzHdnnHJ8LQu8CEIKxZtpPBbfXjNT4KlPEH0o471M2zLhzxrw65xcX4vpaxk311tKVE-BFIapKzv4r1NAHYNvQ2X-Au1sUOuAZQIcWYIf2nkTcvdaIx2tZNqw7PJx_do8dBO8_RiexrYYW58vpwjkWRpU2k2bIOW_epHMTT_OVF8z3fJmOrf-1jfPJrYm9k3lhb76zvFWM_J_m9uTcdMzxDXgpzm8mozbCrLEn2Ktw5tcRlfWuNZ9WGzomDjmmgpO65su95NQb41toizNQgHc-RV9_fOksXU5L46FLB9BM5W3qo_ZTmyh2NOsMb5vifplm8KO76HE5zicTS7o1EeDyKdoxNi7kGXpgin30qA0Y2Ed7bWEMr9knn6MP61B4HRS_f3krGDyAwXMwQDdA4K0gOEBXZ9Hl4LPfFKrwU0qF5MDeAsRAzkKmGKMaznusqVCKpiAB0oxz0We0bx12NTWG6lQRUOUCKTTFQxkY8gJtF9PCvEQeJsQorHiG-1lIA6UIkwZnRBCWUdCOe-jtOqWSWZ2UJHEp2E_dxTPHPfSmpV_iLt0bT98kOh3YAmWS9NBxTdbEDpfJMkg2AIEVOmrXU4Kw4okal04LkIwf_mWFV-jJir2O0PZifmuO0UO9XOTl_HXDJH8A6QVHPw |
| linkProvider | ProQuest Ebooks |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.title=Professional+Microsoft%C2%AE+PowerPivot+for+Excel%C2%AE+and+SharePoint&rft.au=Sivakumar+Harinath&rft.au=Denny+Guang-Yeu+Lee&rft.au=Ron+Pihlgren&rft.date=2010-06-15&rft.pub=Wrox&rft.isbn=9780470587379&rft.externalDocID=9780470587379 |
| thumbnail_m | http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fwww.safaribooksonline.com%2Flibrary%2Fcover%2F9780470587379 |
| thumbnail_s | http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=http%3A%2F%2Fportal.igpublish.com%2Figlibrary%2Famazonbuffer%2FWILEYB0013870_null_0_320.png |