What is Covid-19? In December 2019, a pneumonia outbreak was reported in Wuhan, China. On 31 December 2019, the outbreak was traced to a novel strain of coronavirus,which was given the interim name 2019-nCoV by the World Health Organization (WHO), later renamed SARS-CoV-2 by the International Committee on Taxonomy of Viruses. Some researchers have suggested …
Coronavirus disease (COVID-19) Situation Dashboard
How to Calculate YOY for Incomplete Month Data?
Sept 2019 Sales Data till 09/09/2019 Sept 2018 - Full Month Sales Data A very common situation when you don't have full month data to calculate YOY ( Year-on-year), MOM( Month-on-month). You will end up with comparing incomplete month with full month data for the previous year. A simple way to compare current year sales …
Continue reading "How to Calculate YOY for Incomplete Month Data?"
How to Upload FileStream to Dropbox using C# ?
Install Dropbox.api package using NuGet package manager in Visual Studio This code won't work standable. You need to integrate it with your existing project just like an API to use dropbox file uploader in C#. using Dropbox.Api; using Dropbox.Api.Files; using System; using System.IO; using System.IO.Compression; using System.Linq; namespace Dropbox.Functions { class DropboxUploader { static string …
Continue reading "How to Upload FileStream to Dropbox using C# ?"
Sort by Year – Week in Power BI
In Power BI, if you are creating year-week sales report, then you will encounter a most common issue. i.e Power BI by default return single digit week number/month number. Default Sorting in Power BI: But desired results is: 2018-12 2018-11 2018-09 2017-01 Using this formula once can fix this problem: Year-Month= Data[a_date].[Year]&"-"&FORMAT(Data[a_date].[MonthNo],"00") Year-Week= Data[a_date].[Year]&"-"&FORMAT((Data[a_date].[MonthNo],1),"00")
Credit risk prediction using Artificial Neural Network algorithm
1 Introduction Credit risk or credit default indicates the probability of non-repayment of bank financial services that have been given to the customers. Credit risk has always been an extensively studied area in bank lending decisions. Credit risk plays a crucial role for banks and financial institutions, especially for commercial banks and it is always …
Continue reading "Credit risk prediction using Artificial Neural Network algorithm"
U.S. Household Income Distribution by State – Makeover Monday – Week 3
https://app.powerbi.com/view?r=eyJrIjoiYmMzNDA3MTItNDY2ZC00M2YwLWIyMTQtYmIxNTVmZGU5ODYxIiwidCI6IjZkNjJiMjE0LWQyMWYtNDc0YS05MmEyLWFlNjE4NzNiNjA5ZCIsImMiOjl9 This week we are Visualizing Household Income Distribution in the U.S. by State Data Source: data.world
Email Classification into Relevant Category Using Neural Networks
Email Classification into relevant labels using Neural Networks This research work has been carried out jointly by Deepak Kumar Gupta & Shruti Goyal November 11, 2017 Copyright Notice: Any redistribution or reproduction of part or all of the contents in any form is prohibited other than the following: you may print or download to a …
Continue reading "Email Classification into Relevant Category Using Neural Networks"
MOM Week 24: Turner vs Not Turner – Artwork from The Tate Collection
This visualisation is based on the dataset provided by Makeover Monday for week 24. The Tate collection dataset contains the records of all the artists and artworks in the collection. The overview of the distribution of the collection over years has been of uttermost importance. A large amount of data represents artworks designed by Joseph …
Continue reading "MOM Week 24: Turner vs Not Turner – Artwork from The Tate Collection"
Tutorial: Reading data from PDF Sheets in Tableau
Tableau + PDF = Yayay! Tableau just released latest version 10.3 with exciting features which include the capability of extracting data from PDFs files. Now, you can directly import your market research report, quarterly revenue sheet etc directly into Tableau to build amazing vizs to find hidden insights. How to Connect to PDF files? First step download/update …
Continue reading "Tutorial: Reading data from PDF Sheets in Tableau"