Final Exam: Systems Analyst

  • 1 Video | 30m 32s
  • Includes Assessment
  • Earns a Badge
Final Exam: Systems Analyst will test your knowledge and application of the topics presented throughout the Systems Analyst track of the Skillsoft Aspire Business Analyst to Data Analyst Journey.

WHAT YOU WILL LEARN

  • analyze the detailed distribution of numeric values in a field by creating a violin plot in Plotly
    assemble the pieces required to construct a simple chart using Google Charts
    combine related plots into a single page using a dashboard in Plotly
    configure the axes of a plot to make them more prominent and make your charts easier to read
    constrain a child table from having any values in a column that are not in a specified column of the parent table using foreign key constraints
    convey details about geographical regions using an atlas map in Plotly
    convey hierarchical information in your data using a treemap visualization
    convey information related to countries by using a geo chart
    convey the relationship between two fields in your dataset using a scatter chart
    create and use an update trigger, which is executed after updates to a MariaDB table
    create a plot with two charts by rendering them within subplots
    customize the appearance and the data displayed in a Google chart
    define a Chart Studio table using data and formatting information set in a file
    define a column chart with multiple series stacked on top of one another to recognize their individual and aggregate impact
    demonstrate how Google Charts can be customized using several properties in an options object
    execute commands from the DBeaver environment
    illustrate the basic usage of the DISTINCT and GROUP BY keywords
    illustrate the different ways in which a data table can be created and populated using the DataTable class
    illustrate the various customizations available for a treemap
    install and launch DBeaver as a user interface for MariaDB on macOS
    install and launch DBeaver as a user interface for MariaDB on Microsoft Windows
    install and launch MariaDB on macOS, then connect to it from the terminal
    install and launch MariaDB on Microsoft Windows, then connect to it from the command prompt
    load one of the example charts in Chart Studio to recognize the features available to visualize data
    log in to the Plotly Chart Studio web console and create a new data grid
    merge related plots into a single page using a dashboard in Plotly
    override the default ON DELETE behavior of foreign key constraints in MariaDB tables to implement cascading delete
    perform basic cross and inner joins using SELECT-FROM-WHERE queries
    plot a material chart to visualize the same data viewed with a column chart
    plot locations on a map, which can include satellite, street, or terrain information
  • plot the variations in the price of a tradeable asset using candlestick charts in Plotly
    portray the flow of data from a source to a destination using a Sankey chart
    recognize and use the BETWEEN, LIMIT, and ORDER BY keywords
    recognize different aggregate functions within GROUP BY queries and work with the HAVING clause to filter results of GROUP BY operations
    recognize how default ON DELETE behavior of foreign key constraints in MariaDB works and perform a three-way join
    recognize the different data formats that can be loaded into Chart Studio
    recognize what triggers are, implement an insert trigger, and observe its working mechanism
    render a pie chart to analyze the proportion of contributions from various categories
    render the data present in a file on Google Drive in a Google chart
    represent multiple dimensions of data in your scatter plot by configuring the points that are rendered
    run a few basic SELECT-FROM-WHERE queries
    set up a combo chart with multiple visualizations for the same data
    set up an interactive chart with control within a Google Charts dashboard
    share your Plotly Chart Studio plots
    share your Plotly Chart Studio plots and data with viewers and collaborators
    use a chart editor to enable users to pick the best chart to visualize a dataset
    use Plotly to render information about geographical regions by shading regions based on the value of a variable
    use Plotly to visualize the proportional contribution of various categories that have a hierarchical relationship
    use the Falcon client to integrate Chart Studio with the results of a query against a relational database
    use the following constraints: NOT, NULL, and UNIQUE
    use the JOIN keyword to perform cross joins, inner joins, left outer joins, and right outer joins
    use the LIKE, NOT LIKE, IN, and NOT IN keywords work
    Use the SOME, ALL and ANY keywords to link subqueries to outer queries
    use UNIQUE constraints in an in-depth and applied way
    View the distribution of values in a field by plotting a histogram
    view the relationship between two variables in your dataset by plotting them in a scatter plot
    visualize a series of data using an area chart
    visualize preexisting data in a Chart Studio data grid in the form of a bar chart
    visualize the distribution of numeric values in a field by rendering a box plot using Plotly
    visualize your data in the form of a column chart

IN THIS COURSE

  • Playable
    1. 
    Systems Analyst
    33s
    UP NEXT

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 5 Likes 5  
Likes 3 Likes 3