A geographic information system (GIS) is a framework for gathering, managing, and analyzing data. Rooted in the science of geography, GIS integrates many types of data. It analyzes spatial location (spatial is defined as something related…
DTC: Direct-To-Consumer
WHAT’S DIRECT-TO-CONSUMER (DTC)? Direct-to-consumer (or DTC or D2C) has created quite a shift in the dynamics of the retail industry. Why? Because it allows businesses to cut out the retailer and distributor intermediary, thereby going…
Google Big Query
BigQuery – Google's server-less, highly scalable enterprise data warehouse, is designed to make data analysts more productive with unmatched price-performance. Basically BigQuery is an online database. The benefit of having an online database is that…
Dual Dashboard
Sometimes a company has multiple dashboards for its brands. Before we had just different dashboards for each brand, but now we have a solution that will make managing multiple dashboards much easier! The solution is…
The Feedback Loop
It is widely known that companies are using Business Intelligence software to retrieve, analyse, and transform data into useful business insights. Off-the-shelf Business Intelligence tools include data visualisation, data warehousing, dashboards, and reporting. In contrast to…
Mediacom’s TV template automation
Mediacom TV department contacted us with an idea to make TV planning template more automated, so that the planning phase would be faster. They had the knowledge, how all the calculations should work but not…
SQL server creation and data storage with the…
Since June, we have also been building an overall database to better access data for our dashboards, secure the data access (e.g. if customer changes the webpage and the GA stats get messy) and to…
Adding pictures automatically to a dashboard
In August the team created a system that allows to add multiple images to Power BI dashboards. It has always been one of the most popular suggestions on how to make our dashboards even better.…
Blockchain campaign run by Mindshare AMENA
TLDR version: "Mindshare Asia ran a test blockchain enabled campaign for a FMCG client with a positive result - 28% increase in viewable impressions" The use of blockchain as a technology in media has been widely…
Automated analysis using the MMM framework – Part…
In the previous newsletter, we've talked about how creating an MMM framework simplifies the approach to an unknown dataset and presented an automated correlation analysis. Now we'll present a different section which digs deeper and…