Business Analytics

  1. Analytics Tools and Technologies
    1. Spreadsheet Analytics
      1. Advanced Excel Functions
        1. Lookup Functions
          1. VLOOKUP and HLOOKUP
            1. INDEX and MATCH
              1. XLOOKUP
              2. Logical Functions
                1. IF Statements
                  1. Nested IF
                    1. AND, OR, NOT Functions
                    2. Statistical Functions
                      1. Descriptive Statistics
                        1. Probability Functions
                          1. Regression Functions
                          2. Array Formulas
                            1. Dynamic Arrays
                              1. SUMPRODUCT
                                1. Array Constants
                              2. Data Analysis Tools
                                1. Pivot Tables
                                  1. Data Summarization
                                    1. Calculated Fields
                                      1. Pivot Charts
                                      2. Data Tables
                                        1. One-variable Data Tables
                                          1. Two-variable Data Tables
                                          2. Scenario Manager
                                            1. What-if Analysis
                                              1. Scenario Comparison
                                            2. Optimization Tools
                                              1. Solver Add-in
                                                1. Linear Programming
                                                  1. Nonlinear Programming
                                                    1. Integer Programming
                                                    2. Goal Seek
                                                      1. Single Variable Optimization
                                                        1. Target Value Achievement
                                                    3. Database Management and SQL
                                                      1. Database Fundamentals
                                                        1. Relational Database Concepts
                                                          1. Tables, Rows, and Columns
                                                            1. Primary and Foreign Keys
                                                              1. Normalization
                                                              2. Basic SQL Operations
                                                                1. SELECT Statements
                                                                  1. WHERE Clauses
                                                                    1. ORDER BY and LIMIT
                                                                      1. DISTINCT Values
                                                                      2. Advanced SQL Queries
                                                                        1. Joins
                                                                          1. INNER JOIN
                                                                            1. LEFT JOIN
                                                                              1. RIGHT JOIN
                                                                                1. FULL OUTER JOIN
                                                                                  1. CROSS JOIN
                                                                                  2. Subqueries
                                                                                    1. Correlated Subqueries
                                                                                      1. EXISTS and IN Operators
                                                                                      2. Common Table Expressions
                                                                                      3. Aggregate Functions
                                                                                        1. COUNT, SUM, AVG
                                                                                          1. MIN and MAX
                                                                                            1. GROUP BY Clauses
                                                                                              1. HAVING Clauses
                                                                                              2. Window Functions
                                                                                                1. ROW_NUMBER
                                                                                                  1. RANK and DENSE_RANK
                                                                                                    1. LAG and LEAD
                                                                                                      1. Running Totals
                                                                                                    2. Programming Languages
                                                                                                      1. Python for Analytics
                                                                                                        1. Data Manipulation
                                                                                                          1. Pandas DataFrames
                                                                                                            1. Data Cleaning Operations
                                                                                                              1. Merging and Joining
                                                                                                                1. Grouping and Aggregation
                                                                                                                2. Numerical Computing
                                                                                                                  1. NumPy Arrays
                                                                                                                    1. Mathematical Operations
                                                                                                                      1. Linear Algebra
                                                                                                                      2. Machine Learning
                                                                                                                        1. Scikit-learn
                                                                                                                          1. Model Training and Evaluation
                                                                                                                            1. Pipeline Creation
                                                                                                                            2. Data Visualization
                                                                                                                              1. Matplotlib
                                                                                                                                1. Seaborn
                                                                                                                                  1. Plotly
                                                                                                                                  2. Statistical Analysis
                                                                                                                                    1. SciPy
                                                                                                                                      1. Statsmodels
                                                                                                                                    2. R for Analytics
                                                                                                                                      1. Data Manipulation
                                                                                                                                        1. dplyr Package
                                                                                                                                          1. Data Transformation
                                                                                                                                            1. Pipe Operator
                                                                                                                                            2. Data Visualization
                                                                                                                                              1. ggplot2
                                                                                                                                                1. Grammar of Graphics
                                                                                                                                                  1. Customization Options
                                                                                                                                                  2. Statistical Modeling
                                                                                                                                                    1. Built-in Statistical Functions
                                                                                                                                                      1. Linear Models
                                                                                                                                                        1. Generalized Linear Models
                                                                                                                                                        2. Machine Learning
                                                                                                                                                          1. caret Package
                                                                                                                                                            1. randomForest Package
                                                                                                                                                              1. e1071 Package
                                                                                                                                                          2. Business Intelligence Platforms
                                                                                                                                                            1. Tableau
                                                                                                                                                              1. Data Connection
                                                                                                                                                                1. Multiple Data Sources
                                                                                                                                                                  1. Data Blending
                                                                                                                                                                  2. Visualization Creation
                                                                                                                                                                    1. Drag-and-drop Interface
                                                                                                                                                                      1. Chart Types
                                                                                                                                                                        1. Calculated Fields
                                                                                                                                                                        2. Dashboard Development
                                                                                                                                                                          1. Interactive Elements
                                                                                                                                                                            1. Filters and Parameters
                                                                                                                                                                              1. Actions and Navigation
                                                                                                                                                                            2. Microsoft Power BI
                                                                                                                                                                              1. Power Query
                                                                                                                                                                                1. Data Transformation
                                                                                                                                                                                  1. M Language
                                                                                                                                                                                  2. Data Modeling
                                                                                                                                                                                    1. Relationships
                                                                                                                                                                                      1. DAX Formulas
                                                                                                                                                                                      2. Report Creation
                                                                                                                                                                                        1. Visualizations
                                                                                                                                                                                          1. Slicers and Filters
                                                                                                                                                                                        2. QlikView and Qlik Sense
                                                                                                                                                                                          1. Associative Data Model
                                                                                                                                                                                            1. In-memory Processing
                                                                                                                                                                                              1. Dynamic Associations
                                                                                                                                                                                              2. Self-Service Analytics
                                                                                                                                                                                                1. Drag-and-drop Analysis
                                                                                                                                                                                                  1. Natural Language Queries
                                                                                                                                                                                              3. Cloud Analytics Platforms
                                                                                                                                                                                                1. Amazon Web Services
                                                                                                                                                                                                  1. Data Storage
                                                                                                                                                                                                    1. Amazon S3
                                                                                                                                                                                                      1. Amazon Redshift
                                                                                                                                                                                                      2. Analytics Services
                                                                                                                                                                                                        1. Amazon EMR
                                                                                                                                                                                                          1. Amazon SageMaker
                                                                                                                                                                                                            1. Amazon QuickSight
                                                                                                                                                                                                          2. Microsoft Azure
                                                                                                                                                                                                            1. Data Services
                                                                                                                                                                                                              1. Azure Data Lake
                                                                                                                                                                                                                1. Azure SQL Database
                                                                                                                                                                                                                  1. Azure Synapse Analytics
                                                                                                                                                                                                                  2. Machine Learning
                                                                                                                                                                                                                    1. Azure Machine Learning
                                                                                                                                                                                                                      1. Cognitive Services
                                                                                                                                                                                                                    2. Google Cloud Platform
                                                                                                                                                                                                                      1. Data Storage and Processing
                                                                                                                                                                                                                        1. BigQuery
                                                                                                                                                                                                                          1. Cloud Storage
                                                                                                                                                                                                                            1. Dataflow
                                                                                                                                                                                                                            2. Machine Learning
                                                                                                                                                                                                                              1. AI Platform
                                                                                                                                                                                                                                1. AutoML
                                                                                                                                                                                                                                  1. TensorFlow

                                                                                                                                                                                                                            Previous

                                                                                                                                                                                                                            7. Prescriptive Analytics

                                                                                                                                                                                                                            Go to top

                                                                                                                                                                                                                            Next

                                                                                                                                                                                                                            9. Business Analytics Applications