SCOM and Power View: Performance Forecasting in Power BI

If one built a short-term performance model for SCOM and converted it to long-term, then one might want to apply predictive analysis to it. Power BI provides a way to use forecasting models. I will go through the steps to get the model and views ready for forecasting as well as a simple analysis. "Introducing new forecasting capabilities in Power View for Office 365" describes more about the controls and limits.

This view shows a forecast for CPU utilization for a single server: 




A. Prepare the Data Model for Power BI

B. Modify a Line Chart in a Report View

C. Configure the Forecast


Step by step

A. Prepare the Data Model for Power BI
  1. Upload the data model (the workbook size for processing has an upper limit of 250MB as of this writing)
  2. Go to your Power BI site and navigate to the workbook location 

  3. Click then click Enable for the data model 

  4. Click Enable

  5. After the report has been enabled click Close  

  6. Add the data model to Featured Reports if desired 

  7. Click on the data model to open it
  8. Click on the HTML5 version of Power View in the lower right corner 

  9. Hover over the green arrow in the upper right corner 

  10. Click Explore the data 

B. Modify a Line Chart in a Report View
  1. Select the report view for forecasting from the tabs on the bottom 

  2. Select the line chart 

  3. Reduce the number of lines to one by unchecking values or the legend field 

C. Configure the Forecast
  1. Click Analysis  

  2. Select the line chart
  3. Click on the right arrow to expand the forecast 

  4. Change the Confidence Interval to one standard deviation 

  5. Select different tiles to see the forecast applied to the rest of the view 

  6. Review the automatic Seasonality value to see the detected data cycle 

  7. Hover over the exclamation mark in the upper left of the chart to see warnings 

Comments (3)
  1. hipertensi says:

    Solusi Tekanan darah tinggi menggunakan amazon Obat Herbal Alami Tekanan darah tinggi
    Pada saat ini tidak perlu khawatir dengan Tekanan darah tinggi, disini amazon Plus memberi solusi guna menyehatkan organ tubuh, melalui adanya Obat Tradisional maka semua keluhan anda tentang Tekanan darah tinggi sudah terpecahkan.

  2. Obat Penyakit HIV AIDS Harapanku
    Obat Herbal AIDS amazon Plus Ajaib merupakan salah satu Obat HIV terpercaya. Menurut F. Franklin L.L., sebagai konselor yang telah membuktikan khasiat Obat Alami AIDS amazon dapat memberi kesembuhan para penderita penyakit HIV AIDS. Dengan adanya Obat Penyakit
    AIDS amazon pastinya amat menolong kepada para pasien HIV AIDS supaya bisa bertahan hidup lebih lama

  3. ginjal bocor says:

    Obat Tradisional Ginjal Bocor Jus Kulit Manggis Mengobati Ginjal Bocor
    Penyakit ginjal bocor seringkali ditemui pada anak-anak yang menderita kelainan fungsi ginjal.

Comments are closed.

Skip to main content