Power BI Gant Analysis

Today Power bi have a new Custom Visual, the gant analysis!

It’s an interesting visualization, permit to show to your customer in a new dynamic way  the status of a project:

3.PNG

To use it you have to prepare a dataset with:

  1. List of task of the project
  2. Starting date ( in date format)
  3. Duration of task ( in numeric format, visual create in automatic the end date)
  4.  Resource that work in the task
  5. % Complete, work only with a percentual value and not decimal

These values on power bi have to be inserted like this:

4

Here is a sample file for you to try it out this new custom visual in Power BI .

Annunci

Gap Analysis Visual

Some days ago was realease a ne interesting Custome Visual that i suggest you to use, The Gap Analysis. This particular visual permit user to answer visually question like :

  • · Did one Customer Group respond more favorably to a certain Product category?
  • · Was there a large gap between two different Sales person for a specific Area?
  • · Was the large gap in our most important Product Category?

By visualizing the relative positions of the group on a scale, the distance between the two circles indicates the gap whilst the ordering of the circles indicates which group was greater than the other:

1.PNG

It’s very simple to use:

  1. In the statement goes the value that you want on the left, for example the period of comparison, in my case day of week
  2. IN the groups to compare goes the Attribute that you wanto to compare, if you have more than 2 attribute create a filter and select only 2 attribute, in my case weather website
  3. In the values goes the imput thant you want to compare, in my case mm of rain

2.PNG

Some tips:

– To order the categories, drag a measure / value you would like to order the categories by into the “Sort statements by”

– If you want all the labels to sit under the bars, go to the formatting pane -> Gap Label -> Position -> Below

Power Query Import PDF

Recently I found myself having to import data from a PDF file inside a powerpivot model. This particular format is not supported by PowerQuery, that it is the princial ETL system for power bi.

Searching online and trying different solution i founded a working solution. To use this particola solution you have to convert PDF in other format. If you have Word 2013 it’s very symple to do.

  1. Open the PDF document from Word 2013. You can choose to show only the PDF files to speed-up your search.
  2. Click ok to the message warning you that Word will convert the PDF document in editable Word document.
  3. Activate the editing if word ask you.
  4. Now, save as the document to Web Page (HTML) format. That’s what permit us to import it in Power Query.
  5. Close Word and Open Excel
  6. Select the Power Query tab and choose the « From Web » option.
  1. A dialog window will ask for an URL address. This URL can be a local file, select you file just saved.
  1. The Navigator will appear on the right, displaying the multiple tables found on that page, select what you interested in and import in powerpivot.

 

That’s all. You can use different program to convert PDF in html, you can use for example this site : http://www.convertpdftohtml.net/ or  use C# library, for example this http://www.rasteredge.com/how-to/csharp-imaging/pdf-convert-html/.