Posts

Showing posts with the label Data 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

What is so Trendy in Data Visualization and Reporting

Data Visualization: Data visualization is the process that defines any effort to assist people to understand the importance of data by placing it in a visual context.  Patterns, trends, and correlations that might be missed in text-based data can be represented and identified with data visualization software. It is a graphical representation of numerical data. This is one of the Hot skills in the market, you will get the highest salary. Types of data visualization Visual Reporting Visual reporting uses charts and graphics to represent business performance, usually defined by metrics and time-series information. The best dashboards and scorecards enable the users to drill down one or more levels to view more detailed information about a metric A dashboard is a visual exception report that signifies the ambiguities in performances using visualization techniques Visual Analysis Visual-analysis allows users to visually explore the data to observe the data and discove

5 Emerging Trends in Data Visualization

Image
Nowadays, we deeply drowned in data of diverse kinds due to the increased computational power and accessibility. Specifically, in addition to public data available on the Internet (e.g., census, demographics, environmental data), data pertaining personal daily activities are now more easily collected. For example, through mobile devices that can log people's running distances and time or their manual record of nutrition consumption. Due to such expanded sources of data, there appear new applications that involve data collection, visualization, exploration, and distribution in daily contexts. These applications do, not only display static information but also let users navigate the data in forms of interactive visualizations. 5 Emerging Trends in Data Visualization. #1: This emerging trend has brought both opportunities and challenges to interaction designers to develop new approaches to designing data-based applications. #2: Conveying information has been one of main functio