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 …
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"
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"
In Today’s data era, it is very important to represent data in a way which is suitable for every type of user (Technical or Non-Technical). Use of data visualizations is getting increased exponentially. We have various data visualization tools available in the market such as QlikView, Power BI, Tableau, Google DI studio. Power BI provides …
Reckon Analytics 