Tableau Training

For all your Tableau Training and Consulting needs,Please write to musrk2@gmail.com.


We have specifically designed training for certification,with real time scenarios,helping you to solve your interviews easily.

We have 15 + years of DW/BI industry expertise.

Tableau vs OBIEE

Oracle Business Intelligence Enterprise Edition is a popular and comprehensive BI tool to deliver a full range of data analysis and present reports using a unified, contemporary and scalable architecture. OBIEE has the excellent abilities for reporting, analysis, ad hoc query, (OLAP), dashboards and scorecards.

Why do enterprises prefer and trust OBIEE even though we have several other efficient and effective BI tools and suites? You must know that OBIEE gives immense ease to operate and implement it via web-based interactive workspaces, , mobile devices and Microsoft Office applications. Moreover, the hierarchy drilling feature of this tool is yet another remarkable service making it a widely-used choice of enterprises. Graphical reporting and global support and development capabilities serve as a cherry on the cake both for consumers/clients and business groups.

If you are looking to remove redundancy in report generation and save your time in applying the data analysis and report creation techniques, this is the right fit and thus, important to learn and master. We have developed a technically-rich OBIEE tutorial to assist the Data Analysts and Business Intelligence Developers and let them enhance their skill set. Well-explained using illustrations, you can take a quick tour and gain understanding of several core functionalities and processes used in BI and then apply them to your live data analytics projects and assignments.

Tableau vs OBIEE

Oracle Business Intelligence Enterprise Edition is a popular and comprehensive BI tool to deliver a full range of data analysis and present reports using a unified, contemporary and scalable architecture. OBIEE has the excellent abilities for reporting, analysis, ad hoc query, (OLAP), dashboards and scorecards.

Why do enterprises prefer and trust OBIEE even though we have several other efficient and effective BI tools and suites? You must know that OBIEE gives immense ease to operate and implement it via web-based interactive workspaces, , mobile devices and Microsoft Office applications. Moreover, the hierarchy drilling feature of this tool is yet another remarkable service making it a widely-used choice of enterprises. Graphical reporting and global support and development capabilities serve as a cherry on the cake both for consumers/clients and business groups.

If you are looking to remove redundancy in report generation and save your time in applying the data analysis and report creation techniques, this is the right fit and thus, important to learn and master. We have developed a technically-rich OBIEE tutorial to assist the Data Analysts and Business Intelligence Developers and let them enhance their skill set. Well-explained using illustrations, you can take a quick tour and gain understanding of several core functionalities and processes used in BI and then apply them to your live data analytics projects and assignments.

User filtering in Tableau

A user filter can be created once a dashboard is published on the server & that user logs in on server to view the dashboard. It cannot be applied on Tableau desktop or the reader version.

Let say you have created a dashboard with 1 worksheet for priority(P1/P2/P3/P4 etc.) of Delhi/NCR and you want some specific user to see just the Priority only for “P1 wards of Delhi”

P1 wards of New Delhi - Green

P2 wards of New Delhi - Blue.. etc.

These are the steps you can follow :

1. In the desktop version go to that sheet
2. Click on Server Drop-down menu or click Alt+S.
3. Click on “Create User Filter” and Then on which column you want to restrict the rights, it will prompt you to give your tableau server credentials.
4. Log-in as an “Administrator”
5. A new window will appear, like the image below.

6. Give a name to this filter and select a user to which you want to give rights to see only P1 wards.

7. As soon as you will select a USER and Member and click “OK”,it will create a User filter 1 in the Sets block and will appear where you generally make sets.

8. Drag this set in the “filters shelf”,where to generally drag filters.

See in the image above : User Filetr 1 has been dragged to Filters Shelf.

9. Upload this dashboard/worksheet to the server.

10. Done !!

Next time when that particular user will open this dashboard with their credentials on your tableau server,He/She will only see P1 priority and not P2/P3/P4 etc.

Access Restricted.!!

Hope this helps,For more solutions keep watching this space.

Underlying Sql queries in Tableau

How can you see underlying SQL queries in Tableau?

when you're interacting with Tableau Dashboard it will execute some queries on datasources and build the view on dashboard.if you wants to know this then DO PERFORMANCE RECORDING ON TABLEAU WORKBBOKS ->download performance recording of dashboard in the format of Tableau workbook

In that workbook you can see queries executed by Tableau.and also how much time it has taken for compiling the query,executing the query and building the view etc..,

Desktop/Server/Public/Online differences

Differences between Tableau's Desktop/Server/Public/Online versions

Tableau Desktop

Tableau Desktop is common for everyone. The Tableau Desktop contains different types of development tools, which helps to perform development activities. The TableauDesktop used to visualize and analyze data, helps to create stories, dashboards, workbooks and visualizations. It also helps to convert picture data into optimized database queries. But Tableau Desktop is not secure for visualizing data.

Tableau Desktop is divided into Personal Tableau Desktop and Professional Tableau Desktop.

Personal Tableau Desktop

Data Sources

Cannot Connect To All Listed Data Sources

Price

$999

Professional Tableau Desktop

Data Sources

Connect To All Listed Data Sources

Price

$1,999

Tableau Server

Tableau Server can be collaborated for any organization. Tableau Server is said to be a sharing tool, which helps to share and create data visualization for any organizations and fully secured. In major, it safely distribute interactive data in website or web. Creating new workbooks and dashboards are restricted in Tableau Server. It is used as an elevated concert data sources for desktop users. Tableau Server is highly secured for visualizing data. The Price of Tableau Server depend upon core licensing.

Tableau Online

Tableau Online is also an elevated concert data sources for desktop users. The Tableau Online is hosted in cloud version of SaaS. Tableau Online is limited for editing of workbooks, dashboards, visualizations etc. Tableau Online is also highly secured for data visualizing. The Tableau Online version price is $500

Tableau Public

Tableau Public is free tool offered by the Tableau organization. The Tableau Public is mainly used for publishing interactive data in online, which can be accessible by everyone. Tableau Public is not secured one and anyone can access the data and download.

Does Tableau server/online versions need Tableau Desktop?

No, Tableau Server and Tableau online versions do not need Tableau Desktop.

Tableau Public

Can you learn basics of Tableau with Tableau Public which is free?

Absolutely. The basic difference between Tableau Desktop & Tableau Public is that Desktop version can connect to different number of data sources like Oracle, mysql, salesforce, spark Tables, hadoop, text files and many others whereas Public can only connect to text files. Also there is limit on number of records you can pull in. Also you can only save your visualization on Tableau public server which can be downloaded by anyone so unless there's some confidential data you are working with Tableau public cannot be used. Apart from that the functionality is almost same. Tableau Public is a great tool to start learning data visualization.

Tableau Questions-FAQ

What are the limitations of tableau public?

1. You can only read from txt, Excel or Odata sources
2. All your data is Public
3. You cannot connect with R 
4. There is some limitation on data size that you can have on an id but that is pretty high so not of much concern

Tableau Questions-FAQ

What Tableau Desktop can do that Tableau Public can not do?

Tableau Desktop allows you to:

create workbooks, dashboards and visualizations. Using the professional version of this tool, you can publish your reports and all to Tableau Server/Online/Public.

• Save TWB (Tableau Workbook) and TDE (Tableau Data Extract) files locally, rather than publishing to Tableau Public
• Publish to Tableau Server(s), rather than publishing to Tableau Public
• Save TWBX (Tableau Packaged Workbook) files for use in the free Tableau Reader, rather than publishing to Tableau Public

So you pay for the right to produce private content and share it with a selected audience, rather than publish to the Tableau Public website where anyone can view your analysis (and underlying data).Tableau Public can be used for publishing info that can be accessed by anyone, but it doesn’t let you create dashboards and visualizations. Whatever you publish on this tool is not private. This free tool has a limitation when it comes to the data you can use on it. It connects to Excel and text-based files, but no other database except these.

Conditionally Formatting Cell Background Color

Problem

How to format cell background color based on a KPI (key progress indicator).

Answer

This article expands on the steps for creating key progress indicators, adding information for formatting the cell background color based on the indicator value.

Step 1: Create a KPI 

Create a KPI view using the steps provided in Creating Key Progress Indicators (KPIs).
You can also download the attached sample workbook to see the finished result.

Step 2: Set up conditional background color

1. Drag the KPI field to Color on the Marks card.
2. Change the mark type to Bar.
3. (Optional) Click the arrow in the upper-right corner of the Color legend, select Edit Colors, and select the color palette you want.
4. Drag Number of Records to Size on the Marks card.
5. Click the arrow in the upper-right corner of SUM(Number of Records), select Measure (Sum) > Minimum
6. Adjust mark size as desired. See Size Properties for more information.
7. (Optional) Hide the Number of Record Card. 

To view these steps in action, see the video below: