Final Exam: Business Analyst to Data Analyst

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

WHAT YOU WILL LEARN

  • add a button to a workbook to display a complex user form and demonstrate the resulting fully-fledged user application from Excel
    add user forms to an Access database and configure various user controls
    apply a brute-force approach to find the optimal model for your dataset
    apply basic data manipulation operations on DataFrames
    apply the loc and iloc functions to access specific rows and columns
    cast data types within Series objects
    compare the performance of a small ensemble with a larger one
    compute aggregations on data
    create a dataset out of a data source and analyze the different fields in the data
    create a pandas Series object
    create macros
    create models from your cluster instances to identify the factors which affect cluster membership
    create pandas Series objects
    customize Excel menus to display developer features
    demonstrate the use of MS-Access, a lightweight relational database, and create a sample database (.acc) file and a table
    describe the features and use cases of linear regression
    describe the features of clustering models which can be configured
    describe the process in which a machine learning model is constructed using training data
    describe the process of preparing a dataset for logistic regression
    edit the contents of a range of cells using direct cell references
    filter data using the iloc function
    filter data using the loc, iloc, at, and iat functions
    generate clusters in your input data and analyze the properties of each cluster
    identify and deal with duplicate records
    identify the features of clustering models which can be configured
    illustrate the use of MS-Access, a lightweight relational database, and create a sample database (.acc) file and a table
    import and export data in CSV files
    import and export data using HTML and JSON files
    import data from a CSV file
    introduce user forms as a way to add complex UIs to an Excel workbook and use the VBA forms control toolbox to add elements, such as buttons, to a user form
  • load data from a variety of sources into BigML to train
    load data from a variety of sources into BigML to train and evaluate machine learning models
    lookup data using different techniques
    navigate Visual Basic editor
    organize your BigML resources such as data sources, datasets and models into projects
    perform a brute-force approach to find the optimal model for your dataset
    perform basic data manipulation operations on DataFrames
    perform basic operations on Series objects
    perform common grouping and aggregation operations
    perform inner join operations using the merge() method
    recall the various metrics used to evaluate the quality of a machine learning model
    recognize the features available in BigML to load data and to train a machine learning model
    recognize the properties of ensemble models which can be configured in BigML
    recognize the purpose of clustering algorithms and list some of its use cases
    recognize the types of machine learning algorithms and their applications
    run SQL queries, such as SELECT-FROM-WHERE queries, to analyze data in MS Access
    serialize data to Excel and Pickle files
    specify the rows in a table as well as a primary key, import data from a CSV file into this table, and recognize how SQL queries work in MS Access
    summarize records into bins or categories
    train a logistic regression model to predict an output based on the probability of occurrence
    use BigML to build an ensemble of decision trees to solve a classification problem
    use inner join operations using the merge() method
    use relative references while recording a macro and recognize how it affects the output, accept user input using the InputBox function, and insert sheets into a Workbook from VBA
    use shortcut keys to navigate Visual Basic Editor
    use SQL INSERT statements to add rows to the Access database based on user input to a form
    use the loc and iloc functions to access specific rows and columns
    use VBA macros to autofit rows and columns
    use VBA's support for sending emails from within macros
    wire up a button to VBA code so that whenever that button is clicked, a message is displayed, design a fully-fledged user form to accept complex user input using input boxes, and configure buttons to submit or reset that user input
    wire up a complex user form to store data in an Excel workbook

IN THIS COURSE

  • Playable
    1. 
    Data 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 0 Likes 0  
Likes 3 Likes 3  
Likes 0 Likes 0