Final Exam: Business Analyst to Data Analyst
- 1 Video | 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
recognize the properties of ensemble models which can be configured in BigMLimport data from a CSV filewire up a complex user form to store data in an Excel workbookcreate macrosidentify and deal with duplicate recordsfilter data using the iloc functionload data from a variety of sources into BigML to trainuse BigML to build an ensemble of decision trees to solve a classification problemperform basic operations on Series objectscreate models from your cluster instances to identify the factors which affect cluster membershipperform common grouping and aggregation operationsrecall the various metrics used to evaluate the quality of a machine learning modelsummarize records into bins or categoriestrain a logistic regression model to predict an output based on the probability of occurrencedescribe the features and use cases of linear regressioncreate pandas Series objectsdescribe the process in which a machine learning model is constructed using training datacast data types within Series objectslookup data using different techniquesimport and export data in CSV filesapply basic data manipulation operations on DataFramesimport and export data using HTML and JSON filesperform basic data manipulation operations on DataFramesuse the loc and iloc functions to access specific rows and columnsapply the loc and iloc functions to access specific rows and columnsserialize data to Excel and Pickle filesintroduce 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 formnavigate Visual Basic editorapply a brute-force approach to find the optimal model for your datasetrecognize the purpose of clustering algorithms and list some of its use cases
edit the contents of a range of cells using direct cell referencesrecognize the features available in BigML to load data and to train a machine learning modelgenerate clusters in your input data and analyze the properties of each clusteruse 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 VBAwire 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 inputuse shortcut keys to navigate Visual Basic Editoradd a button to a workbook to display a complex user form and demonstrate the resulting fully-fledged user application from Excelperform inner join operations using the merge() methoduse VBA's support for sending emails from within macrosorganize your BigML resources such as data sources, datasets and models into projectsidentify the features of clustering models which can be configureddescribe the features of clustering models which can be configuredcustomize Excel menus to display developer featurescompute aggregations on datause VBA macros to autofit rows and columnsfilter data using the loc, iloc, at, and iat functionsuse inner join operations using the merge() methodcreate a pandas Series objectspecify 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 Accessrun SQL queries, such as SELECT-FROM-WHERE queries, to analyze data in MS Accessuse SQL INSERT statements to add rows to the Access database based on user input to a formcompare the performance of a small ensemble with a larger oneload data from a variety of sources into BigML to train and evaluate machine learning modelsdescribe the process of preparing a dataset for logistic regressioncreate a dataset out of a data source and analyze the different fields in the dataperform a brute-force approach to find the optimal model for your datasetrecognize the types of machine learning algorithms and their applicationsdemonstrate the use of MS-Access, a lightweight relational database, and create a sample database (.acc) file and a tableillustrate the use of MS-Access, a lightweight relational database, and create a sample database (.acc) file and a tableadd user forms to an Access database and configure various user controls
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.