New Training: Describe Data Analytics Core Concepts
| new skills - Team Nuggets

New Training: Describe Data Analytics Core Concepts

In this 8-video skill, CBT Nuggets trainer Ben Finkel discusses the core concepts of data analytics including reporting, charting, and visualization. We’ll understand how businesses use procedures such as ETL and ELT to support analytics. Watch this new Azure training.

Learn Azure with one of these courses:

This training includes:

  • 8 videos
  • 47 minutes of training

You’ll learn these topics in this skill:

  • Describe Data Analytics Core Concepts
  • Describing Data Visualization
  • Charting and Graphing
  • Advanced Charting
  • Analytics Techniques
  • OLTP vs OLAP Databases
  • Moving Data with ETL and ELT
  • Describe Data Analytics Core Concepts Summary

OLTP vs OLAP Databases: What's the Difference?

In the enterprise environment data is key. The way organizations store data is through databases. That data is then used in a variety of ways such as performing analytics or storing customer records. Because of how important that data is, businesses need to take great care in planning how it is organized and processed. So, database administrators need to understand the differences between OLTP and OLAP.

OLTP stands for online transaction process. This is a high-level concept for the mechanisms in which data is retrieved from various sources, organized, and stored in a database. Those sources can be something like pulling data from an API or data entered by a user such as banking information.

OLAP stands for online analytical processing. OLAP is a high-level concept for performing complex queries against stored data. This is how database administrators and data miners pull data from a database to analyze it and create things like information dashboards.

Understanding how the principles of OLTP and OLAP work are fundamentals of database design and information storage. Both concepts create a roadmap that system administrators use to design how complex data storage systems work and communicate with each other.

Download

Download

Ultimate Systems Administration Cert Guide

A 158-page guide to every Microsoft, VMware, Citrix, AWS, Google, and Linux certification, and how they fit into your career.

By submitting this form you agree that you have read, understood, and are able to consent to our privacy policy.

LEARNING ON MOBILE

Learn anytime anywhere with our mobile apps.

I have read and understood the privacy policy and am able to consent to it.

© 2021 CBT Nuggets. All rights reserved. Terms | Privacy Policy | Accessibility | Sitemap | 1550 Valley River Drive, Eugene, OR 97401 | 541-284-5522
CBT Nuggets