Data Science
Change Tracking Example -SQL Server
Following are the step by step instructions to enable and use the change tracking feature in SQL Server.
If there is a requirement to get incremental or changed data from database frequently without putting a heavy load on database objects, then Change Tracking mechanism of SQL Server...
DW Loading dashboard control in PowerBI and Report Services
It has built in PowerBI, using PB Gateway for updating data, accessed by APS through the mobile:
DW Loading Dashboard Chart by DW Loading vs Affected rows
DW Loading Dashboard KPI’s by DW Loading Accuracy
DW Loading Dashboard - Last TDW Loading
DW Loading Dashboard - KPI’s DW...
Autocomplete with ElasticSearch and JQuery and Python
This is an example using ElasticSearch with JQuery and Python, I built that concept using synonyms in Windows. Thanks to my friend Ricardo for your support ;)
The challenge was to build a solution that would be able to search by a word to return the synonyms like that:
To...
SQL Performance in PowerBI Real-Time
Yes, it's a SQL Performance Monitoring in Real-Time, developed in Power BI, Json, C#, T-SQL, RestAPI and CLR.
It has been building to show up the health performance environments:
Web Version:
Through the Power BI Apps, we can access the indicators online for SQL...
R Syntax (dplyr) - Working as a TSQL language
Introduction to dplyr
2016-06-23
When working with data you must:
Figure out what you want to do.
Describe those tasks in the form of a computer program.
Execute the program.
The dplyr package makes these steps fast and easy:
By constraining your options, it simplifies...
Microsoft ratchets up its R enthusiasm
remain pleasantly surprised at Microsoft's enthusiasm for adding R to its analytics ecosystem (and not [at least yet] fulfilling suspicions its end game is to fork a version of R that is semi-proprietary). Today offered another example, with an R for the Masses with Power BI webinar...
Connection R Studio with different Sources: TXT from Local or Internet, SPSS, Relational Databases, Non-Relational Databases, XML..
For further information:https://www.r-bloggers.com/importing-data-into-r-from-different-sources/
How to do to install Curl in Ubuntu
In Ubuntu command line execute:sudo apt-get install php5-curl
Como instalar Java em Linux Ubuntu
Como instalar o Java no Ubuntu com apt-getDecember 3, 2014 IntroduçãoComo uma grande quantidade de artigos e programas necessitam ter o Java instalado, este artigo irá guiá-lo através do processo de instalação e...
Importing Data Into R from Different Sources
Interesting article explaning who to do to interact R with souces like Cassandra, NoSQL, XML...Source: https://www.r-bloggers.com/importing-data-into-r-from-different-sources/