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 top initial steps you need before you start HR predictive analytics

Top criteria you need before you start analytics in the Human Resource department. I am sure you need many approvals to start analytics in HR.
hr analytics

The risks involved to start analytics in the Human Resource department

  1. You must comply with the legal requirements in which you operate as it relates to the use of people data. The reason is the analytical insights should reflect the cultural and social marks of your organization.
  2. You need to get involved all stakeholders involved and what the cost of what you're doing is relative to the benefit of doing it.
  3. Use analytics through accountable processes, one of which should be acknowledging that using predictive analytics with the workforce has the potential for negative impact, not just positive impact, Walzer said.
  4. Engage the legal department to make sure you understand any implications before you've done something, not after the fact.
  5. Assess whether the use of analytics involves sensitive areas, which it often will, Walzer said. But, she added, these are often accommodated by using reasonable safeguards.
  6. Know what data you just shouldn't collect. 
  7. One example is prescription drug use of employees. "Many employers have access to it through third-party health care providers, but the idea that you're going to bring it in poses a lot of liability to the organization

References

Comments

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