Welcome to our

Blog.

29 Nov 2024

How to get data from Databricks in Excel using Power Query

Databricks is a unified data engineering platform renowned for it's ability to process large datasets. Excel remains the tool of choice for analysis and other end-use-computation. In this post, we will explore how we can use Databricks API to get data into Excel via Power Query.

25 Nov 2024

How to get data from ZIP files using Power Query

Did you ever have to process data from Excel spreadsheets or CSV files locked inside a ZIP archive? With Power Query, you can seamlessly extract and analyse these files without manually unzipping the archive. This post walks you through extracting files from a ZIP archive, handling folder structures, and processing multiple file formats like .xlsx and .csv.

21 Aug 2024

Why small businesses should consider using Azure Virtual Desktop

For startups and small enterprises looking to future-proof their operations and empower a dynamic, remote workforce, Azure Virtual Desktop is an oustanding choice. By leveraging Azure, small businesses can enhance productivity, improve security, and position themselves to adapt to the ever-evolving business landscape, all while keeping costs under control and maximizing their potential for growth.

Take your business to new heights.

Leave your problems with us.