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”) Advertisements

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 … More Credit risk prediction using Artificial Neural Network algorithm

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 … More 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 … More 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 … More Tutorial: Reading data from PDF Sheets in Tableau

Week 22 MOM – Internet user per 100 people in world (v2)

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 … More Week 22 MOM – Internet user per 100 people in world (v2)

Week 22 MOM – Internet user per 100 people in world

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 … More Week 22 MOM – Internet user per 100 people in world

Using R in Tableau

Requirements: Tableau Professional Edition R Studio or R Console Setting Up Tableau Desktop with R: Install following packages in R: install.packages(RServe) Once it is installed then start R Server by entering following command in the console: > library(RServe) > RServe() Configuring Rserve Connection: In Tableau go to following menu setting: Help -> Settings and Performance … More Using R in Tableau

QVC

var divElement = document.getElementById(‘viz1493909286527’); var vizElement = divElement.getElementsByTagName(‘object’)[0]; vizElement.style.width=’100%’;vizElement.style.height=(divElement.offsetWidth*0.75)+’px’; var scriptElement = document.createElement(‘script’); scriptElement.src = ‘https://public.tableau.com/javascripts/api/viz_v1.js’; vizElement.parentNode.insertBefore(scriptElement, vizElement); The objective of this challenge was to create a Decision Support System so that QVC can make strategic decisions to answer some of the business questions such as customer next buy (product and product category), top products … More QVC