Products
Services
Blogs
About
Our
Blogs
We Love To Share
So here are our latest blogs sharing what we have learnt lately, we hope it will make your life easier.
Power BI
Power Automate
Data Literacy
Web Design
Data Ops
MongoDB
Microsoft
Optimal People
SAS
Oracle
Community
ODE
Open Source
Trifacta
Qlik Sense
Coaching
Open Data
AgileBI
CloudBI
YellowfinBI
Optimal Company
Business Intelligence
Managed Services
Data Integration
Analytics
Amazon Web Services
Training
Visualisation
General
Data Engineering
Data Insights
Category...
Select one...
Date (Desc)
Date (Asc)
Author
Title
Remove Filters
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Making Sense of Google Analytics Data
By
Kate Loguteva
2019-06-11
February 9, 2022
Analytics
Here at OptimalBI we love data, and we get upset when it's only piled and doesn't produce value. Like many others who have a website, we use Google Analytics to collect its statistics. This is valuable marketing data, so we want to make use of it and help our...
Database Testing Automation
By
Kate Loguteva
2019-06-04
February 9, 2022
AgileBI
It is hard to overstate the importance of the database testing, erroneous data costs a lot for a business. Yet, when you say testing, developers' noses crinkle as they think it's hard and boring. I have worked on a multiple data warehouse development projects, and I...
Advanced Data Vault Course
By
Kate Loguteva
2019-04-30
February 9, 2022
AgileBI
Recently I went to the Advanced Data Vault Modeling course run by Hans Hultgren to take my knowledge to the next level. It was held in Melbourne, and this was my first time in Australia as well. It was hilarious to find out that the most attendees were from New...
How to Feed AWS Lex with Values from Database
By
Kate Loguteva
2019-02-19
February 9, 2022
Amazon Web Services
On our latest project we have added a chat bot to a website for an alternative way to get input parameters from user in natural language. We've got a library of objects we can visualise based on user's parameters, and it's stored in the database. When new...
Chaining Permissions between Databases in SQL Server
By
Kate Loguteva
2019-01-24
February 9, 2022
Business Intelligence
It's typical in Business Intelligence that users are not getting data from the Data Warehouse database directly. Although the table structure should speak to them, one should be careful when querying Slowly changing dimension type 2 tables to get only point in time...
Oh Data!
By
Kate Loguteva
2018-12-13
February 9, 2022
Data Integration
It is not uncommon for data warehousing to get the data from any possible source the organisation has. ETL developers like myself are enabling data collection from different database types, files and APIs. Recently I had to deal with something I haven't came across...
Store Your Data in a Cool and Dry Place
By
Kate Loguteva
2018-11-13
February 9, 2022
AgileBI
When it comes to the data storage in Business Intelligence, you have options of having an Operational Data Store (ODS), a Persistent Stage (PSA) and a Data Warehouse (DW); all of them are just databases though. I have noticed that sometimes these terms are used...
Data Vault on Graph database
By
Kate Loguteva
2018-09-25
February 9, 2022
Business Intelligence
Recently I have bumped into this blog by David Nicholson. I have heard an opinion that the Graph database and the Data Vault look similar before. This idea comes to mind when you see diagrams next to each other. (You can draw them to be identical, but it doesn't prove...
Graph Database in SQL Server
By
Kate Loguteva
2018-09-11
February 9, 2022
AgileBI
Microsoft has introduced a new feature of graph database in SQL Server 2017. This is not a new idea, graph platforms were on the market for a while now. I have decided to dive in to understand why graph databases are special and how they could be used in Business...
SQL Server Table Partitioning: Divide and Rule
By
Kate Loguteva
2018-08-29
February 9, 2022
Microsoft
For the first time I am on the project that has big enough Data Warehouse tables that could be partitioned. While many data warehouses are big, in my previous projects a single table has rarely exceeded a few million rows, which means it is too early to think about...
Copying a database in SQL Server Data Warehouse
By
Kate Loguteva
2018-08-02
February 9, 2022
Business Intelligence
Data Warehouse solutions often include several copies of the same structure, I mean Development, Production and often Test and Pre-Production environments. When the Data Warehousing team works on the new piece of requirements, they don't want to put fully functioning...
MS SQL Server Management Data Warehouse
By
Kate Loguteva
2018-07-02
February 9, 2022
Business Intelligence
Imagine for a minute, a conversation between a database administrator and a data warehouse developer. DBA asks: "I could never understand what you folks actually do..?" - "Well, we create a single database called a data warehouse where the data from multiple other...
Data Vault: The End of a Star?
By
Kate Loguteva
2018-06-27
February 9, 2022
Business Intelligence
Quite often people ask me, "What's so good about Data Vault that I should immediately start using it instead of the Dimensional modelling I have been using for years?". This is an extremely tough question, so on this point I usually say "You shouldn't, if you are...
Working with files in MS SQL Server
By
Kate Loguteva
2018-06-06
February 9, 2022
Data Integration
With the rise of Digital era more and more organisations want to exchange the data. I'm not talking about Facebook, but mostly about the government organisations I usually work with. One could think that it would be implemented as some sort of API allowing machines to...
Isolating Data Warehouse Layers with MS SQL Server Database Snapshots
By
Kate Loguteva
2018-05-08
February 9, 2022
Business Intelligence
Data warehouses are like ogres... and onions. They have layers. Any Data Warehouse architecture will have at least staging and business data layers, also there could be a raw data layer and a reporting layer. Layers, physical or virtual, should be isolated for...
What's New in ODE version 5
By
Kate Loguteva
2017-09-28
March 23, 2022
ODE
This week we released version 5 of our Optimal Data Engine. Follow the link to download it from the GitHub. Optimal Data Engine (ODE) is an open source Data Warehouse automation tool. It is a config-driven engine that builds and manages your Data Vault. ODE works on...
Reference Data Management with SQL Server Master Data Services
By
Kate Loguteva
2017-07-05
March 23, 2022
Business Intelligence
If you are in Business Intelligence and work for a big organisation, you've might, once or twice, seen a "magic" Excel spreadsheet that holds some valuable data for a few key reports. This data is called a reference master data. Typically it's a relatively static...
Triggers I Have Known and Loved
By
Kate Loguteva
2017-05-12
February 9, 2022
Microsoft
Triggers in Microsoft SQL Server Triggers are pieces of code which are automatically executed on the occurrence of an event in the database. They can be a good solution for a whole range of problems. However, many SQL Server users choose to avoid using triggers as...
Newer Entries
Older Entries
Copyright © 2019 OptimalBI LTD.