Want to learn SSIS project design principles that will streamline your ETL package deployment?
Download our eBook and start saving time and resources.
Data analytics is a constantly evolving landscape.
Stay in the know with more Key2 content.
Power BI Custom Visual Licenses Can Now Be Purchased and Managed in AppSource
Buying and managing licenses for Power BI custom visuals are no longer complicated tasks, as Microsoft just announced a new, simple process for doing so!
What is web3? A Quick Overview
The emergence of web3 has been met with both tremendous hype and deep skepticism. Here’s a brief overview of what web3 is.
How to Group Power BI Measures
Learn how to group Power BI measures to better organize what you’re working with in Power BI and enhance your productivity!
How to Use Microsoft Power Apps to Simplify Customer Communication
The Microsoft Power Apps platform can help you better interact and communicate with your user bases or customers. Here’s an example.
How to Delete Data From a Large Partitioned Table
We were recently faced with a data duplication issue when loading a large table for a client. Here’s the solution we developed to solve the problem!
How to Use SQL Server Management Studio for Quick and Easy CSV Data Export
SQL Server Management Studio provides many ways to export data from a database. Here’s one quick and easy way for CSV data exports.
How to Create Dynamic Azure Data Factory Pipelines with Metadata
Azure Data Factory pipelines are highly useful when migrating on-premise ETL processes and data to the Azure cloud. Learn more in this post!
How to Use Power BI Report Server to Create Inventory Reports & Data Refreshes
Unlike the Power BI service, Power BI Report Server does not come with tools to help analyze a system’s content. Here’s a solution.
Using Polybase for Improved Data Loading
Learn about Polybase, a feature in SQL Server 2016 that can help improve data loading processes. We share a client example as well.
Databricks Utilities (dbutils) – 4 Useful Functionalities
We explore Databricks Utilities (dbutils), a tool for basic data file handling and data manipulation within Databricks Notebooks.
A Quick Look at Azure Databricks Secret Scopes
Azure Databricks secret scopes is an excellent tool for creating effective data security measures and protecting sensitive data.
What’s New in AWS QuickSight
We take a look at the latest features in AWS QuickSight, an incredibly powerful business intelligence service.