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.
Power Automate and creating CSV files
By
Brent Adcock
2023-01-25
January 25, 2023
Power Automate
A simple way to use Power Automate to enable importation of a Summary Excel Workbook into 3rd party reporting tools.
It's the (service) principal of the thing
By
Brent Adcock
2023-01-25
January 25, 2023
Power Automate
This post outlines how to add a Service Principal connection for Dataverse to a Managed Power Automate Solution.
Power BI Visuals
By
Ayesha Mangera
2022-04-13
May 25, 2022
Power BI
An overview of the Visualisations available within Power BI to help present your data.
Introduction to Power BI
By
Ayesha Mangera
2022-04-11
May 25, 2022
Power BI
This blog is an introduction to Microsoft Power BI and the first in a series on how your organisation can use it to explore the data to make business decisions.
Data literate companies are best placed to win!
By
Ayesha Mangera
2022-04-07
May 25, 2022
Data Literacy
A blog on why Data Literacy is so important for companies in the modern data driven world of commerce and steps to improve data literacy within your organisation.
Extension Points in BIML Flex
By
Kate Loguteva
2022-03-16
March 16, 2022
Data Engineering
I have started my career in Business Intelligence with SSIS. We had a reasonably small data warehouse, and my job was to maintain the existing SSIS packages and create new ones. Most of what I was doing was same again, so I could copy and paste many elements from one package into another...
Why Webflow is not just another site designer.
By
Steven Morrison
2022-03-09
March 9, 2022
Web Design
Over my years of web design, I have used many different tools from pure HTML, CSS and JS to WordPress and even Square Space. When I started looking into Webflow I was a bit apprehensive about another no code web-based designer. After I got started playing around with the designer, I was sold...
Power Automate and Excel Data Tables
By
Brent Adcock
2022-03-02
March 2, 2022
Power Automate
So a little while ago I showed some examples of using Power Automate and Excel files. One of the major caveats of using the Excel files was that there needed to be a defined data table in the Worksheet of interest. This blog post will show you a way to get around that limitation…
Low-code, No-code platforms
By
Ayesha Mangera
2022-02-28
April 6, 2022
Data Insights
An overview of the Low Code - No Code platforms and the benefits that they can bring to your business.
Switching to Webflow from WordPress
By
Steven Morrison
2022-02-24
February 24, 2022
Web Design
If you have a look around our website, you made notice a few slight changes to our site this is because we have finally made the change from WordPress to Webflow. Why we did this is for a few reasons one of the top reasons being speed...
Generating date series in Postgres
By
Kate Loguteva
2022-02-23
February 23, 2022
Data Engineering
It was the day when I finally fell in love with Postgres. I got a challenging task to generate data that haven’t existed for reporting. It turned out that it’s very easy to achieve in Postgres…
Saying Bon Voyage to Foghorn
By
Steven Morrison
2022-02-22
February 23, 2022
Optimal Company
It has been a very weird few years now and a lot has changed. Lockdowns and borders being closed thanks to Covid has changed our little group of islands from an international tourist destination to a place for the locals to wander around...
Power Automate making your Excel life easier
By
Brent Adcock
2022-02-16
February 16, 2022
Power Automate
Power Automate is an online tool designed to make your life easier and more productive. This article will show you how to do this with Excel in a way to get rid of the good old manual copy and paste that is a bane of many peoples existence.
Working with JSON in Postgres
By
Kate Loguteva
2022-01-13
May 25, 2022
Data Engineering
One of my customers has a very elegant multi-tenanted application with the flexible schema achieved by the extensive use of JSON. While base tables are the same, JSON allow a lot of customisation. Unfortunately, the tradeoff of this is a lot of manipulation...
Data suggests you should get the COVID-19 vaccine
By
Nic Cox
2021-09-16
February 16, 2022
Data Insights
Data suggests you should get the COVID-19 vaccine Data for this New Zealand focused blog was collected from various worldwide sources between the 18th and 31st August 2021. A list of sources can be found at the end. NZ is currently vaccinating solely with the...
Performing MERGE in PostgreSQL
By
Kate Loguteva
2021-08-31
February 8, 2022
Data Engineering
photo by kolibri5 Some RDBMS support SQL statement MERGE, which also referred as upsert. This is a very common task in data warehousing: we compare the source dataset with what has been recorded in DW, insert new values and update those which have changed since the...
It Is Ok To Make Something For A One Off.
By
Steven Morrison
2021-06-22
February 8, 2022
General
I have done a bit of web scraping lately both to automate some of the tasks I do regularly and some to get data for projects. I have learned one big thing from doing this it is ok to do something for a one off ... sometimes. There are times when working on scripts...
Word Clouds with Python.
By
Steven Morrison
2021-06-15
February 8, 2022
Visualisation
I have been using python for a while now and have used it for a number of different projects, but this one surprised me. Word clouds are something I have not used before. Then, I had the idea of using it for a project a while ago and struggled with finding a way to...
Next
Copyright © 2019 OptimalBI LTD.