Single + Multiple Series Box Plot Charts Oracle APEX - Part 31
Summary
TLDRTech mining's tutorial introduces viewers to the creation of box plot charts for summarizing large datasets, particularly useful for comparing annual sales figures over a decade. The script guides through the process of setting up a table with relevant data, utilizing a provided source code. It demonstrates creating a single-series box plot chart for School A and then extends the tutorial to include a multi-series chart for comparing marks across three schools, enhancing data visualization with interactive features and legends.
Takeaways
- 📊 The video introduces how to create a box plot chart to compare annual sales figures of products over the past 10 years.
- 📈 A box plot is an efficient chart type for summarizing large amounts of data, showing the range and distribution along a number line.
- 🛠️ The process involves creating a table and populating it with relevant data, with the source code provided in the video description.
- 🔗 To create the table, one must click the 'load data' button and ensure the table is created with 15 rows as a success message.
- 📝 View the table by clicking the 'view table' button to browse the columns and existing data.
- 📊 For creating a single-series box plot, open the sales web application and select the box plot option from the chart menu.
- 🔍 Choose 'SQL query' as the source type and enter the provided query to fetch data for the chart.
- 📊 Set the label column to 'course' and the value column to 'school a' to correctly categorize the data for the chart.
- 🏗️ After creating the page, customize the box plot chart region by setting its title and modifying the series name.
- 👀 Test the chart by running the application and hovering the mouse pointer over each box to see the values.
- 📈 To compare marks of multiple schools, create a multi-series box plot using a SQL query that fetches data for all schools.
- 📊 The multi-series box plot enables comparison across different schools, with the legend property turned on for interactive data exploration.
Q & A
What is the purpose of a box plot chart in the context of the Tech mining video?
-A box plot chart is used to efficiently summarize large amounts of data, displaying the range and distribution of data along a number line, which is particularly useful for comparing annual sales figures over a period of time.
How can one create a table for the box plot setup in the video?
-To create a table for the box plot setup, one needs to execute the steps provided in the video, which includes populating the table with relevant data. The source code for this process is linked in the description of the video.
What is the outcome after clicking the 'load data' button in the video?
-If the data loading process is successful, a message indicating that the 'table box plot' has been created with 15 rows will be displayed.
How can viewers browse the created table in the video?
-Viewers can browse the created table by clicking the 'view table' button, which allows them to see all the columns and the existing data in the table.
What is the first step to create a page for a single series box plot chart?
-The first step is to open the sales web application and then click on the 'chart' option followed by selecting the 'box plot' option.
Why is the SQL query important in creating a box plot chart?
-The SQL query is crucial as it fetches and displays the necessary data for the box plot chart. It specifies the data source and ensures that the correct information is visualized.
What is the default orientation of the box plot chart in the video?
-The default orientation of the box plot chart in the video is vertical.
How is the label column set in the box plot chart creation process?
-In the box plot chart creation process, the label column is set to 'course', which categorizes the data on the chart.
What is the significance of changing the series name from 'series 1' to 'school a'?
-Changing the series name from 'series 1' to 'school a' personalizes the chart, making it clear that the data displayed is specifically for school a.
How can one test the created box plot chart in the video?
-To test the created box plot chart, one should run the application, navigate to the reports page, and click on the box plot card. Hovering the mouse pointer over each box will reveal the values.
What changes are made to create a multi-series box plot chart in the video?
-To create a multi-series box plot chart, the SQL query is adjusted to fetch and show all data in the table, and the data of schools B and C are included. The legend property is also turned on to enable the hide and show behavior for each series.
Outlines
📈 Creating a Single-Series Box Plot for Annual Sales Data
This paragraph introduces the process of creating a box plot to compare annual sales figures over a decade. The script explains the utility of a box plot in summarizing large datasets and visualizing data distribution. It guides the viewer through the steps of setting up a table with relevant data, using a provided source code link. The tutorial continues with instructions on loading data into a table, viewing the table, and creating a page for a single-series box plot chart. It includes the selection of chart options, setting properties for the chart, and testing the chart by hovering over it to reveal values. The focus is on creating a single-series chart using a wizard to display data for 'School A'.
📊 Expanding to a Multi-Series Box Plot for Comprehensive Comparison
The second paragraph extends the discussion to creating a multi-series box plot for a more comprehensive comparison of data across multiple entities. It details the steps to modify the SQL query to include data for 'School B' and 'School C', alongside 'School A'. The script instructs the viewer on how to save and run the page to view the multi-series box plot, which now includes data for all three schools. The paragraph also mentions the activation of the legend property to enable interactive features for hiding and showing data series on the chart. The aim is to provide a visual comparison of the marks or data across the three schools using a multi-series box plot chart.
Mindmap
Keywords
💡Tech mining
💡Annual sales figures
💡Box plot
💡Data summary
💡Table
💡Source code
💡Load data
💡SQL query
💡Chart option
💡Single-series box plot
💡Multi-series box plot
💡Legend
Highlights
Introduction to Tech mining and the importance of summarizing annual sales figures over a decade.
Explanation of box plot as an efficient chart type for summarizing large data sets.
Description of how a box plot displays data range and distribution along a number line.
Steps to create a table for box plot setup and populating it with relevant data.
Provision of source code link in the video description for accessing materials.
Guidance on loading data using the 'load data' button and expected outcome.
Instructions on viewing the created table and its columns.
Process of creating a page for a single series box plot chart in a sales web application.
Selection of box plot option and choosing the source type as SQL query.
Entering the SQL query to fetch data for the box plot.
Acceptance of default vertical orientation and setting label and value columns.
Creation of the box plot chart and renaming the default series.
Saving changes and testing the single-series box plot chart functionality.
Demonstration of viewing values by hovering the mouse pointer over each box in the chart.
Introduction to creating a multi-series box plot chart for comparing marks of multiple schools.
Use of a SQL query to fetch and display data for all schools involved.
Enabling the legend property to allow for data series toggling in the chart.
Final note on the practical application of the multi-series box plot for data comparison.
Transcripts
a very warm welcome to Tech mining
if you want to compare the annual sales
figures of your products for the past 10
years you would need a way to summarize
all the data
this box plot is an efficient chart type
to summarize large amounts of data a box
plot displays the range and distribution
of data along a number line
let's create this box plot chart
[Music]
execute these following steps to create
a table for this setup and populate it
with relevant data
link of source code is provided in
description of this video by opening
part 8 folder you'll get the material
used
foreign
[Music]
click this load data button
if everything goes well you will see a
message table box plot created with 15
rows
[Music]
click this view table button to browse
the table
this is the table we have created these
are all the columns in this table
click this data tab to view the existing
data in this table
[Music]
now let's create a page for this single
series box plot chart
open sales web application
[Music]
click the chart option
then select box plot option
[Music]
thank you
choose SQL query for Source type
[Music]
then enter this query in the SQL query
box
[Music]
remaining properties will be the same as
usual
click next
on this screen accept the default
vertical orientation
[Music]
set label column to course
[Music]
value column to school a
[Music]
then click create button
[Music]
after creating the page click this box
plot chart region
set its title to single-series box plot
chart
[Music]
then change the default series name from
series 1 to school a
[Music]
click this save page button to save your
changes
that's it let's test this segment run
this application
foreign
open this reports page click this box
plot card
your mouse pointer over each box to see
the values
note that this first chart which is only
a single series chart is created using
the wizard to show marks of school a
only
[Music]
now let's create same chart for multiple
series
this box plot chart will compare the
marks of all three schools using
multiple series
[Music]
this SQL query will fetch and show all
data in this table
[Music]
foreign
[Music]
s to display the data of school B and
school C
[Music]
thank you
[Music]
click this save and run page button to
see the multi-series box plot chart
foreign
note that this chart is displaying the
data of all three schools
we turned on the legend property to
enable this hide and show Behavior
is for watching
関連動画をさらに表示
Pyramid Chart | Oracle APEX - Part 32
Donut & Range Charts | Minimum & Maximum Quantities | with Legends Oracle APEX - Part 26
Line With Area & Bar Charts with Region Display Selector Oracle APEX - Part 27
Oracle APEX Chart | Stack Unstack | Horizontal Vertical Orientation - Part 25
Faceted Search In Oracle APEX - Part 37
Create Gantt Chart | Oracle APEX - Part 30
5.0 / 5 (0 votes)