Avatar

Enass Zayed

  • Total activity 35
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 17

Activity overview

Latest activity by Enass Zayed
  • Avatar

    Enass Zayed created a post,

    Change in KPI Chart

    Motivation A frequent business question often posted is "What is the change in [users, units sold, views, etc]? Using Python's matplotlib library, one way to visualize this change is to visualize ...

  • Avatar

    Enass Zayed created a post,

    SQL Order of Operations

    The first thing you'll learn in SQL is the order in which we write various clauses in our queries (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, then LIMIT). However, the order in which the data...

  • Avatar

    Enass Zayed created a post,

    Sorting Stacked Proportional Bar Charts by Magnitude

      By default in many charting libraries and tools, series within stack bars are arranged in the same order. Looking at the image below, blue is above orange, which is above green, which is abov...

  • Avatar

    Enass Zayed created a post,

    Window Functions!

    Window Functions are a great way to analyze your data in a different way! Similar to other calculation statements in SQL, window functions allow you to do a calculation across a set of rows or colu...

  • Avatar

    Enass Zayed created a post,

    Additional Date Aggregations: Aggregating by 5 Minute Intervals

    We worked with a customer recently who wanted to aggregate their data in 5 minute intervals. We had a clean way to implement this: from_unixtime(300*floor(unixtime/300)) How this works: We divide t...

  • Avatar

    Enass Zayed created a post,

    Every kind of JOIN

    More often than not, you'll need data from multiple different tables to create the perfect chart! There are many ways to do this but the most common way in SQL would be to use Joins!  There are fou...

  • Avatar

    Enass Zayed created a post,

    Hyperlink to Email - Gmail

    Sisense has a lot of cool functionality around converting links to a simpler format using Markdown language. However, doing things that require more advanced functionality such as bringing up an em...

  • Avatar

    Enass Zayed created a post,

    Everything about CTEs!

    CTEs (common table expressions - also commonly referred to as "with clauses") are an extremely powerful tool in SQL! Similar to subqueries, they can pull "a query in a query," but can be called mul...

  • Avatar

    Enass Zayed created a post,

    Creating a table of variables in SQL

    MySQL aficionados have likely leveraged its ability to declare variables. Unfortunately, this capability isn't supported by all flavors of SQL. For such situations, we can still achieve a similar r...

  • Avatar

    Enass Zayed created a post,

    SQL Alert - Tell me if a value dropped since yesterday

    SQL Alerts are very handy to keep track of any critical metrics. Oftentimes it makes most sense to do a relative comparison of your data. For instance, "alert me if my metric dropped between yester...