DAY 13 - Create visuals using Python Script in Power BI Desktop

DAY 13 - Create visuals using Python Script in Power BI Desktop

Step 1 : Navigate to Python visual icon in the Visualizations pane and click it

Step 2 : Python script editor will appear at bottom on the same page

Step 3 : Drag different columns of data-set to the Values section where it says Add data fields here

Step 4 : Add your visualization script below statement "# Paste or type your script code here:" and click on the Run button to generate a plot

# Paste or type your script code here:
import matplotlib.pyplot as plt
dataset.plot(kind='bar',x='Order',y='Quantity')
plt.show()




#RR #Day13 #Python #DataVizUsingPythonInPowerBI #PowerBI #HappyLearning #WeLearnEveryday

Comments

Post a Comment

Popular posts from this blog

DAY 31 - Organize a Secret Santa Game in your organization using a Python Script

Image
 The script will  perform below mentioned activities: 1.      Assign a Secret Santa randomly to each participant 2.      Save the final extract into an excel file 3.      Send an automated mail to each Secret Santa with a complete address details of his/her Secret Santa Child   Sample final extract file: Sample Mail Format: Prerequisite: 1.       Collect information of participants in an excel file as shown below. 2.  Click on “Manage your Google Account” > Security > Less secure app access Turn ON access for less secure app Note - This setup is required to send a mail from Gmail using Python script   Python Script: # -*- coding: utf-8 -*- """ Created on Wed Dec 2 12:15:58 2020 @author: Rakesh.Ranjan """ import random import pandas as pd import numpy as np import os import string  ss_keys = [] ssc_values = [] input_file_name = "Secret Santa - Information needed-Tes...
Read more

Day 15 - Steps to Import JSON Data-Set in POWER BI & Refresh data-set created from web source in POWER BI

Image
We are going to use  COVID19-India API ( https://api.covid19india.org/ ) to learn this technique. Step 1 : Open POWER BI Desktop Step 2: Navigate to Get Data > Web Enter Web URL of your choice & Click OK                                     Step 3:  A new pop up window will appear. You have to click on Connect. In this section, we are also going to share steps which need to be performed to import JSON data-set I am  interested in state-wise data of COVID-19. So select statewise & click on List Thereafter all record data would appear under list. So you have to click on 'To Table' menu option. Once you click on 'To Table' menu option , data gets expanded into a record form & thereafter you have to click on symbol#' ' to convert records into columns . Do necessary data-modeling and click on 'Close & Apply' menu option. Step 4: I ...
Read more

DAY 10 - Python Program to Print the Pascal’s triangle for n number of rows given by the user

DAY 10 - Python Program to Print the Pascal’s triangle for n number of rows given by the user It's the very basic problem statement in python. Following is an 5 level Pascal's triangle: Sample Input: 5 Sample Output: [1] [1, 1] [1, 2, 1] [1, 3, 3, 1] [1, 4, 6, 4, 1] Solution: import pandas as pd import numpy as np n=int(input("Enter number of rows: ")) nested_list = [] for i in range(n):     k = 0     nested_list.append([]) # keep on adding a new list in each iteration of i     for j in range(i+1):         #keep on appending list[i]         if i <=1: # logic for 1st and 2nd list            nested_list[i].append(1)         else: # logic for 3rd list onwards             if j == 0: # fisrt element of list[i]                 nested_list[i].append(1)      ...
Read more