Welcome To Our Data Analytics Blog
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.
7 Big-Time Benefits of Power BI
Wondering why Power BI is such a popular data analytics platform? Here are seven benefits of Power BI to help explain.
Azure Data Factory – A Key Tool for Modern ETL in the Cloud
Azure Data Factory is a powerful tool every Microsoft-based ETL professional should be familiar with. Learn more about ADF in this article!
Power BI Report Server Scale Out With Load Balancing
Power BI Report Server scale out is a flexible architecture that allows a system to be given more resources in a repeatable format.
3 Key Power BI Data Governance Features
Learn about three of the best Power BI data governance features that enable users of the platform to properly manage their data.
How to Use Azure Integration Runtime in Azure Data Factory
Learn about the Azure Integration Runtime within Azure Data Factory and how to use it to leverage on-premise data and move it to the cloud.
What is a Cloud Solution? Two Useful Examples
Learn about what a great cloud solution looks like with these two examples. We also discuss today’s relevant cloud technologies.
Microsoft Announces a Power BI Angular Component
Microsoft just recently announced a Power BI component for Angular, Google’s popular open-source web application framework. Learn more.
Get our latest analytics content straight to your inbox
Key2 Consulting | info@key2consulting.com | (678) 835-8539