Posts

Showing posts with the label Self-service visualization

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

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