Data Analytics using Tableau

Though we discussed extensively about SAP Business Objects w.r.t business intelligence tools, I could not get a chance to write about Tableau visualizations till now. Not a great thing considering that my experiments with Tableau started way back in 2012 with Tableau version 7.0 (it wasn’t as popular as today, but it was clearly emerging as a leader). Tableau is one of the best visualizations tool that I have experienced and you can’t stop admiring its performance (thanks to in-memory processing of data), interactivity and analytics options (trends and forecasts).

Starting with a few visualizations from my PC. We will explore specific features and steps in later blogs.

Lets analyze data of a company (data source: Local SQL Server database). As you see the sales and profits are declining. I have added a trend line for its sales. This shows a consistent fall and its time for the company to do something serious to revive the business, isn’t it?

graph-1

Sometimes a different visualization is what the need of the hour to convey the same data. How about a packed bubble visualization with the sizes corresponding to Yearly sales. Note that the data is categorized further by Divisions (company locations)

graph-2

And my favorite Geo Maps

graph-3

We will dig into its analytic features and Tableau Online in the upcoming posts.

Docker Integration for Visual Studio Developers

Containerization using Docker

As implementation of solutions based on micro services and containerization are growing like never before, it is important for us to weigh the advantages.  As we know, Docker in this area has gone way ahead of others. Even though it evolved as a container solution based on Linux, of late native support for Docker has been released in Windows Server 2016 and Windows 10 OS.

Docker for Visual Studio Developers

dockerVSfeature

Support for Docker is available in Visual Studio 2017. To build, run and debug your applications from VS in Docker container, you should install Docker for Windows (https://docs.docker.com/docker-for-windows/install/) installed on your PC in addition to Visual Studio 2017.

Once installed, you can specify the option as below to enable Docker support while creating your project. Alternately you can right click on the particular project in solution explorer and use Add->Docker Support.

Docker

Visual studio integration adds the following files to your project

  • Dockerfile – build instructions for the image

Compose Files (to define and run multi-container applications with Docker)

  • Docker-compose.yml
  • Docker-compose.dev.debug.yml
  • Docker-compose.dev.release.yml

The docker-compose.yml file contains the name of the image that is created when project is run

version: '2'
services:
 ci-build:
 image: microsoft/aspnetcore-build:1.1.0-msbuild
 volumes:
 - .:/src
 working_dir: /src
 command: /bin/bash -c "dotnet restore && dotnet publish -c Release -o ./bin/Release/PublishOutput"

Sample Dockerfile

FROM microsoft/aspnetcore:1.1
ARG source
WORKDIR /app
EXPOSE 80
COPY ${source:-obj/Docker/publish} .
ENTRYPOINT ["dotnet", "MyDockerApplication.dll"]