Power BI is a Business analytics framework from Microsoft who is the leader in BI for the last 12 years according to the Gartner. Since we have a dynamic environment, we would love to know the capabilities and integration with this tool.
The following link will take you to the end-to-end features of Power BI.
As the cloud has become something that you cannot avoid in the current technology race, it is important to understand what are the options you have to create a database in the Azure platform. As shown in the below image, there are different architectural options.
The membership function is the key component in fuzzy techniques. When fuzzy techniques are extended to the data warehouse, so that we can make decisions using fuzzy techniques in a data warehouse, it was identified that in the many implementations does no have the data-driven techniques to define fuzzy membership function.
In this research paper, which is a research project on Investigation and Development for Fuzzy Data Warehouse, we have used the famous Box Plot technique to derive a fuzzy function. In this technique, we have mapped the fuzzy function parameters to the Box Plot parameters as shown below.
Data Warehouse is a comprehensive technology that provides the key people within an enterprise with access to any level of the required information within the enterprise. It is an enterprise-wide framework that permits the management of all enterprise information.
Let us see how we can utilise Microsoft technologies at varies stages of the Data Warehouse technologies.
Transaction Log backups are important in a Production environment. It will make sure that you manage your log file size and keeping backups in case of a need to restore.
I am pretty much sure, most of you have scheduled transaction log backups. If you have scheduled Transaction log backups every 15 minutes, then you will see four log backups every hour and will result in nearly 100 backup files a day and you are looking at around 700 log backups per day. Unlike differential backups, you need all your lob backups to recover. Sometimes, you might have less or no transactions but still, there will be a log backup.
Now the question is, Can we create transaction log backup when there is sufficient size. Yes, you can if you are running SQL Server 2017 or later.
In sys.dm_db_log_stats Dynamic Management Function (DMF), there is a new column called log_since_last_log_backup_mb tells you what is the log file size after the last log backup.
Using the following script, you can perform transaction log backups when the log file size is more than a specific size.
DECLARE @log_since_last_log_backup_mb NUMERIC(9, 2) DECLARE @ThreasholdSize INT = 25 DECLARE @folderName VARCHAR(30) = 'D:\DBBACKUP' DECLARE @DatabaseName VARCHAR(30) = 'LB1' SELECT @log_since_last_log_backup_mb = log_since_last_log_backup_mb FROM sys.dm_db_log_stats(db_id(@DatabaseName)) IF @log_since_last_log_backup_mb > @ThreasholdSize BEGIN DECLARE @fileName NVARCHAR(400) = @folderName + '\' +
@DatabaseName + SUBSTRING(REPLACE(CONVERT(VARCHAR, GETDATE(), 111), '/', '')
+ REPLACE(CONVERT(VARCHAR, GETDATE(), 108), ':', ''), 0, 13) + '.bak' BACKUP LOG [LB1] TO DISK = @fileName WITH NOFORMAT ,NOINIT ,SKIP ,NOREWIND ,NOUNLOAD ,STATS = 10 END ELSE PRINT 'No BACKUP'
There are various types of courses available, BSc, Postgraduate Diploma, BA, MSc, MA, MBA, MDA, MPhil, PhD etc. Many of us don't know how these courses are ordered and unaware that there is a framework for these qualifications.
In 2013, the Ministry of Higer Education with the funding from Worldbank defined the SLQF for higher education in Sri Lanka. In 2015 this was updated with the world standards,
The following is the SLQF in summary.
During this pandemic times, meeting solutions are playing a huge role by keeping the professionals, teachers, students at home and still being able to help their work and study whether it is IT or Non-IT.
You might have your own favourite tool to communicate between your teams and groups, but who is the best among all. Let us hear from the Gartner for their opinion on these Meeting Solutions. They have come up with their traditional magic quadrants for Unified Communications as a Service and Meeting Solutions released in 2020 November.
We have discussed How Orange tool can be used for Image Clustering. Now let us look at how we can perform Classification in Orange.
Like before, we let us select an image set which in classified folders. Those folder names will be taken as the classify names.
Following are the set of images that were used for the Image Classification.
We are building models in Machine Learning. How do you know these models are correct. What are the accuracy levels of these models? As we know there are a lot of parameters to verify. In the case of Classification, we use Recall, Precision, F1 measure are the most common evaluation methods apart from accuracy. In this article, it provides how can we compare models that were built in Azure Machine Learning.
Following are the other articles in the series.
After a long wait, Indian Premier League was started and completed for the thirteenth time with Mumbai Indian declared as the undisputed winner.
We discussed about overfitting by using USA and Sri Lankan President elections and this post is to understand overfitting from a different perspective. Overfitting is your machine learning or predicting model is too accurate. You might think that how come high accuracy is a problem as we always try to increase the accuracy of reciting models. Overfitting can occur due to two reasons.
Now let us look at Overfitting criterias in IPL for the champions over the last thirteen years.
