Data Scientist Digest 4

Title: Great R packages for data import, wrangling and visualization

Author: Sharon Machlis, Executive Editor, Data & Analytics, Computerworld
Source: https://www.computerworld.com/article/2921176/great-r-packages-for-data-import-wrangling-visualization.html
How: Install various packages to accomplish dedicated tasks
When to use this: When you need specialized tools for data import, wrangling, visualization and analysis when using R.
Why it’s helpful: Links with explanations of package/ category/ description/ sample use/ author for a variety of tools.
Suggested application: Before doing your own search, check this cheat sheet first for a likely shortcut.
Business impact or insights to be gained: Likely there’s a tool for what you need to do and it may be listed here, saving time and exposing you to additional resources.

Title: Hacking Cross-Database Unions in Tableau: Use Case Summary and Tutorial

Author: Jay Farias, Data Visualization Manager
Source: https://evolytics.com/blog/hacking-cross-database-unions-in-tableau-use-case-summary-and-tutorial/
How: Before bringing into Tableau, use a Cross-Database Join which you can leverage into a cross-database union.
When to use this: When you need to bring multiple databases into Tableau.
Why it’s helpful: Tableau doesn’t support cross-database unions. However, it does support cross-database joins for almost all data sources. It’s an efficient way of locating, shaping, and aggregating data.
Suggested application: When you need a company-wide dashboard to analyze metrics for all business sectors and in aggregate from various data sources.
Business impact or insights to be gained: When you need to unite data from disparate data sources for relevant business intelligence.

Title: Best Database Performance Management Software in 2020

Author: DNSstuff writer
Source: https://www.dnsstuff.com/database-performance-management-software
When to use this: Reviewing and making recommendations for new or first investment into database monitoring tools.
Why it’s helpful: Lays out in detail the top-tier, second-tier, and free data monitoring tools.
Suggested application: Use to discuss with purchasing and essential stakeholders to get buy-in and budget support for IT departments to keep watch on memory and CPU throughout your database and rank queries to ensure vital tasks get completed without decreasing the speed of the entire system.
Business impact or insights to be gained: Database monitoring tools ensure your database interfaces with the appropriate applications to make it easier to get information and organize it without delays or mistakes. They help you control who has access to specific data. Also, database monitoring tools help you to leverage your ability to monitor data, analyze trends, and to assure optimization of your infrastructure.

Subscribe to get more tips and references. (See “subscribe here” on this page.)

Have an article you’d like featured? Send us a note at Contact Us.