Microsoft today announced new forecasting capabilities in Power View for Office 365 users. Power View performs advanced statistical analysis of the data in your line charts to generate forecasts that incorporate trends and seasonal factors. So how does forecasting work? Forecasting in Power View is based on an established suite of methods for time series prediction called exponential smoothing. Over the years many methods have been developed for the analysis of time series, depending on whether the data is strongly seasonal or has no seasonality, how much noise there is in the data, and whether the data contains “surprises” or irregular peaks. In Power View, you can now apply predictive forecasting, and hindcasting, when visualizing and exploring your data. Forecasting in Power View utilizes built-in predictive forecasting models using exponential smoothing to automatically detect seasonality in the data to provide forecast results from a series of data. Explore forecast results by ...

Read More →

Microsoft today announced the general availability of Power BI for Office 365. Power BI for Office 365 is a self-service business intelligence solution designed for everyone. Power BI empowers all kinds of business users to find relevant information, pull data from Windows Azure and other sources, and prepare compelling business intelligence models for analysis, visualization, and collaboration. With this release, we are delivering completely new experiences to customers. For example, Power Query in Excel allows you to easily search and access data within your organization or from publically available sources. In addition once you upload your Excel workbooks to Power BI, you can ask questions of your data using natural language search and instantly receive answers in the form of interactive charts or graphs. Power BI will be added to the list of features that Google Apps and other productivity suite customers will never experience in the near future. Office ...

Read More →