Business Analyst to Data Analyst Proficiency (Advanced Level)

Topics covered

• add complex controls to an app, including spin buttons and checkboxes, create a close button to unload the form's memory and cease displaying it, and add a submit button to store user input in a workbook
• apply past data to make future forecasts using a time series model
• apply regular expressions and other advanced techniques to select and drop columns
• compute statistical summaries on data stored in DataFrames
• create and use an update trigger, which is executed after updates to a MariaDB table
• create a time series model using several years' worth of data
• edit the page view and page theme of a Power BI page and optimize a Power BI report for display on mobile devices using the mobile phone layout feature
• extract discussion topics in a collection of text-based product reviews
• identify the anomalies in a dataset using BigML's anomaly detection model
• link a matrix with a treemap control so that if a matrix row is clicked, the tile corresponding to that row in the treemap is highlighted, and vice versa
• manipulate and analyze time series data
• perform left and right join operations using the merge() method
• plot a value that falls within a range using a gauge chart
• recognize what association rules are and state their applications
• represent multiple dimensions of data in your scatter plot by configuring the points that are rendered
• set the aesthetics of a dashboard and include an option for the user to download the dashboard to a local file
• set up a combo chart with multiple visualizations for the same data
• share a story with the general public by publishing it to Tableau
• split and sample a dataset, which can then be used to train and test a model
• use subqueries in their most fundamental application