Explore and learn data source basics

Try Pentaho Data Integration and Analytics

Version

9.3.x

Audience

anonymous

Part Number

MK-95PDIA000-11

If you have already worked with the Steel Wheels sample data, and want to learn how to create your own data sources and data models with Pentaho, use the Data Source Wizard. The Data Source Wizard helps you define a data source that contains the data you want to use and guides you through the creation of your evaluation data model for use in creating reports.

After you define a data source, you can make it available to other evaluators so they can create reports and analysis by simply picking the data source from the data source list. Any number of reports can be created using a single data source.

Table. Table 2. Explore and Learn Data Sources Basics
Lesson	Do This	Notes
Create Your First Data Source	Create a Data Source Tour the Data Source Wizard See Pentaho Business Analytics for instructions.	Understand how the Pentaho Server and Data Source Wizard work together to create usable data sources and data models. Explore the Data Source Wizard interface. Learn the basics of creating a data source using the Data Source Wizard.
Choose Data Source Types	Choose a data source type See Pentaho Business Analytics for instructions.	Learn about the different data source types supported by the Data Source Wizard. We recommend using a CSV data source for evaluation.
Create Your First CSV Data Source	Create a CSV data source See Pentaho Business Analytics for instructions.	Import a CSV data file using the Data Source Wizard. Create the CSV data source. We recommend creating a report using this new CSV data source, then refining the data model with the . Data Source Model Editor as needed
Refine Your Data Source Model	Edit multidimensional data source models. See Pentaho Business Analytics for instructions.	(Optional) Edit your evaluation data source model using the Data Source Model Editor.
Inline Model Editing	Read Working with Analyzer measures in the Pentaho Business Analytics document.	Learn how to edit your data models while working in Analyzer.
Learn about Streamlined Data Refinery	Learn how to work withStreamlined Data Refinery See Pentaho Data Integration for instructions.	Learn how Streamlined Data Refinery works.