Final Exam: Business Analyst to Data Analyst
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 Exceladd user forms to an Access database and configure various user controlsapply a brute-force approach to find the optimal model for your datasetapply basic data manipulation operations on DataFramesapply the loc and iloc functions to access specific rows and columnscast data types within Series objectscompare the performance of a small ensemble with a larger onecompute aggregations on datacreate a dataset out of a data source and analyze the different fields in the datacreate a pandas Series objectcreate macroscreate models from your cluster instances to identify the factors which affect cluster membershipcreate pandas Series objectscustomize Excel menus to display developer featuresdemonstrate the use of MS-Access, a lightweight relational database, and create a sample database (.acc) file and a tabledescribe the features and use cases of linear regressiondescribe the features of clustering models which can be configureddescribe the process in which a machine learning model is constructed using training datadescribe the process of preparing a dataset for logistic regressionedit the contents of a range of cells using direct cell referencesfilter data using the iloc functionfilter data using the loc, iloc, at, and iat functionsgenerate clusters in your input data and analyze the properties of each clusteridentify and deal with duplicate recordsidentify the features of clustering models which can be configuredillustrate the use of MS-Access, a lightweight relational database, and create a sample database (.acc) file and a tableimport and export data in CSV filesimport and export data using HTML and JSON filesimport data from a CSV fileintroduce 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 trainload data from a variety of sources into BigML to train and evaluate machine learning modelslookup data using different techniquesnavigate Visual Basic editororganize your BigML resources such as data sources, datasets and models into projectsperform a brute-force approach to find the optimal model for your datasetperform basic data manipulation operations on DataFramesperform basic operations on Series objectsperform common grouping and aggregation operationsperform inner join operations using the merge() methodrecall the various metrics used to evaluate the quality of a machine learning modelrecognize the features available in BigML to load data and to train a machine learning modelrecognize the properties of ensemble models which can be configured in BigMLrecognize the purpose of clustering algorithms and list some of its use casesrecognize the types of machine learning algorithms and their applicationsrun SQL queries, such as SELECT-FROM-WHERE queries, to analyze data in MS Accessserialize data to Excel and Pickle filesspecify 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 Accesssummarize records into bins or categoriestrain a logistic regression model to predict an output based on the probability of occurrenceuse BigML to build an ensemble of decision trees to solve a classification problemuse inner join operations using the merge() methoduse 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 VBAuse shortcut keys to navigate Visual Basic Editoruse SQL INSERT statements to add rows to the Access database based on user input to a formuse the loc and iloc functions to access specific rows and columnsuse VBA macros to autofit rows and columnsuse VBA's support for sending emails from within macroswire 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 inputwire up a complex user form to store data in an Excel workbook
IN THIS COURSE
1.Data Analyst33sUP 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 platformDigital badges are yours to keep, forever.