Before data can be used in the visualizations, it is a best practice to prepare the data so that it can be meaningful. Preparing data includes but not limited to the following:- Giving user friendly names to dimensions and measures. To give user friendly names to any data element, right click on the data element, […]
Tableau Tutorial
Tableau – Applying filters
Filters can be applied in Tableau to dimensions and measures. Filters are a good way to answer questions on different data scenerios. Steps: Create visualization according to your requirements Understand the business rule for your filter Drop field which you want to use for filter on the “filter shelf” Tableau will prompt “How do you […]
Tableau – Use multiple tables, joins and data manipulation
Today i want to share with you How to create a data connection by using multiple tables in Tabeau. How to use and modify joins How to do some of the basic data manipulation For this example, i have downloaded Adventure Works database from www.CodePlex.com I have converted the data into excel sheets and placed […]
Tableau – Data connection
Tableau can connect to variety of data sources. It can connect to excel files,relational data bases and many more. When you launch Tableau desktop on your machine, connect screen opens up. Here you can connect to your desired data source. If you have trial version of Tableau desktop then you can just connect to file based data sources. With […]
Business Intelligence Basics – Dimension and Fact
What is a dimension/dimension table In Data warehousing, dimension table contains the textual or descriptive attribute of the data. For example customer dimension will contain details about customer’s name,address,phone number etc. Dimensions are used to slice and dice the data i.e. filter and group the data.Dimension table also help you by looking at data with […]
Tableau Overview
If you are here that means you are an ardent follower of Business Intelligence. Tools like Tableau have changed the way users consume BI data. I came across Tableau few year back and was excited by its visualization and ease in data analysis. Tableau 8.0 is taking a big step in dash boarding and predictive analysis. […]