Data warehouse, data lake and delta lake data platform architectures behave differently in the terms of data upserts or merge, and file partition compaction management. Big data often requires inserts, updates, or other incremental data… Read More »Data Lake VS Delta Lake – Data Upsert and Partition Compaction Management
Azure Synapse serverless on-demand SQL is easy to use and makes fast big data analytics available to everyone who knows SQL. However, there are a couple of optimization actions which significantly reduces the SQL query… Read More »Azure Synapse Serverless SQL Optimization with Examples
I had the chance to present 8.4.2021 in Power BI User Group Finland how Helen Ltd. uses Power BI composite models at the enterprise scale. Here is a summary of the presentation, with the example… Read More »Power BI Composite Models Architecture Example
The key to drive business with numbers and digitalization is to enable seamless analytics and the excitement of discovery to different analytics user profiles. I have encountered three key analytics user profiles in business: DIY.… Read More »How to Serve Three Dissimilar Analytics User Profiles
I had the chance to make a public presentation on the development and results of a forecasting model used in the hedging of the electricity sales of Helen Ltd. Helen has over 450,000 customers throughout… Read More »How to Forecast Long-term Electricity Demand for Hedging, Residential Sector