Deprecated: Return type of Ai1wm_Recursive_Directory_Iterator::hasChildren($allow_links = true) should either be compatible with RecursiveDirectoryIterator::hasChildren(bool $allowLinks = false): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php on line 57

Deprecated: Return type of Ai1wm_Recursive_Directory_Iterator::rewind() should either be compatible with FilesystemIterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php on line 35

Deprecated: Return type of Ai1wm_Recursive_Directory_Iterator::next() should either be compatible with DirectoryIterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php on line 42

Deprecated: Return type of Ai1wm_Recursive_Directory_Iterator::hasChildren($allow_links = true) should either be compatible with RecursiveDirectoryIterator::hasChildren(bool $allowLinks = false): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php on line 57

Deprecated: Return type of Ai1wm_Recursive_Directory_Iterator::rewind() should either be compatible with FilesystemIterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php on line 35

Deprecated: Return type of Ai1wm_Recursive_Directory_Iterator::next() should either be compatible with DirectoryIterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php on line 42

Deprecated: Return type of Ai1wm_Recursive_Extension_Filter::getChildren() should either be compatible with RecursiveFilterIterator::getChildren(): ?RecursiveFilterIterator, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-extension-filter.php on line 47

Deprecated: Return type of Ai1wm_Recursive_Extension_Filter::accept() should either be compatible with FilterIterator::accept(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-extension-filter.php on line 37

Deprecated: Return type of Ai1wm_Recursive_Extension_Filter::getChildren() should either be compatible with RecursiveFilterIterator::getChildren(): ?RecursiveFilterIterator, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-extension-filter.php on line 47

Deprecated: Return type of Ai1wm_Recursive_Extension_Filter::accept() should either be compatible with FilterIterator::accept(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-extension-filter.php on line 37

Deprecated: Return type of Ai1wm_Recursive_Exclude_Filter::getChildren() should either be compatible with RecursiveFilterIterator::getChildren(): ?RecursiveFilterIterator, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-exclude-filter.php on line 41

Deprecated: Return type of Ai1wm_Recursive_Exclude_Filter::accept() should either be compatible with FilterIterator::accept(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-exclude-filter.php on line 37

Deprecated: Return type of Ai1wm_Recursive_Exclude_Filter::getChildren() should either be compatible with RecursiveFilterIterator::getChildren(): ?RecursiveFilterIterator, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-exclude-filter.php on line 41

Deprecated: Return type of Ai1wm_Recursive_Exclude_Filter::accept() should either be compatible with FilterIterator::accept(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-exclude-filter.php on line 37

Deprecated: Return type of Ai1wm_Recursive_Newline_Filter::accept() should either be compatible with FilterIterator::accept(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/filter/class-ai1wm-recursive-newline-filter.php on line 28

Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896

Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896

Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896

Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896

Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896

Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896

Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896

Warning: Cannot modify header information - headers already sent by (output started at /home1/greatsyd/public_html/staging1/wp-content/plugins/all-in-one-wp-migration-unlimited-main--old/lib/vendor/servmask/iterator/class-ai1wm-recursive-directory-iterator.php:0) in /home1/greatsyd/public_html/staging1/wp-includes/rest-api/class-wp-rest-server.php on line 1896
{"id":28247,"date":"2023-01-04T08:47:11","date_gmt":"2023-01-04T08:47:11","guid":{"rendered":"https:\/\/greaterinsights.in\/staging1\/?page_id=28247"},"modified":"2023-11-08T05:40:27","modified_gmt":"2023-11-08T05:40:27","slug":"business-analytics-with-microsoft-excel","status":"publish","type":"page","link":"https:\/\/greaterinsights.in\/staging1\/business-analytics-with-microsoft-excel\/","title":{"rendered":"Business Analytics with Microsoft Excel"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Business Analytics with Microsoft Excel<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Course Overview<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Master the quantitative methods to analyze data using readily available advanced excel tools. Learn to produce actionable insights from data through statistical techniques, data visualization, exploratory and predictive modeling in our business analytics training. Develop skills to define, monitor and optimize metrics to improve your team’s performance.<\/p>

In our Cloudlabs, implement the statistical tools for data analysis through readily available MS Excel functions and add-ins. Be able to implement the most effective excel solution for analytics problems in your organization.<\/span><\/p>

\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t

At the end of the training, participants will be able to:<\/h3><\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
  1. Develop analytical approach to management to utilize data, understand statistical and quantitative models<\/li>
  2. Recognize trends, detect outliers, and summarize data sets concisely<\/li>
  3. Gain hands-on knowledge of mathematical, statistical functions and<\/li>
  4. Use Excel add-ins to develop data analytics & visualization solutions for your organization’s needs.<\/li>
  5. Derive relationship between two or more variables through regression<\/li>
  6. Leverage Analysis ToolPak to conduct a variety of statistical analyses with ease<\/li>
  7. Create excel dashboards to track organization\/project’s performance in one place<\/li>
  8. Provide comprehensive solution to any business challenge through better data-driven decision<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t

    Pre-requisite<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t
    1. Basic knowledge of any spreadsheet software<\/li>
    2. Familiarity with data and statistical terms<\/li>
    3. Suggested:<\/li>
    4. Basic statistics and business analytics concepts<\/span><\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t

      Duration<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t

      2 days<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

      \n\t\t\t\t
      \n\t\t\t\t\t

      Course Outline<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
      \n\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t\t\t
      \n\t\t\t\t\t
      \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t Introduction to Business Analytics<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t
      1. Understanding Data<\/li>
      2. Introduction to Data Analytics<\/li>
      3. Introduction to Business Analytics, Business Intelligence, and Data Mining<\/li>
      4. Analytical Decision Making<\/li>
      5. Future of Business Analytics<\/li>
      6. Big Data Analytics<\/li>
      7. Social Media Analytics<\/li>
      8. Applications in industry domains<\/li>
      9. Methodologies<\/li>
      10. Decision making using data<\/li><\/ol><\/div><\/div><\/div>
        \u00a0<\/div><\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
        \n\t\t\t\t\t
        \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t Introduction to Excel Operations<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t
        1. Importing Data – Comma delimited, Fixed width, Tab delimited<\/li>
        2. Basic Data Manipulation in Excel<\/li>
        3. Arithmetic Formulae<\/li>
        4. Basic Functions in Excel<\/li>
        5. Absolute and Relative Reference<\/li><\/ol><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
          \n\t\t\t\t\t
          \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t Data Organization in Excel<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t
          1. IF and Nested IF<\/li>
          2. VLOOKUP<\/li>
          3. HLOOKUP<\/li>
          4. Index-Match-Offset<\/li>
          5. Rank, Quartile, Percentile<\/li>
          6. Data Filters<\/li>
          7. Pivots<\/li>
          8. Calculated Fields and Items<\/li>
          9. Slicers<\/li><\/ol><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
            \n\t\t\t\t\t
            \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t Getting Started with Data Visualization with Excel<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t
            1. Line Graphs<\/li>
            2. Bar Graphs<\/li>
            3. Pie Charts<\/li>
            4. Scatter Plots<\/li>
            5. Histograms<\/li><\/ol><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
              \n\t\t\t\t\t
              \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tStatistics Fundamentals Revisited<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t
              1. Type of Data<\/li>
              2. Sampling Techniques<\/li>
              3. Measures of central tendency and dispersion<\/li>
              4. Basic probability<\/li>
              5. Binomial distribution<\/li>
              6. Business Application of the Binomial Distribution<\/li>
              7. Poisson distribution<\/li>
              8. Normal distribution<\/li>
              9. Area under the curve<\/li>
              10. Central Limit Theorem<\/li>
              11. NORM.DIST & NORM.INV Function<\/li>
              12. T-Tests<\/li>
              13. T.DIST & T.INV Function<\/li>
              14. Confidence Interval and Application<\/li>
              15. ANOVA<\/li>
              16. Categorical Data Analysis<\/li>
              17. Correlation & Covariance<\/li>
              18. Hypothesis Testing<\/li>
              19. Steps of Hypotheses Test<\/li>
              20. Single Tail and Two Tail Hypotheses Tests<\/li>
              21. Type I & Type II Errors in a Hypothesis Test<\/li><\/ol><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
                \n\t\t\t\t\t
                \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t Solver Add-in<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t
                1. Defining a Problem<\/li>
                2. Step through Solver trial solution<\/li>
                3. Change how Solver finds solution<\/li>
                4. Save and Load a Problem Model<\/li><\/ol><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
                  \n\t\t\t\t\t
                  \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tGoal Seek & What-if<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t
                  1. Goal Seek<\/li>
                  2. What-If Scenario Manage<\/li><\/ol><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
                    \n\t\t\t\t\t
                    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tAnalysis ToolPak<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t
                    1. Load and activate the Analysis ToolPak<\/li>
                    2. Anova: Single Factor<\/li>
                    3. Anova: Two-Factor with Replication<\/li>
                    4. Anova: Two-Factor without Replication<\/li>
                    5. Correlation<\/li>
                    6. Covariance<\/li>
                    7. Descriptive Statistics<\/li>
                    8. Exponential Smoothing<\/li>
                    9. F-Test Two-Sample for Variance<\/li>
                    10. Histogram<\/li>
                    11. Moving Average<\/li>
                    12. Rank and Percentile<\/li>
                    13. Regression<\/li>
                    14. Sampling<\/li>
                    15. t-Test: Paired Two Sample for Means<\/li>
                    16. t-Test: Two-Sample Assuming Equal Variances<\/li>
                    17. t-Test: Two-Sample Assuming Unequal Variances<\/li>
                    18. z-Test<\/li><\/ol><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
                      \n\t\t\t\t\t
                      \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t Power Pivot: Advanced Data Manipulation<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t
                      1. Import Data, Create and Edit Tables<\/li>
                      2. Relationship Between Tables<\/li>
                      3. Calculations<\/li>
                      4. Hierarchies<\/li>
                      5. PivotTables & PivotCharts<\/li><\/ol><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
                        \n\t\t\t\t\t
                        \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tPower View: Advanced Visualization<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t
                        1. Importing Data<\/li>
                        2. Create Charts<\/li>
                        3. Filter and Highlight Data<\/li>
                        4. Slicer and Sorting<\/li>
                        5. Multiple Views<\/li><\/ol><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
                          \n\t\t\t\t\t
                          \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t Power Map: Powerful 3D Visualization<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t
                          1. Exploratory Data Analysis with Power Map<\/li>
                          2. Geocoding data in Power Map<\/li>
                          3. Visualization with Power Map<\/li>
                          4. Custom Maps<\/li>
                          5. Filtering<\/li><\/ol><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t
                            \n\t\t\t\t\t
                            \n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t Dynamic Reports with Excel Dashboards<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t
                            1. Defining Dashboard<\/li>
                            2. Data sources & Importing Data into Excel<\/li>
                            3. KPIs<\/li>
                            4. Dashboard Elements<\/li>
                            5. Preparing data for Dashboard<\/li>
                            6. Analyze the data<\/li>
                            7. Create Charts<\/li>
                            8. Create PivotTables and PivotCharts<\/li>
                            9. Create Dynamic Reports with Filters and Slicers<\/li>
                            10. Enhancing the UI<\/li><\/ol><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
                              \n\t\t\t
                              \n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
                              \n\t\t\t\t\t\t
                              \n\t\t\t\t\t
                              \n\t\t\t
                              \n\t\t\t\t\t\t
                              \n\t\t\t\t
                              \n\t\t\t\t\t

                              Reviews<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                              \n\t\t\t\t
                              \n\t\t\t\t\t\t\t
                              \n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                              \n\t\t\t\t
                              \n\t\t\t\t\t \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

                              Business Analytics with Microsoft Excel Course Overview Master the quantitative methods to analyze data using readily available advanced excel tools. Learn to produce actionable insights from data through statistical techniques, data visualization, exploratory and predictive modeling in our business analytics training. Develop skills to define, monitor and optimize metrics to improve your team’s performance. In […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-28247","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/greaterinsights.in\/staging1\/wp-json\/wp\/v2\/pages\/28247","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/greaterinsights.in\/staging1\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/greaterinsights.in\/staging1\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/greaterinsights.in\/staging1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/greaterinsights.in\/staging1\/wp-json\/wp\/v2\/comments?post=28247"}],"version-history":[{"count":5,"href":"https:\/\/greaterinsights.in\/staging1\/wp-json\/wp\/v2\/pages\/28247\/revisions"}],"predecessor-version":[{"id":36366,"href":"https:\/\/greaterinsights.in\/staging1\/wp-json\/wp\/v2\/pages\/28247\/revisions\/36366"}],"wp:attachment":[{"href":"https:\/\/greaterinsights.in\/staging1\/wp-json\/wp\/v2\/media?parent=28247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}