Tag: Join

Feed: Matillion. Author: Matthew Scullion; Welcome to Q2. Budgets are set, strategies unfolding and sales plans in place.  It can be a time when it’s difficult to see how you’re going to change the way the year turns out for your company but self service reporting could change all that. Well, here are simple 7 ways that something fast and cost effective to implement – cloud-based self service reporting and business intelligence – could deliver REAL bottom line impact in months or weeks: driving-up revenue, freeing-up working capital, growing margins, increasing cash and saving time. Each of the following ideas are ... Read More

Feed: Matillion. Author: Matthew Scullion; There are two types of Business Intelligence solution.  Those that use a proper Data Warehouse, and those that don’t. In our opinion, a Data Warehouse is key to a successful Business Intelligence implementation.  It allows you to join data together from different sources and put all it into one place – one version of the truth.  You can organise the data to make it easy to work with.  You can apply rules and calculations to the data before it enters the Data Warehouse, meaning when you come to report over it, the answers are already ... Read More

Feed: Matillion. Author: Matillion; The Matillion BI Glossary is the “dictionary” of business data available for you to use Matillion BI. Fields in the Glossary can be added to reports and analyses in a simple drag-and-drop manner. The Glossary is great because it means you don’t need to know technical field names, where data is held or how to join complicated tables together.  Instead, you just choose sensibly named fields with useful tooltips from the Glossary, then get on with your reporting and analysis. As part of every implementation, we carefully identify what fields your business needs in its Glossary ... Read More

Feed: R-bloggers. Author: Swimming + Data Science. Did you know that Ohio’s state song is Hang On Sloopy, best known as a hit for the McCoys in 1965? Me either, but this week in the State-Off Tournament we’ll see if seventh seed Ohio (7) can cough hang on against second seeded Texas (2).We’ll also continue building our meet scoring function, with en eye towards including it in a future SwimmeR release.library(SwimmeR) library(dplyr) library(readr) library(stringr) library(purrr) library(flextable) library(ggplot2)Texas ResultsThe Texas results repository strangely doesn’t have results for the 2019-2020 meet, although it was held. After a bit of googling I did ... Read More

Feed: Planet MySQL; Author: Justin Swanhart; I like bugs.  Probably not as much as Valerii Kravchuk (http://mysqlentomologist.blogspot.com/) a former colleague of mine who posted about MySQL bugs for a long time, but I still like bugs.  I like finding bugs, I like fixing bugs, and I like analyzing bugs.   While I work on the WARP storage engine, I am filing bugs and feature requests for issues I find with MySQL.  I also like to comment on MySQL bugs in the bug database to help the MySQL engineers find root causes, and to help end users with workarounds, or explaining ... Read More

Feed: Planet PostgreSQL. © Laurenz Albe 2020Many people consider recursive queries a difficult topic. Still, they enable you to do things that would otherwise be impossible in SQL.This articles gives a simple introduction with examples and shows the differences to Oracle’s implementation of recursive queries.Common table expressions (WITH clauses)A common table expression (CTE) can be seen as a view that is only valid for a single query:WITH ctename AS ( SELECT ... ) SELECT ... FROM ctename ... This could also be written as a subquery in FROM, but there are some advantages to using CTEs:The query becomes more readable.You ... Read More

Feed: SAS Blogs. Author: Mike Gilliland. As we saw in the last installment, The Confidence Man works by making every assertion -- no matter how ridiculous, heinous, or false -- with extreme confidence. By following this practice, with never a waver or inkling of self-doubt, roughly 40% of people will follow along in adoration. If you as a forecaster could pull off this confidence trick, you'd be on the Mount Rushmore of Forecasting! But you can't ... and for good reason. Forecasters operate in a loop of continuous feedback. Their forecasts are published and stored in the organization's system of ... Read More

Feed: Planet PostgreSQL. This idea came to me today from swills: stupid question, would it be possible to make the urls on freshports case insensitive? so that like https://www.freshports.org/x11/libx11 would go to https://www.freshports.org/x11/libX11 After confirming this was for manually typed URLs (as opposed to generated links), I started looking into it. This is what I found. In this post, we’re going to look at some old PHP database code and the PostgreSQL stored procedures behind them. I’ll show you the multi-line stored procedure now in use and how a single query will now do the same thing. This change isn’t ... Read More

Feed: Planet PostgreSQL. There you are writing some SQL, having a great time. Uh oh, you need to iterate over each item in a result set and apply a function. You think, "Now I am going to have to write a stored procedure." Well today's post will give you an alternative by using lateral joins in Postgres.  Lateral... See what I did there? You are probably familiar with normal database joins, which are usually used to match up a column in one table with a column in another table to bring the data from both tables together. When the keyword ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Anubhav Sharma. By Anubhav Sharma, Sr. Partner Solutions Architect, AWS SaaS FactoryBy Tod Golding, Principal Partner Solutions Architect, AWS SaaS FactoryAs you design, develop, and build software-as-a-service (SaaS) solutions on Amazon Web Services (AWS), you must think about how you want to partition the data that belongs to each of your customers, which are commonly referred to as tenants in a SaaS environment. There are several factors (noisy neighbor and data isolation, for example) that influence how you choose to store tenant data. You may choose to store your data in separate storage ... Read More