2023-09-26 05:01
This blog gives you an overview on how to create data catalogues from RDS MySQL instance using AWS Glue crawler
It is assumed that you already have RDS MySQL DB instance running with few… Read More
Blog Directory > Business Blogs > Addend Analytics business Blog >
Addend Analytics Blog
addendanalytics.com
Tags:
business central
database
report
table
rds mysql
sql server
powerpoint
code
selected record
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!
2023-09-25 04:37
In this blog, we will be appending two different queries using PowerBI. This feature is very useful if you want to combine two data tables. We can also append more than 2 tables using PowerB… Read More
2023-09-24 15:45
Exposing data is an important topic for every ERP implementation. Well, within the Microsoft ecosystem it is much easier to exchange the data between two applications (For example from busin… Read More
2023-09-23 15:10
Hi there,
In this blog, I will show you how to export live Power BI reports in PowerPoint.
In order to export the live Power BI file from the Power BI service to PowerPoint, Follow the… Read More
2023-09-22 14:44
Agenda: 1. Problem Statements2. Possible ways3. Solution1. Problem StatementsI want to create a dynamic date table using the date field from another table. I have a table called ‘Task… Read More
2023-09-21 14:27
A very common requirement that we face very often is “To extend the base APIs”. With Business Central you can create Connect apps. Connect apps establish a point-to-point connect… Read More
2023-09-21 14:16
In a small village nestled on the outskirts of Kenya, an NGO had been tirelessly working to improve access to clean drinking water.
Yet, despite their best efforts, they struggled to gaug… Read More
2023-09-20 08:30
1. Open Visual Studio and Create a New Project. From the templates, search for SQL Server Database Project and Click Next.
2. Provide the name of the project and select the location o… Read More
2023-09-19 08:00
In Microsoft Dynamics 365 Business Central, opening a report for a selected record typically involves a few steps with AL code.
Step 1: ( I have created a report for sales order) on Sales… Read More
2023-09-18 07:41
DACPAC (Data-tier Application Package): A DACPAC is a file format used in Microsoft SQL Server for packaging and deploying a database schema and its related objects as a single unit. It&rsqu&hell…Read More
2023-09-17 07:11
Data Labels are one of the critical components of any Power BI visual. It allows users to understand the visuals easily. With the help of Custom Data Labels, users can see a particular data… Read More
2023-09-16 06:59
Table constructors are expressions that create tables.
Every time a constructor is evaluated, a new table is created. A constructor can be used to create an empty table or to create… Read More
2023-09-15 06:35
Creating a connection between an Amazon RDS instance and AWS Glue enables Glue to access data stored in the RDS database. This allows you to use Glue’s data catalog and ETL (Extract, T… Read More
2023-09-14 06:07
Introduction:
In the world of cloud computing, seamless integration between on-premises systems and cloud services is crucial for modern businesses. Azure Integration Runtime is a powerfu… Read More
2023-09-13 06:41
As the red light on a busy intersection turns green and a convoy of cars zooms forward, few drivers pause to consider the behind-the-scenes complexity of producing their trusted vehicles… Read More
2023-09-13 05:37
Dynamic Data Masking (DDM) is a security feature used in relational database management systems (RDBMS) to control the visibility of sensitive data to different users. It helps organizations… Read More
2023-09-12 05:07
Azure DevOps is a set of development tools and services provided by Microsoft to help teams plan, develop, test, and deliver software applications. It includes a wide range of features, incl… Read More
2023-09-11 03:40
Business Context and Aim:
In this POC, we are addressing a scenario where health monitoring devices are sending real-time patients’ health data to the cloud for analysis and storage… Read More
2023-09-08 06:07
In the bustling corridors of modern hospitals, beneath the hum of life-saving machinery and the soft chatter of patients and doctors, lies an often-untapped force of transformation – d… Read More
2023-08-11 11:25
In last blog we launched EC2 stack. It had two instances – dev and prod. It had Security Group with ports 22, 8080, 80 open, IAM policy for EC2 instances.
To refer to our Part 1 blog… Read More
2023-08-11 10:14
AWS CloudFormation is a service that allows developers to deploy AWS resources in an orderly and predictable manner. To deploy the resources, they need to be specified in a document called … Read More
2023-08-11 09:43
Let’s take a quick end-to-end look at how to convert data from one format to another using AWS Glue, then query that data using AWS Athena.
You can download the file used in this tu… Read More
2023-08-11 09:33
Azure Functions is a serverless computing service provided by Microsoft Azure, which allows you to run your code in a serverless environment without worrying about infrastructure management… Read More
2023-08-08 13:42
In this blog, you’ll learn the best practices to use Power BI Dataset.Purpose and features of Power BI Datasets
Power BI Dataset is to be used when we want to separate the data mode… Read More
2023-08-08 13:31
In this blog, I will show you How to Create a Dynamic Page Title with Multiple Slicers.Here’s a step-by-step guide on how to achieve this.Step 1: Import your data into Power
We can… Read More
2023-08-08 13:24
In this blog, I will show you How to Create a Dynamic Page Title with Multiple Slicers.Here’s a step-by-step guide on how to achieve this.Step 1: Import your data into Power BI and cre… Read More
2023-08-08 13:19
In this blog, I’ll describe how to create Pareto Chart in Power BI.
What is Pareto Analysis?Pareto Analysis is a technique used for decision-making based on the Pareto Principle. Th… Read More
2023-08-08 11:59
Problem Statement: To set up data gateway in Power BI service for on-premises data source and to set up scheduled refresh for the Power BI file.
Solution:
For demonstration, the excel… Read More
2023-08-08 08:57
Power BI Desktop Developer Mode is set to revolutionize the world of Business Intelligence (BI) systems by introducing advanced features that enhance collaboration, automation, and scalabili… Read More
2023-08-08 07:27
Introduction
In today’s data-driven world, organizations rely on seamless and efficient data movement and processing to make informed decisions. Azure Data Factory (ADF) is a powerf… Read More
2023-08-08 07:09
To copy file from SharePoint Online requires Azure Active Directory/ Service Principal authentication and SharePoint API to retrieve files.
Step 1 – Register SharePoint Application… Read More
2023-07-09 06:21
Did you know companies using data-driven insights are 23 times more likely to acquire customers?
Data analysis is the cornerstone of successful decision-making in today’s digital la… Read More
2023-06-19 15:11
As a business owner, your ultimate goal must be efficiency, growth, and sustainability. As part of this journey, you may be contemplating a transition from Dynamics GP to Business Central, M… Read More
2023-06-06 09:44
Till now we have
launched EC2 instance
connected it via MobaXterm
installed CodeDeploy-Agent on it
Attached IAM Role to the instance.
If you want to visit Part 1 of this Blog, you can click… Read More
2023-06-06 07:36
In software development, automating code deployment has become a crucial component of DevOps process, as it enables developers and operation team to work seamlessly.
Here comes AWS Code Pipe… Read More
2023-06-06 05:40
Whenever we enter data into sales or purchase lines, the default line type is “Item,” as shown below,
If we want to use a default line type other than item, then follow the belo… Read More
2023-06-05 13:52
Problem Statement: How to create or use variables while creating custom columns in Power Query
Solution:
To declare variables in power query, let and in keywords are used.
Scenario 1: In the… Read More
2023-06-05 13:38
Today we are going to look at how to make visual titles dynamic.
It’s an easy process and helps in making your visual more informative and dynamic in a way that the slicer selections w… Read More
2023-06-05 10:16
In this blog, we will be seeing how we can reset the Decomposition Tree using Bookmark in Power BI.
Step 01:
Create a Decomposition Tree visual on a page. Also, add a date slicer… Read More
2023-06-05 09:30
In this blog, we will be seeing how we can create Dynamic Title in Power BI.
Step 01:
I have created a Clustered Column Chart which is showing Total Sales by Month an… Read More
2023-05-08 12:01
Overview:
A running total is the addition of a sequence of numbers that is updated each time a new number is added to the sequence. We can calculate the running total by adding the… Read More
2023-05-03 13:30
In Business Central, Personalize and Design are two different features that allow you to customize the user interface to suit your preferences and requirements.
Personalize is a feature that… Read More
2023-05-03 13:14
Does sandbox PTE get removed or not after D365 – BC is updated?
when a sandbox environment is updated, any extensions that were installed in that environment will not be automatically… Read More
2023-05-02 12:48
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 chart sh… Read More
2023-05-02 12:40
In this blog, we’ll be creating a custom tooltip and also see how we can configure it in Power BI.
Here, along with the sales amount on the clustered column chart, we want to see the t… Read More
2023-05-02 12:30
In this blog, I’ll explain how to calculate sales for the past 30-60-90 days and display sales data with the help of the Slicers.
The steps we take to display sales data in the past 30… Read More
2023-05-02 12:16
Agenda:
1. Problem Statements
2. Possible ways
3. Solution
1. Problem StatementsI want to select a single date in the filter, so I want the date picker to allow the selection of only one dat… Read More
2023-04-26 12:28
Read Below:
Here we are going to look into how to connect Power BI with Amazon’s Simple Storage Service (S3) to get data.
You would need the following environment already set up / If n… Read More
2023-04-21 11:35
Web service in Business Central
In Business Central, web services are used to expose the functionality of the system to external applications over the internet. This allows other appli… Read More
2023-04-10 12:11
To publish an app file in the production environment in Business Central, you can follow the steps below:
Create an app package: First, you need to create an app package file (.app) that con… Read More
2023-04-10 11:58
Example:
We have the “Job List” report with report ID 10126. Let’s design a new Excel report with an existing report to create charts, a pivot table, and graphs, using for… Read More
2023-04-07 10:09
Example:
We have the “Job List” report with report ID 10126. Let’s design a new Excel report with an existing report to create charts, a pivot table, and graphs, using for… Read More
2023-04-07 08:04
Overview:
Reports are used to display information from a database. Earlier, there were two types of report layouts, i.e., RDLC and WORD. A new type of report layout called Excel Layout has b… Read More
2023-04-04 07:35
In this blog, we will be showing multiple slicer selections in a card or text box in Power BI.
We’ll be adding two slicers containing ShipCountry and ShipCity, and a text box that will… Read More
2023-04-04 07:22
In this blog, we will be seeing how we can make our Power BI report publicly available on a simple web page or embed them on our web page.
Step 01:
Open the report on powerbi.com.
Step… Read More
2023-04-01 10:59
What is Designing in business central?
When we develop extensions in the AL development environment, you have a wide range of possibilities. With the help of Designer mode in Dynamics 365 Bu… Read More
2023-03-14 11:52
What is personalization in Business Central?
Personalization lets you decide which actions to show on the navigation and action bars and on Role centers, and where to show, hide, or move ind… Read More
2023-03-14 09:15
Problem Statement: Retain the slicer selection between different bookmarks.
Below is a simple page where the sales amount is displayed in a table visual with its respective product category… Read More
2023-03-14 09:00
What is the use of highlighting the max value in a visual?
Highlighting the maximum value in the leftmost bar chart instantly improved the value of the visual. It gives us a quick insight in… Read More
2023-03-14 07:41
Login to SharePoint online and follow the below steps: –
Step 1 – Click on create site option as highlighted.
Step 2 – Select the Communication site option.
Step 3 &ndash&hell…Read More
2023-03-14 07:17
In this blog, we will see how to create a form with the pattern “Table of Contents”. And use a parameter table to save the data from the form.
Create a Table:
We have created a… Read More
2023-03-14 07:03
In this blog, we will see how to create a runnable class and how to execute them.
In X++, a runnable class is a class that can be executed directly from the Application Object Tree (AOT) in… Read More
2023-03-13 07:53
Agenda:
Problem Statements
Solution
Problem Statements
I have one slicer and one card visual. So if I select one value from the slicer, it will be reflected on the card visual, but th… Read More
2023-03-13 07:40
Power BI is a powerful business intelligence and data visualization tool, and page navigation is an important aspect of creating effective Power BI reports. In this blog, we will discuss how… Read More
2023-02-10 11:21
This Blog is about displaying the Invoice Number in the header of an RDLC report in Business Central.
When we print a sales or purchase invoice, we see the report has the invoice number in… Read More
2023-02-10 10:13
In this blog, we will learn how to Create a displayed barcode in RDLC Report.
So basically, the barcode is a way of representing the data in form of lines. Any Alpha-Numeric string can be en… Read More
2023-02-10 10:06
In this blog, you will learn about how to get data from weather API and store the result as a JSON file in your system.
Steps to get API data using custom C# code in SSIS.
Prerequi… Read More
2023-02-07 07:35
How to use GULD in BC, And how to visible only limited identifiers through GUID
In Business Central, a GUID (Globally Unique Identifier) data type can be used to store unique identification… Read More
2023-02-07 07:28
What is Multiselection?
Multi-selection for fields in Business Central is a feature that allows users to select multiple items from a list, rather than just one. This is particularly useful… Read More
2023-02-06 12:41
Reports are used to print or display information from a database. In Business Central, earlier there was a property named “DefaultLayout”. With the help of the “DefaultLayo… Read More
2023-02-06 12:20
What is Table in Business Central?
In Business Central, tables are the core objects used to store data.
There are four sections in the table structure:
The first section contains metadata fo… Read More
2023-02-06 07:45
Agenda:
Problem Statements.
Solution.
1. Problem Statement:
We need one card that will show some text and selected values from the slicer.
e.g., I have one slicer (i.e., year) and I want to… Read More
2023-02-06 07:39
Agenda:
1. Expectation
2. Problem Statement
3. Solution
Expectation
Here we have data for all products, and we want to see the sales of each product, but we also want to highligh… Read More
2023-02-06 05:29
What is Visual studio?
Visual Studio is a streamlined code editor with support for development operations like debugging, task running, and version control. It aims to provide just the tools… Read More
2023-02-03 12:55
In this blog, we will be seeing how we can use the Numeric range Parameter in Power BI.
The Numeric range Parameter is a feature that allows us to interact with the variable as a slicer a… Read More
2023-02-03 11:52
In this blog, we will be seeing how we can use Fields Parameter in Power BI.
The Fields Parameter is a feature that allows us to choose which colu… Read More
2022-11-23 06:20
Add Your Heading Text HereAutomating Your Organizations Azure Dev-Ops
Power-BI Reports
Azure Dev-Ops provides us a way of managing, organizing, and tracking all the tasks a… Read More
2022-10-03 12:18
We have to embed the Power BI report in Dynamics 365 directly. But when we select New the drop-down doesn’t give us the option to embed the Po… Read More
2022-10-03 07:27
New updates for Fields Parameter
Agenda:Problem StatementsSolution … Read More
2022-09-29 12:40
Automating Your Organization’s Azure Dev-Ops Power-BI Reports.
Azure Dev-Ops provide us a way of managing, organizing, an… Read More
2022-09-26 06:19
In this Blog, I will show you How to select Max Date and Max Time for the Date.I have this kind of table:CREATE TABLE Dateandtime1(  … Read More
2022-08-29 05:52
Still haven’t empowered your business with Microsoft Power BI? Hurry up!
Microsoft Power BI is a set of Business Intelligence tools used by… Read More
2022-08-02 09:24
Hi Readers , have you ever wondered on how to run a Machine learning Model (in python) in Powerbi application? This Blog will help you with it.Before Implementing it you need to have a ML mo… Read More
2022-07-04 05:17
Hi everyone! As you know tables and matrix visuals are the most go to visual for any Power BI Report.
And there may be a chance where you may have a requirement to display the totals right t… Read More
2022-07-04 04:39
Alerts and Notification are great features provided by Microsoft Power BI for their report users. You will get an alert or notification when the value goes above or below the threshold. You… Read More
2022-06-15 10:18
I worked on a dataset connected through Web API. Multiple tables are appended and used in the report.
I got the below mentioned error while refreshing manually and scheduled in Powe… Read More
2022-06-15 10:12
This is a small blog explaining the DAX expression to count multiple column values into a single column.
Here we have a sample table Table1, which has columns named ID, Dim1, Dim2… Read More
2022-04-20 14:30
The Drillthrough feature in Power BI functions as an indicator for a Power BI Report. With Drillthrough in power bi report, you can create a destination target page in your report. Whe… Read More
2022-04-15 11:15
In this blog I will show you how you can set format for hierarchical axis labels on chart in good way, also we will see how concatenate labels property will help us to achieve this
Issue… Read More
2022-04-10 11:25
Coca Cola beverages Africa is number Coca Cola bottler in Africa and eighth largest brand on global revenue. This is possibly achieved by the brand due to adaptation of Microsoft Technologie… Read More
2022-04-05 09:30
The COVID 19 pandemic has affected the entire world on huge masses. It has not yet been controlled by the governments as the on-going spread of its variants is the main concern. … Read More
2022-03-20 12:45
In our previous blog we saw how CRM is related to HR, in this blog we will how CRM which yields greatest outcomes for maintaining customer relationships, gives in depth benefits for marketin… Read More
Subscribe to Addend Analytics
Get updates delivered right to your inbox!