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

Ravello, a truly delightful place in Italy

After a delightful morning in Amalfi and lunch we started on our next visit for the day, a visit to Ravello. The bus takes less than 20 minutes to reach from Amalfi. Ravello is long associated with Moors (who ruled Sicily and Sardinia), and Moorish art and architecture. The towers and the Moorish arches still exist to remind us of the past.

We arrived around 2 PM and the sun was bright with few clouds. We entered through Via Rufolo and spent some time in the garden. There were flowers, but it was off peak. The view of the mountains and the sea was grand. We walked through Villa Rufolo and the exit opens into the piazza. The Cathedral is the center piece of the piazza.

Panoramic Picture of the Cathedral in the Piazza by Raymond Austin, 2017.

The fa├žade of the Cathedral is without too much decoration, but the main brass door seems to date back to Byzantium and the interior is supposed to be very nice with a beautiful pipe organ. The pulpit sits atop six columns on lion back.

The coffee at the restaurant in the Piazza was very good.

Source :

We did not elect to go inside as we had perhaps less than 2 hours before getting back to hotel.  Ravello is also known for its cameo and coral works and we managed to peek into one of them.

Looking away from the Cathedral in the pizza, one can get a glorious view of the Gulf of Salerno. It is indeed better looking than any of its photographs. With just the right sun and the cloudless sky the view presented to us was fabulous.

Ravello has been the home of merchant class who built up the city. It has become the center of art and music in recent times and we missed seeing the auditorium built by Oscar Meyer of Brazil.

Scenes of Ravello:

Ravello has attracted the rich and the famous over a long period from the likes of Boccaccio to Tennessee Williams, and Wagner seems to have finalized Parsifal on which he had worked for many years after he visited the Rufolo Gardens that inspired him his magical garden, Klingsor.

These are some of the notable visitors/Ravello residents (Wikipedia and other sources):

Maurits Cornelis Escher
Giovanni Boccaccio
Richard Wagner
Virginia Woolf
Greta Garbo
Andre Gide
Joan Miro
Truman Capote
Tennessee Williams
Graham Greene
Jacqueline Kennedy
Leonard Bernstein
Henrik Ibsen
Sara Teasdale

Poem by Sara Teasdale:

Title: To E

I have remembered beauty in the night,
Against black silences I waked to see
A shower of sunlight over Italy
And green Ravello dreaming on her height;
I have remembered music in the dark,
The clean swift brightness of a fugue of Bach's,
And running water singing on the rocks
When once in English woods I heard a lark.

But all remembered beauty is no more
Than a vague prelude to the thought of you –
You are the rarest soul I ever knew,
Lover of beauty, knightliest and best;
My thoughts seek you as waves that seek the shore,
And when I think of you, I am at rest.

Sunday, December 10, 2017

Want to see elephants and drink great coffee - Come to Coorg

Recalling a journey I took in November 2011

Google area map of the places mentioned are shown in the first photo.

On the slopes of the Western Ghats in India, perched on a tiny slice of Karnataka in the southern part of India there is a paradise called 'Coorg' (Anglicized version of 'Kodagu', they were never good at vowels). This is the hub of the friendly and hospitable native ethnic group more popularly known as 'Kodavas'. Coorg is the major producer (there are really two) of 'Coffee' in India producing the exotic spices like pepper and cardamom besides a host of others. Madikeri is the principal city in Coorg.

Bylakuppe, on the way to Madikeri (Mercara is the Anglicized name)
Pictures are worth a thousand words. But Coorg is beautiful. As you travel from Bengaluru (which we did), bypass Mysore city; the fabled city of the Maharajahs and hit the State highway 88 you would be traveling south-west from where you started. The road is nice and even, with many excellent restaurants providing both vegetarian and non-vegetarian food and even one or two specializing in fish. After about 220 (about 137 miles) KMs from where you started you come to the little town of Bylakuppe which provided the home to Tibetans who fled Tibet after the Chinese Occupation of their home land and formed settlements in India.

Entrance to the temple complex
This settlement is in fact a home away from home for them. A  visitor such as myself is greeted by the distinct architectural style from Tibet; the robed monks with tonsured heads; the sounds of gongs and chanting; the beautiful manicured gardens; the neatly laid courtyards and well kept precinct transports you into quiet an alien world.

Entrance to one of the main temples with 3 huge Buddhas

A garden adjoining the temples

The great hall with the Buddhas and the cluster of smaller temples; depicting  Buddhistic lore as perceived by the Tibetans following the Mahayana branch of Buddhism should be extremely interesting to those interested in Buddhism.

Great hall of Buddha

The pictorial renderings, the Shishi lions and the demon like Dwara Palakas (door keepers in many Hindu temples as well as in Buddhist temples such as the one in Nara, Japan) reminded me of my days in Japan visiting many of the great centers of Buddhism.

There is an unmistakable link with Japanese Buddhism; the spectrum of colors in Tibet trumping over somber greys and shades of the same in Japan.

Dubare, heartland of Elephants in Kodagu

Turning into Highway 27 and after driving another 20 Kms south you come to the Dubare Elephant Camp; a tourist oriented camp among many others maintained by Jungle Lodges and Resorts Limited, an organ of Karnataka Government's Forest Department. This is the place where you want to go with your children and see Elephants in their natural habitat. After arriving in Dubare you cross the Cauvery River in a ferry and reach the camp grounds after a very short ride. The get-on, get-off approaches to the boats are not rough hewn and you would exercise caution.

Mid-way in the river Cauvery
Getting off at Elephants Observation area
If you arrive there around 4 P.M or so, to coincide with their feeding time you would see elephants driven by their Mahouts (the elephant driver) sometimes as young as 7 or 8. The tourists flock around the elephants and witness elephants fed with rice, jaggery and coconut wrapped in rice straw.

Feeding Elephants

Visitors communicate with elephants petting them, feeding them and have great fun.

Petting Elephants
There are also elephant rides if you are inclined to ride. At feed time you can meet more than 20 elephants from the very young to the very old and aging. The elephants are trained here to participate in the Dussehra and many other public / religious events and come back here when not participating. At the time of writing there were 60 employed to look after the elephants.

Besides knowing elephants you can also participate in other activities such as coracle riding (native circular boats made of bamboo and reeds) and river rafting.

Dubare to Omkareshwar Temple

Following State Highway 88 a few kilometers further south (see map) brings you to the neighborhood of the temple. Built in 1820 Omkareshwar temple is a significant reminder of our secularism and harmony. The temple is built with a fine blend of Indo-Islamic and Indo-Saracen architectural styles.

Entering the temple from the parking lot
The main gopuram (pyramidal structure common to many South Indian temples and the ancient Tamil dominated regions in Indonesia and Thailand) of the South Indian Temples give way to a Dome above the sanctum-sanctorum surrounded by minarets with the dome at the corners. Built to propitiate the crime of killing a Brahmin, the then ruling king Lingrajendra the Second built this temple dedicated to Omkareshwar, the main deity of the temple. Given the strong Muslim population in Coorg and the neighboring state of Kerala the influence is very easy to comprehend. After parking the car you enter from a side which opens to an open Prakara (walled enclosure) in the center of which you see a Kalyani (a pond).

You need to climb a flight of steps to enter the temple. There is a sacrificial altar at the very entrance and a few more steps bring you to the sanctum-sanctorum.

The main deity, Shiva is flanked by his warrior son Kartikeya and the all-knowing Ganesha.

The above picture taken by Aasif K Farooki for his article on the following site and is used with his permission. The picture is taken from the steps leading to the temple looking out.

From Omkareshwar to TigersCorner Homestay at Hakattur

We tried to catch a glimpse of the Abbey Falls at Abborkatte (about 8 Kms North-East of Madikeri) but it was visitor closing time. I believe it is very beautiful with a hanging bridge and a scenic spot with coffee plantations on either side. Water collected over a large area drops down here to feed the Cauvery (also written Kaveri sometimes) river. Our next move was to get to our lodgings for the night. Unfortunately the directions are not well marked and it helps to hire a local driver who can easily locate the place. The lack of proper guidance to visitor in the form of direction markers and sign posts would help the visitors immensely.
The air was getting colder and we drove towards our stay for the night at a Homestay in Hakattur, the Tiger Corner. Hakattur is only a few Kms directly south of Madikeri. Notwithstanding the name tigers are not seen here as this is not the tiger country (Go to Nagarhole National Park). It is owned by the plantation owner Mr. Prasad and maintained by his wife and other support staff.

 From Madikeri to the Tiger Corner the road is not paved except for a few patches here and there, but it is well worth the coming. It beats or matches in price the other Home-stays in and around Madikeri and the personal touch of Mr. Prasad enriched our stay. The rooms are clean with running hot & cold water; heat from the solar heater added to the machine produced heat.

There is both television and Internet although both were in the process of getting hooked up. We chatted with the owner over a bottle of scotch and nick-knacks to absorb the local news. My friend who was from Kodagu, who later married my sister had many things to discuss. The conversation was a mixture of Kodava, Kannada, English and hand gestures.
The dinner was tasty (you could get both vegetarian and non-vegetarian) with Chapattis; rice noodles, rice, sambars, palya (cooked vegetable with simple spices), curds (what is called Yoghurt in USA); a sweet and coffee. You could also get non-vegetarian food if you order beforehand. Coorgees (that’s how people of Coorg are called) are not strict vegetarians.

The night was cool but not cold and the night sounds were soothing. The day one came to an end hitting the sacks.

Learning about the estate produce

The Home-stay is in the middle of the coffee estate. Mr. Prasad took us out to show the coffee plants. He showed us the Robusta, Arabica and the Kaveri varieties of coffee. Explained how difficult it is to cultivate the coffee. He also explained the dynamics of coffee market and how a good crop in Brazil affects the value of local crop. But they were not doing too badly and the estate owners are known for their wealth.

The planted area (ground) is wet and slushy with the chances of picking up a leech or two is high. You should therefore wear knee-high boots if possible and in any case cover your feet completely. Slippers are no, no. The coffee beans are formed in clusters and I was told when in bloom the white flowers are very fragrant and beautiful.

Mr. Prasad also showed us the pepper corn vines growing on the Arecnut trees providing the overall shade for the coffee bushes underneath. We tasted the pepper-corn and true to its nature it was hot but exhilarating and killed the remnant cold in the chest.

Arecanut (aka betel nut) trees produce a kind of hard nut that is chewed together with beetle leaves and a dash of calcium hydroxide (known as chunnum in Tamil) mashed in the mouth producing a rich red to scarlet color and the juices produced are supposed to improve the digestion. This is a must in most Hindu and Indian weddings after the wedding banquet.

The black soil is also conducive to the growth of cardamom another exotic spice from India. The berries which contain the cardamom pods are at the very bottom of what looks like ginger plants. They look like nodules in-situ and it needs to be processed before it hits the market. Mr. Prasad picked up a few of the berries for us to taste crushed in his palm and the taste of cardamom was superb and nothing like the ones I was used to. Protection Status