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.

Common data  type in bi tools 1. Numeric Data type 2. Sting 3. Date & Time 4. Boolean 5. Geographic 6. Cluster Group 1.  Numeric Data type This data type consists of both integer type or floating type. 2. String String is the collection of characters that give rise to the String data type. 3.  Date & Time Whenever the user enters date and time values, bi tool  automatically registers it under the date data type and date and time data values. 4.  Boolean  The Boolean data values are either True or False. 5. Geographic A geographic data values is country name, state name, city, region, postal codes, etc.  6. Cluster Group Cluster Group data set contains values having a mixture of data types. A cluster group value or mixed data values.

GitHub GitHub is a version control and code hosting platform for collaboration. Acquired by Microsoft in 2018, it allows us and others to work from anywhere on multiple projects at once. With the help of GitHub, we can access our code from anywhere and a positive example of this is that if you ever wrote any code or did any productive work and you need it in the future, then you can easily review your work. And together after writing the code once, you will be able to use your work again and again, which will save your precious time and you will also be able to do  productive work. What is Repository? A repository contains all our project files and the history of each file modification. We can discuss and manage project work created in our repository. Basic Step to Create a Repository Step 1:  Login to GitHub for more  Click me  Login or Sign Up    Successfully Login       After login successfully you will be in GitHub main page/dashboard.  Step 2: After login successfully you will see

Revenue calculation in tableau 1. CYMTD [YEAR]<=TODAY() AND DATETRUNC('month',[YEAR])= DATETRUNC('month',TODAY()) 2. CYQTD [YEAR]<=TODAY() AND DATETRUNC('quarter',[YEAR])=DATETRUNC('quarter',TODAY()) 3. PYMTD ([YEAR]<=DATEADD("year",-1,TODAY())  AND [YEAR]>= DATEADD("year",-1,DATETRUNC("month",TODAY()))) 4. PYQTD [YEAR]<=DATEADD("year",-1,TODAY()) AND [YEAR]>=DATEADD("year",-1,DATETRUNC("quarter",TODAY())) 5. PYTD [YEAR]<=DATEADD('year',-1,TODAY())  AND DATEDIFF('year',[YEAR],TODAY())=1 6. YTD [YEAR]<=TODAY() AND DATETRUNC('year',[YEAR])=DATETRUNC('year',TODAY()) 7. MOM SUM([Revenue CY MTD]-([Revenue PY MTD]))/SUM([Revenue PY MTD]) 8. QOQ SUM([Revenue CY QTD]-([Revenue PY QTD]))/SUM([Revenue PY QTD]) 9. REVENUE CY CASE [Period] WHEN 'YoY' then [Revenue CYTD] WHEN 'QoQ' THEN [Revenue CY QTD] WHEN 'MoM' THEN [Revenue C

Top 10 Charts  Bar Chart Bubble Chart Column Chart Dual Axis Chat Donut Chart Heat Map Line Chart Pie Chart Waterfall Chart Stack Bar Chart Bar Chat A bar chart is a represent of summarizing a set of category data. A bar chart displays data using multiple bars, and each bar represents a particular category. Bubble Chart Bubble charts are commonly used to represent relationships between two or more numerical variables. Each bubble in the chart represents a single data point. Column Chart A column chart displaying data with ranges represented by a rectangle and also called a vertical bar chart. They are a method of making easy comparisons between multiple items or category. Images may be subject to copyright Dual Axis Chart A dual chart allows us to represent and visualize multiple data series, without the need to use additional charts, the relationship between two variables with different magnitudes and scales of measurement. Donut Chart Donut charts let you show the relationship of par

The common types of  features and functionality ETL Data Mining Data Source Visualization Predictive Analytics Dashboard 1. ETL ETL stands for Extract, Transform and Load. And it is the accepted way for organizations to link data from multiple systems into a database, or a data warehouse. Learn More:  Informatica ETL   Process:  2. Data Mining Data mining is a process used by an organization to collect raw data into useful information using software to look for patterns in large batches of data. Data Mining Process: 3. Data Source A data source is the location from which the data being used originates, or is being retrieved from, the physical location. like from any local drive, or server.  4. Visualization Visualization is the technique of presenting data in the form of pictures of diagrams or animations to communicate a message. Which gives an opportunity to understand ideas and business through visual imagery.  Visualization:  5. Predictive Analytics Predictive analytics is the use

  Top Five Bi -Tools 1. Tableau 2. Power BI 3. MicroStrategy 4. Qlik 5. SAS 1. Tableau Tableau is a visual analytics platform tool that transforms the data is used to solve business analytics problems. Preferred skills: Basic understanding of data Tableau current version: 2022.2 Tableau Product Tableau Desktop Tableau Public Tableau Server Tableau Online Tableau Reader Tableau Prep Download link:  Install Tableau 2. Power BI Power BI is an interactive data visualization software tool developed by Microsoft with a primary focus on business intelligence. also it is part of Microsoft Power Platform. Preferred skills: Basic understanding of data and Ms-Excel Power BI current version: 2.106. 582.0 Power BI Product Power BI Desktop Power BI Service Power BI Report Builder Power BI Report Server Download link:  Install PowerBI 4. Qlik Qlik is a business analytics tool, Qlik Sense is a desktop windows application that allows users to create visualizations, charts, interactive dashboards and an

  What is bi technology? BI technology includes many tools and technologies, with the help of which we analyze the data, and on the basis of the data represent the data in the form of charts, graphs and maps etc., so that this technology can help the business user and understand the data and provide a way to grow the business as well as help business users to overcome many challenges and move forward. How can we make our career in this? Anyone can make a career in this, to make a career in BI technology, you will need these things. 1. Your way of understanding and speaking should be simple. 2. You have done college and you have good knowledge of statistics. 3. You should have knowledge of any database and you should be proficient in it. 4. You should have knowledge of web technology. 5. You should have knowledge of how do you expand the data into graphs and charts based on the data. 6. Be able to upgrade to the technology that suits the times. You can make your career in BI on the basi

 Welcome to Tech Tog, Tech Tog will keep you updated with new BI technology and upcoming BI technology, as we all know how BI technology is used by every small and big companies in the 21st century with the help of BI technology, the business model is able to move forward and think and know the assessment happening in the organizations, just as every company is enhancing its business model on BI and AI, because the understanding of the organizations people have adopted the technology and implemented it in their business model over time, due to which the organizations are growing with time and achieving a place in the world as well as other companies. In the same way, Tech Tog will keep you updated with new BI technology and upcoming BI technology.