Accounting Data Analytics

  1. Tools and Technologies
    1. Spreadsheet Software Applications
      1. Advanced Excel Functions
        1. Lookup Functions
          1. VLOOKUP
            1. HLOOKUP
              1. INDEX-MATCH
                1. XLOOKUP
                2. Pivot Table Mastery
                  1. Data Summarization
                    1. Calculated Fields
                      1. Pivot Charts
                      2. Array Formulas
                        1. Conditional Formatting
                        2. Power Query Applications
                          1. Data Connection
                            1. Data Transformation
                              1. Query Optimization
                              2. Power Pivot Capabilities
                                1. Data Modeling
                                  1. DAX Formulas
                                    1. Relationship Management
                                  2. Business Intelligence Platforms
                                    1. Tableau Applications
                                      1. Data Visualization
                                        1. Dashboard Creation
                                          1. Story Development
                                          2. Microsoft Power BI
                                            1. Report Development
                                              1. Data Modeling
                                                1. Power BI Service
                                                2. QlikView and QlikSense
                                                  1. Associative Model
                                                    1. Self-Service Analytics
                                                    2. Dashboard Design Principles
                                                      1. User Experience Design
                                                        1. Visual Hierarchy
                                                          1. Interactive Elements
                                                        2. Audit-Specific Software
                                                          1. ACL Analytics
                                                            1. Data Import and Export
                                                              1. Data Analysis Commands
                                                                1. Scripting Capabilities
                                                                2. IDEA Software
                                                                  1. Data Extraction
                                                                    1. Statistical Analysis
                                                                      1. Reporting Features
                                                                      2. Key Features and Use Cases
                                                                      3. Programming Languages for Data Science
                                                                        1. Python for Data Analytics
                                                                          1. Pandas Library
                                                                            1. Data Manipulation
                                                                              1. Data Cleaning
                                                                                1. Data Aggregation
                                                                                2. NumPy for Numerical Operations
                                                                                  1. Matplotlib for Visualization
                                                                                    1. Seaborn for Statistical Visualization
                                                                                      1. Jupyter Notebooks
                                                                                        1. Interactive Development
                                                                                          1. Documentation
                                                                                            1. Sharing Results
                                                                                          2. R for Statistical Analysis
                                                                                            1. Tidyverse Package
                                                                                              1. Data Wrangling
                                                                                                1. Data Visualization
                                                                                                2. Statistical Modeling Packages
                                                                                                  1. R Markdown for Reporting

                                                                                              Previous

                                                                                              12. Tax Accounting Applications

                                                                                              Go to top

                                                                                              Next

                                                                                              14. Data Visualization and Communication