Catalog Content |
Basic Concepts: Business analytics and intelligence; Data Editing and Controlling with Spreadsheets: Editing and controlling text data, Data searching and addressing; Data Management with Operational Tables: Creating Tables, Slicer, Timeline; Visualization of Data and Information with a Spreadsheet: Charts, Dashboard; Descriptive Analytics with spreadsheets: Central tendency and measures of variability, Probability distributions; Predictive Analytics with spreadsheets: Confidence interval, Hypothesis testing, Correlation and simple linear regression analysis; Data Mining with spreadsheets: SQL server data mining add-in for Excel to get started with data mining. |