SHARE

Views: 180

PowerBI – Study Manager

  ||  

Guide for making a setup based on Excel and Power BI to manage and visualize studies. It provides the capabilities for in-depth management and insights on how the studies are progressing, prioritization needs, scheduling and much more. Excel provides the back-end for the visualized data in Power BI but also functions as a stand-alone studies management software.  

Table of Contents

          

     Excel            Power BI

The following guide provides step-by-step instructions for creating a studies management software in Excel with the input data visualized in Power BI. The presented data is exported from Excel and the visualizations in PowerBI will update as changes to cell data are made in Excel. 

Some key features include:

◍ The ability to manage studies in a very granular and in-depth manner
◍ The ability to modify the platform to accommodate a wide variety of needs and situations 
◍ Powerful visualization and insight capabilities
◍ Interactive and easily understandable user interface

 

Below is an example of the finished studies manager when loaded into PowerBI. Try the different functions by interacting with the elements on the canvas. By pressing this icon you can go into full-screen mode. Switch between the different pages of the report here

Press ESC to return to this page.

Below is an example of the finished studies manager when loaded into PowerBI.

Try the different functions by interacting with the elements on the canvas. By pressing this icon you can go into full-screen mode. Switch between the different pages of the report here

Press ESC to return to this page.

 

 

 

Setup Guide:

This guide provides step-by-step instructions for creating a PowerBI studies management visualization (viz). The viz will automatically update itself if the data inside any of the excel columns are changed.

Here is also a Youtube video that goes through the same step-by-step guide that is presented in written form here. 

……….

 

The tutorial has the following main sections:

 Introducing the project management sheets in Excel

  Performing the export/import

………..

Under development / More coming soon

Subscribe
Notify of
guest
1 Comment
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
trackback

is tadalafil and cialis the same thing?

is tadalafil and cialis the same thing?