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 …
If you’re coming from a SQL Server background, think of Databricks Unity Catalog as a centralized metadata management system that simplifies how data is organized, governed, and shared across different data platforms. It’s designed for modern data lakes (such as those in Azure and AWS) but incorporates familiar concepts for SQL users. Let’s break it …
- SET NOCOUNT ON: Stop the message that shows the count of rows affected by a T-SQL statements. These messages can be suppressed with SET NOCOUNT ON and can increase performance by decreasing network traffic.
- IF EXISTS(): Use IF EXISTS() to check if data exists in a table or not. You can write something …
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 comparing incomplete month with full month data for the previous year. A simple way to compare current year sales …
Problem: Power BI has a Google Analytics connector but one cannot apply filters to the download such as date range, event category, etc. This article will solve the problem by dynamically downloading data using Google Analytics API based on user's requirements.
Software Used: Python and Google Analytics Query Explorer
Solution: OAuth method is used …
Install Dropbox.api package using NuGet package manager in Visual Studio. This code won't work standalone. 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 …
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"
This week we are Visualizing Household Income Distribution in the U.S. by State
Data Source: data.world