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.
New Zealand Traffic Data
By
Steven Morrison
2020-07-22
February 9, 2022
Data Insights
When you ventured out to the supermarket during lockdown, I bet you noticed waaaay less traffic on the roads. I live in the Wellington CBD, and it was really weird walking around with no people, no traffic for weeks. It got me wondering about the data; Thankfully...
Learning Azure with Pluralsight
By
Kate Loguteva
2020-07-14
February 9, 2022
CloudBI
Cloud solutions have little to do with the solutions we have on-premises. Cloud solutions are built with ambitious and monstrously huge goals in mind, so, often it feels like no previous technology has been reused. In addition to some understandable concepts, like...
How to Model a Reporting Layer
By
Kate Loguteva
2020-07-08
February 9, 2022
AgileBI
On my first BI job, where I was an ETL developer, my team was using Microsoft SQL Server Reporting Service (SSRS) as a reporting tool. My job was to model the Data Marts and create the data flows into those tables. Our report analysts were good at SQL, I have even...
ETL is Easy Again in Azure Data Factory
By
Kate Loguteva
2020-06-20
February 9, 2022
CloudBI
Almost two years ago I was a part of the BI team in an organization that decided to move to the Cloud. As a first step they followed the lift and shift approach, so they moved their Data Warehouse and all the existing processes into the Azure environment almost...
SAS Functions Book
By
Steven Morrison
2020-06-18
February 9, 2022
Business Intelligence
Over the years, we've been building up our comic-style SAS function one-page guides, drip-feeding them to you. Well, guess what?! We put them all together and made a book so they're all in the one place, to make referencing them easier for you. Thank you...
Zen and the art of database model maintenance
By
Brent Adcock
2020-06-11
February 9, 2022
Data Integration
So there you are having created a work of beauty in Sparx Enterprise Architect that models all of your databases, and then the fly lands in the ointment. There's a new version of "stuff" coming down the pipeline and you need to update the model or things are...
Checking the File Path from Database in PowerShell
By
Kate Loguteva
2020-05-25
February 9, 2022
Data Ops
On one of my recent projects I was analysing my customer's data for migration. Their legacy application could handle documents. They were stored on the organisation's shared folder, and the file path was recorded in the database with the rest of data. As a part of the...
The best lockdown baking recipes
By
Steven Morrison
2020-05-20
February 9, 2022
Community
The nation has been hit by a baking craze! Lockdown gave some of us more time to do some of the simple things in life, like baking, and, if you were lucky enough to get flour and yeast you could create some delicious treats! I've always enjoyed baking, so loved...
Snowflake and Qlik: End-to-End BI Solution
By
Kate Loguteva
2020-05-14
February 9, 2022
AgileBI
Recently I watched a webinar organised by Snowflake, it was called "Data Warehouse Automation, Ingestion and Industry Leading Analytics with Snowflake and Qlik". In the past I could never find time for webinars, and it's amazing how life can give you opportunities to...
Being social while social distancing
By
Steven Morrison
2020-05-12
February 9, 2022
Community
The world has been social distancing for some time now, and will be for a bit longer, depending where you live. To help put off or at least mitigate going stir crazy I thought I would share what I have been doing to keep up some sort of social life. Before the lock...
Free ETL tools in 2020
By
Kate Loguteva
2020-05-04
February 9, 2022
Business Intelligence
Traditionally business intelligence is an enterprise solution, as only big businesses have multiple sources that require integration and analysis. It is assumed that the rest are small fishes that could be able to analyse their data with simpler accessible tools or...
SAS Utilities: cleanwork
By
Barry Stevens
2020-04-29
February 9, 2022
Business Intelligence
When a user starts and runs code in a SAS session, a number of temporary folders and files are created in the SASWork and SASUtil locations. If that session completed and exits normally these folders and files are removed, however some SAS sessions exit abnormally,...
1080 By The Numbers
By
Steven Morrison
2020-04-28
February 9, 2022
Visualisation
If you have lived in New Zealand for long enough, I am sure you would have heard of the poison 1080, used by the Department of Conservation (DOC) as a form of pest control. 1080 can be used in bait stations or by airdrop, which is used for many of the remote and hard...
Keeping your team connected when they’re working remotely
By
Steven Morrison
2020-04-20
February 9, 2022
Community
Lockdown started on the March 26 here in New Zealand, and following the Prime Minister's announcement on April 20th, we're looking at just an extra 2 business days in Level 4, before we move to Level 3 after the ANZAC long weekend. Level 3 means that...
Adobe equivalent Free Open Source Software (Pt2)
By
Steven Morrison
2020-04-16
February 9, 2022
Open Source
In part two of my Adobe equivalent Free Open Source Software (FOSS) blog I thought I would look at the video editing pipeline and find some free alternatives for your video editing needs. You can read Part One which covers Photoshop, Illustrator and InDesign here....
Difference between ETL and CDC
By
Kate Loguteva
2020-04-06
February 9, 2022
Business Intelligence
Reporting and analytics computations are usually very resource-consuming, therefore they are never executed on the same server where the crucial business application is running. Instead, data is copied into dedicated servers to be dissected and studied for insights....
Keeping your brain busy while in lock down
By
Steven Morrison
2020-03-31
February 9, 2022
Training
Many places all over the world are currently in self-isolation mode in response to the COVID-19 pandemic. In New Zealand, lock down started on Thursday March 26, which means that some people are able to work from home. At OptimalBI, we are working from home and on the...
Check out our new website!
By
Bronwyn Scott
2020-03-18
February 9, 2022
Business Intelligence
Woohoo we've got a new website! If you're reading this blog you're already on it and we reckon you should click a few extra buttons than you were planning to and go check it out... Data really does make anything possible, and we're here to help you harness data...
Previous
Next
Copyright © 2019 OptimalBI LTD.