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.
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.
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.
Azure Solutions Architect
About us At Numerica Tech, we aim to be at the forefront of cloud innovation, empowering businesses to leverage the full potential of cloud solutions, in particular AWS and Azure. Join our dynamic team and play a key role in shaping cutting-edge cloud architectures for our clients. Job description We are seeking a highly skilled […]
AWS Solutions Architect
About us At Numerica Tech, we aim to be at the forefront of cloud innovation, empowering businesses to leverage the full potential of cloud solutions, in particular AWS and Azure. Join our dynamic team and play a key role in shaping cutting-edge cloud architectures for our clients. Job description We are seeking a highly skilled […]
AWS CDK and how it compares to CloudFormation
Infrastructure as Code (IaC) allows you to define and provision cloud resources using code, making the process more automated and consistent. AWS CDK is a powerful IaC tool that comes with the flexibility of a programming language.
How to get started with AWS CDK
AWS CDK (Cloud Development Kit) is a great way to manage your cloud infrastructure using familiar programming languages. AWS CDK allows you to define your cloud resources in a more intuitive way compared to traditional JSON or YAML-based approaches.