Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

 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

New Wave in Data Analytics in 2014

Now that we’re in the swing of a new year, we’ve taken stock of the data analytics trends that are brewing and developed a list of the Top 5 trends we believe are going to dominate the industry this year. Even if some of them don’t realize their full potential in 2014, it promises to be an important year in which consumer trends and technology innovation will further shape a future in which companies make data-driven decisions.
1. Data Visualization Goes Mainstream
In the mid-90s, e-mail introduced the Internet to consumers, made it more accessible, and catalyzed user adoption. Similarly, data visualization will make data analytics more accessible in 2014. Visual analytics allows business users to ask interactive questions of their prepared data sets and get immediate visual responses, which makes the whole process engaging.
This trend will democratize access to data and foster a strong data analysis culture where business users will look for data and perform visual analysis before making decisions. The quick wins that data visualization provides will lead to a changed mindset that will allow for future forays into more advanced analytics that uses math, statistics, and complex data sets. In 2014, we could see some further innovation around collaboration of business users in answering business questions. Soon, the business utility and future of a dashboard could be determined by how many “likes,” “shares,” and comments it receives from business users.
Read more atHERE


Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers