Featured Post

SQL Query: 3 Methods for Calculating Cumulative SUM

Image
SQL provides various constructs for calculating cumulative sums, offering flexibility and efficiency in data analysis. In this article, we explore three distinct SQL queries that facilitate the computation of cumulative sums. Each query leverages different SQL constructs to achieve the desired outcome, catering to diverse analytical needs and preferences. Using Window Functions (e.g., PostgreSQL, SQL Server, Oracle) SELECT id, value, SUM(value) OVER (ORDER BY id) AS cumulative_sum  FROM your_table; This query uses the SUM() window function with the OVER clause to calculate the cumulative sum of the value column ordered by the id column. Using Subqueries (e.g., MySQL, SQLite): SELECT t1.id, t1.value, SUM(t2.value) AS cumulative_sum FROM your_table t1 JOIN your_table t2 ON t1.id >= t2.id GROUP BY t1.id, t1.value ORDER BY t1.id; This query uses a self-join to calculate the cumulative sum. It joins the table with itself, matching rows where the id in the first table is greater than or

Ideas: How Bigadata Helps HR Teams


Big Data is the buzzword of the year. Every leader — whether they’re managing a small team or are at the helm of a multinational corporation with thousands of employees — is wondering how they can use Big Data to better get to know their people, to create a setting that better suits their needs and, in turn, drive recruitment and retention.

As co-authors of The Decoded Company: Know Your Talent Better Than You Know Your Customers, we’ve spent a lot of time thinking about this exact topic. Here are the top five trends you should be thinking about.

  1.  We are living in a data-abundant environment, and it’s changing everything. Gary Hamel, one of the world’s leading thinkers on the topic of management, has written extensively on the topic of the technology of leadership (or what he more accurately calls the technology of human accomplishment).
  2. He believes — and we tend to agree — that this might be the most important technology humanity has ever created. It gives us extraordinary superpowers to organize people into achieving feats that would be otherwise impossible, particularly from an economic perspective. Consider, for example, that Apple has achieved a market cap of $468.99B with 80,300 full-time employees (from its 2013 Annual report), or almost $6m per head.
  3. The challenge is that the management tools we use every day were designed around the assumption that data is expensive to gather and therefore infrequently available. Today’s reality is very different.
  4. Data is abundant and incredibly cheap to gather, store, process, and analyze. This epic shift has led to radically different business models on one hand, but only incremental management philosophy tinkering on the other.
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