McGraw-Hill Education (Asia)

PowerShell for Microsoft SharePoint 2010 Administrators

Authors: Goude, Niklas; Karlsson, Mattias
ISBN-13: 978-0-07-174797-4
ISBN-10: 0071747974
©2011 | 1st Edition | 512 pages , Softcover
Pub Date: October 2010
Price: US$ 45.00
Learn More

This hands-on guide shows SharePoint 2010 administrators how to use PowerShell to automate repetitive tasks and conduct remote troubleshooting.

PowerShell for Microsoft SharePoint 2010 Administrators explains how to take advantage of PowerShell─the built-in scripting language─to increase productivity by automating tasks on both local and remote systems. PowerShell is fully integrated into SharePoint 2010, providing administrators with a revolutionary set of tools, including more than 500 new PowerShell commands. This book covers all PowerShell capabilities.

This comprehensive guide provides an introduction to PowerShell for administrators who have never used it before. Specifics on how and why to use PowerShell with SharePoint are included. Real-word scenarios demonstrate the advantages of PowerShell as a tool to solve common problems.

PowerShell for Microsoft SharePoint 2010 Administrators

1. Covers the latest versions: SharePoint 2010 and PowerShell 2.0
2. Is written by global SharePoint and PowerShell experts and bloggers
3. Includes comparisons between PowerShell scripting and built-in SharePoint tools that demonstrate the differences and provide a good understanding of when to use PowerShell
4. Requires no prior knowledge of PowerShell—provides a good introduction to both PowerShell and SharePoint
5. Offers extensive PowerShell script examples for download

Practical PowerPivot & DAX Formulas for Excel 2010

Authors: Tennick, Art
ISBN-13: 978-0-07-174685-4
ISBN-10: 0071746854
©2011 | 1st Edition | 512 pages , Softcover
Pub Date: September 2010
Price: US$ 39.99
Learn More

Extract actionable BI using Excel 2010 PowerPivot and DAX language

Featuring 200 ready-to-use DAX queries, Practical PowerPivot & DAX Queries for Excel 2010 shows Office and Excel power users how to take advantage of DAX (Data Analysis Expressions)—the new standard language for extracting BI within Excel. An entire section shows how to create tables, pivot tables, and PowerPivot tables in Excel. You can then progress to writing DAX queries and formulas to harness the power of BI.

This solutions-based guide contains more than 200 DAX queries that can be immediately applied across a wide variety of BI-related problems. It begins with fundamental principles and simple queries and rapidly progresses to complex and sophisticated queries. The book is structured as follows:

1. Query: Introduction and description of query and its use
2. Syntax: Complete DAX syntax
3. Result: Screen shot showing the data returned in an Excel 2010 pivot table
4. Analysis: Analysis of the results and tips for customization

Practical PowerPivot & DAX Queries for Excel 2010

1. Includes 200+ ready-to-use, easily customizable DAX queries, all available for download
2. Features a practical and hands-on approach with a minimum of difficult concepts and theory
3. Explains how to visualize actionable BI
4. Helps to dramatically improve analysis and decision-making skills

Microsoft SharePoint 2010 Web Applications The Complete Reference

Authors: Holland, Charlie
ISBN-13: 978-0-07-174456-0
ISBN-10: 0071744568
©2011 | 1st Edition | 640 pages , Softcover
Pub Date: September 2010
Price: US$ 45.00
Learn More

Leverage SharePoint’s revolutionary software development platform to build business applications

Microsoft SharePoint 2010 Web Applications: The Complete Reference is the perfect guide for developers who want to use SharePoint to build any type of web application using SharePoint as a platform. In SharePoint 2010, practically all of the additional functionality is aimed at extending this development capability. This book fully covers all of these features. Learn how to build a self-service web portal for customers; create a unified access point for all internal line-of-business applications; deliver e-commerce solutions; and much more.

Microsoft SharePoint 2010 Web Applications: The Complete Reference :

1. Defines best practices covering the entire project lifecycle
2. Explains which development tool best suits each task
3. Provides step-by-step, real-world examples with downloadable sample code
4. Features comprehensive coverage of all the new SharePoint 2010 features
5. Helps to builds the skills required to use SharePoint as a development platform, both from a software development perspective and from a project management perspective

How to Do Everything Microsoft SharePoint 2010

Authors: Cawood, Stephen
ISBN-13: 978-0-07-174367-9
ISBN-10: 0071743677
©2011 | 1st Edition | 304 pages , Softcover
Pub Date: August 2010
Price: US$ 24.99
Learn More

Written by a former member of the SharePoint development team, this is a step-by-step guide to mastering the latest release of this integrated suite of server capabilities.

In How to Do Everything: Microsoft SharePoint 2010, Stephen Cawood—one of the people who helped build SharePoint—offers advice from his many years of working with SharePoint customers, cutting to the core and focusing on key features to get you up to speed quickly. You’ll get easy-to-follow tutorials on blogs, wikis, MySites, Web parts, taxonomy, document management, workflow, publishing sites, team sites, and much more. Take full advantage of the content management, enterprise search, collaboration, and information-sharing capabilities of SharePoint 2010 with help from this practical guide.

How to Do Everything: Microsoft SharePoint 2010:

1. Covers the key new features, including new out-of-the-box web parts and SharePoint taxonomy
2. Contains step-by-step examples that walk you through the most common SharePoint tasks
3. Explains how to use SharePoint Workspace to work with SharePoint offline
4. Includes valuable advice from SharePoint experts
5. Functions as a handy reference to learn new features and as a refresher

Microsoft SharePoint 2010 QuickSteps

Authors: Matthews, Marty; Buchanan, Nancy
ISBN-13: 978-0-07-174193-4
ISBN-10: 0071741933
©2011 | 1st Edition | 272 pages , Softcover
Pub Date: August 2010
Price: US$ 21.99
Learn More

A full-color, step-by-step guide to all the key features of SharePoint 2010

Microsoft SharePoint 2010 QuickSteps starts you up on SharePoint 2010 right away, including SharePoint Server 2010, SharePoint Designer 2010, and SharePoint Workspace 2010. Color screenshots and clear instructions make it easy to ramp up on the latest release of Microsoft’s integrated collaboration suite. Follow along and quickly learn how to plan, build, administer, and secure a SharePoint site and integrate it with Microsoft Office 2010. Get up to speed on SharePoint 2010 in no time with help from this practical, fast-paced guide.

Microsoft SharePoint 2010 QuickSteps

1. Offers full-color coverage of the key capabilities of the entire SharePoint suite
2. Features high production quality, breadth of coverage, and a low price
3. Includes color screenshots on every page with step-by-step explanations

Business Intelligence with Microsoft® Office PerformancePoint™ Server 2007

Authors: Utley, Craig
ISBN-13: 978-0-07-149370-3
ISBN-10: 0071493700
©2008 | 1st Edition | 358 pages , Softcover
Pub Date: January 2008
Price: US$ 49.99
Learn More

Deliver BI Solutions with Microsoft Office PerformancePoint Server 2007

Maximize the powerful BI tools available in PerformancePoint 2007 with help from this practical guide. You will learn how to collect and store data, monitor progress, analyze performance, distribute dynamic reports, and create maintainable projects and forecasts. Business Intelligence with Microsoft Office PerformancePoint Server 2007 provides full details on creating scorecards and dashboards, performing advanced analysis on data, and setting up business plans. You will also learn how to integrate PerformancePoint with ProClarity, Excel 2007, and SQL Server Reporting Services.

1. Configure, deploy, and secure all the PerformancePoint components
2. Create KPIs, scorecards, reports, and dashboards with the Dashboard Designer
3. Create business models with the Planning Business Modeler and create budgets and forecasts with Excel 2007
4. Enable advanced data analysis with PerformancePoint Server and ProClarity tools
5. Take advantage of the enhanced analytic capabilities of Excel 2007
6. Use SQL Server Reporting Services for analytics
7. Align performance with organizational objectives

Microsoft® Office Project Server 2007: The Complete Reference

Authors: Gochberg, Dave; Stewart, Rob
ISBN-13: 978-0-07-148599-9
ISBN-10: 0071485996
©2008 | 1st Edition | 647 pages , Softcover
Pub Date: January 2008
Price: US$ 59.99
Learn More

The ultimate guide to Microsoft Office Project Server 2007

This comprehensive guide takes you through the planning and implementation lifecycle of a Project Server installation. You will learn how to utilize this powerful software to set up and manage projects, allocate human as well as financial resources, track progress, and adjust activities quickly to accommodate project changes and updates.

Endorsement

“Microsoft Office Project Server 2007 is an extremely advanced and dynamic toolset requiring fundamental organizational inspection. Rob and Dave provide an equally deep and unique perspective of this powerful solution.” –Daniel T. Renier, Principal Consultant, Milestone Consulting Group, Inc.

Microsoft ® Office 2007 Business Intelligence

Authors: Harts, Doug
ISBN-13: 978-0-07-149424-3
ISBN-10: 0071494243
©2008 | 1st Edition | 444 pages , Softcover
Pub Date: November 2007
Price: US$ 39.99
Learn More

Extract and analyze mission-critical enterprise data using Microsoft Office 2007

This authoritative volume is a practical guide to the powerful new collaborative Business Intelligence tools available in Office 2007. Using real-world examples and clear explanations, Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop shows you how to use Excel, Excel Services, SharePoint, and PerformancePoint with a wide range of stand-alone and external data in today’s networked office. You will learn how to analyze data and generate reports, scorecards, and dashboards with the Office tools you’re already using to help you in your everyday work.

1. Create Excel PivotTables and PivotCharts and apply Conditional Formatting
2. Convert Excel spreadsheets into Excel Tables with Conditional Formatting and Charting
3. Connect external data to Excel using Office Data Connections and SharePoint
4. Create SharePoint dashboards that display data from multiple sources
5. Add Key Performance Indicators and Excel Services reports to your dashboards
6. Harness advanced SQL Server 2005 data analysis tools with the Excel Data Mining Add-In and Visio Cluster Diagrams
7. Generate integrated PerformancePoint Scorecards
8. Create Visio PivotDiagrams and Windows Mobile spreadsheets

All of the examples in the book can be downloaded for free by doing the following: go to www.mhprofessional.com. Click on the Computing tab. Click on the Downloads page. Click on the book’s title to download the examples.

Microsoft® Office SharePoint® Server 2007: A Beginner’s Guide

Authors: Gilster, Ron
ISBN-13: 978-0-07-149327-7
ISBN-10: 0071493271
©2008 | 1st Edition | 625 pages , Softcover
Pub Date: September 2007
Price: US$ 39.99
Learn More

Set up and administer a SharePoint Server 2007 environment

Get started on Microsoft Office SharePoint Server 2007 quickly and easily with help from this step-by-step guide. Using clear instructions, Microsoft Office SharePoint Server 2007: A Beginner’s Guide shows you how to set up and configure SharePoint Server, collect and store data, build lists and libraries, and enable enterprise search capabilities. You’ll learn how to create portals and Web pages, secure your SharePoint Server 2007 environment, and optimize performance. Microsoft Office 2007 integration techniques are also covered.

1. Install and configure SharePoint Server 2007
2. Secure your SharePoint Server network and data
3. Easily locate files and folders using the Search feature
4. Simplify data collection using forms and workflows
5. Logically organize content into lists and libraries
6. Monitor, maintain, and back up your SharePoint Server environment
7. Build Web applications and portals from reusable, modular Web Parts
8. Improve efficiency using customized views and metadata schemes
9. Seamlessly integrate with Microsoft Office Outlook 2007

Microsoft® Office SharePoint® Server 2007: The Complete Reference

Authors: Sterling, David
ISBN-13: 978-0-07-149328-4
ISBN-10: 007149328X
©2008 | 1st Edition | 788 pages , Softcover
Pub Date: September 2007
Price: US$ 49.99
Learn More

The definitive guide to Microsoft Office SharePoint Server 2007

Deploy and manage Microsoft Office SharePoint Server 2007 in the enterprise with help from this one-stop resource. Through detailed instructions, screenshots, and code samples, this comprehensive guide shows you, step-by-step, how to use SharePoint Server and make the most of all its powerful tools and utilities.

Microsoft Office SharePoint Server 2007: The Complete Reference explains how to develop a customized installation plan, configure the server for optimal performance, and administer users, documents, and content. You’ll get full details on designing feature-rich portals and collaboration sites, creating user-friendly forms and workflows, using modular Web Parts, and incorporating business data.

1. Install and configure SharePoint Server for the entire enterprise
2. Manage the server from the Central Administration site
3. Design SharePoint Server portals, websites, lists, and document libraries
4. Work with SharePoint Web Parts or build your own
5. Ensure cross-site consistency using site columns and content types
6. Create site definitions and templates using SharePoint Designer and Visual Studio
7. Build custom workflows using SharePoint Designer
8. Extend SharePoint Server using the Object Model and Event Receivers
9. Import and map enterprise information using the Business Data Catalog
10. Use the advanced services of Office Search and Excel Web Services

Endorsement

“This well-planned and well-written book offers a comprehensive reference for IT professionals, application developers and business analysts working with SharePoint applications.” – James A. Robertson, MCSD.NET, Senior Software Engineer, Applied Information Sciences

Visualizing Information with Microsoft® Office Visio® 2007

Authors: Parker, David
ISBN-13: 978-0-07-148261-5
ISBN-10: 007148261X
©2007 | 1st Edition | 448 pages , Softcover
Pub Date: April 2007
Price: US$ 49.99
Learn More

Create and distribute data-connected Microsoft Office Visio diagrams and reports

Get full details on the powerful features of Microsoft Office Visio 2007 inside this comprehensive volume. Written by Visio expert David Parker, Visualizing Information with Microsoft Office Visio 2007 demonstrates how to effectively visualize, explore, and communicate complex business information. Learn to use PivotDiagrams, Data Graphics, and Smart Tags, as well as link data to shapes and create meaningful Visio documents and reports. Plus, you’ll get vital security information, time-saving tips, troubleshooting techniques, and downloadable macros and code samples.

Essential Skills for Database Users and Professionals

1. Create shapes and link them to data
2. Summarize and analyze information using PivotDiagrams
3. Use Data Graphics, Smart Tags, and SmartShapes to reinforce information
4. Generate robust Excel, HTML, and XML reports
5. Create custom, reusable templates, stencils, and masters
6. Update and enhance diagrams with Reviewer’s comments and markups
7. Integrate Visio diagrams with other Windows applications
8. Publish and securely distribute Visio documents and summaries
9. Extend functionality using VBA macros, add-ins, and wrapper applications