Dynamic Google Analytics API using Python

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 …

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 …

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 …