Showing posts with label Business Intelligence. Show all posts
Showing posts with label Business Intelligence. Show all posts

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:
http://www.tableausoftware.com/products/trial

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:
http://hodentekMSSS.blogspot.com

Thursday, February 07, 2013

About SSDT and VS 2012


SQL Server Data Tools is a great combo, a combo for both DBA types and developer types and every other type in between. But the installation of this tools has created some confusion from day one and it still continues.

In Visual Studio 2012 Pro and above you don't see the BI templates for SSRS, SSIS and SSAS. There is however a Report Project (both VB and C#). This division requires you to have both SQL Server 2012 and Vs 2012 accessing SSDT (in SQL Server 2012) for BI projects and use VS2012 for all others. Follow this link for complete details:

http://hodentekmsss.blogspot.com/2013/02/want-to-know-more-about-ssdt.html

Tuesday, December 25, 2012

Are you serious about SQL Server 2012?

If the answer is yes, I recommed that you download immediately the SQL Server 2012 Developer Training Kit. This can be installed from here:
http://www.microsoft.com/en-us/download/details.aspx?id=27721



Before you install the KIT you need to install the Web Platform Installer 4.0. You can get it from the same link. Read the previous post here for installing Web PI 4.0: http://hodentek.blogspot.com/2012/12/you-can-get-lots-of-stuff-from-web.html

Note that the KIT's executable may not necessariloy show up in WEB PI4.0!!

When you run the Kit related exe (http://download.microsoft.com/download/D/0/9/D098DCF2-1888-4624-920B-B2DE71B2728F/SQL2012DevTrainingKit.WebInstaller.exe) file you will download the kit.



On this computer it was installed in the default folder "C:\Program Files\Microsoft\Web Platform Installer\WebPlatformInstaller.exe". Note that you have to allow Activex on your IE and you may get this warning, better pay attention to it and enable it.



When you run this program you will find the default.htm, the starting point of your journey.
C:\SQL2012UpdateForDevsTrainingKit\Default.htm

Default.htm opens out like this. You can learn a lot, not just DBA, but also development and of course BI.



Good luck.

Aloha from Honolulu

Saturday, January 26, 2008

My articles on Microsoft Reporting Services

Review of these articles may help in understanding Microsoft SSRS (Vs 2003 & VS 2005; SQL 2000 and SQL 2005) in a reasonable amount of time.

On Importing an Access Parametric Report into SQL 2000 Reporting Services

ASP.NET and SQL 2000 Reporting Services

SQL Server 2000 Reporting Services: Creating a report from scratch

Creating a Chart with SQL 2000 Reporting Services


Building a Multi-table Report with SQL 2005 Reporting Services

Generating and Hosting a SQL Server Reporting Services Report Using SQL Server 2005 Business Intelligence Development Studio

This reader liked the article and he was kind enough to communicate to me:(name is masked)

Feedback sent from IP: 193.188.161.31
Referring URL: http://aspalliance.com/819Thankyou for providing such beautifully documented/illustrated mini tutorial on Reporting Services. Had purchased a book to learn RSS, but your tutorial although short was very precise and you spoke to the point. I really liked your method of exposing the basic intricacies in the Reporting Server. I now find it more easy to approach the Reporting Server.Thankyou once again for your efforts.Best Regards,XXXXXXX
"
DMCA.com Protection Status