2024-03-05 03:00
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… Read More
Blog Directory > Business Blogs > Addend Analytics business Blog >
Addend Analytics Blog
addendanalytics.com
Tags:
business
business central
central
computer vision
number
unity catalog
category
chatgpt
lineage
dynamics business central
We’re young and dynamic Data Analytics consultancy growing rapidly. We work with our clients to make sense of their data. We specialize in the application of Business Intelligence, Data Science tools to solve business challenges. To know more about our services, Contact us today!
2024-03-04 09:52
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, s… Read More
2024-03-04 07:31
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 u… Read More
2024-03-02 08:05
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 appl… Read More
2024-03-01 07:16
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 di… Read More
2024-02-29 06:55
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 3… Read More
2024-02-29 06:35
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… Read More
2024-02-28 06:03
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 sliv… Read More
2024-02-27 05:05
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, pla… Read More
2024-02-26 06:16
Moving from QuickBooks to Dynamics 365 Business Central is a significant shift for small and medium-sized businesses (SMEs) in North America.
This change promises to provide advanced busi… Read More
2024-02-26 04:37
Introduction
Welcome, data enthusiasts! In this article, we’ll delve into the revolutionary world of Copilot for Power BI, an innovative tool that taps into the potential of genera… Read More
2024-02-25 04:00
In Microsoft Dynamics 365 Business Central, reports are usually about displaying data neatly for analysis or printing. However, there’s a special kind called a processing-only report… Read More
2024-02-24 15:41
In Microsoft Dynamics 365 Business Central, reports are used to present data in a structured and often formatted manner for analysis, decision-making, or printing. Microsoft Dynamics 365 Bus… Read More
2024-02-23 15:00
Introduction:
In the ever-evolving landscape of cloud computing, serverless architectures have become a game-changer, allowing developers to focus solely on writing code without worrying… Read More
2024-02-23 05:39
Embarking on the journey from QuickBooks to Dynamics 365 Business Central is a transformative step for any business aiming to scale and enhance its operational capabilities.
However, this… Read More
2024-02-20 07:13
For many North American small and medium business owners, transitioning from QuickBooks to a more robust and comprehensive solution like Dynamics 365 Business Central represents a pivotal st… Read More
2024-02-17 06:44
In the digital era, where agility and efficiency define business success, choosing the right partner for Business Central integration becomes pivotal. Addend Analytics stands at the forefron… Read More
2024-02-15 05:54
In an era where digital transformation is not just an option but a necessity for growth, integrating Dynamics 365 Business Central is a pivotal strategy for North American small and medium b… Read More
2024-02-13 14:41
Integrating Dynamics 365 Business Central is a pivotal move for North American small and medium businesses aiming for growth and efficiency in the digital age, where business agility and dat… Read More
2024-02-11 14:33
Embarking on a Microsoft Dynamics 365 Business Central implementation marks a transformative step for any North American small or medium business aiming to streamline operations and enhance… Read More
2024-02-09 13:47
In the bustling landscape of North American business, where data management and operational efficiency are not just buzzwords but the backbone of success, Microsoft Dynamics 365 Business Cen… Read More
2024-01-30 10:20
If you’re running a business and using Dynamics GP software, consider switching to a newer one called Business Central. It’s like upgrading from an old smartphone to the latest m… Read More
2024-01-29 15:26
What kinds of Power Apps licenses are there?
There are three types of Power Apps licenses, they are:
1. Power Apps Nested License
When you buy Microsoft 365 (Office 365) and Dynamic… Read More
2024-01-28 14:51
Introduction:
In the age of information, organizations are constantly seeking ways to harness the power of data to gain valuable insights and make informed decisions. Azure Databricks, a… Read More
2024-01-27 14:23
Introduction:
In the era of data-driven decision-making, Azure stands out as a powerful platform for data engineering, offering a suite of tools and services to seamlessly manage, process… Read More
2024-01-27 09:48
Let’s talk about something super important for businesses – how much it costs to use specific software. We’re looking at Business Central, a tool that helps companies manag… Read More
2024-01-26 13:35
Azure Logic Apps is a cloud-based service provided by Microsoft Azure that allows you to automate workflows and integrate systems, applications, and data across cloud and on-premises environ… Read More
2024-01-25 05:39
In our last blog we have completed the first 3 sections of buildspec.yml file.
We will continue it from here.
3.a) Shell
It is an optional filed.
It specifies the supported … Read More
2024-01-24 13:15
Think about the last time you upgraded your phone or computer to a newer model. It’s exciting, but it can also be tricky. You’ve got to move all your apps, files, and settings ov… Read More
2024-01-24 05:08
In the realm of modern software development, the seamless integration and deployment of code have become paramount. Behind the scenes, tools and configurations orchestrate these processes, a… Read More
2024-01-23 16:02
If you want to restrict access to your AWS Cognito user pool to only a specific company’s domain, you can follow these steps:
Step 1. Create a Lambda function that allows access to… Read More
2024-01-22 15:28
In this guide, we will walk through how to attach Microsoft SSO (Single Sign-On) to an existing user pool in Amazon Cognito.
Step 1. Sign in to the Azure portal Console and navigate to th… Read More
2024-01-21 12:43
How sometimes do you switch from using one tool or app to another at school, which can be tricky?
Well, businesses sometimes face a similar situation. Many companies use QuickBooks to man… Read More
2024-01-21 12:02
In the world of big data and analytics, Databricks has become a superhero, simplifying complex tasks for data enthusiasts. Let’s take a journey into the world of Databricks in simple t… Read More
2024-01-20 11:10
Whether you’re wrangling data, running analyses, or crafting reports, having a solid understanding of SQL, Python, and Databricks queries is essential. In this guide, we’ll walk… Read More
2024-01-19 10:40
In Visual Studio Code, there are two ways to create objects: 1) by using snippets, and 2) by using wizards. If you are trying to create objects in AL Language using a wizard, here you can ge… Read More
2024-01-18 11:25
You have to keep track of money, products, and what your customers need.
Now, a tool called Business Central helps real businesses do all this in the real world. It’s like having a… Read More
2024-01-18 08:17
Reporting is a main part of any ERP system, and Business Central provides strong reporting capabilities. Here is an overview of reporting in Business Central:
A) Standard Reports:
Busi… Read More
2024-01-17 07:42
In the world of Business Intelligence, fact tables play a crucial role in data modeling, acting as a central hub for important metrics. Let’s explore different types of fact tables, co… Read More
2024-01-16 07:03
In this blog, we will be seeing how we can show the previous 6 months of data from single slicer selection for multiple calculations using calculation groups in Power BI.
Calculatio… Read More
2024-01-15 10:53
Imagine you’re running a business and need the best tools to help it grow and make more money—that’s what we call maximizing ROI or getting the most bang for your buck… Read More
2024-01-15 06:13
In this blog, we will be seeing how we can show the previous 6 months of data from single slicer selection in Power BI.
Regarding the data model, we have created two relationships b… Read More
2024-01-12 10:05
Business Central can be considered a comprehensive solution that guarantees a seamless product creation and delivery process to stores. It resembles a highly efficient assistant who possesse… Read More
2024-01-09 09:28
Think of QuickBooks like a basic calculator; it’s excellent for simple math. But as your math gets more complex, you need something more powerful, like a graphing calculator.
That&r&hell…Read More
2024-01-06 05:32
Think of Business Central as a super-smart app that helps businesses manage their work. After a company uses it, they enters a phase where they need to keep learning and getting help to use… Read More
2024-01-03 04:59
Imagine you’re building a Lego set. You wouldn’t start without a plan, right? That’s what Agile is like for software. It’s a smart way to make software by breaking th… Read More
2023-12-31 12:00
Transitioning enterprise accounting systems proves no small undertaking, wrought with technical and operational disruptions if not handled expertly.
Yet dynamically growing companies who… Read More
2023-12-27 11:37
Legacy accounting systems like Dynamics GP no longer cut it for today’s data-driven small businesses. As companies scale to midmarket size and beyond, limitations become painfully appa… Read More
2023-12-22 10:33
Transitioning from QuickBooks to Business Central marks a significant technological leap in your business. It moves from a system tailored for small-scale operations to a more robust, featur… Read More
2023-12-17 10:08
With over 2.6 million users worldwide, QuickBooks has long reigned as the champion accounting software for small and medium-sized businesses.
Yet, as these businesses grow and their opera… Read More
2023-12-13 09:23
A tailored outline for Business Central integration becomes invaluable when embarking on the journey from planning to going live. Such a guideline will delve into the intricacies of integrat… Read More
2023-12-09 13:41
Things move fast in the business world, so adapting quickly is necessary. That’s where Agile methodology comes in. It’s a flexible approach to software development that can shake… Read More
2023-12-05 13:09
When automating your business, choosing the right partner to customize and implement Microsoft Dynamics 365 Business Central is a huge deal. It can make all the difference.
This cho… Read More
2023-12-01 12:31
The world of business automation is growing fast, and customized software solutions like Dynamics 365 Business Central are now a must-have.
But to get the most out of these solutions, the… Read More
2023-11-27 09:14
What are Azure Functions:
Azure Functions is a serverless compute service provided by Microsoft Azure that allows developers to build, deploy, and run event-driven functions without the n… Read More
2023-11-26 08:34
Ways to Create Azure Functions:
Azure Functions can be created using various methods and tools, depending on your preference and requirements. Here are several ways to create Azure Functi… Read More
2023-11-25 04:53
Introduction
In the realm of database management, SQL User-Defined Functions (UDFs) stand as powerful tools, offering flexibility, reusability, and enhanced productivity. These custom fun… Read More
2023-11-24 04:21
Introduction
Temporal tables in SQL Server provide an effective way to manage historical data, allowing you to track changes in your data over time. In this blog post, we’ll explore… Read More
2023-11-23 17:26
We need to follow the below steps to change the Data Source.
Step-1: Log in to Power BI Service
Go to the Power BI Service website (https://app.powerbi.com/).
Log in with your Power… Read More
2023-11-22 16:57
In this Blog, I will show You How to Create One page with multiple tabs in Power BI Report using bookmarks buttons.
What are Bookmarks?
Bookmark is a Power BI feature that enables you… Read More
2023-11-21 02:09
Row-level security in SQL Server is a feature that allows you to control access to rows in database tables based on user permissions and policies. This feature was introduced in SQL Server 2… Read More
2023-11-20 01:33
Understanding the order in which SQL queries are executed is crucial for anyone working with databases, whether you’re a database administrator, a developer, or a data analyst. SQL que… Read More
2023-11-19 16:33
Aim of the POC:
The aim of this Proof of Concept (PoC) is to demonstrate the implementation of Azure Computer Vision Services for text extraction from images and image categorizatio… Read More
2023-11-18 15:05
In our last blog we launch the EC2 instance, downloaded .tar file for WordPress.In this blog, we will launch the WordPress sample website, make it available on the user-friendly domain name… Read More
2023-11-17 12:49
In the digital age, your website isn’t just a virtual storefront; it’s often the very heart of your business, serving as a portal for engagement, commerce, and connection. To ens… Read More
2023-11-16 12:22
Change Data Capture ie CDC captures the data that is being inserted, updated, deleted from a table in database.
This is done by enabling CDC on database and then on the concerned table… Read More
2023-11-15 11:50
WebSocket APIs enable real-time, bidirectional communication between web clients and servers, making them ideal for applications that require low latency, such as chat, online gaming, and li… Read More
2023-11-14 08:04
In today’s digital age, data and information flow incessantly, making it imperative for businesses to stay ahead of the game. One way to gain a competitive edge is by harnessing the po… Read More
2023-11-13 04:57
Below is the process of how we can embed Power BI reports in Dynamics 365 CRM by creating Solutions in Power Apps.
To create Solutions in Power Apps, sign into Power Apps and select &lsqu&hell…Read More
2023-11-11 02:40
To add path parameters to API Gateway, follow these steps:
Create an API using the AWS Management Console. Add a resource, and in the resource’s path, include a set of curly bracket… Read More
2023-11-01 06:53
Our tools can differentiate insight and oversight in the bustling digital marketplace. Picture a seasoned chef meticulously selecting between two knives, each with its unique edge and balanc… Read More
2023-10-30 06:24
In the world of data-driven business, the tools we choose can determine the success or failure of our strategies. Picture yourself at a crossroads, with two paths leading to potential triump… Read More
2023-10-29 09:40
REST APIs (Representational State Transfer) are widely used for building scalable and interoperable web services. One popular solution to create and manage REST APIs is Amazon API Gateway. I… Read More
2023-10-28 06:03
An API gateway is an essential component of API management that serves as a bridge between clients and backend services. In the case of AWS, Amazon API Gateway provides a comprehensive solut… Read More
2023-10-28 05:49
In a world brimming with data, an intriguing transformation is unfolding within the hallowed halls of NGOs. A quiet alley in New York City echoes with the animated chatter of an NGO executiv… Read More
2023-10-27 05:38
Introduction
Power BI is a powerful business intelligence tool that allows you to transform data into insightful visualizations and reports. One of the lesser-known but incredibly useful… Read More
2023-10-26 05:18
Amidst the towering skyscrapers of New York City, a perplexed NGO executive sat pondering. Despite her organization’s passion, mission, and devoted volunteers, she was at a loss.
Bu… Read More
2023-10-26 04:57
Introduction
In the rapidly evolving world of data management, the ability to capture and respond to changes in your data is paramount. Change Data Capture (CDC) is a game-changing techno… Read More
2023-10-25 04:36
In our last blog we created S3 bucket, Route 53 Domain name for our static website.Now we will create SSL certificate from ACM and CloudFront Distribution to make the website secure and user… Read More
2023-10-24 15:25
In the ever-evolving landscape of web development and hosting, the Amazon Web Services (AWS) cloud platform continues to reign supreme. Its robust suite of services empowers businesses and d… Read More
2023-10-24 15:17
There’s an old saying in America’s industrial sector that goes, “Change is the only constant in manufacturing.” As we entered the 21st century, there was a shift from… Read More
2023-10-23 15:05
In today’s fast-paced digital world, businesses need efficient and flexible solutions to automate workflows, connect systems, and simplify data integration. Logic Apps, a powerful offe… Read More
2023-10-22 14:45
In the fast-paced world of automotive manufacturing, every decision matters. A slight delay on the assembly line or a miscalculation in inventory can lead to significant financial losses… Read More
2023-10-22 14:32
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 em… Read More
2023-10-21 14:07
In this blog, I’ll describe how to calculate a cumulative sum by Product ID in Power B.Here are step-by-step instructions for calculating a cumulative sum in Power BI using a measure… Read More
2023-10-20 07:56
Azure Data Factory
Azure Data Factory (ADF) is a cloud-based data integration service provided by Microsoft as part of the Microsoft Azure ecosystem. It allows you to create, schedule, ma… Read More
2023-10-19 07:29
Introduction
Power BI is a powerful business intelligence tool that enables users to visualize and analyse data from various sources. One of the key features that make Power BI versatile… Read More
2023-10-18 07:14
Tables can be created using DAX function which is datatable().
Returns a table with data defined inline.
Datatable function allows values to be entered which is specific to the defined… Read More
2023-10-17 06:58
In the world of data management, there’s often a need to import data from various sources, and Microsoft SQL Server provides an excellent solution for this by allowing you to create a… Read More
2023-10-16 06:24
Configuring schedule refresh in Power BI is a process by which you specify when and how often your Power BI datasets and reports should be automatically updated with the latest data from you… Read More
2023-10-15 06:04
Databricks
Databricks is a unified data analytics platform built on Apache Spark. It provides a collaborative workspace for data scientists and engineers to work together on data projects… Read More
2023-10-14 05:22
Block blobs and append blobs are two types of blob storage in Azure Blob Storage, and they are designed for different use cases.
Note: There also exists a third types of blob called… Read More
2023-10-13 14:10
Azure Data Lake Storage Gen1 (ADLS Gen1) does not have a native concept of “blobs” like Azure Blob Storage does. In Azure Blob Storage, data is stored in containers as blobs. How… Read More
2023-10-12 13:42
In this blog, we’ll be seeing 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… Read More
2023-10-11 09:39
In the world of data management, integration, and extraction of data from external sources like Excel files are common tasks. SQL Server provides various methods to achieve this, and in this… Read More
2023-09-30 07:05
When working with databases, one common operation is to insert or update records based on certain conditions. This operation is commonly known as “upsert,” which is a combination… Read More
2023-09-29 06:46
In this blog, I’ll describe How to use “NetworkDays” Dax Function in Power BI
In Power BI’s DAX language, you can use the NETWORKDAYS function to calculate the num… Read More
2023-09-28 14:47
In the realm of construction, the foundations are shifting. Gone are the days when erecting towering structures merely considered durability and functionality.
Today, as climate concerns… Read More
2023-09-28 06:08
In this blog, we will be merging two different queries using Power BI. This feature is very useful if you want to combine one or more columns with another query using Power BI.
Product Ta… Read More
2023-09-27 05:43
In Microsoft Dynamics 365 Business Central, you can create a report that generates one page per record in the dataset. This is often referred to as a “one report per page” scenar… Read More
Subscribe to Addend Analytics
Get updates delivered right to your inbox!