Tag: row

Feed: SAS Blogs. Author: Phil Weiss. There are many compelling reasons existing SAS users might want to start integrating SAS Viya into their SAS9 programs and applications.  For me, it comes down to ease-of-use, speed, and faster time-to-value.  With the ability to traverse the (necessarily iterative) analytics lifecycle faster than before, we are now able to generate output quicker – better supporting vital decision-making in a reduced timeframe.   In addition to the positive impacts this can have on productivity, it can also change the way we look at current business challenges and how we design possible solutions. Earlier this year I ... Read More

Feed: What's New. Amazon QuickSight users can now add combo charts to their analyses and dashboards. Combo charts are useful for visualizing data of different scales, such as product revenue ($) and units sold (#), in a single visualization. Data can be visualized as bars or lines, with two axes to display separate scales for each. Combo charts are available in both Standard and Enterprise Editions of Amazon QuickSight ... Read More

Feed: Planet MySQL; Author: Sheeri K. Cabral; Notes/errata/updates for Chapter 7:See the official book errata at http://tahaghoghi.com/LearningMySQL/errata.php – Chapter 7 includes pages 223 – 275. Supplemental blog post – ORDER BY NULL – read the blog post and the comments! GROUP BY and HAVING examples – Supplemental blog post. The example of HAVING in the text shows a use case where HAVING is the same function as WHERE. This blog posts shows examples of HAVING that you cannot do any other way. In the section called “The GROUP BY clause”, on pages 231-232, the book says:“you can count any column ... Read More

Feed: R-bloggers. Author: Gavin L. Simpson. One of the specialist smoother types in the mgcv package is the Markov Random Field (MFR) smooth. This smoother essentially allows you to model spatial data with an intrinsic Gaussian Markov random field (GMRF). GRMFs are often used for spatial data measured over discrete spatial regions. MRFs are quite flexible as you can think about them as representing an undirected graph whose nodes are your samples and the connections between the nodes are specified via a neighbourhood structure. I’ve become interested in using these MRF smooths to include information about relationships between species. However, ... Read More

Feed: SQL Server Customer Advisory Team. Author: Arvind Shyamsundar. Authored by Arvind Shyamsundar (Microsoft)Credits: Prasad Wagle, Srinivasa Babu Valluri, Arun Jayapal, Ranga Bondada, Anand Joseph (members of the Sayint by Zen3 team)Reviewers: Nellie Gustafsson, Umachandar Jayachandran, Dimitri Furman (Microsoft) This blog post was inspired our recent work with the Sayint dev team, who are a part of Zen3 Infosolutions. SQLCAT has been working with them in their process of adopting SQL Server 2017. Microsoft introduced the ability to invoke external Python scripts in SQL Server 2017, and this capability to effectively move ‘intelligence’ closer to the data, was a big ... Read More

Feed: R-bloggers. Author: Peter Laurinec. Ensemble learning methods are widely used nowadays for its predictive performance improvement. Ensemble learning combines multiple predictions (forecasts) from one or multiple methods to overcome accuracy of simple prediction and to avoid possible overfit. In the domain of time series forecasting, we have somehow obstructed situation because of dynamic changes in coming data. However, when a single regression model is used for forecasting, time dependency is not the obstacle, we can tune it at current time of a sliding window. For this reason, in this post, I will describe you two simple ensemble learning methods ... Read More

Feed: Planet PostgreSQL. DBA's best friends: pg_stat_activity and pg_locks. Today, I would like to discuss another handy stats views - pg_stat_activity. This is really useful and powerful view the value of which is hard to measure. In short, the main goal of pg_stat_activity is to show the current activity in Postgres. Hence, if you would like to know what is going on in the database at any given moment, pg_stat_activity is the first place to check. Having worked with Postgres for several years now I’ve accumulated many useful queries. The majority of which I’ve already mentioned in the first article ... Read More

Feed: Planet big data. Author: Dylan Czarnecki. The CX leadership gapSee the results of the 2017 CX Index and discover how to create breakaway CX. Watch the webinar replay    In this year’s Customer Experience Index, Forrester ranked and measured CX quality of 28 US direct and traditional retail banks brands. The research is based on Forrester’s CX Index methodology, which measures how well a brand’s CX strengthens the loyalty of its customers. After analyzing the new data, we found that two stalwarts of CX quality top Forrester’s CX Index again in 2017: USAA leads all direct banks. For the third ... Read More

Feed: Percona Database Performance Blog. Author: Bradley Mickel. Bradley Mickel  | October 9, 2017 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL PREVIOUS POST In this blog post, I’ll discuss some of the MySQL and MariaDB default configuration differences, focusing on MySQL 5.7 and MariaDB 10.2. Percona Server for MySQL uses the same defaults as MySQL, so I will not list them separately. MariaDB Server is a general purpose open source database, created by the founders of MySQL. MariaDB Server (referred to as MariaDB for brevity) has similar roots as Percona Server for MySQL, but is quickly diverging from MySQL compatibility ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Vincent Granville. Here is a new set of easy questions recently published, covering Statistics Programming (General, Big Data, Python, R, SQL) Modeling Behavioral Culture Fit Problem-Solving Statistics: What is the Central Limit Theorem and why is it important? - Answer (or click here for more advanced material on this topic) What is sampling? How many sampling methods do you know? What is the difference between Type I vs Type II error? Answer What is linear regression? What do the terms P-value, coefficient, R-Squared value mean? What is the significance of each of these components? - Answer, Answer ... Read More