Pasar al contenido principal

Data Automation: 1-Wk Workshop

Clouds On Mars

Analysis and data refresh automation for an existing Power BI report or dashboard to ensure the data is always up-to-date.

This 1-week engagement is to ensure that your Power BI dashboard always shows fresh data.

First, we analyze the existing process for loading source data, then we provide the setup of the Power BI components for an automated data refresh process.

The process will run on a scheduled time basis or by direct query into the data source accordingly to business needs and most effective technical architecture (we prefer to automate based on Azure, OneDrive or Office components like Excel, but will help with any data source supported by Power BI).

Agenda

Day 1 & 2

Current state analysis of data architecture, business process and data sources for your Power BI solution including the desired schedule for an automated process.

Day 3 & 4

Design and implementation of the automated process of data refresh in your Power BI environment.

Day 5

Testing and fine tuning of the configuration, hands-on workshop for future administrators.

Deliverables

  • Dynamic, always fresh Power BI report or dashboard .
  • Configurable data refresh process working based on desired schedule.

Note

  • As an extension of the implementation we offer an extended service of continuous remote monitoring of your Power BI dashboard done on a daily basis with a range of automated and manual checks.
  • When possible, we will fix issues overnight, which will ensure high availability of your Power BI dashboard and continuous high quality data refresh.
https://gallery.azure.com/artifact/20151001/cloudsonmars.cloudsonmars_8_us_data_refresh_automation.1.0.0/Artifacts/SampleImage/c2d8ac99-19f8-4aa3-bc8c-6740b603c956.png
https://gallery.azure.com/artifact/20151001/cloudsonmars.cloudsonmars_8_us_data_refresh_automation.1.0.0/Artifacts/SampleImage/c2d8ac99-19f8-4aa3-bc8c-6740b603c956.png
https://gallery.azure.com/artifact/20151001/cloudsonmars.cloudsonmars_8_us_data_refresh_automation.1.0.0/Artifacts/SampleImage/5d343767-63a7-41fc-a434-7b6f5a4fae2b.png
https://gallery.azure.com/artifact/20151001/cloudsonmars.cloudsonmars_8_us_data_refresh_automation.1.0.0/Artifacts/SampleImage/9329b229-797b-4f18-a85e-ef2f60c93449.png
https://gallery.azure.com/artifact/20151001/cloudsonmars.cloudsonmars_8_us_data_refresh_automation.1.0.0/Artifacts/SampleImage/8b9a0a9e-94ff-4cb0-906f-e6e84e319cb4.png
https://gallery.azure.com/artifact/20151001/cloudsonmars.cloudsonmars_8_us_data_refresh_automation.1.0.0/Artifacts/SampleImage/0ec280f1-fcae-4a2c-bee8-247ac16bec00.png