We are the Best Consulting web site as part of the annual WebAward Competition!

(832) 981-4635
info@datacrafters.io
img
Language

English

Specialization in Analytics on Azure

Data Crafters has achieved the highest level of specialization granted by Microsoft, becoming one of the few companies in the world with the prized specialization ‘Analytics on Microsoft Azure.’ This achievement validates the value we created for our customers in leveraging Microsoft Fabric to drive growth and delivering best in class tailored solutions. It required […]

To Pie or not to Pie

To Pie or not to Pie When it comes to visualizing data, choosing the right chart can make all the difference. The right visual not only makes your data easy to understand but also helps convey the insights more effectively. In this article, we’ll explore when to use pie charts and when to opt for […]

The Power of Partitioning: Efficient Data Management with Microsoft Fabric

The Power of Partitioning: Efficient Data Management with Microsoft Fabric In today’s data-driven world, managing large datasets efficiently is crucial for maintaining performance and ensuring seamless operations. One way to achieve this is through data partitioning. In this post, we’ll explore how I handle New York taxi data spanning from 2016 to 2018 using partitioning […]

Authenticating using Service Principal in Microsoft Fabric SQL Endpoint

Microsoft Fabric provides SQL Endpoint on Lakehouse and Warehouse through which we can run SQL queries and Stored Procedures on the stored data. Whenever we run SQL statements, they need to be authenticated by a principal so that the SQL Engine can check whether the principal is authorized to access and execute statements. But unlike […]

Streamlining the Invoice Management Process by Integrating PowerApps in D365 F&O

Microsoft Dynamics 365 Finance and Operations (D365 F&O) is a critical tool for modern businesses, offering a comprehensive suite of applications to manage financials, supply chain operations, and enterprise resource planning (ERP). This powerful platform helps organizations streamline their processes, gain deeper insights through advanced analytics, and drive operational excellence. However, despite its robust capabilities, […]

Data Engineering in Microsoft Fabric: Part 4 – Orchestration

Data orchestration is an automated way to manage and organize data from different sources, making it ready for analysis. It’s also known as data pipeline orchestration or data workflow orchestration. This process covers many parts of data management, such as ensuring data quality, following data rules (governance), and automating various tasks. It also handles moving […]

Data Engineering in Microsoft Fabric: Part 3 – Transformation – Stored Procedure

Are you writing the same SQL code repeatedly? Thinking of a way to reuse the code? If yes, then you have come to the right place! Or if you want to know about stored procedure and how to create/execute them, this article is for you as well. A stored procedure is a group of SQL […]

Leveraging MSSparkUtils for file operations in MS Fabric

Microsoft Fabric is an all-in-one analytics solution for enterprises that helps you create, use, and govern data insights across your organization. In the context of Fabric, Spark integration enables developers to leverage Spark’s capabilities for big data processing within the Fabric ecosystem. Spark is a powerful open-source distributed computing framework that specializes in scalability, speed, […]

Stay ahead in a rapidly world. Subscribe to Prysm Insights,our monthly look at the critical issues facing global business.

[mc4wp_form]