Course Outline
Introduction
- How Dremio solves the problem of data staging, data warehousing, aggregation, extracts, etc.
Installing and Configuring Dremio
Overview of Dremio Features and Architectures
- Data Acceleration
- Data Reflections (on HDFS, MapR-FS, cloud storage such as S3, local storage, etc.)
Query Execution Life Cycle
- Planning, coordination, execution,
Navigating the Dremio Web UI
Discovering Data
- The unified data catalog
Curating Data
- Creating virtual datasets
Using SQL to Define Transformations
- Joins and data type conversions
- Connecting through ODBC, JDBC and REST
Sharing Data with Team
- Uploading, collaboration, and access rights
Integrating Dremio with BI (Business Intelligence) Tools
- Serving up data for Tableau
Integrating Dremio with an Elasticsearch Cluster
Summary and Conclusion
Requirements
- An understanding of Hadoop, NoSQL, and other data storage concepts
- Experience with writing SQL queries
- Experience with Linux command line
Testimonials (5)
Hands-on examples allowed us to get an actual feel for how the program works. Good explanations and integration of theoretical concepts and how they relate to practical applications.
Ian - Archeoworks Inc.
Course - ArcGIS Fundamentals
All the topics which he covered including examples. And also explained how they are helpful in our daily job.
madduri madduri - Boskalis Singapore Pte Ltd
Course - QGIS for Geographic Information System
I liked Pablo's style, the fact that he covered a lot of subjects from report design , customization with html to implementing simple ML algortithms. Good balance theoretical information / exercices. Pablo really covered all topics i was interested in and gave comprehensive answers to my questions.
Cristian Tudose - SC Automobile Dacia SA
Course - Advanced Data Analysis with TIBCO Spotfire
Actual application of spotfire and all basic functions.
Michael Capili - STMicroelectronics, Inc.
Course - Introduction to Spotfire
The thing I liked the most about the training was the organization and the location