Its All About Analytics
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"
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?"
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
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"
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"
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"
Makeover Monday -Week 22 This is the first time when I contributed to #MakeoverMondaytableau community work. I really enjoyed working with a different set of data and finding insights which might be useful for the betterment of our society. Looking forward to doing more #MakeoverMonday from next week. About Dataset: Internet users per 100 people This …
Continue reading "Week 22 MOM – Internet user per 100 people in world (v2)"
Reckon Analytics 