Blog

by Andrew Bilsdon, Delivery Lead – Altis Sydney ‘Understanding of a situation or event only after it has happened or developed.’ So why would we bother writing a blog about this, how can we understand something before it happens? My thoughts are not related to the order in which we do things, I am going to

By Mik Panchal, Managing Consultant – Altis Sydney As we welcome 2020, we want to take the time to celebrate our top stories from 2019 and thank our Altis community for the great content. Here are some of our success stories & how we have helped our customers achieve tangible business outcomes. Using Machine Learning

by Andrew Bilsdon, Delivery Lead – Altis Sydney Google Earth and the accompanying Earth Engine are a fantastic source of satellite data. Before starting, it will help to understand a little about satellite data and how it is shared. Firstly there are many satellites that are available to the public, a few examples include: European Space

by Ian Stuart, Principal Consultant – Altis UK As a company, we are proud to offer sponsorship to sporting teams that our employees and their families are involved in! When I heard of the scheme I was quick to suggest sponsorship of my hang gliding and paragliding club in Kent: Dover & Folkestone Hang Gliding

by Andrew Bilsdon, Delivery Lead – Altis Sydney I have the pleasure of working with a colleague who was a professional chef. He is humorous and keen to share his experiences with those of us who have time to chat. One day, we were discussing the latest reality show that involves chefs and young aspiring

Andrew Bilsdon, Delivery Lead – Altis Sydney Let’s agree that the cliche of ‘data is an asset’ is not disputed, the question is really, how much of an asset. Before we go too far, some ground rules: The terms Data and Information are used interchangeably as is the case in general conversation, particularly with non-IT

Mik Panchal, Managing Consultant – Altis Sydney Are you working on a dashboard containing Actuals vs. Budget KPIs? This post will discuss the use of a Bullet chart as an alternative to a Gauge chart by looking at the good and not-so-good aspects of each approach. Gauge Charts Gauge charts look great, but how effective

Mik Panchal, Managing Consultant – Altis Sydney Are you implementing an Analytics solution using Azure and Power BI? Mik Panchal, our Sydney Managing Consultant, shares our recent success story using Microsoft Cloud infrastructure. This post will walk you through the benefits of using our Azure Framework and Power BI to provide robust self-service capabilities to

Guillaume Jaudouin, AWS Practice Lead – Altis Sydney In the few weeks leading up to AWS re:Invent, there have been a few important service enhancements announced in the data & analytics space. Here is your quick guide to the recent AWS announcements. Two AWS Redshift announcement to start with:   Amazon Redshift Automatic Table Sort

by Aleck Kulabukhov, Managing Consultant Sydney   Introduction XML parsing is a compute-expensive exercise. XML is quite a popular way to store unstructured data so we often face a “Big XML Dilemma” – we can either: pre-parse XML, extract the required fields and store them in a most efficient and fast-to-query way (such as Data

Ian Stuart, Principal Consultant – Altis UK Microsoft’s Power BI Dashboard In A Day workshop has been developed over the past three years as a free event for those interested in exploring Power BI or furthering their Power BI knowledge.  It is aimed at those with some reporting expertise and prior knowledge of Power BI

by Phoebe Parker – Consultant, Altis Melbourne   Recently, a client asked if it was possible to customise the axis on a line graph in Power BI, as there was no option for it in any menus. We did not want to change the chart type, as it was still the best way to visualise

So you have been inundated with information about upcoming internships and graduate positions, now it’s time to make the choice. Here are a few tips when looking to apply for the right internship for you: BE PREPARED. Most intern applications require current transcripts and an up to date resume. Make sure you include information that

Ian Stuart, Principle Consultant, Altis UK   I have been attending the London Power BI User Group for a few years now and I heartily recommend going along to it or to your local one.  Mary Fealty was the main presenter at the last event and she described the London meetup as “the biggest on

Have you been wondering how to get more value from your Salesforce data?  Margaret Chan, our New Zealand GCP Practice Lead, shares how to easily import Salesforce data into Google BigQuery. Integrate Salesforce data using BigQuery Data Transfer Service Create a project and enable the BigQuery API Enable the BigQuery Data Transfer Service Assign users that will create the

Richard Roose, NSW Delivery Lead shares his views on where Snowflake fits into a Data and Analytics architecture.   Whilst RDBMS’s have long been used for traditional transactional workloads (OLTP), the focus of this discussion is on their use for Data & Analytics workloads (OLAP).   In a world of on-premise vs. on-premise cloud vs.

To Data Lake, Data Hub, Data Warehouse is not the question. Which cloud platform to put your Snowflake instance on is the question – talk to Altis about the answer. For those contemplating re-architecting or greenfields data lakes/data hubs/data warehouses in a cloud environment, talk to Altis about why you should be considering the “tour

by Ian Stuart, Altis UK Recently I reported that Antonio Burian, aged just 18, won the Romanian National Championship and, as a result, qualified for the Paragliding World Cup in China. I am delighted to report that he was placed 31st in a field of 118 of the world’s top pilots.  This is a remarkable

by Ian Stuart, Altis UK   Antonio Burian, aged just 18, has just won the Romanian National Championship and, at the same time, qualified for the Paragliding World Cup. He is on his way to China as I type to take part in that! This is his greatest accomplishment to date having previously: • broken

By Kent Teague, Managing Consultant, Melbourne With the rapid spread of data visualisation tools like Power BI and Tableau, often outside of IT, Altis is commonly asked: is the data warehouse dead? Can’t I just grab the data and create my own reports? This article will talk to the continued importance of understanding the business

by Dawie Kruger, Microsoft Azure Practice Lead It was great to attend the launch of Snowflake on Azure. Having implemented the Snowflake solution on AWS for more than 6 clients, it is great to see the addition of the Microsoft Azure infrastructure.  For those of you wondering what Azure services are being utilized here is

Delivery and Higher Education Practice Lead, Altis Consulting, Australia Peter chose to be interviewed on a sailboard at sunset in Jericoacoara, Brazil. Connect with Peter 1. Tell us about what Altis does, and the specific assistance it offers its customers in the UK. Altis works exclusively in the field of data and analytics and has

By Margaret Chan – GCP Practice Lead, New Zealand Altis recently launched our new cloud practice focused on Google’s Cloud Platform (GCP) and as the NZ GCP Practice Lead I recently sat the Professional Cloud Architect exam.  In this blog I will share my learnings and thoughts through the certification journey.  Hopefully this will be

  By Katrina Pilcher, RM and Mythili Baker, Head of Innovation     Growth in the adoption of self-service BI tools and increasing data literacy across organisations is leading to an increase in the number of individuals across the business who want to and who have access to be able to perform their own analytics.

  By John Hoffman, CEO   In celebration of International Women’s Day, Altis wanted to acknowledge our success while highlighting an area for improvement.   No gender pay gap For the third year in a row, women are paid the same as their male counterparts and in some cases slightly more at Altis, Australia’s largest

By Chris Kearns, Regional Manager, Altis UK   Consider the following four scenarios and ask yourself which is closest to your organisation: Scenario 1: Your organisation relies on an army of people to manually create a mountain of spreadsheets/PowerPoint slides to provide information to support decision making. Different people create similar siloed reports that don’t

Nadine Hamilton – Principal Consultant, Canberra     There are many reasons that organisations, both public and private should be sharing data, not the least is the significant potential it offers for social and economic benefits through better delivery of services, better and more informed decision making or policy setting, and to support research into current and emerging social, economic and environmental issues.  The

Richard Roose – Principal Consultant, Sydney   What makes a Modern Data & Analytics (D&A) platform? Well, it turns out that much of what defined a traditional Data Warehouse is still required for a Modern Data & Analytics Platform. We still extract, clean, merge and load data but modern times have resulted in more variety of

Samuel Ward-Riggs – Managing Consultant, London First DevOps, now DataOps (and ArchOps, DevSecOps, and WinOps!?).  You would be forgiven for thinking that the tech hipsters have started a campaign of random capitalization, emulating their favourite i-products and the eXPeriments carried out at the turn of the ME-llennium.  But make no mistake: DevOps is a step-change in

A great way to start 2019 with Altis being awarded our Microsoft Gold Cloud Platform Competency. This goes hand in hand with our Gold Competencies in Data Analytics and Data Platform. If you would like to know more about our offering on the Azure Platform, have a look at our Microsoft Azure Practice Page or contact us.  

Sam Turner, Consultant, Altis Sydney   The Power BI REST API allows users to programmatically control their datasets in the Power BI service. This includes triggering a refresh of a dataset, monitor the status of a currently refreshing dataset, or view the refresh history of a dataset. As will be demonstrated, the use of this API

Guillaume Jaudouin, our AWS Practice Lead shares his thoughts on one of the major AWS announcements from the re:Invent week, Lake Formation.  Below are some of Guillaume’s initial thoughts on this recently announced service. This is one of the most exciting announcements from the AWS re:Invent week (at least for us with a focus on

Neil Sparrow, Managing Consultant, Altis London When I started my career as a technical guy I firmly believed that “problem solving” in the realms of “technical” i.e implementing a specific system vs  “soft skills” such as business analysis were worlds apart. Over the last decade, working in mixed projects covering both aspects, I have changed my

Neil Sparrow, Managing Consultant, Altis London Neil recently attended a fascinating meetup discussing how the nature of how we manage data could change. Hosted by the DataNinjas community and Blis group, he heard speakers from the web advertising, data hosting and data science sectors. These are his key takeaways: Data as Product We should treat Data as

Richard Roose, Principal Consultant from our Sydney office, recently attended a Lunch & Learn session hosted by Altis where Snowflake presented their disruptive technology offering. Richard shares his 4 key takeaways below. Separate Storage & Compute: The 1st piece of the puzzle was to separate storage from compute. This simple concept created a number of distinct advantages.

Sean Ryan, Senior Consultant, Sydney Overview of Spatial Capabilities in PowerBI: It has only been in the last 5-10 years that mapping capabilities have made a transition from specialised GIS (Geographic Information Software) software into mainstream tools that are being utilised by a far wider audience across organisations that never had a dedicated spatial team

Our Canberra and Sydney teams recently participated in GovHack 2018. In Canberra, the teams developed Communities Skin Health – A mobile application that identifies skin conditions Insolvencies Fact or Spin – A model that predicts personal insolvency using a deep learning algorithm In Sydney, the team developed ‘Beat the Heat’  – a dashboard to communicate

Learn the art of Storytelling with Data, presented by Amazon best selling author, Cole Nussbaumer Knaflic. For the first time in Auckland, Sydney & Melbourne, Cole will be delivering her training. This 1-day workshop will enable you to bring data to life and use it to communicate a story to an audience, with a focus

“I am very proud of the Altis family, as we embody our ethos of ‘Connecting with Courage, Heart, and Insight’ which is reflected in our amazing culture,” said John Hoffman, CEO of Altis.   “This award is a testament to our passion of building a unique consultancy that puts our team and clients first.  This does

Garry Farrell – Managing Consultant – Altis Consulting Have you ever wondered whether your tweets on Twitter are having an impact on your followers and clients?  If you have, the good news is that Microsoft has created an easy to use template to help you get your Twitter analysis up and running in just one

Altis have been working on a number of projects to assist our customers move their data and analytics workloads to the Azure Cloud.  In this blog, James Mitchell from our Canberra office shares some project details and insights into one of these successful projects, where we established a new data warehouse environment in Microsoft Azure

Developing a mobile-based computer vision prototype for seed classification by Jarred Wynan and Martyn Upton, consultants in our Canberra office. We were recently asked to work on a short project to develop a proof of concept using Microsoft’s cognitive services to identify species of seeds using a mobile phone and its built-in camera capabilities.  As daunting as this sounds, within

Ian Stuart from our London office, has again been featured on the APM website, outlining the outcomes from his latest webinar. I recently presented at an APM webinar entitled “Taking portfolio benefits management to the next level with modern analytics”. The feedback was very positive – see some of the comments below: It would seem, from this

By Khai Tan, Managing Consultant Altis recently assisted  BAI Communications (BAI) in Australia with the implementation of their new Reporting and Analytics Platform. On the new platform, we delivered their first Power BI dashboard to monitor Digital Television (DTV) service performance at all Broadcast Australia (a BAI communications company) tower sites. Information is presented using ArcGIS maps

Creating value out of data is one of the highest priorities in business across all industries and services in the private and public sectors alike.  Ian Stuart of our London office gives an overview in a blog and webinar he recently presented for the Association for Project Management . Current state Data and analytics is a

By Dawie Kruger, Azure Practice Lead, Australia   In my previous blog Using SSIS within Azure Data Factory v2, we looked at using the Azure Data Factory SSIS Runtime and how the Altis ETL Jumpstart Kit was easily ported to run in the new environment. In this blog I will take you through some new

Altis partners with a number of water utilities across Australia, deploying a range of data and analytics solutions to reduce costs, improve decision making and expedite corporate & regulatory reporting. A growing trend that we are seeing is the implementation of smart metering trials, pilots, rollouts or at least planning for these implementations. Smart meters are an

How to Incorporate GeoMap: Use Case 2 – University Students GeoMap is a newly introduced address verification tool allowing individuals, companies and institutes to better take control of their addresses. But GeoMap is more than just a simple verification tool. Through GeoMap’s capabilities, our clients can geocode, validate and gain socio-economic insights into any physical

How to Incorporate GeoMap: Use case 1 – Application Assessment Improving application processing through easy-to-use, efficient geocoding. GeoMap is a newly established Australian address verification tool that allows for geocoding and socio-economic insight into all Australian addresses. Over a three part series we will explore the  ways in which businesses and institutes can incorporate GeoMap

Paul Butera, Altis Data Scientist, Melbourne In the space of image classification, not much has changed for years. Up until recently, even utilising deep learning, the pinnacle of multiclass object detection remained, at most, detecting one or two different kinds of objects within a single frame. Put more simply, we have been able to train