Its All About Analytics
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 …
Continue reading "Databricks Unity Catalog Explained for SQL Server Folks"
1. SET NOCOUNT ON: Stop the message that shows the count of rows affected by a T-SQL statments. These messages can be suppressed with SET NOCOUNT ON and can increase performance by decreasing network traffic 2. IF EXISTS(): Use IF EXISTS() to check if data exist in a table or not. You can write something …
Continue reading "Six Simple Steps to Improve Stored Procedures in SQL Server"
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?"
Problem: Power BI has a Google Analytics connector but one can not 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 …
Continue reading "Dynamic Google Analytics API using Python"
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# ?"
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")
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"
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
Reckon Analytics 