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.
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...
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...
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...
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...
Motivation Via Data
By
Steven Morrison
2021-06-08
February 8, 2022
Visualisation
How to Use Data to Motivate.I have found myself not motivated to get up and out walking for a while now and know I need to do something about it. However, even with this realization that I have not done anything about it for the last few weeks. So thought I would try...
Working With Typography. 101
By
Steven Morrison
2021-06-01
February 8, 2022
Visualisation
We use words each day of our lives it is only when we use these same words on a screen that we think about how we display them. The ways you can play with typography are endless. You can go from the simply use of contrasting fonts for the body text and headings to the...
Adobe How To – Photoshop Part 2
By
Steven Morrison
2021-05-24
February 8, 2022
Training
Carrying on from part 1 where I covered how to remove objects from images in multiple ways I am going to cover some more things that can help you out in Photoshop first up is one of the big things in Photoshop, that being masking. The 2 main ways to mask that I use...
Google Analytics… Why use it?
By
Steven Morrison
2021-05-18
February 8, 2022
Data Insights
Google Analytics I have been using Google Analytics for a while now mostly to look at the traffic on our site. Why I have been doing this is for a few reasons one of which is just to keep the team up-to-date with our top blogs. Why I do this and why it is important...
Adobe How To – Photoshop Part 1
By
Steven Morrison
2021-05-11
February 8, 2022
Training
Much like Illustrator Photoshop is a great tool for design. Photoshop is not just for editing photos, but for working with images to create works of art for whatever project you happen to be working on. There are many great tools in Photoshop to help you in your...
Getting Past The Wall.
By
Steven Morrison
2021-05-04
February 8, 2022
General
Sometimes the hardest things about design work is not the design itself, but the countless hours where you are trying to think of what to even make. Sometimes it’s easy you sit at your desk and boom you are going. Other days you are sitting there coming up with ideas...
Adobe How to – Illustrator
By
Steven Morrison
2021-04-20
February 8, 2022
Training
Most Adobe programs have some things that are easy to do once you know how to do them, but if you don’t it’s not very intuitive so I thought I would do a list of things and tell or show you how to do them. Paste in place This is a very easy thing to do and can be very...
Git 101
By
Steven Morrison
2021-04-13
February 8, 2022
Training
Git is an unbelievably useful tool for version control. It is used to keep a backup of your work that you can revert to if needed. Working with git you are able to make branches of your work. A branch is an independent line of development used when working on any new...
How to read and work with data in python
By
Steven Morrison
2021-04-06
February 8, 2022
Data Insights
I've found that most of the tutorials for python data work are in videos. While this can be good, it's not as easy to skim through for that one thing you are stuck on. So I thought I would cover some basics: how to read a csv and some simple data visualization. Read...
3 reasons why I like Python
By
Steven Morrison
2020-09-07
February 9, 2022
Data Engineering
3 reasons why I enjoy coding with Python, and what I use it for (beginner) I can’t be called a code monkey when compared to my colleagues, but recently I’ve found Python to be really helpful with some of my work tasks, so I signed up for a Udemy course to learn...
Where to find some open data
By
Steven Morrison
2020-07-27
February 9, 2022
Open Data
The OptimalBI team loves open source and is also mad about data. Alison wrote a blog on Open source datasets already, and because there's more options out there, I thought I would give you some more places to get open data from for your various data needs. I have...
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...
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...
Older Entries
Copyright © 2019 OptimalBI LTD.