SharePoint has become a de-facto platform for storing and sharing business data in lists, document libraries etc. But unlike the ease of reporting and running statistics on relational database, SharePoint on its own does not provide such flexibility when it comes to extracting business intelligence. Due to this limitation, often, managers might find themselves spending a lot of time and resource in exporting data to spreadsheet, and performing manual computation and parsing. Some organizations even use specialized data professionals and a dozen different software packages, just to produce simple reports. Worst, if the report doesn’t have the required information, you will have to start over, wasting precious time.

As there is a time and expense involved in getting answers from SharePoint lists, a lot of business intelligence information often goes unused, due to that fact that, SharePoint is designed to store data, and not to help you analyze it.

Mining intelligence and insights from data stored in SharePoint

The AssistMyTeam OLAP tool for SharePoint, is designed to give you a simple and yet powerful tool to configure OLAP cube from your SharePoint lists, and then analyze and create reports straightaway, out of the box. It is perfectly suited to spot new trends and discover unknown problems from your data that are stored in SharePoint lists.

In the OLAP SharePoint Manager tool, you can enter the URL of your SharePoint site (e.g.. http://companyweb/) to show up all the available lists in a hierarchical tree from which you can select a particular SharePoint list to configure for OLAP Cube. Alternatively, you can also enter the URL of the particular SharePoint list (e.g.. http://companyweb/Lists/Tasks/AllItems.aspx) to directly load the available fields in the grid for cube configuration. With either techniques, you can choose which SharePoint fields to include in the cube. You can also set aggregate function for the measure fields or define new derived fields such as a hierarchy or a calculated field.

You can add your own derived OLAP fields such as a composite hierarchical field (e.g.. Project-Task) or a calculated field (e.g.. Total Project Budget), based on existing SharePoint fields. For easy recognition, derived fields are distinctly colored and highlighted (in green).

New OLAP composite dimension – E.g. Project – Task

New OLAP calculated member – E.g. Total Project Budget

Once you have chosen which fields or dimensions to include in the statistic, you can select aggregate functions such as count, distinct count, sum, average, maximum or minimum for those numeric or currency fields, so as to set them as ‘measures’ in the OLAP cube.

When you click the ‘Run Statistics‘ button, it would generate a cube, which will be loaded in the OLAP Statistics tool that consists of the Grid and Chart Views as shown below. This OLAP Client tool, consists of the Grid and Chart Views. On the left is the Cube structure – measures and hierarchies as a tree. The measures are grouped in the set, displayed in the branch. All the rest of the tree nodes are the dimensions that contain hierarchies. You can then drag dimensions (fields) from the cube structure to the pivot areas (Columns and Rows areas), and then select a measure or two from the cube, and drag it to the values area to generate the statistics.

OLAP Grid

The OLAP Client Grid view (above) is comprised of a multi-dimensional table with expandable nodes. These nodes group and display data according to the hierarchies used to define the measures and dimensions upon which the underlying data has been organized. In tandem with the OLAP Chart view, the OLAP Grid view provides an ideal means of clearly conveying data to the user. It is highly navigable and quickly provides detailed information to the user. The speed with which data recall occurs and the strong formatting the grid enforces ensure data is always presentable and easily understandable. Consequently, OLAP Grid views can easily be ported to spreadsheet applications for report compilation purposes.

You can navigate through these dimensions by drilling down, rolling up, or drilling across. You can drill down to access the detailed level of data, or roll up to see the summarized data. You can roll up through the hierarchy levels of dimensions or to specific characteristics or data elements (columns) of the dimensions. You can also drill across dimensions to access the data of interrelated dimensions. In addition, you can set one of these powerful computational functions such as sum, averages, distinct count, maximum, minimum etc. for the measure field.

OLAP Chart

While the Grid view (below) allows working with numbers, chart view allows representing your data graphically. This gives you and your team a unique opportunity to analyze data visually, dealing with charts rather than numbers, which is much easier to perceive. Now it’s easier than ever to spot new trends and discover unknown problems in your data flow. The statistical tool will help you gain an insight into your data and make new discoveries.

Exporting to file

After a particular snapshot of the statistics is achieved, If you need to share or publish the statistical findings, export it to image, PDF, Excel etc, or print it.

 
You also have the options to save the pivot settings to file, for accessing the same snapshot in future. If your database is located on a network, you can also save the cube data to file such that you can work offline with the cube, even when the database is not available, or when the network is disconnected.

Benefits

AssistMyTeam OLAP tool for SharePoint provides managers with the unique ability to explore large complex data from your SharePoint and allows displaying in grids, charts and graphs and support most common operations such as pivoting, drill down/slice and dice, filtering etc. With such arrays of information, you and your management team can re-engineer your business processes, reinforce resources and forecast problem areas and exploit all these factors for competitive advantage. With the capability of complex calculations, trend analysis and sophisticated data modeling, and reporting, OLAP tool helps you to identify critical information on your not so obvious data and extract mission critical information and intelligence that will enable better decision – in your business.

To get more info about the tool, you can visit – https://www.assistmyteam.net/OLAPSharePoint/

 

Many organizations have the requirement to store emails data from PST or mailboxes to an external database for varied reasons – for integration with CRM suites, to generate reports or statistics, or simply for redundant backup, archival or audit purposes to mention a few. However, there is no direct way of exporting emails data from Outlook to a database. That is, Outlook’s built-in Import and Export wizard only supports export of Outlook data to excel or a PST file.

Connecting Outlook to database for seamless export

The AssistMyTeam Database Exporter add-in for Microsoft Outlook is designed to overcome this limitation (i.e., the inability of the Outlook’s built-in ‘Import and Export Wizard’ to export data to an external database), by allowing you to export any kind of data, including custom fields, to a database, in a simple click, or even better, on the fly with no intervention from the user. There are 3 ways of exporting Outlook data to an external database:

1. Exporting items of an Outlook folder to a database

To export the contents of an Outlook folder, click the ‘Export to DB’ button as shown below. You will be shown with the ‘Select Fields’ dialog, with which you can opt which form to be used for displaying the available fields.

By default, the first option ‘Retrieve from the first item’ is selected, and what it does is, to probe the first item of the folder and automatically seek out all the available fields, including any number of user defined custom fields. It is recommended that you stick with this option of displaying the fields, unless, you want to retrieve Outlook specific fields only (second option), or want to use a particular custom form out of many defined for that Outlook folder (third option).

2. Exporting items including those in subfolders

By default, when you export the contents of an Outlook folder using the ‘Export to DB’ button, only the items of the current folder is taken into account. Items inside the subfolders (if any) are excluded from the export. Below are a few export options available.

  1. When exporting to database, include all items from subfolders
    When you choose to export the contents of an Outlook folder, enable this option to include items in subfolders of any number of levels. For example, below, the current folder is ‘My Company’. When exporting this to database, if you had checked this option, the contents of the subfolders such as ‘Bookings’, ‘Cases’, ‘Ongoing’, ‘Customers’ etc, will also be exported to the same database.
  2. Export all data from all subfolders to a single table
    Export all the items in the current folder, as well as those in subfolders in the same/single table, using this option. With this, the fields that you had chosen for the current folder will be applied to all the items in the subfolders as well.
  3. Export data of each subfolder to separate table in same database
    Another option is to export items in each of the subfolder to a separate table. This gives more flexibility in configuring the field options of the subfolders to be exported. For example, you can set the same chosen fields as that of the root folder, or use the default form for that subfolder, or even better, probe the first item of the subfolder to seek out the available fields. The latter option comes handy if you have user defined fields available on the folder or the item level.

3. Automation – Monitor Inbox for live export to database

Database Exporter supports real-time monitoring of any number of Outlook folders (can be a public folder or shared mailbox folder too). This will automatically process incoming mails or newly added appointments, tasks or contact items and add the data for the chosen fields to the database, without any intervention from the user. This automation would be particular useful, if you want to maintain a parallel copy or backup of your current Outlook items. This spares you from having to do that laborious work of copying and pasting the data from Outlook to database manually.

Automatic export works by allowing Database Exporter add-in to monitor selected Outlook folders (can be a shared or a public folder too), such that, when new emails are received or new appointments or tasks are added, Database Exporter automatically processes those items in real time and extract relevant data and add them to a pre-configured database. Each folder would have exactly one database each.

If you enable this option ‘Automatically update DB record when Outlook item is updated/changed’, whenever an existing Outlook item on a monitored folder is edited and saved, instantly the changes will also be reflected in the corresponding record in the database. This feature enables you to maintain synchronization between the Outlook items and the records in the database, on the fly, with no manual work.

If the Outlook folder is monitored for auto export and the option ‘Removing database record on item deletion from Outlook’ is checked, a delete button appears in the Database Exporter toolbar that enables you to delete the unnecessary Outlook items and at the same time, remove the corresponding database records automatically.

Benefits

  • Seamless integration with Microsoft Outlook
  • Export the contents of the Outlook folder to a relational database such as MS Access (MDB), Azure SQL, and all versions of SQL Server (including Express editions)
  • Support pre-defined Outlook fields as well as custom fields defined for that folder
  • Choose any customized form defined for that Outlook folder Supports POP, IMAP, Exchange mailbox and Public folders
  • Export all kind of Outlook items – mails, posts, appointments, tasks, journals or contacts
  • Optionally include items from the subfolders in the export, either to a single table or to separate table for each subfolder
  • Supports export of notes (Plain Body or HTML Body of the Outlook item, including task, appointment and contact item).
  • Real-time monitoring of incoming emails/new items of an Outlook folder, and automatically export the data to a database
  • Special MSI installer available for enterprise wide deployment (upon request)
  • Support for Office 2016 and 64 bit Versions
  • Support export to Microsoft Access and Microsoft SQL Server and cloud based Azure SQL

The Database Exporter addin works in your Exchange Public folders or PST just as fine as it does in your Inbox. To get more info about the tool, you can visit – https://www.assistmyteam.net/DatabaseExporter/

 

SharePoint has become the de-facto sharing platform for teams in organizations; storing business and transactional data on lists, document libraries etc. But unlike the ease of reporting and running statistics on relational database, SharePoint on its own does not provide such flexibility when it comes to querying and building reports. Due to this limitation, often, managers might find themselves spending a lot of time and resource in exporting data to spreadsheet and performing manual computation and parsing. Some organizations even use specialized data professionals and a dozen different software packages, just to produce simple reports. Worst, if the report doesn’t have the required information, you will have to start over, wasting precious time.

As there is a time and expense involved in getting answers from SharePoint lists, a lot of business intelligence information often goes unused, due to that fact that, SharePoint is designed to store data, and not to help you analyze it.

Connecting SharePoint to database for seamless export

The AssistMyTeam Database Exporter app for SharePoint is designed to give you a simple and yet powerful tool to let you replicate your SharePoint list data to a relational database for archival or reporting purpose.

In the Database Exporter tool, you can enter the URL of your SharePoint site (e.g.. http://companyweb/) such that it would show up all the available lists in a hierarchical tree from which you can select the particular SharePoint list for replication to relational database. Alternatively, you can also enter the URL of the particular SharePoint list (e.g.. http://companyweb/Lists/Tasks/AllItems.aspx) to directly load the available fields in the grid. With either techniques, you can choose which SharePoint fields to include in the export.

Before you can export a SharePoint list to a relational database, you are required to choose which fields of the list are to be included into the export. You do this by checking the corresponding check-box of the third column ‘Include in Database’. If you want all fields to be included, you can click ‘Select All’ option located at the bottom.

To export the selected SharePoint list with data of chosen field, click ‘Export to Database’. This will pop-up the database option dialog box, where you can choose the database type, name and specify the path and credentials etc.

A snapshot of replicated tables and their corresponding data in MS SQL Server from the SharePoint lists.

Benefits

  • Works with WSS, MOSS, SharePoint 2010, 2013, 2016 and Office 365
  • Support almost all data types used in SharePoint list Choose your own fields for inclusion to the database export
  • Supports export to relational Microsoft databases such as Microsoft Access (MDB)Microsoft SQL Server including Express editions, and Microsoft cloud based Azure SQL
  • No SharePoint list view threshold issues (i.e., limit of 5000 items) .
  • Install on any Windows PC or server, virtual or physical, and does not require any changes to SharePoint. Optimized for Office 365 SharePoint Online.

To get more info about the tool, you can visit – https://www.assistmyteam.net/DatabaseExporterSharePoint/

 

Managers often find it difficult to get the correct insights from their emails, appointments or tasks that are tagged with projects or some business data. Though Outlook views are excellent way of presenting information in a more obvious way in folder, it does not give you the summarized data that one needs often, to see broader trends based on aggregation, and to see these trends broken down by any number of variables. Given that the generalization of information using Outlook views are constrained by a few fields (or dimensions) at a time, it is hard to fully evaluate a complex set of answers without the ability to inspect each dimension in detail, while at the same time, preserving context eliminating all guesswork.

Mining intelligence and insights from Outlook emails, appointments or tasks

The AssistMyTeam OLAP tool for Outlook is designed to give you a simple and yet powerful tool to configure OLAP cube from your mailbox, and then analyze and create reports straightaway, out of the box. It is perfectly suited to spot new trends and discover unknown problems from your Inbox, Calendar or Task folders. The tool allows you to define any field as the measure with different function – sum, count, distinct count, maximum, minimum etc, against which statistics is to be executed. Real strength of this tool is its ability to examine and view data in ways not ordinarily possible. By allowing varying levels of granularity during data inspection and visualization, a lot of information can be revealed that would otherwise be hard to attain. Now it is easier than ever to spot new trends and easily answer many of the perspective information which otherwise are hidden.

AssistMyTeam OLAP tool for Outlook

On every outlook folder, you will find the OLAP toolbar, containing two buttons – first one enables you to choose which fields or dimensions (including user defined ones) to include in the statistic. It also lets you define which fields will act as ‘measures‘ in the function column. Selected fields and other settings are saved for that specific folder so that when you come back to this folder next time, it will show the same selected fields.

AssistMyTeam OLAP Client tool

As seen in the screenshot above, user-defined fields are distinctly highlighted for easy recognition. For example, States, TotalCost, RegionWise are user-defined fields in this task folder. You can also add new OLAP fields – a composite (also known as hierarchy) or a calculated field, based on the existing member fields of Outlook. OLAP fields are also colored differently for easy recognition (e.g., green)

New OLAP composite dimension – E.g., Projects per Country

New OLAP calculated member – E.g., Projects Total Cost

Then you can run the statistics tool from the toolbar or from the fields selection dialog. Depending on the number of folder items, it might take a few seconds to generate the cube from the Outlook folder, before loading the OLAP Statistics tool, as shown below.

When you click the ‘Run Statistics‘ button, it would generate a cube from the particular Outlook folder (e.g., Inbox or Calendar), which will be loaded in the OLAP Statistics tool. This tool consists of the Grid and Chart Views. On the left is the Cube structure – measures and hierarchies as a tree. The measures are grouped in the set, displayed in the branch. All the rest of the tree nodes are the dimensions that contain hierarchies. You can then drag dimensions (fields) from the cube structure to the pivot areas (Columns and Rows areas), and then select a measure or two from the cube, and drag it to the values area to generate the statistics.

OLAP Grid view

The OLAP Client Grid view (above) is comprised of a multi-dimensional table with expandable nodes. These nodes group and display data according to the hierarchies used to define the measures and dimensions upon which the underlying data has been organized. In tandem with the OLAP Chart view, the OLAP Grid view provides an ideal means of clearly conveying data to the user. It is highly navigable and quickly provides detailed information to the user. The speed with which data recall occurs and the strong formatting the grid enforces ensure data is always presentable and easily understandable. Consequently, OLAP Grid views can easily be ported to spreadsheet applications for report compilation purposes.

You can navigate through these dimensions by drilling down, rolling up, or drilling across. You can drill down to access the detailed level of data, or roll up to see the summarized data. You can roll up through the hierarchy levels of dimensions or to specific characteristics or data elements (columns) of the dimensions. You can also drill across dimensions to access the data of interrelated dimensions. In addition, you can set one of these powerful computational functions such as sum, averages, distinct count, maximum, minimum etc. for the measure field.

OLAP Chart view

While the Grid view (below) allows working with numbers, chart view allows representing your data graphically. This gives you and your team a unique opportunity to analyze data visually, dealing with charts rather than numbers, which is much easier to perceive. Now it’s easier than ever to spot new trends and discover unknown problems in your data flow. The statistical tool will help you gain an insight into your data and make new discoveries.

Exporting to file

After a particular snapshot of the statistics is achieved, If you need to share or publish the statistical findings, export it to image, PDF, Excel etc, or print it.

You also have the options to save the pivot settings to file, for accessing the same snapshot in future. If your database is located on a network, you can also save the cube data to file such that you can work offline with the cube, even when the database is not available, or when the network is disconnected.

Benefits

AssistMyTeam OLAP tool for Microsoft Outlook provides managers with the unique ability to explore metadata and project information stored in emails or appointments in multidimensional view in the form of grids, charts and graphs. With support most common operations such as pivoting, drill down/slice and dice, filtering etc., you and your management team can re-engineer your business processes, reinforce resources and forecast problem areas and exploit all these factors for competitive advantage.

To put in perspective, this OLAP tool can:

  • Represent Outlook fields (including custom fields) as OLAP dimensions, which are naturally interrelated through functional subject areas.
  • Provide an OLAP Grid view with support for a multi-dimensional table with expandable nodes. Unique features of control allows for building the OLAP-reports of the exceptional level of complexity.
  • Provide an OLAP Chart view that allows representing the data graphically. This gives you a unique opportunity to analyze your business data visually, dealing with charts rather than numbers, which is much easier to perceive.
  • Enable you to navigate through these dimensions by drilling down, rolling up, or drilling across – drill down to access the detailed level of data, or roll up to see the summarized data. Roll up through the hierarchy levels of dimensions or to specific characteristics or data elements (columns) of the dimensions. Drill across dimensions to access the data of interrelated dimensions.
  • Provide powerful computational functions such as sum, averages, distinct count, maximum, minimum etc. for the measure field (when creating the cube).
  • Allow you to save the current state of the statistics in the Grid/Chart working area to a report view file, with specific member fields on the pivot panels (Rows and Column areas) and measure fields in the values area. You can use this report view file in future, to retain back the same state of statistics.
  • Support exporting reports to a wide range of formats including Excel, Adobe PDF, XML, bitmaps or web pages.

To get more info about the tool, you can visit – https://www.assistmyteam.net/OLAPOutlook/

 

For many managers, the collection and processing of timesheets can be a slow and labor intensive work. And employees hate to fill out timesheets – a common universal fact which makes supervisors and managers constantly struggle to adopt an effective and accurate time tracking in the organization. No doubt, they find it frustrating again and again, when they have to nag their staffs to submit timesheets. The consequence is that organizations land up spending considerable human and IT resources alone in performing checks, authentication and reviews to avoid incorrect data slipping through and creating payroll errors. Evidently, organizations need to devise a better solution that supports the way employees prepare and submit timesheets and do not hinder it. A solution that is easy to use and require little or no training at all.

Leveraging Outlook for timesheet collection

In today’s business workplace, most staffs already use Microsoft Outlook extensively – all day, every day for email communications, meetings and contacts. So having a time tracking solution that can easily integrate with Outlook and fits with employees ways of working today, can be just the key to overcoming and solving many of these challenges. And this is one of the main feature of this Microsoft Outlook add-in ‘Team TimeSheet for Outlook‘ that makes it very easy for employees and workers to prepare timesheet and project deliverables in Outlook and publish to a central database.

From the dedicated timesheet form, individual worker can prepare timesheets, tag project metadata and enter other deliverables from the familiar interface of Outlook appointment or task items. Once a timesheet is finalized and ready, it is published to the central database in just a single click. This submission process is seamlessly integrated in your Microsoft Outlook and the whole exercise is transparent to the user.

Leveraging the familiar workflow of Outlook appointments and tasks, this timesheet add-in extends your Outlook as an ideal platform to work, plan on projects and tasks and allows for quick reporting of timesheets, expenses and billing, notes and other intrinsic data to a central database repository.

Streamline timesheet collection and reporting process in the organization

To avoid critical data falling into the cracks leading to information loss and introduce inconsistency in timesheets, expenses or billings, this add-in provides a centrally administered control panel from which projects, tasks, timeline and automated notification emails are deployed to all the members across the organization through Outlook. When member works on project related tasks via Outlook, the timesheet add-in can automatically set the timeline (such as start, due or end date) of the Outlook item with those defined for the particular project.

As timesheets and project deliverables are collected from Outlook items in a standardized structure, there is no separate control process that is required for verifying data format and accuracy, thus saving time, efforts and resources.

Automatic emails notification to workers and managers

Automatic email notification and alerts are essential for keeping team members and managers informed with the progress of the project and tasks. This TimeSheet add-in offers a whole lot of notification options for different reporting events such as when a report is submitted, updated or withdrawn, or when a manager is assigned to the project, or when the audited report is approved or declined etc. Furthermore, these notifications can be fully customized using templates. Automatic emails and alerts are send out directly when a relevant event occurs and the whole exercise is transparent to the users.

Keep Project information fully synchronized among members

One of the challenges of project management is deploying projects and their deliverables at the right time to the right people. This add-in provides real-time transparency to all members to all the projects by keeping all vital project information fully up to date from the central database. On every Outlook startup, the add-in can be set to synchronize the administrator defined projects, tasks, custom fields and other global settings. This is particularly useful to automatically retrieve any new projects/activities or settings that were added or changed by the administrator in due course.

When new projects are added, team members are notified by email automatically informing about the availability of the new projects and their deliverables. Optionally, expired projects can be made unavailable to all members automatically. If members try to submit their timesheets or deliverables on the expired projects, they can be warned and void the reporting.

Control how workers use Outlook for project deliverables

When collecting timesheets and project deliverables from workers, consistency and accuracy of the reported data satisfying the organizational standard is crucial. Administrators can apply certain restrictions in the way the Team TimeSheet functions in Outlook such as,

  • the ability to report project deliverables from the default calendar or task folders only, or from any folder.
  • the ability to update existing published timesheet data.
  • the ability to cancel and withdraw published timesheet.
  • the ability to check for minimum work compliance.
  • the ability to prevent reporting of timesheets for expired project.

Color coding of timesheet items

Color coding an appointment or task item in Microsoft Outlook makes it easy to distinguish between various items on your calendar or task. By color coding your Outlook items, you can scan quickly and tell what types of appointments or tasks you have coming up. It also helps you to distinguish between various work projects at first glance. From the manager add-in, each project can be assigned a unique color code from the supported 25 colors in Outlook. If you enable this option, all the projects with color codes will be added to the ‘Master Category List’ of your Outlook.

Once the projects with color codes are imported to your Outlook, when you tag an Outlook appointment or task item with a project, the corresponding color code would be applied automatically. As this color code is deployed centrally, all members working on projects would have same uniform color coding for the entire team.

In Outlook calendar, appointments tagged with different projects are color coded.

Outlook views especially geared for effective project tracking

Outlook views are a wonderful tool to automatically sort, quickly find information and rapidly re-arrange Outlook items in any folder. Views can also be organized to group and filter items to make a particular feature of your information obvious at first glance. This TimeSheet add-in provides special Outlook views to help you to work with your projects and deliverables in a simpler and sensible way.

Table view of Outlook calendar folder, where all the appointments are grouped by the reported state. Reported timesheets will be group under ‘Yes’ and unreported items under ‘No’ or ‘None’. You can easily differentiate reported items from the unique ID value.

Table view of Calendar folder, where all the appointments are first grouped by project, and then sub-grouped by activity value, to generate a hierarchy tree representation and may prove useful to track and pinpoint a specific project or activity, or to get the number of items belonging to a specific project or activity, or simply just to have a listing that is better organized and summarized.

Offline Support

Supports offline mode with Outlook, allowing coding of time and expenses while away from the office. In leveraging the Microsoft Outlook platform for time and expense reporting, this add-in also offers an ideal billing solution for distributed organizations – companies with multiple locations or employees who travel on a regular basis. Through their Outlook client, team members can work on the time sheets and other deliverables of the projects in Outlook in offline mode wherever they are located. Once the timesheeets and project deliverables are ready, workers can submit time sheets when they are connected to the database server.

Audit Manager to accept or reject timesheets

After a time sheet is submitted, it can be routed to the appropriate supervisor, eliminating delays in the approval process. With Audit Manager module of the add-in, a time sheet can be approved with the click of a button or sent back to the particular member for revision. Additionally, instead of rejecting a report, supervisors and managers can also choose to make amendment to project, task or cost directly and can approve to prevent delays and meet deadlines. Notification emails on approval or rejection are automatically sent out to the concerned member.

Reporting, Charting, and Data Analysis – multi-dimensional OLAP

With the integrated Online Line Analytical Processing (OLAP) tool, managers can analyze submitted timesheets and other project deliverables in multidimensional view to extract critical information and intelligence that will enable better decision in business. The integrated OLAP tool supports the ability to explore large complex data sets and allows displaying in grids, charts and graphs and support most common operations such as pivoting, drill down/slice and dice, filtering etc. It’s simplistic point-and-click interface will ensure managers easily achieve the high-level views of information they require. Additionally, creating reports destined for different management levels is a simple task – and eliminates the manager dependence on IT personnel.

OLAP Grid with a pre-defined report view (Total Cost per Project per Member)

By unifying data analysis needs on a single platform, it provides an unparalleled array of reporting tools for web portals, intranet applications, websites, and other data-rich applications. It also provides more then 30 inbuilt reports geared towards providing out-of-the-box. Managers can also easily create and save their user-defined reports for future references. Any report, chart, grid or graph can be saved to PDF, images, web pages or printed.

OLAP Chart view with customized color code for the Work dimension.

Summary

Compared to a similar system based on Excel or the web, this timesheet add-in provides substantially better range of functionality for time reporting. Leveraging the familiar workflow of Outlook appointments and tasks, it simplifies timesheet creation, submission and tracking for employees, yet offers managers and administrators greater control throughout the time reporting process. With the assurance that team members are reporting through a regulated system such as Outlook, that promotes accurate, consistent time reporting, managers can leverage precise, up-to-date budget and billing reports for project estimation and budgeting. The end result is a reduced administration costs and little or no requirement of specialized skills and user training. Your team members are productive within minutes after installing and setting up the application in their Outlook. Because of this, user adoption is maximized, yet training time and costs are minimized. More importantly, reporting process of work done and expense is streamlined for all employees, resulting in a highly accurate and scalable solution for the organization.

Who should use it?

This timesheet solution is ideal for organizations looking for an enterprise time and billing management solution with Microsoft Outlook integration. Project Managers, will find it easier to distribute projects, timelines and calculate expenses and track budgets for current and past projects. Human Resource Managers can easily calculate work done and payroll for staffs and contractors without using an expensive ERP suite. With summary and OLAP reports, Analysts and Accountants would have access to budget information, accurate to the last number. Freelancers can easily calculate the exact hours and expenses to bill their employers.

To get more info about the tool, you can visit – https://www.assistmyteam.net/TeamTimeSheet/

© 2018 bahrurBlog
AssistMyTeam