Microsoft

3 posts

How To Use Excel for Seasonal Forecasting

If you have years worth of sales data, you can use that data, with the help of Excel, to predict upcoming trends and help you plan for your business. Forecasts can help you with important business decisions, such as managing staff and inventory, planning budgets, and predicting cash flow issues. […]

Using XMLA in Pentaho Reporting

Anyone who has ever actually attempted it may have noticed that Pentaho Report Designer does not natively accept XMLA as a datasource.  It is still possible, and this little guide will step you through how to do this.  We used MSSQL 2008R2 with the standard Adventure Works example data loaded.  […]

How to Use MySQL and Microsoft PowerPivot Together

Overview This document shows how an Open Source Database like MySQL can be used with Microsoft’s popular Excel plugin PoweverPivot.  Many clients enjoy the familiarity of Excel and ease of use that PowerPivot brings but the clients do not want to married with any one particular vendor in their Business […]