Its All About Analytics
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 …
Q. Tableau vs Qlikview, the differences between these platforms? Best Answer: Both, QlikView and Tableau are fabulous tools, which are changing the way BI used to happen traditionally. Both have their own pros and cons. Let me provide my perspective on it: Benefits / Pros for both the tools: 1. Fast implementation - typically it …
Continue reading "Tableau vs Qlikview, the differences between these platforms?"
Reckon Analytics 