Blog

by Ian Stuart, Principal Consultant – Altis UK In the first blog of this series, I covered the key steps that we need to focus on to ensure that usage of Power BI is effective in our organisations. In that blog I also delved into Training and Governance that provides the foundation for us to

  by Margaret Chan, Principal Consultant – Altis NZ Being able to track and forecast spending on the Cloud Platform is one major challenge in cost management today. While the cloud offers scalability, consumption-based payment model can be hard to keep a tab on. The most common way is to utilise the cost management portal

by Ian Stuart, Principal Consultant – Altis UK In the first blog of this series, I outlined the three key steps that we need to focus on to ensure that usage of Power BI is effective in our organisations. I then delved into Training and Governance that provides the foundation for us to get started

by Jason Williams, Delivery Lead – Altis Canberra Organisations aim to create insights in an efficient way, however, most face problems with data coming from disparate sources or from inadequate access to data. For best results, we need to aim to ensure that all users have access to the same data, to make accurate and

by Ian Stuart, Principal Consultant – Altis UK In the first blog of this series, I outlined the three key steps that we need to focus on to ensure that usage of Power BI is effective in our organisations. I then delved into Training and Governance that provides the foundation for us to get started

by Jason Williams, Delivery Lead – Altis Canberra Data and analytics have become extremely popular in the last few months and for good reason. Being able to embrace Business Intelligence (BI) and having the ability to leverage insights, it’s now possible to make informed decisions. By having the right BI tools implemented and understanding how

by Samuel Ward-Riggs, Managing Consultant – Altis UK We rely on information to do our jobs every day, information provided to us by Data Platforms. But what exactly is a Data Platform, and how does today’s information request turn into tomorrow’s KPI dashboard? Join me at the whiteboard to demystify Data Platforms and the jargon

by Ian Stuart, Principal Consultant – Altis UK We have been working with Power BI since it arrived on the market in 2015.  Since then we’ve worked with a lot of organisations to help them successfully incorporate Power BI into their daily operations. We’ve distilled this experience into 3 key steps that are underpinned with

by Jason Williams, Delivery Lead – Altis Canberra   Since the start of COVID-19 organisations are beginning to realise the importance of data and will begin to consider how to utilise data available to them. As part of this, organisations need to ask themselves, do our staff have the necessary skillset to derive meaningful insights

by Gordon Sinclair, Managing Consultant – Altis Sydney A large proportion of the world’s population has been affected directly or indirectly from the spread of the coronavirus. Using data to monitor and manage the impact in my local context, was a clear benefit to me and to others. During the early stages of reporting on

by Andrew Bilsdon, Delivery Lead –  Altis Sydney   I had the great pleasure of visiting a friend in Northern Tasmania whose family are running a successful dairy farm in the beautiful Devonport region where the grass is green and rain plentiful. Being a desk-bound IT type, I was of little practical help so my

by Dawie Kruger, Azure Practice Lead & Richard Roose, Principal Consultant – Altis Sydney In this webinar, we discuss how you can pragmatically kick start your Data Governance initiative using the Azure Data Catalog. Use this link to view the free webinar, or watch it below.   As “Data Literacy” and Data & Analytics in organisations continues to mature, it’s becoming more

by Neha Kaul, Managing Consultant – Altis Sydney In this webinar, we discussed how you can transform the way you build your modern-day Data Analytics Platform using the Altis Automated Serverless Data Lake Framework. This webinar was attended by a large group who came from varying industries and roles. With a growing emphasis on delivering

by Ian Stuart, Principal Consultant – Altis UK Last year I wrote a blog that described the Power BI Dashboard In A Day (DIAD) programme and how organisations and individuals can benefit from attending this free training. The Coronavirus pandemic has brought about some changes to how the course is delivered, but the broad features

by Mik Panchal, Managing Consultant & Manan Patel, Senior Consultant In this webinar, we discussed how you can accelerate your analytics solution with Azure using the Altis Azure Framework. With more and more emphasis on delivering data in Azure “Cloud” for analytics, there has been a big focus on automating this process in order to

by Garry Farrell, Managing Consultant- Altis Sydney Data lakes are very popular, and I have been helping to extend the framework we use with our clients. Our framework is an important starting point for discussions with our clients. It also doubles as a best practice design for the consultants to get the build done efficiently,

Sylvia Howes has been with Altis Consulting for three years, a BRW Employer of choice every year for the past decade. She’s passionate about using data to create change and has just moved into the full-time role of Data4Good Lead. Altis founded Data4Good to encourage corporations to use data to make a positive impact on the world. Her extroverted,

by Mik Panchal, Managing Consultant- Altis Sydney This Blog is a step-by-step guide to build the integration pattern used to extract JSON data from an API using Azure Data Factory. Using an API to extract data in a JSON format has become a common method for extracting data into Azure SQL Database or Azure Blob.

by Garry Farrell, Managing Consultant – Altis Sydney Do you have files that you would like to combine and develop into reports?  I once worked with a client who was transforming and combining files, by hand, of different formats and structures. Her mission was to merge 7 files from 7 different financial institutions. So, it wasn’t a simple

by Andrew Bilsdon, Delivery Lead – Altis Sydney I am writing this in May 2020, as some countries are starting to relax the restrictions put in place to manage the pandemic we have been dealing with. I was motivated into writing this blog by a recent LinkedIn post. It received many comments and confirmed my

by Lynn Naing, Managing Consultant – Altis Sydney As Data Lake popularity grows, the common fundamental question we get asked from clients is ‘How to best design a Data Lake Storage?’. There is no silver bullet for ‘Best’ design as different clients have different requirements and use cases. However, there is a good common foundational

by Kent Teague, Managing Consultant – Altis Melbourne Did you guess Data LakeHouse? And, no I’m not talking about the latest episode of Grand Designs. Although like Kevin McCloud in his quest to follow design projects from laying the foundation through to the building of dream homes. We’ll be looking at the foundation of the

by Charmaine Loratet, Head of People & Culture For many of us working, we are finding ourselves in uncharted waters as we adjust to the new normal whilst faced with a global pandemic. For us here at Altis Consulting, we have continued to focus on our core business values of ‘Connecting with Courage, Heart and Insight’.

by Andrew Li, Senior Consultant – Altis Sydney Agile & Scrum methodology has no doubt seen widespread adoption across software teams. However, many teams in areas like data and analytics have yet to catch onto this trend and its benefits. This post provides a brief case study of the benefits of the Agile approach at

by Andrew Heinceslater, Consultant – Altis Melbourne Starting a new job can be a stressful time. No matter how many times you go through the experience, it doesn’t get any easier. This is number 11 for me, and let me tell you it isn’t always the first day that is the toughest. It’s the following

It’s been a tough time for all, as we deal with the outcomes of COVID-19. Our daily lives have drastically changed and will continue to do so for some time. To help support our community we have put together some tips & words of advice to guide us during COVID-19.   Please feel free to

by Charmaine Loratet, Head of People & Culture Due to the current Covid-19 pandemic, the way a lot of us live & work has drastically changed! We’ve heard all the advice from experts on social distancing & making sure we wash our hands. What seems to be discussed less is the psychological disruption working from

by Nate Wang, Consultant – Altis Melbourne Using both Azure SQL Database and Power BI as Business Intelligence tools in your company? Then this easy, but often neglected, functionality might help you supercharge your reports’ performance with no additional cost. Sounds good? Read on! This blog post will cover: The background What is the Azure

by Andrew Bilsdon, Delivery Lead – Altis Sydney I frequently engage with clients as a Tech Lead. My habit is to always clarify what is expected from me so that I am set up for success. Now the beauty to the role is that it is extremely flexible and broad, so not surprisingly so is

by Mythili Baker, Head of Innovation – Altis Sydney After attending the Gartner Data & Analytics Summit in Sydney last week it’s clear that data governance isn’t going anywhere and it’s still a major challenge for organisations. The first main theme behind this I see is the growth of self-service. Tools such as Tableau, Qlik

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