Posts

Showing posts from April, 2022

Data Blending in Tableau

 How the data blending works in Tableau? When you use data blending to combine data, a query is sent to the database for each data source that is used on the sheet. The results of the queries, including the aggregated data, are sent back to and combined by Tableau. The view uses all rows from the primary data source, the left table, and the aggregated rows from the secondary data source, the right table, based on the dimension of the linking fields. Data Blending 1-when the dataset is from a different data source 2-Uses only left join. 3-Data can be available at different levels of granularity. 4-Sends separate queries to each dataset, aggregates, and then perform blending Tableau Public Link: https://public.tableau.com/app/profile/arabinda.mohapatra/viz/BLENDING_16509621767950/definitation?publish=yes

Relationship in Tableau

  Relationships are a dynamic, flexible way to combine data from multiple tables for analysis. We recommend using relationships as your first approach to combining your data because it makes data preparation and analysis easier and more intuitive.  ----------------------------------------------------------------------------------- Requirements for using relationships When relating tables, the fields that define the relationships  1 must have the same data type. 2-Changing the data type in the Data Source page does not change this requirement. 3- Tableau will still use the data type in the underlying database for queries. 4-You can't define relationships based on geographic fields. 5-Circular relationships aren't supported in the data model. 6-You can't define relationships between published data sources. 7- - Relationships do not allow us to decide on the join type. 8- In the earlier versions of Tableau, in the absence of a relationships, this task would have require...

Coding Challenge Part 2

  Python program to find l.c.m. of two numbers num1 = int(input("Enter first number: "))   num2 = int(input("Enter second number: "))   if num1 > num2:       greater = num1   else:       greater = num2   while(True):       if((greater % num1 == 0) and (greater % num2 == 0)):           lcm = greater           break       greater += 1   print("LCM of",num1,"and",num2,"=",greater) Python program to calculate the cube of a number num=int(input("Enter the number:-")) import math cube_n=num*num*num print("cube  OF {} is {} ".format(num,cube_n) ) Python program to calculate the square root of a number ¶ num=int(input("Enter the number:-")) if num<0:     print("Negative numbers can't have square roots") else:     import math     sqrt_n=math.sqrt(num)   ...

Python Coding Intreview question

 #Coding challenge  Python program to reverse a number n = int(input("please give a number : ")) print("before reverse your numeber is : ",n) reverse = 0 while n!=0:     reverse = reverse*10 + n%10            n = (n//10) print("After reverse : %d" %reverse)  Python program for palindrome using an iterative method n=int(input("Enter a number: ")) reverse,temp=0,n while temp!=0:     reverse=reverse*10+temp%10     temp=temp//10 if reverse==n:     print("number is palindrom") else:     print("number is not palindrom") Program to check a number is Armstrong or not in num = int(input("please give a number : ")) if num!=0:     input_number=[]     res = [int(x) for x in str(num)]     print(res)     for i in res:         input_number.append(i**3)         result = 0         for ele in range(0, len(input_n...