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.
Keep your knowledge sharp and explore some of our recent content.
The Challenge of Data Consistency Using Self-Service Analytics
Author: Mark Seaman With Power BI/Fabric moving more towards self-service analytics, you may realize that different teams or individuals can get different answers to the same questions. Many users may be familiar with Power BI, but they may lack expertise in creating...
Databricks Q3 Product Roadmap High Level Recap
Author: Jason Bacani Key2 Consulting is registered Databricks Consulting Partner. Databricks’ goal is to be a data analysis platform that democratizes data and AI so that every company can quickly make smarter and informed decisions to lead within their industries. ...
Connecting Databricks to Power BI Using Partner Connect
Author: Mark Seaman Partner Connect is a Databricks tool that simplifies the data connection process to partner products. All the connections are created in Databricks without having to go to the partner product the user would like to connect the data to. Partner...
Case Study: Summit Integration Process
Author: David Thomas Background This client faced significant challenges in managing the ingestion and distribution of terabytes of data from multiple sources while maintaining data integrity and providing rapid access to mission critical data. The organization...
Rebuilding Indexes Based on Partition
A quick summary of what indexes and partitions are in SQL Server, when they are most beneficial, and a few scripts used to identify specific problem areas.
Key2 Consulting Partners With Databricks To Help Companies Maximize Data and AI
Key2 Consulting announces a partnership with data intelligence leader Databricks.
How to Build Metadata-Driven Pipelines in Microsoft Fabric
Metadata-driven pipelines in Microsoft Fabric offer flexibility, reusability, and scalability in data integration processes.
Getting Started With Copilot in Microsoft Fabric
We explain what Copilot in Microsoft Fabric is, how to enable it, and share some use cases of the technology.
SQL Database in Microsoft Fabric – Getting Started
Announced in November 2024, SQL database in Microsoft Fabric is an autonomous, developer-friendly database accessible by other Fabric services.
Data Streaming Made Easy With Microsoft Fabric
Microsoft Fabric’s event stream and event house features make it easy for users to collect, process, and store streaming data.
How To Perform Data Cleansing and Transformation with PySpark in Microsoft Fabric
In this article, we explore some practical examples of data cleansing and transformation using PySpark within Microsoft Fabric’s Notebook environment.
Microsoft Fabric Data Integration Using Pipelines, Dataflow Gen2, and Notebooks
We explore the three different methods Microsoft Fabric offers for data integration: Data Pipelines, Dataflows Gen2, and Fabric Notebooks.
Key2 Consulting | info@key2consulting.com | (678) 835-8539