Tech Togs

Custom font in tableau Custom fonts allow us to use beautiful combinations of different fonts on our website and tools to improve typography and user experience. How to use custom fonts in Tableau To use a custom font, you download it from the web, and copy-paste the download file into the fonts folder of control panel. After copy paste successfully, launch tableau application again, now you will be able to see new fonts in tableau application. These are the steps to add custom fonts to Control Panel 1. Find and download the font you want to use Here's an idea of your font will look like. 2. Search selected font in google web then download 3. Check your downloads folder, if the file is in zip extension then extract it before use. 4. After successfully extracting just copy and paste it to this location. 5. New font successfully install in your machine, just relaunch the tableau application, now you will be able to see new fonts in tableau application.

 Tableau converting text case  UPPER case function lower case function Proper case function UPPER case function : The upper case function converts all letters to uppercase (capital letters) ex: Function  Name : UPPER (Name) Result: Name: AJAY KUMAR lower case function : The lower case function converts all letters to lowercase.(small letters) ex: Function Name: LOWER(Name) Result: Name: ajay kumar Proper Case The Proper case is text that is capitalized with the first letter of each word. ex: Create a calculator field for this: Name UPPER(LEFT(SPLIT([Name],' ',1),1)) + LOWER(MID(SPLIT([Name],' ',1),2,20)) + ' ' + UPPER(LEFT(SPLIT([Name],' ',2),1)) + LOWER(MID(SPLIT([Name],' ',2),2,20)) + ' ' + UPPER(LEFT(SPLIT([Name],' ',3),1)) + LOWER(MID(SPLIT([Name],' ',3),2,20)) Result: Name: Ajay Kumar

Tableau Navigation Tableau navigation features give us users the ability to seamlessly move from one dashboard, sheet, or story — all within a workbook. Tableau Menu  In the Tableau menu we find all the available menu commands and the main interface of the Tableau application. And we can also Navigate it with [Alt + _ ] command Using alt key we can navigate all the menu of tableau application tool. There are 11 data menu in Tableau application File Data Worksheet Dashboard Story Analysis Map Format Server Window Help

LOD Function Level Of Detail expressions (LOD) allows us to calculate values at data source level and visualization level in tableau application tool. This gives us more control over the level of granularity we want to calculate. Types of LOD FIXED INCLUDE EXCLUDE Fixed : It compute a value using the specified dimensions, without reference to the dimensions in the view. ex: {FIXED [Region] : SUM([Sales])} Include: Calculating values using specified dimensions other than whatever dimensions are in the view ex: { INCLUDE [Customer Name] : SUM([Sales]) } Exclude: It declare dimensions to omit from the view level of detail. ex: {EXCLUDE [Order Date (Month / Year)] : AVG({FIXED [Order Date (Month / Year)] : SUM([Sales])})}

Tableau Presentation Sheet Dashboard Story 1. Sheet A worksheet has a single view with shelf, cards, legends, and data and analytics panes in the side bar. 2. Dashboard A dashboard is a collection of multiple views in which you can compare multiple types of data at once. If you have a set of scenes that you review daily, you can see all the scenes together in one dashboard. 3. Story A story is a sequence of visualizations that work together to communicate information. You can create stories to tell a data narrative. How to check tableau version? Open tableau application, after opening, by clicking on the Help tab in the top, click on About Tableau Public, the application will show you the app version. Step 1 Step 2 Step 3 Image subject to copyright

 Change data type in tableau like this By dragging the table when you are connected to a data source in Tableau, you will get to see the table's data in a tabular form. Where the header of the data and the data type for that column will appear on the top left side. You can place the data column according to the data type here. And if the data is coming from some other data source (DB)  then we can maintain it through tableau calculation. Step 1: Step 2:

Tableau Data Connection Data Connection The data connection format allows us to store information about what data should be available in the database in the form of a data table. Live Connection Extract Connection Live Connection Live connections facilitate real-time updates. So that in any way, when the data source is updated, it shows the same data in real time which is present in the database. Extract Connection Extract is a kind of batch that needs to be refreshed periodically to get updated data. Extracts are often much faster than live connections.