Category: Data & Analytics
Data Visualisation Tips – Bullet Chart, an alternate to Gauge Chart
December 20, 2019
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 …
Should we invest more time getting data into a Data Warehouse (DW) or analysing the data to create insights for the business?
December 12, 2019
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 …
Cost-effective XML storage and querying at scale
October 31, 2019
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 …
How to customise the axis in Power BI
September 4, 2019
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 …
Tired of the hidden costs and limitations of your current RDBMS for Data & Analytics workloads?
July 24, 2019
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. …
Join the “tour de force” of AWS and Snowflake
July 18, 2019
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 …
I have Power BI, do I need a data warehouse?
June 5, 2019
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 …
Snowflake released on Azure in Australia!
May 30, 2019
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 …
Passing GCP’s Professional Cloud Architect exam
May 14, 2019
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 …
Managing self-service BI teams
April 2, 2019
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. …
Putting together a roadmap to guide your Data & Analytics journey
February 26, 2019
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 …