Author – Sana Khatoon Data Engineer What you will take away from this blog- Get familiar with Azure Machine Learning Studio Workspace How to create experiments Calculate Mean and Standard Deviation on MPG data for various automobiles Integrate Machine Learning Model in Power BI Desktop Visualize your model Prerequisites- Requires Azure Subscription for creating Azure…
Author- Ashfaq Pathan (Data Engineer) Move and Extract data in batches using Azure Data Factory Prerequisite: Azure Subscription Azure Data Factory Azure Storage Account Problem Statement: While we were moving all the data in the last 15 min from Azure File Share to Azure Blob Storage, the volume of the data would vary in…
Author – Sana Khatoon Data Engineer What you will take away from this blog- Get familiar with Machine Learning Workspace Predict Diabetes Score using Linear Regression Integrate Machine Learning Model in Power BI Desktop Visualize your model using Python Visuals Prerequisites- Requires Azure Subscription for creating Automated ML Workspace Install Python on your system Understanding…
Author- Kriti Bhardwaj(Data Engineer) In this documentation you will learn how to migrate On-premises MySQL to Azure database for MySQL using DMS. Here I have taken demo sample database to migrate with minimal downtime. Pre-requisites: Create Azure database for MySQL. Create a virtual machine. Create DMS. Install MySQL workbench. Both Azure database for MySQL and…
Author- Shruti Srivastava (Data Engineer) In this article, it is explained how to build a SSAS Multidimensional cube, deploy it in one Azure VM and then copy and restore it into a second Azure VM. For this purpose, we have to create two Azure Virtual machines named shrutiVM main(in which SSAS cube is deployed) and…
Author- Ashfaq Pathan (Associate Data Engineer) Transactional Replication Setup We will set up a transactional replication for migrating the database from Managed Instance to SQL Server 2017 hosted on Azure SQL-VM. Managed Instance will be both Publisher and Distributor. SQL Server will be Subscriber. Prerequisites: 1. Azure Subscription. 2. Storage account with one file-share in it…
Author – Kriti Bhardwaj, Associate Data Engineer This article describes how to set up Data-in Replication in Azure Database for MySQL by configuring the source and replica servers. Data-in Replication allows you to synchronize data from an external MySQL server into the Azure Database for MySQL service. The external server can be on-premises, in virtual…
Author: Shruti Srivastava, Associate Data Engineer In this blog, We will check how to migrate data from Azure SQL database to Azure SQL Managed Instance. Pre-requisites: Azure Account SSMS Steps: A. Create Azure SQL Database with sample database Click on Create Sql database . Enter subscription name, resource group, Database name, Server name. Select…
Author: Ayush Chauhan, Data Engineer In this article, we will see how to automatically save the attachments associated with an Outlook Mail to Azure File Share using Microsoft Flow. This helps to archive the Outlook attachments. To optimize the attachment extraction from email to further optimize the performance of your entire solution you…
Author: Sneha Valia Tally.ERP 9 Tally is at the forefront of simplifying business management for business through automation. Tally.ERP 9 is a windows–based Enterprise Resource Planning software. The software handles Accounting, Inventory Management, Order Management, Tax Management, Payroll, Banking and many such requirements of the business. It supports all day-to-day processes from recording invoices to generating various MIS reports. Tally’s product caters…
