80 Fundamental Models with Excel Templates for Business Analysts
  • 80 Fundamental Models with Excel Templates for Business Analysts
  • 80 Fundamental Models with Excel Templates for Business Analysts
  • 80 Fundamental Models with Excel Templates for Business Analysts
  • 80 Fundamental Models with Excel Templates for Business Analysts
  • 80 Fundamental Models with Excel Templates for Business Analysts
  • 80 Fundamental Models with Excel Templates for Business Analysts
  • 80 Fundamental Models with Excel Templates for Business Analysts
  • 80 Fundamental Models with Excel Templates for Business Analysts
  • 80 Fundamental Models with Excel Templates for Business Analysts
  • 80 Fundamental Models with Excel Templates for Business Analysts
  • 80 Fundamental Models with Excel Templates for Business Analysts
Originally published: 28/05/2019 15:34
Last version published: 11/07/2019 10:25
Publication number: ELQ-49351-4
View all versions & Certificate
certified

80 Fundamental Models with Excel Templates for Business Analysts

Toolkit for analysts including approximately 80 Excel templates and the description of each model

Description
Toolkit for business analysts and it provides about 80 models / techniques used to solve day-to-day business issues. Each model is explained in a simple way, and this is why the book is suitable to readers with different levels of technical skills. For almost each tool presented in this book, it is possible to download a ready-to-use template in Excel which make the practical implementation easier. Table of contents:

STRATEGIC ANALYSIS
3. INTRODUCTION
4. ENVIRONMENTAL ANALYSIS (PEST)
5. COMPETITIVE MAP
6. BLUE OCEAN MODEL
7. IMPORTANCE–PERFORMANCE MATRIX
8. VMOST
9. RESOURCE AUDIT
10. BOSTON MATRIX
11. PORTER’S FIVE FORCES
12. PRODUCT LIFE CYCLE ANALYSIS
13. DIVERSIFICATION MATRIX (G.E. MATRIX)
14. INTERNATIONALIZATION MATRIX
15. BUSINESS MODEL CANVAS
16. SWOT ANALYSIS
17. ANSOFF’S MATRIX

PRICING AND DEMAND
18. INTRODUCTION
19. PRICE ELASTICITY OF DEMAND
20. GABOR–GRANGER PRICING METHOD
21. VAN WESTENDORP PRICE SENSITIVITY METER
22. MONADIC PRICE TESTING
23. CONJOINT ANALYSIS
24. CHOICE-BASED CONJOINT ANALYSIS

CUSTOMER ANALYTICS
25. INTRODUCTION
26. RFM MODEL
27. CUSTOMER LIFETIME VALUE 1
28. CUSTOMER LIFETIME VALUE 2
29. NET PROMOTER SCORE® (NPS®)
30. CUSTOMER VALUE MATRIX
31. CUSTOMER PROBABILITY MODEL
32. SURVIVAL ANALYSIS
33. SCORING MODELS

STATISTICAL ANALYSIS
34. INTRODUCTION
35. DESCRIPTIVE STATISTICS
36. INTRODUCTION TO REGRESSIONS
37. PEARSON CORRELATION
38. LINEAR REGRESSION
39. OTHER REGRESSIONS
40. PATH ANALYSIS
41. INTRODUCTION TO HYPOTHESIS TESTING
42. BAYESIAN APPROACH TO HYPOTHESIS TESTING
43. t-TEST
44. TEST OF PROPORTIONS
45. A/B TESTING
46. ANOVA
47. INTRODUCTION TO NON-PARAMETRIC MODELS
48. CHI-SQUARE
49. SPEARMAN’S RANK CORRELATION
50. PHI CORRELATION
51. MANN–WHITNEY U TEST
52. WILCOXON SIGNED-RANK TEST
53. KRUSKAL–WALLIS TEST
54. FRIEDMAN TEST
55. SCHEIRER–RAY–HARE TEST
56. MCNEMAR TEST
57. COCHRAN’S Q TEST
58. INTRODUCTION TO CLASSIFICATION MODELS
59. BINARY CLASSIFICATION
60. LOGISTIC REGRESSION
61. CLUSTER ANALYSIS
62. PROFILE ANALYSIS
63. PRINCIPAL COMPONENT ANALYSIS
64. EXPLORATORY FACTOR ANALYSIS
65. CONFIRMATORY FACTOR ANALYSIS

FORECASTING
66. INTRODUCTION
67. S-CURVE LIFE CYCLE ANALYSIS
68. MOVING AVERAGE
69. EXPONENTIAL SMOOTHING
70. TIME SERIES ANALYSIS
71. PICKUP MODELS
72. REGRESSIONS

WHAT-IF ANALYSIS AND OPTIMIZATION MODELS
73. INTRODUCTION
74. SCENARIO ANALYSIS
75. SIMPLE DECISION TREES
76. GAME THEORY MODELS
77. MONTE CARLO SIMULATIONS
78. MARKOV CHAIN MODEL
79. SALES FUNNEL ANALYSIS
80. OPTIMIZATION

This Best Practice includes
1 pdf file with the description and links to download Excel templates

Acquire business license for $9.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • Be the first to review this Downloadable Tool

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Alberto Scappini

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on 80 Fundamental Models With Excel Templates For Business Analysts?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...