DAY 12 - INDIA COVID-19 TRACKER IN POWER BI 

I have created COVID-19 INDIA tracker in POWER BI. Kindly have a look and provide your valuable feedback.  

I am also creating INDIA COVID-19 TRACKER in Public Tableau so that you can access it and also get the feel of fully interactive Dashboard.


You'll get data-set from multiple websites. Just get the flat files from any one of these public websites.

Step 1: Use python to do data cleansing and make sure to create a data-set                       named - INDIA-COVID-19 which is having these 5 columns (i.e.                                 State,Confirmed,Active,Recovered & Death) 

Step 2: Load this data-set in Power BI 

Step 3:  Create below mentioned 5 pages in Power BI

             a) Dashboard --> It's being used to navigate to other 4 pages . It's your                       landing page.



    
             b) INDIA COVID-19-Tracker --> It's your first page where you can find                         bubbles across India Map. Each bubble is representing a state and it                       also displays the data summary , if you hovers over it. There are 4                           number cards on the page which would show the summary at                                   INDIA/State level. If you select a state , then number on each                                   card,Map and Table would display value of corresponding state. So                           page is fully interactive in nature.

                Moreover I have added a Home Icon which can redirect you to                                  Dashboard Page.



             c) State-wise break up of COVID-19 Case --> It's the 2nd Page which                           displays state-wise break-up of COVID-19 case in Histogram Format.  

                  Also added Home Icon here.



             d) COVID-19-INDIA-HEATMAP --> It's the 3rd page which displays data                       in Heatmap format. Each Box represents a state and its size depends                     on number of COVID-19 cases. 
  
                 For example, a state with maximum cases of COVID-19 is represented                     by a bigger box.



              e) Q & A --> 
                  This is one of the most powerful tools in Power BI. Natural Language                      Q& A allows users to write questions and Power BI generates graphs                      automatically. So there is no need to generate these graphs manually. 



#RR #Day12 #Python #PowerBI #INDIACOVID-19TRacker #HappyLearning #WeLearnEveryday


Comments

Post a Comment

Popular posts from this blog

Day 32 - Python Script to track Available COVID-19 Vaccine Slots for 18+ in India

Image
 Booking a COVID-19 vaccination slot reminds me of good old days of booking a TATKAL ticket in   Indian train. If you are lucky and very fast with Keyboard then we would be able to book the train   ticket  under TATKAL quota. Otherwise Surprise !!!  Same rule applies here too but we don't have idea about the next available slot timings for vaccination. When is the next slot going to open ? Still it's a suspense for us. By the time we come to know that there are few slots available, CoWIN portal ( https://www.cowin.gov.in/home ) shows that it's already booked. I have observed that people are struggling to find an available slots in their locality. So I thought of writing a python script using public API to track the available COVID-19 vaccine slots in the entire city. Task for interested folks who want to send an alert to a group/channel: Please trigger an email or message on WhatsApp/Telegram group whenever you get any data in the output file - "18plus...
Read more

DAY 1 - Steps to prepare your windows laptop for Python Programming

Steps to prepare your windows laptop for Python Programming ############################################ 1. Open the URL : https://lnkd.in/fgWmkH3 and click on Version - 'Download Python X.Y.Z' 2. Now IDLE (Python GUI) and Python (command line) should now by in your program menu 3. Search for file - 'idle.bat' in C drive and copy the file path 4. Create a new bat file with name - 'idle.bat' at your desktop to access python idle 5. Enter the single line - "FILE_PATH_OF_IDLE.BAT\idle.bat" and save the file. for example, C:\Users\Rakesh.Ranjan\AppData\Local\Programs\Python\Python37-32\Lib\idlelib\idle.bat 6. Double click the bat file to access Python IDLE Steps to install pandas in windows laptop ############################################ 1. Search for file - 'pip.exe' in C drive and copy the file path 2. Open the command prompt and go to above path For example - cd C:\Users\Rakesh.Ranjan\AppData\Local\Programs\Python\Python37...
Read more

DAY 13 - Import data dynamically from Oracle DB using Python script in Power BI Desktop

Image
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 ...
Read more