Logo Ust Does Tech
Logo Inverted Logo
  • Posts
  • Databricks
    • Databricks Labs Data Generator
    • Using Auto Loader on Azure Databricks with AWS S3
    • Using and Abusing Auto Loader's Inferred Schema
  • Data Lake
    • Introduction to Data Lakes
    • Deep Dive Into Data Lakes - SQL Bits
  • Data Mesh
    • What is Data Mesh?
    • Data Mesh Deep Dive
    • Data Domain Fictional Case Study in Retail
    • Data Product Fictional Case Study in Retail
  • Data Science
    • Forecasting Methods and Principles
  • SQL
    • Triangulation Arbitrage in SQL
    • CI CD with Synapse Serverless
  • Testing
  • Strategy
    • Why Data Quality is Important
  • Data Modelling
    • Tabular Automation with TMSL and PowerShell - SQL Bits
Hero Image
Forecasting: Methods and Principles

What comes to your mind when you hear the words forecasting, forecasts etc? Invariably, you’ll think of weather forecasts. But forecasts are much more than that. Forecasting is the process of making predictions of the future based on past and present data and analysis of trends. It’s a process that has existed for millennia, though often with dubious methodologies… Instead of looking in to a crystal ball to predict the future we are going to employ the power of statistics!

November 16, 2015 Read
Hero Image
Currency Conversion in SQL using Triangulation Arbitrage

Some systems use a single currency as a base, which is something that I noticed recently when working with IBM Cognos Controller, e.g. USD to convert local currencies into. But what if you want / need to rebase into another currency but still retain the original base? This doesn’t appear to be easy to achieve within Cognos Controller itself, but it is achievable within SQL and a wider ETL framework.

May 12, 2015 Read
Hero Image

January 1, 0001 Read
  • ««
  • «
  • 1
  • 2
  • »
  • »»
Navigation
  • About
  • Projects
  • Recent Posts
Contact me:
  • [email protected]

Toha Theme Logo Toha
© 2021 Copyright.
Powered by Hugo Logo