Microsoft Project Server

Last updated
Project Web App (PWA) initial screen ProjectWebApp initialscreen.gif
Project Web App (PWA) initial screen
A schedule shown in PWA Project Center ProjectWebApp ProjectCenter.gif
A schedule shown in PWA Project Center

Microsoft Office Project Server is a project management server solution made by Microsoft since 2000. It uses Microsoft SharePoint as its foundation, and supports interface from either Microsoft Project (Professional edition) as a client application or by web browser connecting to its Project Web App (PWA) component.

Contents

Overview

As an extension of Microsoft Project, Project Server provides the Project Web App (PWA, formerly Project Web Access). Microsoft Project Server stores project information in a central SQL Server database, protected from unauthorized access and corruption. A Project Administrator can control security defining users and access rights.

The Project Center supports reports across an organization at the project level. Managers can drill down into project details. Tasks, Projects and Resources can have Enterprise Custom Fields defined (similar to Custom Fields in the Microsoft Project desktop application).

The project manager needs to communicate project plans and to distribute task assignments to team members. The assignment of tasks can be distributed to team member home pages in PWA. They need to communicate status and changes to keep the project manager up to date. Project Server supports electronic communication over the web via PWA. Team members can update their tasks' status via PWA and the My Tasks list or via a Time Sheet.

Resource workloads can be analyzed by project and by resource with the Resource Center, allowing organizations to forecast future resource requirements and make more efficient use of resources. Project Server also includes a resource planning module that facilitates macro-level planning of resources to projects.

The view definition is easier to understand and more robust with PWA than with Microsoft Project. Views can be protected to assist standardization. Project Server stores custom calendars, views, tables, filters, and fields, in an Enterprise Global area where users have access to the latest version every time they restart Microsoft Project.

For each published project in Microsoft Project a Project Workspace can be created. A Project Workspace is a custom Microsoft SharePoint Teamsite (built for Project Server) where the Project team can share a web version of the project schedule as well as documents, issues, risks and a list of the project deliverables.

History

Versions for Windows include:

2007

The architecture of Project Server 2007 contains significant changes.

The 2003 Microsoft Project version employed ODBC to connect to the server, which is problematic over low bandwidth and high latency connections. This problem is often skirted by remotely using a PC with the same network (LAN) as the server.

The 2007 version uses SOAP to access the server. Although this facilitates clients over low bandwidth / high latency connections, it adds a level of complexity (in the form of a Queue) that must be managed by an administrator. Specifically, a job in the queue could get stuck and block other jobs from completion. The advantage of the queue is that MS Project uses a local cache, enabling the user to continue to work on his project plan even when he is not connected to the server.

The 2007 version has 14 OLAP cubes which can be used to do Data Analysis with. It is an improvement over the 2003 version which only had 1 OLAP cube. With the new cube Calculated measures can be added to the cubes, which enables reporting on custom created fields.

Project Server 2007 features a local cache which effectively allows the user to have 2 copies of a Project Schedule. Changes made after the first save will just be synchronized rather than replacing the server copy which speeds up response times. But currently there are known cache issues.

2010

Microsoft Project 2010 adds ribbons to its user interface. Ribbons are available in other Office products, such as Microsoft Project and PWA. Other features include Project Portfolio Server, the inclusion of a "Timeline" view, which graphically represents key tasks and milestones. Another view that helps with resource management is the Team Planner, which provides a graphical view of assignments of tasks to resources. The Team Planner also shows unscheduled and unassigned tasks.

This version brought about two name changes: The word "Office" was dropped from the name of both Microsoft Project and Project Server. In addition, "Project Web Access" was renamed to "Project Web App". [1]

2013

Significant changes with the 2013 version increase what browser access can do and simplify usage: [2] [3]

Project Server 2013 and Microsoft Project 2013 are not backward-compatible with other versions of Project Server. Project Server 2013 only supports Microsoft Project Pro 2013; and Microsoft Project Pro 2013 only connects to Project Server 2013. [4]

2016

The Project Server 2016 release looks largely similar to the 2013 version, but

Related Research Articles

<span class="mw-page-title-main">Microsoft Office</span> Suite of office software

Microsoft Office, or simply Office, is a discontinued family of client software, server software, and services developed by Microsoft. It was first announced by Bill Gates on August 1, 1988, at COMDEX in Las Vegas. Initially a marketing term for an office suite, the first version of Office contained Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Over the years, Office applications have grown substantially closer with shared features such as a common spell checker, Object Linking and Embedding data integration and Visual Basic for Applications scripting language. Microsoft also positions Office as a development platform for line-of-business software under the Office Business Applications brand.

<span class="mw-page-title-main">Microsoft Access</span> Database manager part of the Microsoft Office package

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately.

<span class="mw-page-title-main">Microsoft Outlook</span> Email, notes, task, calendar software and contact management

Microsoft Outlook is a personal information manager software system from Microsoft, available as a part of the Microsoft Office and Microsoft 365 software suites. Though primarily an email client, Outlook also includes such functions as calendaring, task managing, contact managing, note-taking, journal logging and web browsing, and has also become a popular email client for many businesses.

Online analytical processing, or OLAP, is an approach to answer multi-dimensional analytical (MDA) queries swiftly in computing. OLAP is part of the broader category of business intelligence, which also encompasses relational databases, report writing and data mining. Typical applications of OLAP include business reporting for sales, marketing, management reporting, business process management (BPM), budgeting and forecasting, financial reporting and similar areas, with new applications emerging, such as agriculture.

<span class="mw-page-title-main">Microsoft Project</span> Project management software

Microsoft Project is a project management software product, developed and sold by Microsoft. It is designed to assist a project manager in developing a schedule, assigning resources to tasks, tracking progress, managing the budget, and analyzing workloads.

Essbase is a multidimensional database management system (MDBMS) that provides a platform upon which to build analytic applications. Essbase began as a product from Arbor Software, which merged with Hyperion Software in 1998. Oracle Corporation acquired Hyperion Solutions Corporation in 2007. Until late 2005 IBM also marketed an OEM version of Essbase as DB2 OLAP Server.

<span class="mw-page-title-main">Outlook on the web</span> Microsoft’s personal information manager web app

Outlook on the web is a personal information manager web app from Microsoft. It includes a web-based email client, a calendar tool, a contact manager, and a task manager. It also includes add-in integration, Skype on the web, and alerts as well as unified themes that span across all the web apps. It is included in Exchange Server 2016, and Exchange Online

<span class="mw-page-title-main">Microsoft Office 2007</span> Version of Microsoft Office

Microsoft Office 2007 is an office suite for Windows, developed and published by Microsoft. It was officially revealed on March 9, 2006 and was the 12th version of Microsoft Office. It was released to manufacturing on November 3, 2006; it was subsequently made available to volume license customers on November 30, 2006, and later to retail on January 30, 2007, shortly after the completion of Windows Vista. The ninth major release of Office for Windows, Office 2007 was preceded by Office 2003 and succeeded by Office 2010. The Mac OS X equivalent, Microsoft Office 2008 for Mac, was released on January 15, 2008.

<span class="mw-page-title-main">Microsoft InfoPath</span> Microsoft Office suite application to design rich XML-based forms

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. Microsoft initially released InfoPath as part of the Microsoft Office 2003 family. The product features a WYSIWYG form designer in which the various controls are bound to data, represented separately as a hierarchical tree view of folders and data fields.

<span class="mw-page-title-main">Microsoft Office 2010</span> 2010 version of Microsoft Office

Microsoft Office 2010 is a version of Microsoft Office for Microsoft Windows unveiled by Microsoft on May 15, 2009, and released to manufacturing on April 15, 2010, with general availability on June 15, 2010, as the successor to Office 2007 and the predecessor to Office 2013. The macOS equivalent, Microsoft Office 2011 for Mac was released on October 26, 2010.

<span class="mw-page-title-main">Palo (OLAP database)</span>

Palo is a memory resident multidimensional database server and typically used as a business intelligence tool for controlling and budgeting purposes with spreadsheet software acting as the user interface. Beyond the multidimensional data concept, Palo enables multiple users to share one centralised data storage.

Microsoft Application Virtualization is an application virtualization and application streaming solution from Microsoft. It was originally developed by Softricity, a company based in Boston, Massachusetts, acquired by Microsoft on July 17, 2006. App-V represents Microsoft's entry to the application virtualization market, alongside their other virtualization technologies such as Hyper-V, Microsoft User Environment Virtualization (UE-V), Remote Desktop Services, and System Center Virtual Machine Manager.

Azure DevOps Server is a Microsoft product that provides version control, reporting, requirements management, project management, automated builds, testing and release management capabilities. It covers the entire application lifecycle and enables DevOps capabilities. Azure DevOps can be used as a back-end to numerous integrated development environments (IDEs) but is tailored for Microsoft Visual Studio and Eclipse on all platforms.

<span class="mw-page-title-main">SharePoint</span> Web application platform

SharePoint is a web-based collaborative platform that integrates natively with Microsoft Office. Launched in 2001, SharePoint is primarily sold as a document management and storage system, but the product is highly configurable and its usage varies substantially among organizations.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

<span class="mw-page-title-main">XLCubed</span>

XLCubed is a business intelligence software and consulting services company. Established in 2001, XLCubed develops business intelligence software and provides business intelligence and performance management consulting services. The company is privately held and based out of the United Kingdom in the Thames Valley IT corridor.

<span class="mw-page-title-main">IBM Cognos Analytics</span>

IBM Cognos Business Intelligence is a web-based integrated business intelligence suite by IBM. It provides a toolset for reporting, analytics, scorecarding, and monitoring of events and metrics. The software consists of several components designed to meet the different information requirements in a company. IBM Cognos has components such as IBM Cognos Framework Manager, IBM Cognos Cube Designer, IBM Cognos Transformer.

<span class="mw-page-title-main">IcCube</span>

icCube is a company founded in Switzerland that provides business intelligence (BI) software of the same name. The software can be fully embedded, can be hosted in a managed environment or installed in a customer's machine on premises.

<span class="mw-page-title-main">Progressive web app</span> Specific form of single page web application

A progressive web application (PWA), or progressive web app, is a type of application software delivered through the web, built using common web technologies including HTML, CSS, JavaScript, and WebAssembly. It is intended to work on any platform with a standards-compliant browser, including desktop and mobile devices.

Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform. Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights. Data may be input by reading directly from a database, webpage, or structured files such as spreadsheets, CSV, XML, and JSON.

References

  1. O'Cull, Heather (15 January 2010). "PWA now stands for Project Web App". Microsoft Project 2010 blog. Microsoft. Retrieved 17 April 2013.
  2. "Project Server 2013 – What's new and what's changed?". Project Server Blogs. 25 July 2012. Retrieved 18 April 2013.
  3. "Project Server 2013 Preview - First Look". EPM Central. Retrieved 18 April 2013.
  4. "Hardware and software requirements for Project Server 2013". TechNet Library . Microsoft. 16 July 2012. Client requirements for Project Server 2013. Retrieved 6 September 2013.
  5. "Project Server 2016—born in the cloud". 5 May 2016. Retrieved 2 Aug 2017.
  6. "Whats new in Microsoft Project 2016?" . Retrieved 4 May 2016.
  7. "Microsoft Project 2016 details on the new version" . Retrieved 4 May 2016.
  8. "What's deprecated or removed in Project Server 2016" . Retrieved 1 Aug 2017.
  9. OFFICE 365: Business Intelligence Reporting In Project Online With Power BI And Excel FaceofIT.com

<LOGOUT>user-release</LOGOUT>