Gainers & Loosers

Monday, December 15, 2014

Tableau Software for Rapid fire BI

I visited the Tableau Software booth at TechNet Asia-Pacific 2014 and I was quite impressed with the Tableau products (and the various data sources that can be used): Tableau for Desktop; Tableau Server; and Tableau on line which provides Business Intelligence in the cloud.

I just wanted to take a look at their Tableau on line and visited their trial page here:

The first step is you need to register to get in. After registering you can request for a trial use of the Tableau Desktop software. Following this you will get the software suitable for your architecture. On my Windows 8.1 I got the x64bit version of the software (TableauDesktop,msi 124MB).
You can double click the msi file at the download location. At the welcome screen accept the license terms after viewing the same. The version you will be installing is 8.3 (Actually you get the 8.2 version as I found out while using the trial software).

After registration you can start using the software. I just used the trial to see how easy; how intuitive and how difficult to use.
When launched the first window to display is a workbook called Book1 as shown.

It opens in the Workbooks view with Data on the left and a number of Sample Workbooks at the footer (bottom) as shown above.

You can connect to a data source or you can connect to saved data sources, some of them from Excel, some from Access and other from Tableau data. If you are just exploring you have option to watch the product tour or the training videos.

The menu is simple enough for this view with File, Data, Server and Help. The Help menu offers the following:

Let us just explore the World Indicators sample. Click on this sample at the bottom of the screen. The processing request get sent to the data source and this is what you will see. This is read-only.

It has the classic look of analytical software with Measures, Dimensions, Filters etc. You are looking at the bar graph of 2010 GDP Per Capita by country.

Let us modify the filter. Right click on Region to display the regions from which you can choose.

Clicking on Filter brings up the Filter[Region] tabbed pane as shown.

Let us remove all but Asia ; click apply and click OK.
The UI changes to the following:

Right click on Country/Region on Rows to display a finer filtering as shown.

Go ahead and choose India and China (first choose none to remove all check marks and then choose India and China). Click Apply and then OK. The UI changes to the following:

Let us say you want to include data for  more years (right now only 2010). Right click on YEAR(Date..) under Filters and choose from 2000 to 2005. The picture changes to the following:

You also have some associated information at the bottm of the page.

Click on Country Ranks and you would get a whole lot of information from all the countries in the database.

By dragging the slider in the Year pane you can compare how things changes with time.

In the Show Me window you can choose the chart type and chart features . The next image shows the bubble chart for the same data.

 This post has only shown some simple features that you can look up using the sample book that comes with the software and I am sure it is lot more sophisticated than described here. Of course all this is based on crating a model which you can do in Tableau.

For connecting to SQL Server 2012 from Tableau please visit my other blog in a day or two:

Sunday, December 14, 2014

Microsoft Azure Government at TechNet Asia-Pacific 2014

Government is big business and of course vendors are after government money. Microsoft Azure Government had a 'briefing' room at the recent  concluded TechNet Asia-Pacific event in Honolulu.

Microsoft recently announed the launch of Microsoft Azure Govrnment. A complete cloud for any goverment organization to pursue the goals of more efficient and agile operation in the mobile-centric world of today.

The Microsoft Azure Government has all the key ingredients, Azure, Microsoft Office 365 and Dynamics CRM (early next year). It goes without saying that all these operate under federal government's tight security standards.

More story here:

As recent as last year Microsoft's Azue was granted the FedRAMP JAB-P-ATO, a distinction that gets the blessings of the government. Read more details here:

The Dynamics CRM online with SLA of 99.9 should greatly improve the effieciency and productivity.
Microsoft is not alone in trying to woo the government, IBM is moving to open its new Softlayered govenment focused data centers (Texas and Virginia) which are designed for greater control and security.
More details here:

Saturday, December 13, 2014

Honolulu learning event: Learn SQL Server Reporting Services 2012

This hands-on course will provide you with the ability to create cutting edge reports using Microsoft's latest reporting services product, SQL Server 2012.

The course is offered by the Pacific center for Advanced technology Training:

Please register at the above site. 

Report writing is one of the most important IT related jobs in an enterprise. This course is for you if you would like to master report writing/authoring using SQL Server Reporting Services. The course begins with a presentation of essential technical background, after which you will work through guided hands-on exercises. At the end of the course you will have gained:
• A solid understanding of how to interact with SQL Servers
• Knowledge and experience installing and configuring reporting Services
• A working knowledge of using Report Builder to author reports and deploy them to report server
• A working knowledge of Report Manager's ability to carry out administrative tasks related to all aspects of reports; creating shared data sources, folder and folder hierarchies on the report server, and report models; managing security and subscriptions; and configuring data driven subscriptions
• An understanding of how to embed report viewer controls in windows and web projects.

Venue: Honolulu Community College Honolulu Community College
874 Dillingham Blvd Honolulu, HI 96817-4598 Phone: (808) 845-9211
Official Website:

Section 1 - Mar 31 - May 7, 2015; TTh; 5:30 pm - 8:30 pm; 12 mtgs

I will be using my latest book on SQL Server Reporting Services for this course: Protection Status