# Enass Zayed

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

## Activity overview

Latest activity by Enass Zayed
• 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 ...

• 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...

• 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...

• 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...

• 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...

• 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...

• 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...

• Enass Zayed created a post,

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...

• 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...

• 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...