Databases Scheduling a Pipeline in Azure Data Factory By Satya Gopi Requirement: How to schedule a pipeline to run on a daily basis in Azure Data Factory Solution: Log into Azure Portal, Open existed pipeline in data factory On the top header we have Trigger option Click on Trigger and we...
Databases Connecting to On-Premises SQL Server in Azure Data Factory By Ramu Vudugula I have created a pipeline in Azure data factory. I want to copy data from SQL server hosted in my local machine. In Azure we can connect to any cloud services but we cannot connect on-premises sources. To achieve this...
Javascript Display a Progress Bar at Top of Webpage By admin Display a Progress bar at the top of your webpage which states how much user has scrolled with jQuery Prerequisites: Knowledge on HTML and jQuery In this blog we will be discussing how to get the percent of page a...
Databases Connecting Presto with Mongo 4.2 By admin This blog would explain how to connect Presto with Mongo 4.2 Prerequisites: Mongo 4.2 Presto 0.226 To create a connection between Presto and Mongo, follow below process: Make data easy with Helical Insight. Helical Insight is the world's best open...
Power BI Creating User Input Variables in a Power BI Report By admin Requirements: In a report, a user should have the flexibility to enter the input number and that number should filter the data. In Power BI reports, we can create slicer with input number and we have options to choose either...
AWS Connecting to Database from AWS Glue By Sai Kavya Sathineni From AWS Glue, you can connect to Databases using JDBC connection. Follow the below steps to connect to Database: Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Grab The 30 Days...
Jaspersoft Increase the Column Width for Jasper Adhoc Report By Satya Gopi In this blog we are going to cover how to increase the column width for jasper adhoc reports. Perquisites: Jasper 6.4 Enterprise Databases: SugarCRM Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence...
Services Connecting to PostgreSQL Database in Power BI Desktop By Ramu Vudugula Microsoft Power BI Desktop is a business intelligence tool which can be used to connect to any type data source I.e either a file or from a database, transform and visualize the data. Make data easy with Helical Insight. Helical...
Services Controlling Month and Quarter Slicers in Power BI By Sohail Today let's look into Controlling Month and Quarter Slicers, i.e Disable QTD Slicer on click of Type Slicer(Values are MTD and QTD) and versa To my best of understanding, PowerBI revolves around The DataSet and its relationship so with that...
Databases Update Data in MySQL Database Using Sequelize and Nodejs By admin Sequelize is an ORM tool which is used to save data from node application to the databases like MySQL, Postgres and many others and a Model is basically a table in the database. Make data easy with Helical Insight. Helical...
Pentaho Export Mondrian Schema to Excel using PDI By Mounika This blog explains how to create a job in PDI which can export Mondrian schema which is in XML format to excel. Consider below a sample of Mondrian Schema: <?xml version="1.0" encoding="UTF-8" standalone="no"?> <Schema name="TransactionType"> <Dimension highCardinality="false" name="Dim Customers" type="StandardDimension"...
Data Visualization Binary Gaps with Python By admin Recently I saw a question on-line to find the Binary Gaps in a Binary Number. What is a Binary Gap? A binary gap within a positive integer N is any maximal sequence of consecutive zeros that is surrounded by ones...