Posts

Showing posts with the label Tableau

Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

4 Tableau Popular Products

Image
I want to share with you what are Tableau Products most popular. This quick review helps you get instant knowledge. Tableau Products We’ve done years of research to build a system that supports people’s natural ability to think visually. Shift fluidly between views, following your natural train of thought. You’re not stuck in wizards or bogged down writing scripts.  You just create beautiful, rich data visualizations.  It's so easy to use that any Excel user can learn it. Get more results for less effort. And it’s 10 –100x faster than existing solutions. Here is all about  What is Tableau software 1. Tableau desktop Tableau Desktop is based on breakthrough technology from Stanford University that lets you drag and drop to analyze data. You can connect to data in a few clicks, then visualize and create interactive dashboards with a few more. 2. Tableau server Tableau Server is a business intelligence application that provides browser-based analytics anyone can

12 Top Tableau Small Projects for Practice

Image
Tableau is one of the best visualization tools. With Tableau Desktop you can connect to multiple data sources. Tableau Desktop is based on breakthrough technology from Stanford University that lets you drag & drop to analyze data. Best 12 Tableau Exercises: Small Projects for Practice. You can connect to data in a few clicks, then visualize and create interactive dashboards with a few more. We’ve done years of research to build a system that supports people’s natural ability to think visually.  Shift fluidly between views, following your natural train of thought. You’re not stuck in wizards or bogged down writing scripts.  You just create beautiful, rich data visualizations. It's so easy to use that any Excel user can learn it. Get more results for less effort. And it’s 10 –100x faster than existing solutions Keep Reading The 12 Exercises from Tableau Tableau Tutorial

Tableau 2 Top Books to Read

Image
In this post, I have given two top data visualization in Tableau books. These books helpful for your self-study.   Top Tableau Course Contents Introduction to Tableau  Connecting to data  Visual analytics  How to design dashboard  Mapping  Calculations  How to publish and Manage with Tableau  Security with Tableau ..... Read more . Two Best books on Tableau to Learn and Visualize the Data. #1.  Learning Tableau Learn how to create effective data visualizations with Tableau and unlock a smarter approach to business analytics.  It might just transform your organization About This Book Create stylish visualizations and dashboards that explain complexity with clarity. Learn effective data storytelling to transform how your business uses ideas and makes decisions Explore all the new features in Tableau 10 and start to redefine what business. analytics means to your organization. #2.  How to create Data Visualization in Tableau  Tableau Your Data! is a co

5 Tableau Features Useful for Data Analytics

Image
Below are the top Tableau features for data analytics. Tableau 9 for Data Science engineers. CONNECTING TO LOCAL FILE  Tableau can connect to any local file or database such as Excel  Text File Access  Statistical File, or  Another Database file CONNECTING TO SERVER Tableau can connect to your data server too. It can connect to almost any type of data server. Below are some of the most popular databases that Tableau can connect: Tableau Server Google Analytics Google BigQuery Hortonworks Hadoop Hive MapR Hadoop Hive IBM DB2 IBM BigInsights IBM Netezza Microsoft SQL Server Microsoft Analysis Services Oracle Oracle Essbase MySQL PostgreSQL SAP While working on Tableau, data can have Live Connection where any change in the source data will be automatically updated in Tableau. On the other hand, data can be Extracted to the Tableau repository so that any change made here will not affect the original source data. CONNECTING TO EXCEL FILE To connect

7 Features of Tableau Self-service Engine

Image
Tableau introduced the Self-Service tool. This Tool helps user queries while importing data from multiple sources. This project is called Project Maestro . This is an additional feature for the data analysis engine. Self-Service Engine in Tableau The visual ways of inspecting, joining and editing data. Results could then be piped into Tableau for analysis. Speedier data import and analysis. Tableau's new data engine works based on Hyper technology. You can see now faster to import and analyze large data sets with Tableau. Hundreds of thousands of records being imported per second, as well as being visualized in real-time as the import process continued. This engine developed based on feedback from the user community. It supports natural language queries. Tableau is aiming for true natural speech, not merely being able to type in questions that require using exact field names and functions. The example is you can ask questions like Tell me the cheapest houses in near Calif

The best answer for 'Efficient Workbook' in Tableau

Image
There are several factors that define an “efficient” workbook. Some of these factors are technical and some more user-focused. An efficient workbook is: A workbook that takes advantage of the “principles of visual analysis” to effectively communicate the message of the author and the data, possibly by engaging the user in an interactive experience. A workbook that responds in a timely fashion. This can be a somewhat subjective measure, but in general we would want the workbook to provide an initial display of information and to respond to user interactions within a couple of (< 5) seconds.  Tableau latest version is 9.1.2 as on writing this post Tableau version 8 and Version 9 differences Individual Query time improved by 10x Dashboard Query times improved by 9x Query Fusion improving times by 2x And Query Caching improving times by 50x

How to learn Tableau best way with self Study tutorials

Image
#Tips To Mastering Tableau Self Study Video Tutorials The Tableau training website offers a multitude of resources for Tableau users with many of the videos being brief and addressing specific topics. This self-study syllabus organizes those videos to help you find the training you need on specific topics quickly. Tableau 9 for Data Science Engineers. To learn any Software Tool, you need to follow these steps: Tutorials - Either on-line or class room Books -Read theory from the scratch Hands on Training - Just practice what you learnt Materials -Written by experienced developers Blogs/Websites/Forums give you much insights The below link contains valuable video tutorials. You can learn Tableau quickly in a just few days. Take Video Lessons Here

2 Top Tableau Unique Features

Image
Tableau is one of the most popular tools in data analysis. Learning the Tableau gives you so many options in data analysis career. You can download Tableau Software free version here . Get a complete understanding document on how Tableau works here . Read this post for advancing in your Tableau Career. Unique functionality in Tableau Tableau Software was founded on the idea that analysis and visualization should not be isolated activities but must be synergistically integrated into a visual analysis process. Visual analysis means specifically: 1). Data Exploration Visual analysis is designed to support analytical reasoning. The goal of the visual analysis is to answer important questions using data and facts. In order to support analysis, it is not enough to only access and report on the data. Analysis requires computational support throughout the process. Typical steps in the analysis include such operations as filtering to focus on items of interest sorting to rank

The best visualization tool Tableau for Software Developers (1 of 2)

Image
#The best visualization tool Tableau for Software Developers: Why Tableau:  Companies that have invested millions of dollars in BI systems are using spreadsheets for data analysis and reporting. When BI system reports are received, traditional tools often employ inappropriate visualization methods. People want to make informed decisions with reliable information. They need timely reports that present the evidence to support their decisions. They want to connect with a variety of datasources, and they don't know the best ways to visualize data. Ideally, the tool used should automatically present the information using the best practices. 3 Kinds of Data Known Data (type 1) Encompassed in daily, weekly, and monthly reports that are used for monitoring activity, these reports provide the basic context used to inform discussion and frame questions. Type 1 reports aren't intended to answer questions. Their purpose is to provide visibility of operations. Data YOU Know Y

What is Tableau Software

Image
Stanford University Computer Science department is the origin of Tableau. The initiation started in the Department of Defense, a sponsored research project. Chris Stolte, a Ph.D. candidate, was researching visualization techniques for exploring relational databases and data cubes. Tableau Invention Stolte's Ph.D. advisor, Professor Pat Hanrahan, a founding member of Pixar and chief architect for Pixar's RenderMan, was a worldwide expert in the science of computer graphics. Chris, Pat, and a team of Stanford Ph. D.s realized that computer graphics could deliver huge gains in people's ability to understand databases. Before Tableau Their invention VizQL™ brought together these two computer science disciplines for the first time. VizQL lets people analyze data just by building drag-and-drop pictures of what they want to see. Tableau 8   While Tableau 8 improves on the previous seven major releases of the software, the core approach to visual design remains the same: