{"id":4329,"date":"2025-08-08T00:10:15","date_gmt":"2025-08-08T00:10:15","guid":{"rendered":"https:\/\/uplatz.com\/blog\/?p=4329"},"modified":"2025-08-08T00:13:34","modified_gmt":"2025-08-08T00:13:34","slug":"data-analyst-cheat-sheet","status":"publish","type":"post","link":"https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/","title":{"rendered":"Data Analyst Cheat Sheet"},"content":{"rendered":"<p><!-- Data Analyst Cheat Sheet --><\/p>\n<div style=\"margin: 30px 0; font-family: 'Segoe UI', -apple-system, BlinkMacSystemFont, sans-serif;\">\n<style>\n    .da-container {\n      max-width: 1200px;\n      margin: 0 auto;\n      line-height: 1.6;\n    }\n    .da-header {\n      text-align: center;\n      background: linear-gradient(135deg, #7c3aed 0%, #5b21b6 100%);\n      color: white;\n      padding: 40px 30px;\n      border-radius: 20px;\n      margin-bottom: 40px;\n      box-shadow: 0 10px 30px rgba(124, 58, 237, 0.3);\n    }\n    .da-header h1 {\n      font-size: 2.5rem;\n      margin: 0 0 15px 0;\n      font-weight: 700;\n    }\n    .da-header p {\n      font-size: 1.1rem;\n      margin: 0;\n      opacity: 0.9;\n    }\n    .section {\n      margin-bottom: 50px;\n    }\n    .section-title {\n      background: linear-gradient(135deg, #8b5cf6 0%, #7c3aed 100%);\n      color: white;\n      padding: 20px 25px;\n      border-radius: 12px;\n      font-size: 1.6rem;\n      font-weight: 600;\n      text-align: center;\n      margin-bottom: 30px;\n      box-shadow: 0 6px 20px rgba(139, 92, 246, 0.3);\n    }\n    .cards-grid {\n      display: grid;\n      grid-template-columns: repeat(auto-fit, minmax(300px, 1fr));\n      gap: 25px;\n    }\n    .info-card {\n      background: #ffffff;\n      border: 2px solid #e9d5ff;\n      border-radius: 12px;\n      padding: 25px;\n      box-shadow: 0 4px 15px rgba(0,0,0,0.08);\n      transition: all 0.3s ease;\n      position: relative;\n      overflow: hidden;\n    }\n    .info-card:hover {\n      transform: translateY(-5px);\n      box-shadow: 0 8px 30px rgba(0,0,0,0.15);\n      border-color: #7c3aed;\n    }\n    .info-card::before {\n      content: '';\n      position: absolute;\n      top: 0;\n      left: 0;\n      right: 0;\n      height: 4px;\n      background: linear-gradient(135deg, #7c3aed, #5b21b6);\n    }\n    .card-header {\n      display: flex;\n      align-items: center;\n      gap: 12px;\n      margin-bottom: 15px;\n    }\n    .card-icon {\n      font-size: 1.8rem;\n      flex-shrink: 0;\n    }\n    .card-title {\n      font-size: 1.3rem;\n      font-weight: 600;\n      color: #1e293b;\n      margin: 0;\n    }\n    .card-content {\n      color: #475569;\n      font-size: 0.95rem;\n    }\n    .framework-card {\n      background: linear-gradient(135deg, #7c3aed 0%, #5b21b6 100%);\n      color: white;\n      border: none;\n    }\n    .framework-card .card-title {\n      color: white;\n    }\n    .framework-card .card-content {\n      color: rgba(255,255,255,0.9);\n    }\n    .highlight {\n      background: linear-gradient(120deg, #e9d5ff 0%, #ddd6fe 100%);\n      padding: 2px 6px;\n      border-radius: 4px;\n      font-weight: 500;\n      color: #5b21b6;\n    }\n    .process-list {\n      list-style: none;\n      padding: 0;\n      margin: 0;\n    }\n    .process-list li {\n      background: #faf5ff;\n      margin: 10px 0;\n      padding: 15px;\n      border-radius: 8px;\n      border-left: 4px solid #7c3aed;\n      font-size: 0.95rem;\n    }\n    .process-list li strong {\n      color: #5b21b6;\n    }\n    .metric-grid {\n      display: grid;\n      grid-template-columns: repeat(auto-fit, minmax(250px, 1fr));\n      gap: 20px;\n    }\n    .metric-card {\n      background: #f8fafc;\n      padding: 20px;\n      border-radius: 8px;\n      border-left: 4px solid #8b5cf6;\n      text-align: center;\n    }\n    .metric-title {\n      font-weight: 600;\n      color: #5b21b6;\n      font-size: 1.1rem;\n      margin-bottom: 8px;\n    }\n    .metric-desc {\n      font-size: 0.9rem;\n      color: #64748b;\n      margin: 0;\n    }\n    .template-card {\n      background: #1e293b;\n      color: #f8fafc;\n      padding: 20px;\n      border-radius: 8px;\n      margin: 15px 0;\n      font-family: 'Consolas', 'Monaco', 'Courier New', monospace;\n      font-size: 0.9rem;\n      border-left: 4px solid #7c3aed;\n    }\n    .template-title {\n      color: #c4b5fd;\n      font-weight: 600;\n      margin-bottom: 10px;\n      font-family: 'Segoe UI', sans-serif;\n    }\n    .priority-high {\n      background: #fef2f2;\n      border-left-color: #ef4444;\n    }\n    .priority-medium {\n      background: #fffbeb;\n      border-left-color: #f59e0b;\n    }\n    .priority-low {\n      background: #f0fdf4;\n      border-left-color: #22c55e;\n    }\n    .tools-grid {\n      display: grid;\n      grid-template-columns: repeat(auto-fit, minmax(280px, 1fr));\n      gap: 20px;\n    }\n    .tool-item {\n      background: #faf5ff;\n      padding: 15px;\n      border-radius: 8px;\n      border-left: 4px solid #7c3aed;\n    }\n    .tool-name {\n      font-weight: 600;\n      color: #5b21b6;\n      margin-bottom: 5px;\n    }\n    .tool-desc {\n      font-size: 0.9rem;\n      color: #64748b;\n      margin: 0;\n    }\n    .analysis-phase {\n      background: #f8fafc;\n      border: 2px solid #e2e8f0;\n      border-radius: 8px;\n      padding: 20px;\n      margin: 15px 0;\n    }\n    .phase-title {\n      background: #7c3aed;\n      color: white;\n      padding: 8px 16px;\n      border-radius: 6px;\n      display: inline-block;\n      font-weight: 600;\n      margin-bottom: 15px;\n    }\n    @media (max-width: 768px) {\n      .da-header h1 {\n        font-size: 2rem;\n      }\n      .da-header {\n        padding: 25px 20px;\n      }\n      .section-title {\n        font-size: 1.4rem;\n        padding: 15px 20px;\n      }\n      .cards-grid {\n        grid-template-columns: 1fr;\n      }\n      .tools-grid {\n        grid-template-columns: 1fr;\n      }\n    }\n  <\/style>\n<div class=\"da-container\">\n    <!-- Header --><\/p>\n<div class=\"da-header\">\n<h1>\ud83d\udcca Data Analyst Cheat Sheet<\/h1>\n<p>Complete guide to data analysis techniques, tools, statistical methods, and visualization best practices<\/p>\n<\/p><\/div>\n<p>    <!-- Core Analysis Concepts --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\ud83c\udfaf Core Analysis Concepts<\/div>\n<div class=\"cards-grid\">\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udd0d<\/span><\/p>\n<h3 class=\"card-title\">Types of Data Analysis<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <span class=\"highlight\">Four levels of analytics maturity<\/span><\/p>\n<p>            <strong>Descriptive Analytics:<\/strong><br \/>\n            \u2022 What happened? Historical data summary<br \/>\n            \u2022 Reports, dashboards, KPI tracking<\/p>\n<p>            <strong>Diagnostic Analytics:<\/strong><br \/>\n            \u2022 Why did it happen? Root cause analysis<br \/>\n            \u2022 Correlation analysis, drill-down reports<\/p>\n<p>            <strong>Predictive Analytics:<\/strong><br \/>\n            \u2022 What will happen? Future forecasting<br \/>\n            \u2022 Statistical modeling, machine learning<\/p>\n<p>            <strong>Prescriptive Analytics:<\/strong><br \/>\n            \u2022 What should we do? Optimization<br \/>\n            \u2022 Decision support, recommendation engines\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udcc8<\/span><\/p>\n<h3 class=\"card-title\">Data Types &#038; Measurement<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Quantitative Data:<\/strong><br \/>\n            \u2022 <strong>Discrete:<\/strong> Countable values (customers, orders)<br \/>\n            \u2022 <strong>Continuous:<\/strong> Measurable values (revenue, time)<\/p>\n<p>            <strong>Qualitative Data:<\/strong><br \/>\n            \u2022 <strong>Nominal:<\/strong> Categories without order (color, brand)<br \/>\n            \u2022 <strong>Ordinal:<\/strong> Categories with order (rating, size)<\/p>\n<p>            <strong>Measurement Scales:<\/strong><br \/>\n            \u2022 <strong>Ratio:<\/strong> True zero point (age, income)<br \/>\n            \u2022 <strong>Interval:<\/strong> Equal intervals, no true zero (temperature)\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83c\udfaf<\/span><\/p>\n<h3 class=\"card-title\">Analytics Framework<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>CRISP-DM Methodology:<\/strong><br \/>\n            1. <strong>Business Understanding:<\/strong> Define objectives<br \/>\n            2. <strong>Data Understanding:<\/strong> Explore and assess data<br \/>\n            3. <strong>Data Preparation:<\/strong> Clean and transform<br \/>\n            4. <strong>Modeling:<\/strong> Apply analytical techniques<br \/>\n            5. <strong>Evaluation:<\/strong> Assess results against objectives<br \/>\n            6. <strong>Deployment:<\/strong> Implement findings<\/p>\n<p>            <em>Iterative process with feedback loops between stages<\/em>\n          <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- Statistical Analysis --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\ud83d\udcca Statistical Analysis Fundamentals<\/div>\n<div class=\"cards-grid\">\n<div class=\"info-card framework-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udccf<\/span><\/p>\n<h3 class=\"card-title\">Descriptive Statistics<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Central Tendency:<\/strong><br \/>\n            \u2022 Mean: Average value (sensitive to outliers)<br \/>\n            \u2022 Median: Middle value (robust to outliers)<br \/>\n            \u2022 Mode: Most frequent value<\/p>\n<p>            <strong>Variability:<\/strong><br \/>\n            \u2022 Range: Max &#8211; Min<br \/>\n            \u2022 Variance: Average squared deviation<br \/>\n            \u2022 Standard Deviation: Square root of variance<br \/>\n            \u2022 IQR: 75th percentile &#8211; 25th percentile<\/p>\n<p>            <strong>Distribution Shape:<\/strong><br \/>\n            \u2022 Skewness: Asymmetry measure<br \/>\n            \u2022 Kurtosis: Tail heaviness measure\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card framework-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udd2c<\/span><\/p>\n<h3 class=\"card-title\">Inferential Statistics<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Hypothesis Testing:<\/strong><br \/>\n            \u2022 Null hypothesis (H\u2080) vs Alternative (H\u2081)<br \/>\n            \u2022 p-value: Probability of observing data if H\u2080 true<br \/>\n            \u2022 Significance level (\u03b1): Threshold (usually 0.05)<br \/>\n            \u2022 Type I error: False positive<br \/>\n            \u2022 Type II error: False negative<\/p>\n<p>            <strong>Confidence Intervals:<\/strong><br \/>\n            \u2022 Range of plausible values for parameter<br \/>\n            \u2022 95% CI: 95% confidence true value is within range\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card framework-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83e\uddea<\/span><\/p>\n<h3 class=\"card-title\">Common Statistical Tests<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Comparing Means:<\/strong><br \/>\n            \u2022 One-sample t-test: Sample vs population<br \/>\n            \u2022 Two-sample t-test: Compare two groups<br \/>\n            \u2022 ANOVA: Compare multiple groups<\/p>\n<p>            <strong>Relationships:<\/strong><br \/>\n            \u2022 Correlation: Linear relationship strength<br \/>\n            \u2022 Chi-square: Independence of categorical variables<br \/>\n            \u2022 Regression: Predict dependent variable<\/p>\n<p>            <strong>Non-parametric Tests:<\/strong><br \/>\n            \u2022 Mann-Whitney U: Compare medians<br \/>\n            \u2022 Kruskal-Wallis: Multiple group comparison\n          <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- Excel for Data Analysis --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\ud83d\udcca Excel for Data Analysis<\/div>\n<div class=\"cards-grid\">\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83e\uddee<\/span><\/p>\n<h3 class=\"card-title\">Essential Excel Functions<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n<div class=\"template-card\">\n<div class=\"template-title\">Statistical Functions:<\/div>\n<p>=AVERAGE(A1:A100)          \/\/ Mean<br \/>\n=MEDIAN(A1:A100)           \/\/ Median<br \/>\n=MODE.SNGL(A1:A100)        \/\/ Mode<br \/>\n=STDEV.S(A1:A100)          \/\/ Sample standard deviation<br \/>\n=VAR.S(A1:A100)            \/\/ Sample variance<br \/>\n=QUARTILE(A1:A100, 1)      \/\/ First quartile<br \/>\n=PERCENTILE(A1:A100, 0.95) \/\/ 95th percentile<br \/>\n=CORREL(A1:A100, B1:B100)  \/\/ Correlation coefficient<\/p>\n<p>\/\/ Conditional Statistics<br \/>\n=AVERAGEIF(B1:B100, &#8220;>100&#8221;, A1:A100)    \/\/ Conditional average<br \/>\n=COUNTIFS(A1:A100, &#8220;>50&#8221;, B1:B100, &#8220;Yes&#8221;) \/\/ Multiple criteria count<br \/>\n=SUMIFS(C1:C100, A1:A100, &#8220;Product A&#8221;, B1:B100, &#8220;>100&#8221;)<\/p>\n<p>\/\/ Lookup and Reference<br \/>\n=VLOOKUP(E2, A1:C100, 3, FALSE)    \/\/ Vertical lookup<br \/>\n=INDEX(C1:C100, MATCH(E2, A1:A100, 0)) \/\/ Index-match<br \/>\n=XLOOKUP(E2, A1:A100, C1:C100)     \/\/ Modern lookup (Excel 365)\n            <\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udccb<\/span><\/p>\n<h3 class=\"card-title\">Pivot Tables &#038; Analysis<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Pivot Table Components:<\/strong><br \/>\n            \u2022 <strong>Rows:<\/strong> Categories to group by<br \/>\n            \u2022 <strong>Columns:<\/strong> Additional grouping dimension<br \/>\n            \u2022 <strong>Values:<\/strong> Metrics to calculate<br \/>\n            \u2022 <strong>Filters:<\/strong> Data subset controls<\/p>\n<p>            <strong>Common Aggregations:<\/strong><br \/>\n            \u2022 Sum, Average, Count, Max, Min<br \/>\n            \u2022 Percentage of total, running totals<br \/>\n            \u2022 Year-over-year growth calculations<\/p>\n<p>            <strong>Advanced Features:<\/strong><br \/>\n            \u2022 Calculated fields and items<br \/>\n            \u2022 Grouping dates and numbers<br \/>\n            \u2022 Pivot charts for visualization\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83c\udfa8<\/span><\/p>\n<h3 class=\"card-title\">Data Visualization in Excel<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Chart Types &#038; Use Cases:<\/strong><br \/>\n            \u2022 <strong>Column\/Bar:<\/strong> Compare categories<br \/>\n            \u2022 <strong>Line:<\/strong> Show trends over time<br \/>\n            \u2022 <strong>Scatter:<\/strong> Examine relationships<br \/>\n            \u2022 <strong>Pie:<\/strong> Show parts of whole (limit to 5-7 slices)<br \/>\n            \u2022 <strong>Area:<\/strong> Show cumulative totals<br \/>\n            \u2022 <strong>Combo:<\/strong> Multiple metrics with different scales<\/p>\n<p>            <strong>Best Practices:<\/strong><br \/>\n            \u2022 Clear titles and axis labels<br \/>\n            \u2022 Consistent color scheme<br \/>\n            \u2022 Remove chart junk (unnecessary elements)<br \/>\n            \u2022 Use data labels when helpful\n          <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- SQL for Analysis --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\ud83d\uddc4\ufe0f SQL for Data Analysis<\/div>\n<div class=\"cards-grid\">\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udd0d<\/span><\/p>\n<h3 class=\"card-title\">Essential SQL Queries<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n<div class=\"template-card\">\n<div class=\"template-title\">Basic Analysis Queries:<\/div>\n<p>&#8212; Data exploration<br \/>\nSELECT COUNT(*) as total_records,<br \/>\n       COUNT(DISTINCT customer_id) as unique_customers,<br \/>\n       MIN(order_date) as earliest_order,<br \/>\n       MAX(order_date) as latest_order<br \/>\nFROM orders;<\/p>\n<p>&#8212; Summary statistics<br \/>\nSELECT<br \/>\n    AVG(order_value) as avg_order_value,<br \/>\n    MEDIAN(order_value) as median_order_value,<br \/>\n    STDDEV(order_value) as std_dev,<br \/>\n    MIN(order_value) as min_value,<br \/>\n    MAX(order_value) as max_value,<br \/>\n    COUNT(*) as total_orders<br \/>\nFROM orders<br \/>\nWHERE order_date >= &#8216;2024-01-01&#8217;;<\/p>\n<p>&#8212; Percentile analysis<br \/>\nSELECT<br \/>\n    PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY order_value) as q1,<br \/>\n    PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY order_value) as median,<br \/>\n    PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY order_value) as q3,<br \/>\n    PERCENTILE_CONT(0.95) WITHIN GROUP (ORDER BY order_value) as p95<br \/>\nFROM orders;\n            <\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udcca<\/span><\/p>\n<h3 class=\"card-title\">Analytical SQL Functions<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n<div class=\"template-card\">\n<div class=\"template-title\">Window Functions for Analysis:<\/div>\n<p>&#8212; Running totals and moving averages<br \/>\nSELECT<br \/>\n    order_date,<br \/>\n    daily_revenue,<br \/>\n    SUM(daily_revenue) OVER (ORDER BY order_date) as running_total,<br \/>\n    AVG(daily_revenue) OVER (ORDER BY order_date<br \/>\n        ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as moving_7_day_avg<br \/>\nFROM daily_sales;<\/p>\n<p>&#8212; Ranking and percentiles<br \/>\nSELECT<br \/>\n    customer_id,<br \/>\n    total_spent,<br \/>\n    RANK() OVER (ORDER BY total_spent DESC) as spending_rank,<br \/>\n    NTILE(10) OVER (ORDER BY total_spent) as decile,<br \/>\n    PERCENT_RANK() OVER (ORDER BY total_spent) as percentile_rank<br \/>\nFROM customer_totals;<\/p>\n<p>&#8212; Period-over-period analysis<br \/>\nSELECT<br \/>\n    month,<br \/>\n    revenue,<br \/>\n    LAG(revenue, 1) OVER (ORDER BY month) as prev_month_revenue,<br \/>\n    LAG(revenue, 12) OVER (ORDER BY month) as same_month_last_year,<br \/>\n    (revenue &#8211; LAG(revenue, 1) OVER (ORDER BY month)) \/<br \/>\n        LAG(revenue, 1) OVER (ORDER BY month) * 100 as mom_growth,<br \/>\n    (revenue &#8211; LAG(revenue, 12) OVER (ORDER BY month)) \/<br \/>\n        LAG(revenue, 12) OVER (ORDER BY month) * 100 as yoy_growth<br \/>\nFROM monthly_revenue;\n            <\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83e\udde9<\/span><\/p>\n<h3 class=\"card-title\">Advanced Analysis Patterns<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n<div class=\"template-card\">\n<div class=\"template-title\">Cohort Analysis Example:<\/div>\n<p>WITH first_purchase AS (<br \/>\n    SELECT customer_id,<br \/>\n           MIN(DATE_TRUNC(&#8216;month&#8217;, order_date)) as cohort_month<br \/>\n    FROM orders<br \/>\n    GROUP BY customer_id<br \/>\n),<br \/>\ncustomer_activity AS (<br \/>\n    SELECT o.customer_id,<br \/>\n           fp.cohort_month,<br \/>\n           DATE_TRUNC(&#8216;month&#8217;, o.order_date) as activity_month,<br \/>\n           EXTRACT(EPOCH FROM (DATE_TRUNC(&#8216;month&#8217;, o.order_date) &#8211; fp.cohort_month)) \/<br \/>\n               (60*60*24*30) as period_number<br \/>\n    FROM orders o<br \/>\n    JOIN first_purchase fp ON o.customer_id = fp.customer_id<br \/>\n)<br \/>\nSELECT cohort_month,<br \/>\n       period_number,<br \/>\n       COUNT(DISTINCT customer_id) as customers,<br \/>\n       ROUND(100.0 * COUNT(DISTINCT customer_id) \/<br \/>\n           FIRST_VALUE(COUNT(DISTINCT customer_id))<br \/>\n           OVER (PARTITION BY cohort_month ORDER BY period_number), 2) as retention_rate<br \/>\nFROM customer_activity<br \/>\nGROUP BY cohort_month, period_number<br \/>\nORDER BY cohort_month, period_number;\n            <\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- Python for Data Analysis --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\ud83d\udc0d Python for Data Analysis<\/div>\n<div class=\"cards-grid\">\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udc3c<\/span><\/p>\n<h3 class=\"card-title\">Pandas Fundamentals<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n<div class=\"template-card\">\n<div class=\"template-title\">Essential Pandas Operations:<\/div>\n<p>import pandas as pd<br \/>\nimport numpy as np<\/p>\n<p># Data loading and exploration<br \/>\ndf = pd.read_csv(&#8216;data.csv&#8217;)<br \/>\ndf = pd.read_excel(&#8216;data.xlsx&#8217;, sheet_name=&#8217;Sales&#8217;)<br \/>\ndf.head()                    # First 5 rows<br \/>\ndf.info()                    # Data types and memory usage<br \/>\ndf.describe()                # Statistical summary<br \/>\ndf.shape                     # Dimensions<br \/>\ndf.columns.tolist()          # Column names<\/p>\n<p># Data cleaning<br \/>\ndf.dropna()                  # Remove missing values<br \/>\ndf.fillna(df.mean())         # Fill with mean<br \/>\ndf.drop_duplicates()         # Remove duplicates<br \/>\ndf[&#8216;column&#8217;].unique()        # Unique values<br \/>\ndf[&#8216;column&#8217;].value_counts()  # Frequency counts<\/p>\n<p># Data transformation<br \/>\ndf[&#8216;new_column&#8217;] = df[&#8216;col1&#8217;] + df[&#8216;col2&#8217;]  # Create new column<br \/>\ndf.groupby(&#8216;category&#8217;).agg({                # Group by operations<br \/>\n    &#8216;sales&#8217;: [&#8216;sum&#8217;, &#8216;mean&#8217;, &#8216;count&#8217;],<br \/>\n    &#8216;profit&#8217;: &#8216;sum&#8217;<br \/>\n})<br \/>\ndf.pivot_table(values=&#8217;sales&#8217;, index=&#8217;product&#8217;,<br \/>\n               columns=&#8217;month&#8217;, aggfunc=&#8217;sum&#8217;)  # Pivot table\n            <\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udcca<\/span><\/p>\n<h3 class=\"card-title\">Data Visualization<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n<div class=\"template-card\">\n<div class=\"template-title\">Matplotlib &#038; Seaborn Examples:<\/div>\n<p>import matplotlib.pyplot as plt<br \/>\nimport seaborn as sns<\/p>\n<p># Set style<br \/>\nplt.style.use(&#8216;seaborn-v0_8&#8217;)<br \/>\nsns.set_palette(&#8220;husl&#8221;)<\/p>\n<p># Basic plots<br \/>\nplt.figure(figsize=(10, 6))<br \/>\nplt.plot(df[&#8216;date&#8217;], df[&#8216;sales&#8217;])           # Line plot<br \/>\nplt.bar(df[&#8216;category&#8217;], df[&#8216;sales&#8217;])        # Bar chart<br \/>\nplt.scatter(df[&#8216;advertising&#8217;], df[&#8216;sales&#8217;]) # Scatter plot<br \/>\nplt.hist(df[&#8216;sales&#8217;], bins=20)              # Histogram<\/p>\n<p># Seaborn statistical plots<br \/>\nsns.boxplot(x=&#8217;category&#8217;, y=&#8217;sales&#8217;, data=df)      # Box plot<br \/>\nsns.violinplot(x=&#8217;category&#8217;, y=&#8217;sales&#8217;, data=df)   # Violin plot<br \/>\nsns.heatmap(df.corr(), annot=True, cmap=&#8217;coolwarm&#8217;) # Correlation matrix<br \/>\nsns.pairplot(df)                                    # Pairwise relationships<br \/>\nsns.regplot(x=&#8217;advertising&#8217;, y=&#8217;sales&#8217;, data=df)   # Regression plot<\/p>\n<p># Customization<br \/>\nplt.title(&#8216;Sales Analysis&#8217;, fontsize=16)<br \/>\nplt.xlabel(&#8216;Category&#8217;, fontsize=12)<br \/>\nplt.ylabel(&#8216;Sales ($)&#8217;, fontsize=12)<br \/>\nplt.xticks(rotation=45)<br \/>\nplt.tight_layout()<br \/>\nplt.show()\n            <\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udcc8<\/span><\/p>\n<h3 class=\"card-title\">Statistical Analysis<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n<div class=\"template-card\">\n<div class=\"template-title\">SciPy Statistical Tests:<\/div>\n<p>from scipy import stats<br \/>\nimport scipy.stats as stats<\/p>\n<p># Descriptive statistics<br \/>\nstats.describe(df[&#8216;sales&#8217;])         # Complete description<br \/>\ndf[&#8216;sales&#8217;].skew()                  # Skewness<br \/>\ndf[&#8216;sales&#8217;].kurtosis()             # Kurtosis<\/p>\n<p># Hypothesis testing<br \/>\n# One-sample t-test<br \/>\nt_stat, p_value = stats.ttest_1samp(df[&#8216;sales&#8217;], 100000)<br \/>\nprint(f&#8221;t-statistic: {t_stat:.4f}, p-value: {p_value:.4f}&#8221;)<\/p>\n<p># Two-sample t-test<br \/>\ngroup_a = df[df[&#8216;group&#8217;] == &#8216;A&#8217;][&#8216;sales&#8217;]<br \/>\ngroup_b = df[df[&#8216;group&#8217;] == &#8216;B&#8217;][&#8216;sales&#8217;]<br \/>\nt_stat, p_value = stats.ttest_ind(group_a, group_b)<\/p>\n<p># Chi-square test for independence<br \/>\ncontingency_table = pd.crosstab(df[&#8216;category&#8217;], df[&#8216;region&#8217;])<br \/>\nchi2, p_value, dof, expected = stats.chi2_contingency(contingency_table)<\/p>\n<p># Correlation analysis<br \/>\ncorrelation, p_value = stats.pearsonr(df[&#8216;advertising&#8217;], df[&#8216;sales&#8217;])<br \/>\nspearman_corr, p_value = stats.spearmanr(df[&#8216;advertising&#8217;], df[&#8216;sales&#8217;])<\/p>\n<p># ANOVA<br \/>\nf_stat, p_value = stats.f_oneway(<br \/>\n    df[df[&#8216;category&#8217;] == &#8216;A&#8217;][&#8216;sales&#8217;],<br \/>\n    df[df[&#8216;category&#8217;] == &#8216;B&#8217;][&#8216;sales&#8217;],<br \/>\n    df[df[&#8216;category&#8217;] == &#8216;C&#8217;][&#8216;sales&#8217;]<br \/>\n)\n            <\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- Business Intelligence Tools --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\ud83d\udcca Business Intelligence Tools<\/div>\n<div class=\"cards-grid\">\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udcc8<\/span><\/p>\n<h3 class=\"card-title\">Tableau Essentials<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Key Concepts:<\/strong><br \/>\n            \u2022 <strong>Dimensions:<\/strong> Categorical data (qualitative)<br \/>\n            \u2022 <strong>Measures:<\/strong> Numerical data (quantitative)<br \/>\n            \u2022 <strong>Calculated Fields:<\/strong> Custom formulas<br \/>\n            \u2022 <strong>Parameters:<\/strong> Interactive user inputs<\/p>\n<p>            <strong>Common Calculations:<\/strong><br \/>\n            \u2022 Running totals: RUNNING_SUM(SUM([Sales]))<br \/>\n            \u2022 Percentage of total: SUM([Sales])\/TOTAL(SUM([Sales]))<br \/>\n            \u2022 Year-over-year growth: (SUM([Sales]) &#8211; LOOKUP(SUM([Sales]), -12))\/LOOKUP(SUM([Sales]), -12)<br \/>\n            \u2022 Rank: RANK(SUM([Sales]), &#8216;desc&#8217;)<\/p>\n<p>            <strong>Best Practices:<\/strong><br \/>\n            \u2022 Use appropriate chart types for data<br \/>\n            \u2022 Consistent color schemes and formatting<br \/>\n            \u2022 Clear titles and labels\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\u26a1<\/span><\/p>\n<h3 class=\"card-title\">Power BI Fundamentals<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>DAX (Data Analysis Expressions):<\/strong><br \/>\n            \u2022 <strong>Calculated Columns:<\/strong> Row-level calculations<br \/>\n            \u2022 <strong>Measures:<\/strong> Aggregated calculations<br \/>\n            \u2022 <strong>Tables:<\/strong> Virtual table functions<\/p>\n<p>            <strong>Common DAX Functions:<\/strong><br \/>\n            \u2022 Total Sales = SUM(Sales[Amount])<br \/>\n            \u2022 Sales YTD = TOTALYTD([Total Sales], Calendar[Date])<br \/>\n            \u2022 Previous Year = CALCULATE([Total Sales], SAMEPERIODLASTYEAR(Calendar[Date]))<br \/>\n            \u2022 Growth % = DIVIDE([Total Sales] &#8211; [Previous Year], [Previous Year])<\/p>\n<p>            <strong>Key Features:<\/strong><br \/>\n            \u2022 Power Query for data transformation<br \/>\n            \u2022 Interactive dashboards and reports<br \/>\n            \u2022 Natural language Q&#038;A<br \/>\n            \u2022 Mobile-optimized views\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udcca<\/span><\/p>\n<h3 class=\"card-title\">Looker &#038; Google Data Studio<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Looker (LookML):<\/strong><br \/>\n            \u2022 Model layer for consistent metrics<br \/>\n            \u2022 SQL-based modeling approach<br \/>\n            \u2022 Reusable dimensions and measures<br \/>\n            \u2022 Git-based version control<\/p>\n<p>            <strong>Google Data Studio:<\/strong><br \/>\n            \u2022 Free Google visualization tool<br \/>\n            \u2022 Easy Google Sheets integration<br \/>\n            \u2022 Calculated fields and parameters<br \/>\n            \u2022 Collaborative report sharing<\/p>\n<p>            <strong>Use Cases:<\/strong><br \/>\n            \u2022 Marketing performance dashboards<br \/>\n            \u2022 Executive reporting<br \/>\n            \u2022 Self-service analytics\n          <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- A\/B Testing & Experimentation --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\ud83e\uddea A\/B Testing &#038; Experimentation<\/div>\n<div class=\"cards-grid\">\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\u2696\ufe0f<\/span><\/p>\n<h3 class=\"card-title\">Experimental Design<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Key Components:<\/strong><br \/>\n            \u2022 <strong>Hypothesis:<\/strong> Clear, testable prediction<br \/>\n            \u2022 <strong>Control Group:<\/strong> Baseline\/current experience<br \/>\n            \u2022 <strong>Treatment Group:<\/strong> New variant being tested<br \/>\n            \u2022 <strong>Random Assignment:<\/strong> Unbiased group allocation<br \/>\n            \u2022 <strong>Sample Size:<\/strong> Adequate power to detect effect<\/p>\n<p>            <strong>Success Metrics:<\/strong><br \/>\n            \u2022 <strong>Primary:<\/strong> Main KPI you&#8217;re trying to impact<br \/>\n            \u2022 <strong>Secondary:<\/strong> Supporting metrics<br \/>\n            \u2022 <strong>Guardrail:<\/strong> Metrics that shouldn&#8217;t be harmed<\/p>\n<p>            <strong>Common Pitfalls:<\/strong><br \/>\n            \u2022 Insufficient sample size<br \/>\n            \u2022 Multiple testing without correction<br \/>\n            \u2022 Stopping tests early<br \/>\n            \u2022 Selection bias in assignment\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udccf<\/span><\/p>\n<h3 class=\"card-title\">Statistical Power &#038; Sample Size<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n<div class=\"template-card\">\n<div class=\"template-title\">Sample Size Calculation (Python):<\/div>\n<p>import scipy.stats as stats<br \/>\nfrom statsmodels.stats.power import ttest_power<br \/>\nfrom statsmodels.stats.proportion import proportion_effectsize<\/p>\n<p># For proportions (conversion rates)<br \/>\ndef sample_size_proportion(p1, p2, alpha=0.05, power=0.8):<br \/>\n    effect_size = proportion_effectsize(p1, p2)<br \/>\n    n = stats.norm.ppf(1 &#8211; alpha\/2)**2 * 2 * p1 * (1-p1) \/ (p1-p2)**2<br \/>\n    return int(n)<\/p>\n<p># Example: Current conversion 5%, want to detect 1% increase<br \/>\ncurrent_rate = 0.05<br \/>\ntarget_rate = 0.06<br \/>\nsample_size = sample_size_proportion(current_rate, target_rate)<br \/>\nprint(f&#8221;Required sample size per group: {sample_size}&#8221;)<\/p>\n<p># For continuous variables (means)<br \/>\ndef sample_size_ttest(mu1, mu2, sigma, alpha=0.05, power=0.8):<br \/>\n    effect_size = abs(mu1 &#8211; mu2) \/ sigma<br \/>\n    n = 2 * (stats.norm.ppf(1-alpha\/2) + stats.norm.ppf(power))**2 \/ effect_size**2<br \/>\n    return int(n)<\/p>\n<p># Power analysis &#8211; what effect can we detect?<br \/>\ndetectable_effect = ttest_power(effect_size=None, nobs=1000,<br \/>\n                               alpha=0.05, power=0.8)\n            <\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udcca<\/span><\/p>\n<h3 class=\"card-title\">Results Analysis<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n<div class=\"template-card\">\n<div class=\"template-title\">A\/B Test Analysis Example:<\/div>\n<p># Chi-square test for conversion rates<br \/>\nfrom scipy.stats import chi2_contingency<\/p>\n<p># Test data<br \/>\ncontrol_conversions = 250<br \/>\ncontrol_visitors = 5000<br \/>\ntreatment_conversions = 280<br \/>\ntreatment_visitors = 5000<\/p>\n<p># Create contingency table<br \/>\nobs = [[control_conversions, control_visitors &#8211; control_conversions],<br \/>\n       [treatment_conversions, treatment_visitors &#8211; treatment_conversions]]<\/p>\n<p># Perform chi-square test<br \/>\nchi2, p_value, dof, expected = chi2_contingency(obs)<\/p>\n<p># Calculate conversion rates and confidence intervals<br \/>\ncontrol_rate = control_conversions \/ control_visitors<br \/>\ntreatment_rate = treatment_conversions \/ treatment_visitors<br \/>\nlift = (treatment_rate &#8211; control_rate) \/ control_rate * 100<\/p>\n<p>print(f&#8221;Control conversion rate: {control_rate:.3f}&#8221;)<br \/>\nprint(f&#8221;Treatment conversion rate: {treatment_rate:.3f}&#8221;)<br \/>\nprint(f&#8221;Relative lift: {lift:.1f}%&#8221;)<br \/>\nprint(f&#8221;Statistical significance (p-value): {p_value:.4f}&#8221;)<\/p>\n<p># Confidence interval for difference in proportions<br \/>\nimport statsmodels.stats.proportion as smp<br \/>\nci_lower, ci_upper = smp.confint_proportions_2indep(<br \/>\n    control_conversions, control_visitors,<br \/>\n    treatment_conversions, treatment_visitors<br \/>\n)\n            <\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- Customer Analytics --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\ud83d\udc65 Customer Analytics<\/div>\n<div class=\"cards-grid\">\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udd04<\/span><\/p>\n<h3 class=\"card-title\">Cohort Analysis<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Purpose:<\/strong> Track user behavior over time<\/p>\n<p>            <strong>Types of Cohorts:<\/strong><br \/>\n            \u2022 <strong>Time-based:<\/strong> Users who signed up in same period<br \/>\n            \u2022 <strong>Behavioral:<\/strong> Users who performed specific action<br \/>\n            \u2022 <strong>Size-based:<\/strong> Users grouped by spend\/usage<\/p>\n<p>            <strong>Key Metrics:<\/strong><br \/>\n            \u2022 Retention rates by cohort month<br \/>\n            \u2022 Revenue per cohort over time<br \/>\n            \u2022 User lifecycle patterns<\/p>\n<p>            <strong>Applications:<\/strong><br \/>\n            \u2022 Product-market fit assessment<br \/>\n            \u2022 Feature impact measurement<br \/>\n            \u2022 Customer lifetime value prediction<br \/>\n            \u2022 Churn analysis and prevention\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udcb0<\/span><\/p>\n<h3 class=\"card-title\">Customer Lifetime Value (CLV)<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n<div class=\"template-card\">\n<div class=\"template-title\">CLV Calculation Methods:<\/div>\n<p># Simple CLV calculation<br \/>\navg_order_value = df.groupby(&#8216;customer_id&#8217;)[&#8216;order_value&#8217;].mean()<br \/>\npurchase_frequency = df.groupby(&#8216;customer_id&#8217;)[&#8216;order_id&#8217;].count() \/ months<br \/>\ncustomer_lifespan = 1 \/ churn_rate  # months<\/p>\n<p>simple_clv = avg_order_value * purchase_frequency * customer_lifespan<\/p>\n<p># Granular CLV with cohort analysis<br \/>\nimport numpy as np<\/p>\n<p>def calculate_clv_cohort(cohort_data, discount_rate=0.1):<br \/>\n    &#8220;&#8221;&#8221;<br \/>\n    cohort_data: DataFrame with retention rates by period<br \/>\n    discount_rate: Monthly discount rate for NPV<br \/>\n    &#8220;&#8221;&#8221;<br \/>\n    clv = 0<br \/>\n    for period, retention_rate in enumerate(cohort_data[&#8216;retention_rate&#8217;]):<br \/>\n        period_revenue = cohort_data.loc[period, &#8216;revenue_per_user&#8217;]<br \/>\n        discounted_value = period_revenue * retention_rate \/ ((1 + discount_rate) ** period)<br \/>\n        clv += discounted_value<br \/>\n    return clv<\/p>\n<p># Predictive CLV using regression<br \/>\nfrom sklearn.linear_model import LinearRegression<br \/>\nfeatures = [&#8216;recency&#8217;, &#8216;frequency&#8217;, &#8216;monetary&#8217;, &#8216;avg_days_between_orders&#8217;]<br \/>\nmodel = LinearRegression()<br \/>\nmodel.fit(customer_features[features], historical_clv)<br \/>\npredicted_clv = model.predict(new_customers[features])\n            <\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83c\udfaf<\/span><\/p>\n<h3 class=\"card-title\">RFM Analysis<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n<div class=\"template-card\">\n<div class=\"template-title\">RFM Segmentation Code:<\/div>\n<p>import pandas as pd<br \/>\nfrom datetime import datetime, timedelta<\/p>\n<p>def rfm_analysis(df, customer_id=&#8217;customer_id&#8217;, order_date=&#8217;order_date&#8217;, revenue=&#8217;revenue&#8217;):<br \/>\n    # Calculate Recency, Frequency, Monetary<br \/>\n    snapshot_date = df[order_date].max() + timedelta(days=1)<\/p>\n<p>    rfm = df.groupby([customer_id]).agg({<br \/>\n        order_date: lambda x: (snapshot_date &#8211; x.max()).days,  # Recency<br \/>\n        customer_id: &#8216;count&#8217;,                                   # Frequency<br \/>\n        revenue: &#8216;sum&#8217;                                          # Monetary<br \/>\n    }).round(2)<\/p>\n<p>    rfm.columns = [&#8216;Recency&#8217;, &#8216;Frequency&#8217;, &#8216;Monetary&#8217;]<\/p>\n<p>    # Create RFM scores (1-5 scale)<br \/>\n    rfm[&#8216;R_Score&#8217;] = pd.qcut(rfm[&#8216;Recency&#8217;].rank(method=&#8217;first&#8217;), 5,<br \/>\n                            labels=[5,4,3,2,1]).astype(int)<br \/>\n    rfm[&#8216;F_Score&#8217;] = pd.qcut(rfm[&#8216;Frequency&#8217;], 5,<br \/>\n                            labels=[1,2,3,4,5]).astype(int)<br \/>\n    rfm[&#8216;M_Score&#8217;] = pd.qcut(rfm[&#8216;Monetary&#8217;], 5,<br \/>\n                            labels=[1,2,3,4,5]).astype(int)<\/p>\n<p>    # Combine scores<br \/>\n    rfm[&#8216;RFM_Score&#8217;] = rfm[&#8216;R_Score&#8217;].astype(str) + \\<br \/>\n                       rfm[&#8216;F_Score&#8217;].astype(str) + \\<br \/>\n                       rfm[&#8216;M_Score&#8217;].astype(str)<\/p>\n<p>    # Customer segments<br \/>\n    segment_map = {<br \/>\n        r'[4-5][4-5][4-5]&#8217;: &#8216;Champions&#8217;,<br \/>\n        r'[3-5][2-5][3-5]&#8217;: &#8216;Loyal Customers&#8217;,<br \/>\n        r'[3-5][1-3][1-3]&#8217;: &#8216;Potential Loyalists&#8217;,<br \/>\n        r'[4-5][0-1][0-1]&#8217;: &#8216;New Customers&#8217;,<br \/>\n        r'[3-4][0-1][0-1]&#8217;: &#8216;Promising&#8217;,<br \/>\n        r'[2-3][2-3][2-3]&#8217;: &#8216;Customers Needing Attention&#8217;,<br \/>\n        r'[2-3][0-2][0-2]&#8217;: &#8216;About to Sleep&#8217;,<br \/>\n        r'[0-2][2-5][2-5]&#8217;: &#8216;At Risk&#8217;,<br \/>\n        r'[0-1][4-5][4-5]&#8217;: &#8220;Can&#8217;t Lose Them&#8221;,<br \/>\n        r'[1-2][1-2][1-2]&#8217;: &#8216;Hibernating&#8217;,<br \/>\n        r'[0-2][0-2][0-2]&#8217;: &#8216;Lost&#8217;<br \/>\n    }<\/p>\n<p>    rfm[&#8216;Segment&#8217;] = rfm[&#8216;RFM_Score&#8217;].replace(segment_map, regex=True)<br \/>\n    return rfm\n            <\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- Key Metrics & KPIs --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\ud83d\udcca Key Business Metrics &#038; KPIs<\/div>\n<div class=\"metric-grid\">\n<div class=\"metric-card priority-high\">\n<div class=\"metric-title\">\ud83d\udcb0 Revenue Metrics<\/div>\n<p class=\"metric-desc\">Total Revenue, MRR\/ARR, ARPU, Revenue Growth Rate, Revenue per Customer<\/p>\n<\/p><\/div>\n<div class=\"metric-card priority-high\">\n<div class=\"metric-title\">\ud83d\udc65 Customer Metrics<\/div>\n<p class=\"metric-desc\">CAC, CLV, Churn Rate, Retention Rate, NPS, Customer Satisfaction<\/p>\n<\/p><\/div>\n<div class=\"metric-card priority-medium\">\n<div class=\"metric-title\">\ud83d\udcc8 Growth Metrics<\/div>\n<p class=\"metric-desc\">User Growth Rate, Market Share, Viral Coefficient, Organic vs Paid Growth<\/p>\n<\/p><\/div>\n<div class=\"metric-card priority-medium\">\n<div class=\"metric-title\">\u26a1 Operational Metrics<\/div>\n<p class=\"metric-desc\">Conversion Rates, Funnel Analysis, Time to Value, Feature Adoption<\/p>\n<\/p><\/div>\n<div class=\"metric-card priority-low\">\n<div class=\"metric-title\">\ud83d\udcca Engagement Metrics<\/div>\n<p class=\"metric-desc\">DAU\/MAU, Session Duration, Page Views, Bounce Rate, Stickiness Ratio<\/p>\n<\/p><\/div>\n<div class=\"metric-card priority-low\">\n<div class=\"metric-title\">\ud83d\udca1 Product Metrics<\/div>\n<p class=\"metric-desc\">Feature Usage, User Flows, A\/B Test Results, Product-Market Fit Score<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- Data Visualization Best Practices --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\ud83c\udfa8 Data Visualization Best Practices<\/div>\n<div class=\"cards-grid\">\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udcca<\/span><\/p>\n<h3 class=\"card-title\">Chart Selection Guide<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Comparison:<\/strong><br \/>\n            \u2022 <strong>Bar Charts:<\/strong> Compare categories<br \/>\n            \u2022 <strong>Column Charts:<\/strong> Compare values over time<br \/>\n            \u2022 <strong>Horizontal Bar:<\/strong> Long category names<\/p>\n<p>            <strong>Trends &#038; Time Series:<\/strong><br \/>\n            \u2022 <strong>Line Charts:<\/strong> Continuous data over time<br \/>\n            \u2022 <strong>Area Charts:<\/strong> Cumulative values<br \/>\n            \u2022 <strong>Slope Charts:<\/strong> Before\/after comparisons<\/p>\n<p>            <strong>Relationships:<\/strong><br \/>\n            \u2022 <strong>Scatter Plots:<\/strong> Correlation between variables<br \/>\n            \u2022 <strong>Bubble Charts:<\/strong> 3-dimensional relationships<\/p>\n<p>            <strong>Composition:<\/strong><br \/>\n            \u2022 <strong>Pie Charts:<\/strong> Parts of whole (max 7 categories)<br \/>\n            \u2022 <strong>Stacked Bar:<\/strong> Subcategory composition<br \/>\n            \u2022 <strong>Treemap:<\/strong> Hierarchical data\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83c\udfa8<\/span><\/p>\n<h3 class=\"card-title\">Design Principles<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Clarity:<\/strong><br \/>\n            \u2022 Clear, descriptive titles and labels<br \/>\n            \u2022 Appropriate scale and axes<br \/>\n            \u2022 Remove unnecessary elements (chart junk)<br \/>\n            \u2022 Use white space effectively<\/p>\n<p>            <strong>Color Usage:<\/strong><br \/>\n            \u2022 Consistent color scheme<br \/>\n            \u2022 Use color to highlight key insights<br \/>\n            \u2022 Consider colorblind accessibility<br \/>\n            \u2022 Limit to 6-8 colors maximum<\/p>\n<p>            <strong>Typography:<\/strong><br \/>\n            \u2022 Readable font sizes (minimum 10pt)<br \/>\n            \u2022 Consistent font family<br \/>\n            \u2022 Proper hierarchy with font weights<\/p>\n<p>            <strong>Interactivity:<\/strong><br \/>\n            \u2022 Tooltips for additional context<br \/>\n            \u2022 Filters for data exploration<br \/>\n            \u2022 Drill-down capabilities\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udcf1<\/span><\/p>\n<h3 class=\"card-title\">Dashboard Design<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Layout Principles:<\/strong><br \/>\n            \u2022 Most important metrics at top-left<br \/>\n            \u2022 Logical flow and grouping<br \/>\n            \u2022 Consistent spacing and alignment<br \/>\n            \u2022 Mobile-responsive design<\/p>\n<p>            <strong>Information Hierarchy:<\/strong><br \/>\n            \u2022 Executive summary at top<br \/>\n            \u2022 Supporting details below<br \/>\n            \u2022 Use size and position to show importance<\/p>\n<p>            <strong>Performance:<\/strong><br \/>\n            \u2022 Optimize load times<br \/>\n            \u2022 Use aggregated data when possible<br \/>\n            \u2022 Progressive loading for complex dashboards<\/p>\n<p>            <strong>User Experience:<\/strong><br \/>\n            \u2022 Intuitive navigation<br \/>\n            \u2022 Contextual help and explanations<br \/>\n            \u2022 Export and sharing capabilities\n          <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- Essential Tools --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\ud83d\udee0\ufe0f Essential Data Analyst Tools<\/div>\n<div class=\"tools-grid\">\n<div class=\"tool-item\">\n<div class=\"tool-name\">\ud83d\udcca Spreadsheets<\/div>\n<p class=\"tool-desc\">Excel, Google Sheets, Numbers &#8211; fundamental analysis tool<\/p>\n<\/p><\/div>\n<div class=\"tool-item\">\n<div class=\"tool-name\">\ud83d\uddc4\ufe0f SQL Databases<\/div>\n<p class=\"tool-desc\">MySQL, PostgreSQL, SQL Server, BigQuery, Snowflake<\/p>\n<\/p><\/div>\n<div class=\"tool-item\">\n<div class=\"tool-name\">\ud83d\udc0d Programming<\/div>\n<p class=\"tool-desc\">Python, R, SAS &#8211; advanced statistical analysis<\/p>\n<\/p><\/div>\n<div class=\"tool-item\">\n<div class=\"tool-name\">\ud83d\udcc8 Visualization<\/div>\n<p class=\"tool-desc\">Tableau, Power BI, Looker, D3.js, matplotlib, ggplot2<\/p>\n<\/p><\/div>\n<div class=\"tool-item\">\n<div class=\"tool-name\">\ud83d\udcca BI Platforms<\/div>\n<p class=\"tool-desc\">Tableau, Power BI, Qlik Sense, Looker, Sisense<\/p>\n<\/p><\/div>\n<div class=\"tool-item\">\n<div class=\"tool-name\">\ud83e\uddea Experimentation<\/div>\n<p class=\"tool-desc\">Optimizely, Google Optimize, Adobe Target, VWO<\/p>\n<\/p><\/div>\n<div class=\"tool-item\">\n<div class=\"tool-name\">\ud83d\udcf1 Web Analytics<\/div>\n<p class=\"tool-desc\">Google Analytics, Adobe Analytics, Mixpanel, Amplitude<\/p>\n<\/p><\/div>\n<div class=\"tool-item\">\n<div class=\"tool-name\">\ud83d\udd27 Data Processing<\/div>\n<p class=\"tool-desc\">Alteryx, Dataiku, Knime, Trifacta, OpenRefine<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- Analysis Process Framework --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\ud83d\udd04 Data Analysis Process<\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n          <span class=\"card-icon\">\ud83d\udccb<\/span><\/p>\n<h3 class=\"card-title\">Step-by-Step Analysis Framework<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n<div class=\"analysis-phase\">\n<div class=\"phase-title\">1. Define the Problem<\/div>\n<p>            \u2022 Understand business context and objectives<br \/>\n            \u2022 Define specific, measurable questions<br \/>\n            \u2022 Identify key stakeholders and success criteria<br \/>\n            \u2022 Set project timeline and deliverables<br \/>\n            \u2022 Document assumptions and constraints\n          <\/div>\n<div class=\"analysis-phase\">\n<div class=\"phase-title\">2. Data Collection<\/div>\n<p>            \u2022 Identify relevant data sources<br \/>\n            \u2022 Assess data quality and completeness<br \/>\n            \u2022 Extract data using appropriate tools<br \/>\n            \u2022 Document data lineage and definitions<br \/>\n            \u2022 Validate data integrity and accuracy\n          <\/div>\n<div class=\"analysis-phase\">\n<div class=\"phase-title\">3. Data Exploration<\/div>\n<p>            \u2022 Perform initial data profiling<br \/>\n            \u2022 Identify patterns, outliers, and anomalies<br \/>\n            \u2022 Calculate descriptive statistics<br \/>\n            \u2022 Create preliminary visualizations<br \/>\n            \u2022 Formulate hypotheses based on observations\n          <\/div>\n<div class=\"analysis-phase\">\n<div class=\"phase-title\">4. Data Cleaning<\/div>\n<p>            \u2022 Handle missing values appropriately<br \/>\n            \u2022 Remove or correct erroneous data<br \/>\n            \u2022 Standardize formats and units<br \/>\n            \u2022 Create derived variables as needed<br \/>\n            \u2022 Document all transformation steps\n          <\/div>\n<div class=\"analysis-phase\">\n<div class=\"phase-title\">5. Analysis &#038; Modeling<\/div>\n<p>            \u2022 Apply appropriate analytical techniques<br \/>\n            \u2022 Perform statistical tests and validations<br \/>\n            \u2022 Build predictive models if required<br \/>\n            \u2022 Validate results and check assumptions<br \/>\n            \u2022 Interpret findings in business context\n          <\/div>\n<div class=\"analysis-phase\">\n<div class=\"phase-title\">6. Insights &#038; Recommendations<\/div>\n<p>            \u2022 Synthesize key findings and insights<br \/>\n            \u2022 Develop actionable recommendations<br \/>\n            \u2022 Quantify business impact where possible<br \/>\n            \u2022 Address limitations and uncertainties<br \/>\n            \u2022 Prepare compelling data story\n          <\/div>\n<div class=\"analysis-phase\">\n<div class=\"phase-title\">7. Communication &#038; Action<\/div>\n<p>            \u2022 Create executive summary and detailed report<br \/>\n            \u2022 Design effective visualizations<br \/>\n            \u2022 Present findings to stakeholders<br \/>\n            \u2022 Define success metrics for recommendations<br \/>\n            \u2022 Plan follow-up analysis and monitoring\n          <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- Common Challenges --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\u26a0\ufe0f Common Analyst Challenges &#038; Solutions<\/div>\n<div class=\"cards-grid\">\n<div class=\"info-card priority-high\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udd0d<\/span><\/p>\n<h3 class=\"card-title\">Data Quality Issues<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Challenge:<\/strong> Incomplete, inaccurate, or inconsistent data<\/p>\n<p>            <strong>Solutions:<\/strong><br \/>\n            \u2022 Implement data validation checks<br \/>\n            \u2022 Create data quality scorecards<br \/>\n            \u2022 Establish data governance processes<br \/>\n            \u2022 Document data definitions and sources<br \/>\n            \u2022 Use statistical methods to detect anomalies<br \/>\n            \u2022 Collaborate with data engineering teams<br \/>\n            \u2022 Always validate results against business logic\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card priority-high\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83c\udfaf<\/span><\/p>\n<h3 class=\"card-title\">Unclear Requirements<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Challenge:<\/strong> Vague or changing business questions<\/p>\n<p>            <strong>Solutions:<\/strong><br \/>\n            \u2022 Ask clarifying questions upfront<br \/>\n            \u2022 Document requirements and assumptions<br \/>\n            \u2022 Create analysis plan with stakeholder approval<br \/>\n            \u2022 Use iterative approach with regular check-ins<br \/>\n            \u2022 Provide multiple scenarios and options<br \/>\n            \u2022 Educate stakeholders on data limitations<br \/>\n            \u2022 Set realistic expectations for deliverables\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card priority-medium\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\u23f0<\/span><\/p>\n<h3 class=\"card-title\">Time Constraints<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            <strong>Challenge:<\/strong> Pressure for quick turnaround on analysis<\/p>\n<p>            <strong>Solutions:<\/strong><br \/>\n            \u2022 Prioritize high-impact analysis<br \/>\n            \u2022 Use automated tools and templates<br \/>\n            \u2022 Focus on key metrics and insights<br \/>\n            \u2022 Communicate trade-offs clearly<br \/>\n            \u2022 Build reusable analysis frameworks<br \/>\n            \u2022 Invest in self-service analytics<br \/>\n            \u2022 Manage stakeholder expectations proactively\n          <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- Best Practices --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\u2705 Data Analysis Best Practices<\/div>\n<div class=\"cards-grid\">\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udcca<\/span><\/p>\n<h3 class=\"card-title\">Analysis Quality<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            \u2022 <strong>Reproducibility:<\/strong> Document all steps and code<br \/>\n            \u2022 <strong>Version Control:<\/strong> Track changes in analysis<br \/>\n            \u2022 <strong>Peer Review:<\/strong> Have colleagues check your work<br \/>\n            \u2022 <strong>Statistical Rigor:<\/strong> Use appropriate tests and methods<br \/>\n            \u2022 <strong>Validation:<\/strong> Cross-check results with multiple approaches<br \/>\n            \u2022 <strong>Sensitivity Analysis:<\/strong> Test robustness of conclusions<br \/>\n            \u2022 <strong>Ethical Considerations:<\/strong> Avoid bias and misrepresentation\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udcac<\/span><\/p>\n<h3 class=\"card-title\">Communication<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            \u2022 <strong>Know Your Audience:<\/strong> Tailor message to stakeholders<br \/>\n            \u2022 <strong>Tell a Story:<\/strong> Create narrative around data<br \/>\n            \u2022 <strong>Focus on Insights:<\/strong> Not just data, but what it means<br \/>\n            \u2022 <strong>Visual Design:<\/strong> Clear, effective charts and dashboards<br \/>\n            \u2022 <strong>Action-Oriented:<\/strong> Provide specific recommendations<br \/>\n            \u2022 <strong>Confidence Levels:<\/strong> Express uncertainty appropriately<br \/>\n            \u2022 <strong>Follow Up:<\/strong> Track impact of recommendations\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\ude80<\/span><\/p>\n<h3 class=\"card-title\">Continuous Improvement<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            \u2022 <strong>Stay Current:<\/strong> Learn new tools and techniques<br \/>\n            \u2022 <strong>Industry Knowledge:<\/strong> Understand business domain<br \/>\n            \u2022 <strong>Automation:<\/strong> Streamline repetitive tasks<br \/>\n            \u2022 <strong>Collaboration:<\/strong> Work closely with stakeholders<br \/>\n            \u2022 <strong>Feedback Loop:<\/strong> Learn from analysis outcomes<br \/>\n            \u2022 <strong>Knowledge Sharing:<\/strong> Document and share learnings<br \/>\n            \u2022 <strong>Experimentation:<\/strong> Test new approaches regularly\n          <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>    <!-- Career Development --><\/p>\n<div class=\"section\">\n<div class=\"section-title\">\ud83c\udfaf Data Analyst Career Development<\/div>\n<div class=\"cards-grid\">\n<div class=\"info-card priority-high\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83d\udcbb<\/span><\/p>\n<h3 class=\"card-title\">Technical Skills<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            \u2022 <strong>Statistical Analysis:<\/strong> Hypothesis testing, regression, ANOVA<br \/>\n            \u2022 <strong>SQL Proficiency:<\/strong> Complex queries, window functions, CTEs<br \/>\n            \u2022 <strong>Excel\/Sheets:<\/strong> Advanced functions, pivot tables, macros<br \/>\n            \u2022 <strong>Programming:<\/strong> Python\/R for data analysis<br \/>\n            \u2022 <strong>Visualization:<\/strong> Tableau, Power BI, or similar tools<br \/>\n            \u2022 <strong>Database Knowledge:<\/strong> Understanding of data models<br \/>\n            \u2022 <strong>A\/B Testing:<\/strong> Experimental design and analysis\n          <\/div>\n<\/p><\/div>\n<div class=\"info-card priority-medium\">\n<div class=\"card-header\">\n            <span class=\"card-icon\">\ud83e\udde0<\/span><\/p>\n<h3 class=\"card-title\">Business Acumen<\/h3>\n<\/p><\/div>\n<div class=\"card-content\">\n            \u2022 <strong>Industry Knowledge:<\/strong> Understanding your domain<br \/>\n            \u2022 <strong>Business Metrics:<\/strong> KPIs and success measures<br \/>\n            \u2022 <strong>Strategic Thinking:<\/strong> Connect data to business outcomes<br \/>\n            \u2022 <strong>Process Understanding:<\/strong> How business operations work<br \/>\n            \u2022 <strong>Stakeholder Management:<\/strong> Understanding different needs<br \/>\n            \u2022 <strong>Project Management:<\/strong> Organizing and prioritizing work<br \/>\n            \u2022 <strong>Change Management:<\/strong> Driving adoption of insights\n          <\/div>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\ud83d\udcca Data Analyst Cheat Sheet Complete guide to data analysis techniques, tools, statistical methods, and visualization best practices \ud83c\udfaf Core Analysis Concepts \ud83d\udd0d Types of Data Analysis Four levels of <span class=\"readmore\"><a href=\"https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/\">Read More &#8230;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2452,248],"tags":[],"class_list":["post-4329","post","type-post","status-publish","format-standard","hentry","category-cheat-sheet","category-data-analytics"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data Analyst Cheat Sheet | Uplatz Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Analyst Cheat Sheet | Uplatz Blog\" \/>\n<meta property=\"og:description\" content=\"\ud83d\udcca Data Analyst Cheat Sheet Complete guide to data analysis techniques, tools, statistical methods, and visualization best practices \ud83c\udfaf Core Analysis Concepts \ud83d\udd0d Types of Data Analysis Four levels of Read More ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Uplatz Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Uplatz-1077816825610769\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-08T00:10:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-08T00:13:34+00:00\" \/>\n<meta name=\"author\" content=\"uplatzblog\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@uplatz_global\" \/>\n<meta name=\"twitter:site\" content=\"@uplatz_global\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"uplatzblog\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/data-analyst-cheat-sheet\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/data-analyst-cheat-sheet\\\/\"},\"author\":{\"name\":\"uplatzblog\",\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/#\\\/schema\\\/person\\\/8ecae69a21d0757bdb2f776e67d2645e\"},\"headline\":\"Data Analyst Cheat Sheet\",\"datePublished\":\"2025-08-08T00:10:15+00:00\",\"dateModified\":\"2025-08-08T00:13:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/data-analyst-cheat-sheet\\\/\"},\"wordCount\":3172,\"publisher\":{\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/#organization\"},\"articleSection\":[\"Cheat Sheet\",\"Data Analytics\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/data-analyst-cheat-sheet\\\/\",\"url\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/data-analyst-cheat-sheet\\\/\",\"name\":\"Data Analyst Cheat Sheet | Uplatz Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/#website\"},\"datePublished\":\"2025-08-08T00:10:15+00:00\",\"dateModified\":\"2025-08-08T00:13:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/data-analyst-cheat-sheet\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/uplatz.com\\\/blog\\\/data-analyst-cheat-sheet\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/data-analyst-cheat-sheet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Analyst Cheat Sheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/\",\"name\":\"Uplatz Blog\",\"description\":\"Uplatz is a global IT Training &amp; Consulting company\",\"publisher\":{\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/#organization\",\"name\":\"uplatz.com\",\"url\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/Uplatz-Logo-Copy-2.png\",\"contentUrl\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/Uplatz-Logo-Copy-2.png\",\"width\":1280,\"height\":800,\"caption\":\"uplatz.com\"},\"image\":{\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/Uplatz-1077816825610769\\\/\",\"https:\\\/\\\/x.com\\\/uplatz_global\",\"https:\\\/\\\/www.instagram.com\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/7956715?trk=tyah&amp;amp;amp;amp;trkInfo=clickedVertical:company,clickedEntityId:7956715,idx:1-1-1,tarId:1464353969447,tas:uplatz\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/uplatz.com\\\/blog\\\/#\\\/schema\\\/person\\\/8ecae69a21d0757bdb2f776e67d2645e\",\"name\":\"uplatzblog\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7f814c72279199f59ded4418a8653ad15f5f8904ac75e025a4e2abe24d58fa5d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7f814c72279199f59ded4418a8653ad15f5f8904ac75e025a4e2abe24d58fa5d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7f814c72279199f59ded4418a8653ad15f5f8904ac75e025a4e2abe24d58fa5d?s=96&d=mm&r=g\",\"caption\":\"uplatzblog\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Analyst Cheat Sheet | Uplatz Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/","og_locale":"en_US","og_type":"article","og_title":"Data Analyst Cheat Sheet | Uplatz Blog","og_description":"\ud83d\udcca Data Analyst Cheat Sheet Complete guide to data analysis techniques, tools, statistical methods, and visualization best practices \ud83c\udfaf Core Analysis Concepts \ud83d\udd0d Types of Data Analysis Four levels of Read More ...","og_url":"https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/","og_site_name":"Uplatz Blog","article_publisher":"https:\/\/www.facebook.com\/Uplatz-1077816825610769\/","article_published_time":"2025-08-08T00:10:15+00:00","article_modified_time":"2025-08-08T00:13:34+00:00","author":"uplatzblog","twitter_card":"summary_large_image","twitter_creator":"@uplatz_global","twitter_site":"@uplatz_global","twitter_misc":{"Written by":"uplatzblog","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/#article","isPartOf":{"@id":"https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/"},"author":{"name":"uplatzblog","@id":"https:\/\/uplatz.com\/blog\/#\/schema\/person\/8ecae69a21d0757bdb2f776e67d2645e"},"headline":"Data Analyst Cheat Sheet","datePublished":"2025-08-08T00:10:15+00:00","dateModified":"2025-08-08T00:13:34+00:00","mainEntityOfPage":{"@id":"https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/"},"wordCount":3172,"publisher":{"@id":"https:\/\/uplatz.com\/blog\/#organization"},"articleSection":["Cheat Sheet","Data Analytics"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/","url":"https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/","name":"Data Analyst Cheat Sheet | Uplatz Blog","isPartOf":{"@id":"https:\/\/uplatz.com\/blog\/#website"},"datePublished":"2025-08-08T00:10:15+00:00","dateModified":"2025-08-08T00:13:34+00:00","breadcrumb":{"@id":"https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/uplatz.com\/blog\/data-analyst-cheat-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/uplatz.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Analyst Cheat Sheet"}]},{"@type":"WebSite","@id":"https:\/\/uplatz.com\/blog\/#website","url":"https:\/\/uplatz.com\/blog\/","name":"Uplatz Blog","description":"Uplatz is a global IT Training &amp; Consulting company","publisher":{"@id":"https:\/\/uplatz.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/uplatz.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/uplatz.com\/blog\/#organization","name":"uplatz.com","url":"https:\/\/uplatz.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/uplatz.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/uplatz.com\/blog\/wp-content\/uploads\/2016\/11\/Uplatz-Logo-Copy-2.png","contentUrl":"https:\/\/uplatz.com\/blog\/wp-content\/uploads\/2016\/11\/Uplatz-Logo-Copy-2.png","width":1280,"height":800,"caption":"uplatz.com"},"image":{"@id":"https:\/\/uplatz.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Uplatz-1077816825610769\/","https:\/\/x.com\/uplatz_global","https:\/\/www.instagram.com\/","https:\/\/www.linkedin.com\/company\/7956715?trk=tyah&amp;amp;amp;amp;trkInfo=clickedVertical:company,clickedEntityId:7956715,idx:1-1-1,tarId:1464353969447,tas:uplatz"]},{"@type":"Person","@id":"https:\/\/uplatz.com\/blog\/#\/schema\/person\/8ecae69a21d0757bdb2f776e67d2645e","name":"uplatzblog","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7f814c72279199f59ded4418a8653ad15f5f8904ac75e025a4e2abe24d58fa5d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7f814c72279199f59ded4418a8653ad15f5f8904ac75e025a4e2abe24d58fa5d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7f814c72279199f59ded4418a8653ad15f5f8904ac75e025a4e2abe24d58fa5d?s=96&d=mm&r=g","caption":"uplatzblog"}}]}},"_links":{"self":[{"href":"https:\/\/uplatz.com\/blog\/wp-json\/wp\/v2\/posts\/4329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/uplatz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/uplatz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/uplatz.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/uplatz.com\/blog\/wp-json\/wp\/v2\/comments?post=4329"}],"version-history":[{"count":1,"href":"https:\/\/uplatz.com\/blog\/wp-json\/wp\/v2\/posts\/4329\/revisions"}],"predecessor-version":[{"id":4330,"href":"https:\/\/uplatz.com\/blog\/wp-json\/wp\/v2\/posts\/4329\/revisions\/4330"}],"wp:attachment":[{"href":"https:\/\/uplatz.com\/blog\/wp-json\/wp\/v2\/media?parent=4329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/uplatz.com\/blog\/wp-json\/wp\/v2\/categories?post=4329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/uplatz.com\/blog\/wp-json\/wp\/v2\/tags?post=4329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}