In this blog, we’ll see the use of the default tooltip in Power BI as we need to see the sales amount and quantity in a single chart.  Plotting them in a clustered column chart shows that the sales amount is in thousands, but the quantity is in hundreds or even less than a hundred.  We cannot compare these values shown in the graph as the difference between them is huge. By default, we can see a tooltip when we hover over the bar of the clustered column chart as shown below. Below are the steps to add Quantity in the Default Tooltip – Step 01  We have a Tooltips option in the ..read more

By default, SQL is not case-sensitive; the use of capitalized letters in SQL queries typically follows a naming convention rather than influencing the query’s functionality. However, scenarios may arise where case sensitivity becomes crucial, particularly when dealing with data that holds distinct meanings based on the case. In such situations, we can leverage database collation to address this issue. Before delving into a solution, it’s essential to comprehend the concept of database collation. In SQL Server, collation refers to a set of rules that determine how string comparison and sorting ..read more

Manufacturing and distribution businesses must stay ahead using the latest technology to improve efficiency and drive growth. Dynamics 365 Business Central is a great option for businesses upgrading from traditional platforms like Dynamics GP. This comprehensive blog delves into Business Central’s enhanced capabilities to manufacturers and distributors, spotlighting its native manufacturing and distribution features, advanced warehouse and inventory management, and robust supply chain management solutions. Furthermore, we explore the seamless integration with Microsoft Power Platform—Power BI ..read more

Below are the steps for installing an on-premises data gateway and connecting it to the Azure Services: Step 01 Run the .exe and click on Install. Step 02 Sign in with the email address you’ll use for development in Azure. Step 03  Select Register a new gateway on this computer and click Next. Step 04 Fill in the required details and remember the name of the Region which is been used. Then click on Configure. Step 05 After Configuring the below pop-up will appear where you have to click on Create a gateway in Azure. Step 06 Now fill in the required details with the same Region to Create a ..read more

Azure Cognitive Services is a collection of cloud-based APIs and services developed by Microsoft, designed to enable developers to add AI (Artificial Intelligence) capabilities to their applications without requiring deep expertise in AI or machine learning. These services cover a wide range of functionalities as follows: Computer Vision: This service allows applications to analyze and understand visual content in images and videos. It can perform tasks like image recognition, object detection, and image classification. Text Analytics: Text Analytics service enables sentiment analysis, key ..read more

Introduction Greetings, data enthusiasts! In this blog, we will see how to master the art of creating effective prompts for ChatGPT. Whether you’re familiar with ChatGPT or just diving in, understanding how to tailor your queries is key to unlocking its full potential. For detailed video: (Click here) While writing the prompt for an AI model, we have to keep below points in mind: Clear and Specific Prompts: When it comes to prompts, clarity is king. The more specific your query, the better the results. Let’s say you want to calculate year-over-year growth. A basic prompt like “What is year ..read more

Staying ahead in business technology means embracing systems that offer functionality, flexibility, and insight. For many North American SMEs, transitioning from Dynamics GP to Dynamics 365 Business Central, coupled with the power of the Microsoft Power Platform, marks a pivotal shift towards achieving this goal. This integration isn’t just an upgrade; it’s a transformation, enabling businesses to streamline operations, harness data for smarter decision-making, and drive growth like never before. This blog will explore the seamless synergy between Business Central and the Power Platform, inclu ..read more

In the world of SQL, generating a specific number of rows with data can be a common requirement, especially for solving problems, testing purposes, or when populating tables with sample data. In this blog post, we’ll explore various methods to achieve this task efficiently. Additionally, we’ll include a column in the generated data to indicate the row count, providing a useful reference for analysis. Method 1: Using Recursive CTEs One way to generate rows with a sequential row count is by utilizing a recursive Common Table Expression (CTE). The following example demonstrates this approach Thi ..read more

Hello readers! Lets go through of one the use case of EXCEPT function.  Problem Statement: To find the count of lost customers with respect to previous month and date selected in sliver visual. Solution: There are two tables namely Calendar and Sales by Store and they have a relationship between them based on transaction date column. Step 1: To calculate count of customers till date. Date is selected from slicer visual available on the report page. The count of customers till date is calculated by using VALUE() function which will return list of distinct values in a column. This part is c ..read more

Introduction: In the dynamic world of data engineering, understanding the journey of your data is paramount. Data lineage, the visualization of the flow of data through its lifecycle, plays a crucial role in ensuring data quality, compliance, and effective decision-making. In this blog post, we will delve into the intricacies of monitoring and auditing data changes using Unity Catalog within the Databricks environment. Join us on a journey to uncover the power of data lineage in enhancing your data management practices. Understanding Data Lineage in Databricks: Data lineage provides a comprehe ..read more