Posts

Showing posts from March, 2020

India Fights COVID-19 Coronavirus..........

Image
CLICK here to get COVID-19 Updates India Fights COVID-19 CoronaVirus The outbreak of coronavirus disease (COVID-19) has been declared a Public Health Emergency of International Concern (PHEIC) and the virus has now spread to many countries and territories. While a lot is still unknown about the virus that causes COVID-19,  we do know that it is transmitted through direct contact with respiratory droplets of an infected person (generated through coughing and sneezing) Individuals can also be infected from touching surfaces contaminated with the virus and touching their face (e.g., eyes, nose, mouth).  While COVID-19 continues to spread it is important that communities take action to prevent further transmission, reduce the impacts of the outbreak and support control measures. COVID-19 is a disease caused by a new strain of coronavirus. ‘CO’ stands for corona, ‘VI’ for virus, and ‘D’ for disease. Formerly, this disease was referred to as ‘2019 novel coronav...

World-wide issue COVID 19

Image
/ https://public.tableau.com/profile/ritimugdha.das2797#!/ For updates open the above mentioned link and click on COVID-19 image. Coronavirus disease (COVID-19) is an infectious disease caused by a newly discovered coronavirus. Most people infected with the COVID-19 virus will experience mild to moderate respiratory illness and recover without requiring special treatment.  Older people, and those with underlying medical problems like cardiovascular disease, diabetes, chronic respiratory disease, and cancer are more likely to develop serious illness. The best way to prevent and slow down transmission is be well informed about the COVID-19 virus, the disease it causes and how it spreads. Protect yourself and others from infection by washing your hands or using an alcohol based rub frequently and not touching your face.   The COVID-19 virus spreads primarily through droplets of saliva or discharge from the nose when an infected person coughs or sneezes, so it’s i...

DATE FUNCTION IN TABLEAU

DATE FUNCTION :   1.          DATEADD   Function :  DATEADD(date_part, Interval, date)  Example : DATEADD(‘day’,15, #2014-09-15#)  = 2014-09-30  12:00:00 AM       2.   DATEDIFF   function   : DATEDIFF(date_part,date1,date2, start_of_Week )  : ‘Start_of_Week’  is not mandatory    DATEDIFF(‘day’,#2014-09-05#,#2014-09-20#)  = Five 3.          DATENAME Function :  DATENAME(date_part, date, [ start_of_Week] )  : ‘Start_of_Week’  is not mandatory  DATENAME(‘Month’,#2014-09-01#)  = “September” Datename(‘weekday’,[order Date])= Sunday,Monday,Tuesday,…,Saturday) DATENAME('month',[Order Date])=January,February,March,…. DATENAME('week',[Order Date]) (Week number)      4.   DATEPARSE Function : DATEPARSE(format,String)   This date functions prim...

Rank Function in Tableau

Rank function : you can create a calculated field using Rank function. Rank(expression,[‘asc’],[‘desc’]) For  example of rank function we take below table Example:  Stores Sales A 10 B 20 c 20 d 40 e 50 a.        If we use ‘ Rank(Sum([Sales])) ’ we get the result as Stores Rank Function Sales A 5 10 B 3 20 c 3 20 d 2 40 e 1 50 Here rank 4 is skipped. b.       Rank_Dense () RANK_DENSE(sum([sales])) Stores Rank Function Rank Dense function Sales A 5 4 10 B 3 3 20 c 3 3 20 d 2 2 40 e 1 1 50 On this same number gives the same rank. on above example on two cells sales amount is 20 . then it gives same rank to both. c.        Rank_modified() Create a calculated field using rank_modified function  Rank_modified(expression,[‘asc’I...