Wednesday, December 13, 2017

Power BI: Data Visualization with Data Bars

Looking at a bunch of data does not give a feeling for the big and small values without making comparisons by reasoning. This next table is trivial in that you can easily see the small and big values. However I have chosen this to make the explanation easy to understand.

This comparison is built into the idea of presenting data bars in Microsoft programs such as MS Excel and Microsoft SQL Server Reporting Services 2012.

In the June 2017 version of Power BI Desktop which is in preview 'Data Bars' are supported. What Data Bars do is to show visually how big or small data values are. Here is an example from my previous post how the data is visualized after adding Data Bars.

Four types of Data Bars are shown in the above: Data Bars, Color Scales, Icon sets and 'Above average' types.

In the present version this is how 'Data Bars' feature is implemented.

I have imported the same data as in the previous post into Power BI using 'Get Data'.

I added the two fields 'State' and 'Item Value' into the fields as shown above.
 I had to rename 'State' to 'St' as 'State' may be keyword in Power BI which automatically formats as s map (this was on another page of the view)

This is probably some 'bug' in the software in this Preview version here.

Now right click the 'Item Value' in the fields as shown.

In the Conditional formatting menu choose 'Color scales'.

Here you can choose colors to represent Minimum, Middle and Maximum values and click OK.

That is all there is to it.

Monday, December 11, 2017

Linius Video Virtualization

Video content need not be a black-box containing the various stuff that go into video like, images, audio, etc. Video Virtualization takes your video file and converts it into another file where the individual pieces in the original video can be edited.

Microsoft, Amazon and IBM are investing in Video Virtualization. Microsoft with the help of Magenic is making Video Virtualization available on Microsoft Azure.

Here is a video that explains Video Virtualization of Linius.

Linius has perfected Video Virtualization protected by patents that all the three previously mentioned cloud companies are using (going to use?).

This is serious stuff as most user experience these days are driven by videos, be it entertainment, news or anything else. Being a single technical source, Linius will profit hugely.

I was driven by curiosity and wanted to see how far I can go in creating a Virtual Video file using Linius Video Virtualization Engine (VVE). I did get to the part of bringing in my video file here: 
Video created to describe a visit to Amalfi in Italy.
I was able to get this file into VVE at this site:

When I tried to edit, the software broke my file (which was actually a slide-show) into attached individual frames for each slide. There were no controls in Step 2 where you can edit.

Anyway, I published it after the second step and it produced another file at the VVE site.
<!-- Paste this snippet into the DIV element on your web page -->    
      <iframe style='width: 100%;height: 100%;' src=''/>

Now I am not sure how to go from here to edit this '186490283' file.

Some of my unanswered questions are:

Do I need to get to the file on VVE site to edit it?
How do I edit it? Graphic User Interface? If Programmatic, how?
How do I use its features, Search, modifying content, introduce ads, etc.?

Do you need a light-weight tool to develop SQL Server projects?

Well there is a heavy-weight tool, SQL Server Management Studio that is installed as a separate application from SQL Server installation (used to be a part of the SQL Server installation).

SQL Operations Studio is a lighter tool. It is free and you can carry out database development operations using it. It is available for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data warehouse on Windows, Mac or Linux.
The preview version became available in November of 2017.

If you would like to use it you need to download the version you want from here:

I downloaded the Windows version. You need to extract the files into a folder. 

The executable is sqlops.exe and it is indeed a small file.

SQLOPS user interface in Windows 10 Protection Status