{"id":250,"date":"2014-07-16T08:29:50","date_gmt":"2014-07-16T08:29:50","guid":{"rendered":"http:\/\/www.portatour.com\/blog\/users\/?p=250"},"modified":"2014-07-16T08:29:50","modified_gmt":"2014-07-16T08:29:50","slug":"data-analysis-in-excel-2013-new-odata-api-opens-up-new-reporting-possibilities","status":"publish","type":"post","link":"https:\/\/www.portatour.com\/blog\/users\/en\/2014\/07\/16\/data-analysis-in-excel-2013-new-odata-api-opens-up-new-reporting-possibilities\/","title":{"rendered":"Data analysis in Excel 2013: new OData-API opens up new reporting possibilities"},"content":{"rendered":"

Most computer users are familiar with Microsoft Excel. Very few know about “PowerPivot<\/strong>”\u00a0\u2013 an AddOn to Excel 2013 offering various possibilities to analyse and visualize large amounts of data.<\/p>\n

\"Excel<\/a><\/p>\n

Do you want to know, how often which customer was visited during a certain period? How the effective visit count correlates with the revenue of a customer? How the amount of total visits compares to the amount of visits with a sale? And how these figures evolve over the course of time? These are just four out of many possible questions on which you now can get an answer based on PowerPivot in combination with portatour\u00ae.<\/p>\n

Your organization has two or more portatour\u00ae users? You are portatour\u00ae administrator? You have Excel 2013 installed on your computer? Then you are all set to enjoy the new OData Excel interface<\/strong>. With the press of a button all your data (customers, appointments, and reports) of all your users can be downloaded into Excel to be analyzed in PowerPivot. Excel Version 2013 is required\u00a0\u2013 older versions are not supported. Setup instructions for administrators can be found in portatour\u00ae Anywhere menu at\u00a0Options > Excel Data Analysis<\/strong>.<\/p>\n

Note: Using pivot tables and charts in Excel requires experience in data analysis. If this is new to you, ask your IT department or your IT support. For self-studying, blog posts, video tutorials, and books can be found. Start by searching in Google, YouTube or Amazon for “Excel Power Pivot”. Please understand that we can not provide support for Microsoft Excel.<\/em><\/p>\n

We wish you great success and new insights into your data. We are looking forward to your feedback which you can send to\u00a0feedback@portatour.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Most computer users are familiar with Microsoft Excel. Very few know about “PowerPivot”\u00a0\u2013 an AddOn to Excel 2013 offering various possibilities to analyse and visualize large amounts of data. Do you want to know, how often which customer was visited during a certain period? How the effective visit count correlates with the revenue of a […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-250","post","type-post","status-publish","format-standard","hentry","category-anywhere-en"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t