Data Science - Python

Step 1 : Open Power BI & then navigate to Get Data > Web > Enter   https://api.covid19api.com/summary   to access COVID-19 World data Step 2: Import Custom Visual – ‘Text Filter’ as we are going to add a Search Box which would search across columns – CountryCode, Country, TotalConfirmed, TotalRecovered, TotalDeaths Step 3: Create a new column# ‘SearchBox’ which would be concatenation of columns – CountryCode, Country, TotalConfirmed, TotalRecovered, TotalDeaths Now a new column is a part of the data-set. We can use part of string to filter the data. For example – we can search by just typing ‘0’ in search box or CountryCode or Country or Partial String …… Step 4: Let’s use the formula column in our chart to filter data.   Step 5: Tada  🎉🎉 we are able to filter data across a combination of columns !!! Step 6: Import a new custom visual – ‘Play Axis’ . It’s ...

Prerequisite: You should have knowledge of Power Apps to build INSERT/UPDATE/DELETE custom form and data source should be SharePoint Online List or SQL Server. So you should be ready with a PowerApps custom form which would have ability to insert/update/delete data directly from the data source Ask: Is it possible to INSERT/UPDATE/DELETE data directly in POWER BI ? Yes, it’s quite possible to achieve the functionality using PowerApps in POWER BI. I have tested it on Data Source - 'SharePoint List' and it’s working as expected  🎉🎉 Please follow step-by-step instructions below. 1.         Launch POWER BI Desktop tool 2.        Get Data From SharePoint Online List or SQL Server 3.       Import a custom visual – ‘PowerApps for Power BI’ from AppSource 4.    Click on the PowerApps icon to use this functionality in the page. 5.    Add rele...

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 ...

If you want to see latest data of an excel workbook into your POWER BI Report then you have to follow these steps. > Open Power BI Desktop > Refresh the data-set > Publish the POWER BI Report again > Open POWER BI SERVICE to see the changes at website - http://app.powerbi.com/ Isn't it a tedious process ? You just need to install a gateway executable file (On-premises data gateway (personal mode).exe) and configure it to automate the refresh. Yeah, it's so simple !!!! Step 1: Update your excel workbook with latest data-set Step 2: Launch the Personal Gateway and enter your email Id to configure it. Now it's ready to be used !!! Step 3 : Now you have to login to POWER BI Service and open the data-set which needs to be refreshed automatically. I have already created a POWER BI REPORT with name - "INDIA COVID-19 TRACKER " and its associated data-set is having same name. We have to configure highlighted sections to automate ...

A  list  in  SharePoint  is a collection of data that gives you and  your  co-workers a flexible way to organize information. Add columns for different types of data, such as text, currency, or multiple choice.  Moreover it can be accessed from POWER BI. Yeah, that's the only interesting point for me !!! So any person with appropriate permission can read or edit the data of SharePoint List. Importing files from SharePoint Online List, is a great way to make sure the work you’re doing in Excel stays in-sync with the Power BI service. I'll explain its connectivity with POWER BI in the last section of this blog.  Advantage of SharePoint List : 1. It can be accessed from Data Visualization Tool like POWER BI ,Tableau etc. 2. You need to give access to a user and the user can access the SharePoint List. 3. Ability to create many different views where you can sort,filter or group by attributes/fields 4. Ability to set permission at row ...

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

DAY 13 - Import data dynamically from Oracle DB using Python script in Power BI Desktop Step 1 : Python IDLE  & Power BI need to be installed in your system Step 2: Execute the below script independetly in Python IDLE and make sure it's getting executed successfully. import cx_Oracle import pandas as pd connection = None try:     #Oracle DB Connection Details       username = 'p_user_name'     password = 'p_password'     dsn = 'hostname:port_number/service_name'       connection = cx_Oracle.connect(         username,         password,         dsn)       # show the version of the Oracle Database     #print(connection.version)       cur = connection.cursor()     cur.execute("select * from oe_order_headers_all where rownum <=10") #fetching 10 records from Order Header Table ...