Chants of big data & bigger insights


My Calendar Insights

#PowerQuery: New Calendar Template with Categories and better Recurring calc

I have updated the Calendar Template to include Categories and better calculation of recurring meetings.

Calendar Template v2.2

Note: This is no longer the official template under File–>New, but an improved one. Microsoft may consider using it in the future version, but I am no longer there to push it through 🙂

Help me improve it by sharing your feedbacks.

Happy new year!



My Calendar Insights in Excel 2016

This week we have announced on Office Blogs the release of 3 new Excel templates that harness advanced data analytics technologies in Excel 2016:

  • Power Query (Excel 2016 new get-data and transformation features that are available in the Get & Transform section of the Data tab).
  • Power Pivot measures.

You are welcome to try out the new templates and examine their queries and DAX formulas. The templates are available in File –> New section of Excel 2016.


If you can’t find the template in File –> New, you can download it from TechNet Gallery here.

Continue reading “My Calendar Insights in Excel 2016”

Blog at

Up ↑