Servers

    Calendar Analytics Tool

    Language:
    English
    Calendar Analytics allows users to connect to their Microsoft® Exchange Calendar and get dashboard views on meeting statistics inside Microsoft® Office Excel 2010.
    • Version:

      1.0

      File Name:

      CalendarAnalytics.zip

      Date Published:

      4/22/2011

      File Size:

      2.8 MB

        Calendar Analytics allows them to connect to their Microsoft® Exchange Calendar and get dashboard views on meeting statistics inside Microsoft® Office Excel 2010.

        With this FREE add-in, you can:

        • Automatically retrieve time spent in calendar.
        • Drive ad-hoc analysis of your meeting times by day, by hour, by categories and business priorities.
        • View information about past meetings and future scheduled events.
        • Customize your views (using slicers, DAX formulas or reference tables).
        • Access this analysis for yourself and anyone who shares their calendar full details with you.

        You can find additional information (videos, description and related links) on www.bizintelligence.tv.

        Important:
        1) Please note, that, after Installation, Calendar Analytics will manifest itself as a Microsoft® Excel 2010 file called “Calendar Analytics.xlsx” on your desktop.
        2) Please note that Calendar Analytics works only with the latest versions of Microsoft® Excel 2010 and of Microsoft® PowerPivot for Excel 2010. To download Microsoft® PowerPivot for Excel 2010, please go to www.PowerPivot.com
        3) Please note that Calendar Analytics takes advantage of Exchange Web Services (EWS). Exchange Web Services works with Exchange Server, Exchange Online as well as hybrid environments.

    • Supported Operating System

      Windows 7

        • Supported Operating Systems
          • Windows 7 Professional
          • Windows 7 Enterprise
        • Preinstalled Software (Prerequisites):
          • Microsoft® Office Excel 2010.
          • Microsoft® PowerPivot for Excel 2010.
          • Minimum of 2 GB of RAM
          • 5MB of available hard disk space
      • Microsoft® Outlook instructions
        1. Assign the appropriate category to each appointment/meeting item in your Outlook calendar.
        2. Add new categories via the "Categorize" button on a calendar appointment/meeting in Outlook.

        Microsoft® Excel instructions
        1. Open the “Calendar Analytics.xlsx” file on your desktop.
        2. Click the "Refresh Calendar" button embedded inside the "Who" or "What" worksheet.
        3. The interface will display prompting you to enter your full email address.
        4. Enter your full email address. Users with more than 1 email address may need to try each of them.
        5. Click Next.
        6. The interface will display prompting you to enter a start date and end date.
        7. Enter a start date and end date for the timeframes for the Dashboard to reflect.
        8. Click Next.
        9. The interface will prompt you for the user's aliases to add. You can add multiple.
        10. Type in users' aliases of whom you have permission (i.e. "Full details") to access their Outlook calendar and click Add.
        11. Click Next.

        Refresh the data
        12. On the PowerPivot tab in Excel, click “Update All”.
        13. Wait until PowerPivot Window has refreshed.
        14. Close the PowerPivot Window.
        15. On the Data tab in Excel click “Refresh All”.

        Category Groups
        1. In addition to relying on Outlook categories, you group them into Category Groups. This will allow you to view groups of similar Outlook categories (for instance, grouping meetings into Projects, Administrative, Personal, etc).
        2. On the Categories worksheet in Excel, enter appropriate category groups in the right hand column.
        3. In order to see changes, repeat task 12 through 15 above.

    Popular downloads

      • 01

        Microsoft® SQL Server® 2012 Express

        Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

      • 03

        Microsoft® SQL Server® 2008 Management Studio Express

        Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.

      • 04

        Microsoft® SQL Server® 2014 Express

        Microsoft SQL Server 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

      • 05

        Microsoft Power Query for Excel

        Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial