Category: Data & Analytics

Webinar: Serverless ETL Using ALTIS DLA and AWS

September 15, 2021

By Manan Patel, Senior Consultant – Altis Sydney Last month, I presented a webinar that explained the Altis DLA and how it can be integrated with AWS services to create a Serverless ETL architecture. The architecture utilises AWS Step Functions, AWS Lambda Functions, AWS S3 and AWS Redshift to build an automated, metadata-driven data platform.

Webinar: The Paths To Insight

September 8, 2021

By Abhishek Kookana – Senior Consultant, Matthew De Maria – Senior Consultant & Andrew Bilsdon – Delivery Lead In the data and analytics industry, we often promise the delivery of “Actionable Insights”. This webinar focuses on the different pathways and approaches that you can take to generate these insights and the potential benefits of each

Webinar: What is Design Thinking?

August 18, 2021

By Monai Thangsuphanich, Senior Developer – Altis Sydney In this webinar, we discussed an in-depth overview of the design thinking process and how our Innovation team uses this process to design and develop new products. What is Design Thinking? When you are searching for articles on design thinking, there are several good definitions of design

Altis Joins The Marshall McAdam Data & Analytics Podcast

July 28, 2021

by Guillaume Jaudouin, Head of Growth- Altis Sydney In a recent episode of the Marshall McAdam ‘Talk Data To Me’ podcast series, our very own Head of Growth, Guillaume Jaudouin joined Tim Hutchinson. They discussed a range of topics, including data & analytics trends, using data to save the Tasmanian Devil and all things Data4Good; a Not-For-Profit

How to Move Towards Best Practice Data Visualisation

July 21, 2021

By Julia Gusman, Managing Consultant – Altis Sydney I’ve been teaching BI courses and workshops for over ten years. Most of my training has been on-site and in person. However, recently we have moved to deliver training online and I am seeing lots of benefits from this mode of delivery. In particular, the flexibility of being

Installing Ubuntu Bash for Windows 10 – WSL2 Setup

July 12, 2021

Anandraj Jagadeesan, Principal Consultant – Altis Sydney   I wrote the blog on Installing Ubuntu Bash for Windows 10 using WSL (Windows Subsystem for Linux) a few years back. This has been one of the most popular blog pages on the Altis site. Since then, Microsoft has made improvements and has released the WSL2 version

Webinar: Amazon Managed Workflow for Apache Airflow

July 7, 2021

By Deep Menasigi, Senior Consultant – Altis Sydney Workflow management plays a vital role in the data engineering domain. Traditionally ETL pipelines were orchestrated using legacy client-server based monolithic applications such as Control-M, Tivoli, Autosys etc. These legacy applications provided limited control to the developers with little or no room for customization. Both from the

Webinar: The Value of Data and Information

June 30, 2021

By Andrew Bilsdon, Delivery Lead – Altis Sydney Following on from my recent webinar, The Value of Data and Information, I have written this blog to pick up on some of the key points. This blog focuses on some of the key topics, they are: The Problem Discussing Data Value Measuring Value The Problem Quantifying

Webinar: Building an Azure Data Platform & Power BI Embedded Reporting Solution to Provide iiPay’s Clients Insight into their Payroll Data

June 23, 2021

By Chris Kearns, Regional Manager – Altis UK iiPay is a market leader in cloud-based global payroll solutions that deliver accurate and compliant payrolls. iiPay understood that they could deliver significant value to their clients through their payroll data. The ability for their clients to analyse, be proactive decision-makers, and realise the strategic resource that their

Webinar: Using Custom Visio Visuals in Power BI

June 22, 2021

By Markos Keir, Managing Consultant – Altis Sydney I was recently asked to create a very specific visualisation in Power BI for one of my clients. The visual required me to display a map of NSW with major river systems highlighted in a different colour based on their status as well as displaying icons showing

Moving from What Has Happened to What Will Happen

May 26, 2021

By Andrew Bilsdon, Delivery Lead – Altis Sydney The Analytics Industry often promises that we can predict what will happen, or discover hidden correlations between seemingly unrelated variables in datasets. My experience is that we still spend too much time on Operational Reports that tell users what has happened in a single data set or

Qlik Excellence in Healthcare: Altis at the Department of Health

May 13, 2021

By Abhishek Kookana, Consultant – Altis Canberra The COVID pandemic brought with it uncertainty, change and the need for a complete reassessment of the work environment. In the midst of the ever-changing landscape, our consultants, along with the team at the Federal Government Department of Health, worked tirelessly to ensure that their client needs were

Data Visualisation Best Practice – What, Why & How.

April 19, 2021

By Ian Stuart, Data Visualisation Specialist, Altis Consulting UK Introduction What is Data Visualisation best practice, why should I be interested in it, and how do I go about it?  Let us see: What is Data Visualisation Best Practice? Designing attractive reports and dashboards, that best help you to communicate stories with data. That’s the

Speed Up Report Development With Custom Power BI Themes

April 13, 2021

by Roger Light, Data & Analytics Consultant, Altis Consulting UK Ever spend time fiddling with obscure settings in your reporting tool to get things to look consistent? Sometimes the data modelling and visualisation layout are a breeze compared with ironing out those small distracting details to make your report look good. So why bother? Because

Webinar: Altis Data Load Scaffolding Using Snowflake

by Anup Ramadas – Principal Consultant, Gordon Sinclair – Managing Consultant & Manan Patel – Senior Consultant Built using over 20 years of experience, the Altis Data Load Scaffolding (DLS) helps Altis’ clients simplify their Data Warehouse development, operation and maintenance. In this webinar, we discussed how the DLS is used to help our clients

Webinar: Get More Out Of Snowflake

March 17, 2021

by Brook Queree, Senior Consultant – Altis QLD So your organisation has moved its data into the cloud, now what? As businesses realise the benefits behind cloud data platforms such as Snowflake, more and more use cases discovered that would never have been possible before. This is the power of the cloud, adding accessibility and

Embedded Analytics with Power BI – Part 2

February 23, 2021

by Samuel Ward-Riggs, Principal Consultant- Altis UK In Part 1 of this blog, we introduced Power BI Embedded, an Azure Platform as a Service (PaaS) offering that enables organisations to securely embed Power BI reports and dashboards within their apps, seamlessly blended with their corporate look and feel. Now, let’s dive into the details of

Webinar: Altis Snowstream – Stream Data Ingestion for Snowflake

February 18, 2021

by Anandraj Jagadeesan – Principal Consultant, Andrew Li – Senior Consultant & Mike Setterberg – Senior Consultant   Organisations, looking for speed, reliability, cost savings and security, are migrating their applications to the cloud. Naturally, the data platforms must take the same path and migrate to the cloud. Altis is a leader in helping organisations

Embedded Analytics with Power BI – Part 1

February 15, 2021

by Samuel Ward-Riggs, Principal Consultant- Altis UK   Data visualisation tools like Power BI, Qlik, and Tableau help us to visualise data to support decision making, but can we provide those same capabilities to our customers? Embedded visualisations place best-in-class analytics seamlessly within your application or website. Analysts within your organisation, rather than software engineers,

AWS Community Chats With Altis

January 27, 2021

by Guillaume Jaudouin, Market Development Leader in Management- Altis Sydney In the most recent episode of AWS Community Chats, our very own Market Development Leader in Management, Guillaume Jaudouin joined AWS’ Aley Hammer. He shares his tips to help you get started with data & analytics and provides insight into the upcoming trends in this

Top 10 Stories From 2020 By Our Altis Community

January 20, 2021

by Mik Panchal, Managing Consultant- Altis Sydney As we welcome 2021, we want to take the time to celebrate our top stories from 2020 and thank our Altis community for the great content. Here are some of our success stories and how we have helped our customers achieve tangible business outcomes. The Importance of Data

Can we follow Hans Rosling’s dynamic example using Power BI and when should we try?

January 8, 2021

By Roger Light, Data & Analytics Consultant, Altis UK   Hans Rosling was renowned for his eye-catching and insightful presentations, using data visualisation as a tool to successfully promote awareness of world health and development issues. Wouldn’t it be great if we could make our own reports as compelling and memorable as his? Here we

Effectively Delivering Data

December 9, 2020

  by Andrew Bilsdon, Delivery Lead – Altis Sydney If you are involved in a data project, or the delivery of data as a service, this post is pitched at you. The recommendations are based on my 15 years of experience in data, information and analytics and are intentionally pragmatic. Self-service has arrived Unlike the

Building an Azure Data Platform to Drive Performance in Air Traffic Management

December 2, 2020

by Chris Kearns, UK Regional Manager Air Navigation Solutions (ANSL) delivers air traffic control and engineering services at some of the world’s busiest and most complex airports including Gatwick and Edinburgh Airport. ANSL have access to many and varied data sources but have been limited to analysing this data through largely manual means. ANSL partnered

How To Get Senior Leadership Alignment Around Data & Analytics

November 25, 2020

By Chris Kearns, Regional Manager – Altis UK Organisations have no shortage of data available from corporate systems such as Finance, HR, CRM, etc. but the challenge is bringing all this data together to support decision making. There are proven approaches for bringing such data together for use in reporting and analytics platforms but this

Using Your Data to Make Insights

November 18, 2020

By Jason Williams, Delivery Lead – Altis Canberra It’s a common understanding across most organisations that data and analytics are valuable. Most organisations have large quantities of data available to them but don’t access and analyse that information effectively, either through having not collected or stored the information appropriately or the lack of technology and

3 Keys to Data & Analytics Strategy Success

November 4, 2020

By Ben Atchison, Delivery Lead, Melbourne Altis has conducted in excess of 50 strategy and roadmap engagements across a wide range of industries and technologies. These 3 factors are important to getting your strategy right: Find a Trusted Partner Effective strategies unfold over the course of months and years, so it is important to think

Power BI – The Road to Success: Part 4 (of 4)

October 28, 2020

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

Cloud Cost Management: Altis Billing Dashboard

October 14, 2020

  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

Power BI – The Road to Success: Part 3 (of 4)

October 7, 2020

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

Power BI – The Road to Success: Part 2 (of 4)

September 23, 2020

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

Data Platforms in a Nutshell

September 9, 2020

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

Power BI – The Road to Success: Part 1 (of 4)

September 2, 2020

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

How Data Literacy Can Benefit Your Organisation

August 26, 2020

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

Power BI and COVID-19

August 5, 2020

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

Growing A Better Cow On A Smarter Farm

July 22, 2020

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

An Introduction to Pragmatic Data Governance with Azure Data Catalog

July 15, 2020

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

Transform the Way You Build Your Modern-Day Data Analytics Platform with AWS

July 8, 2020

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

The Evolution of Power BI Dashboard in a Day (DIAD) During the Coronavirus Pandemic

June 19, 2020

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

Webinar: Accelerate Your Analytics Solution with Azure

June 17, 2020

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

How To Validate Data Lake Files Using Azure Data Factory

June 10, 2020

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,

Azure Data Factory (ADF): How to extract JSON data from an API to Azure SQL Server

June 3, 2020

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.

Power BI Desktop for the Business User

May 28, 2020

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

Has Worldometer Killed Data Visualisation?

May 20, 2020

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

How to Best Design a Data Lake Storage?

May 6, 2020

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

What Do You Get When You Cross A Data Warehouse With A Data Lake?

April 29, 2020

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

Transforming Delivery in a Distributed Team

April 15, 2020

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

How To Connect Power BI to Read-only Replica of Azure SQL Database & More

March 18, 2020

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

Tech Leadership

March 4, 2020

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

The Importance of Data Governance

February 26, 2020

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