Data Analyst: Free Skill Evaluation

What Is Data Analytics? Types of Analytics Role of Data Analyst Data Analyst Workflow Business Problem Framing Metrics vs KPIs Business Dimensions Business Measures Root Cause Thinking Excel Interface Data Entry Formatting Number Formats Sort & Filter Freeze Panes Tables Arithmetic Functions Conditional Functions Conditional Aggregation Lookup Functions Text Functions Date Functions Dynamic Array Concepts Data Validation Conditional Formatting Named Ranges Advanced Lookup Problems Error Handling What-If Analysis PivotTable Fundamentals Rows / Columns / Values / Filters Aggregations Grouping Calculated Fields Concepts Slicers Timelines PivotCharts Dashboard Principles KPI Cards Interactive Filters Chart Selection Dashboard Layout Executive Dashboard Design Power Query Fundamentals Import Data Data Types Remove / Rename Columns Filter Rows Replace Values Handle Null Values Split Columns Merge Columns Pivot / Unpivot Merge Queries Append Queries Conditional Columns Custom Columns Group By Folder-Based Automation Query Dependencies M Language Concepts Database Concepts Relational Databases Primary Keys Foreign Keys Relationships Normalization Concepts SELECT DISTINCT WHERE AND / OR IN BETWEEN LIKE NULL ORDER BY LIMIT COUNT SUM AVG MIN / MAX GROUP BY HAVING INNER JOIN LEFT JOIN RIGHT JOIN Concepts FULL JOIN Concepts Self Join Multiple Joins String Functions Numeric Functions CASE WHEN COALESCE NULLIF Subqueries CTE Window Functions Running Totals Moving Average Ranking Month-over-Month Growth Year-over-Year Growth Percent Contribution First / Last Purchase Customer Lifetime Metrics Funnel Analysis Cohort Analysis Retention Repeat Customer Rate Customer Segmentation Product Ranking Revenue Analysis Churn Analysis What Is Power BI? Power BI Workflow Data Sources Cardinality Filter Direction Fact Tables Dimensions Star Schema Snowflake Schema Date Dimension Role-Playing Dimensions Concepts Model Optimization Calculated Column vs Measure Measures DISTINCTCOUNT DIVIDE IF SWITCH CALCULATE Filter Context Row Context Context Transition Concepts FILTER ALL REMOVEFILTERS VALUES SELECTEDVALUE SUMX AVERAGEX RELATED Time Intelligence Growth Measures Rolling Metrics Bar Charts Line Charts Area Charts Tables & Matrix Scatter Plot Maps Concepts Decomposition Tree Concepts Waterfall Funnel Drill Down Drill Through Tooltips Bookmarks Buttons Dynamic Titles Visual Hierarchy Color Usage Accessibility Data-Ink Principles Mobile Layout Concepts Executive Report Design Self-Service Analytics Publishing Workspaces Semantic Models Refresh Scheduled Refresh Gateways Concepts Apps Concepts Sharing & Collaboration Permissions Row-Level Security Workspace Security Deployment Concepts Model Size Efficient DAX Power Query Optimization Query Folding Concepts Performance Analyzer Microsoft Fabric Fundamentals OneLake Concepts Lakehouse Awareness Warehouse Awareness Fabric + Power BI Relationship AI-Assisted Fabric Analytics Concepts Mean Median Mode Variance Standard Deviation Percentile Distribution Outliers Correlation Correlation vs Causation Probability Fundamentals Conditional Probability Normal Distribution Concepts Sampling Bias Null Hypothesis Alternative Hypothesis P-Value Concepts Confidence Intervals T-Test Concepts Chi-Square Concepts Statistical vs Business Significance Control Group Treatment Group Conversion Rate Lift Significance Experiment Interpretation Why Python for Analysts? Variables Lists Dictionaries Conditions Loops Functions Files Arrays Mathematical Operations Missing Values Concepts Series DataFrames Read CSV Read Excel Read SQL Filtering Sorting Missing Values Duplicates GroupBy Merge Pivot Date Handling Apply Matplotlib Histograms Scatter Plots Time-Series Charts Choosing the Right Chart Revenue Analytics Profit Analysis Customer Analytics Product Analytics Channel Analytics Regional Analytics Sales KPIs Salesperson Performance Territory Performance Forecast vs Actual Impressions Clicks CTR CPA CAC ROAS Campaign Analysis Customer Acquisition Churn Repeat Customers Purchase Frequency Average Order Value Customer Lifetime Value Concepts RFM Segmentation Active Users DAU / WAU / MAU Engagement Feature Usage Drop-Off Revenue Expenses Gross Margin Profit Budget vs Actual Variance Analysis SLA Turnaround Time Productivity Failure Rate Process Bottlenecks Capacity Headcount Attrition Hiring Funnel Attendance Performance Diversity Metrics Concepts Observation vs Insight Story Structure Executive Summaries Presenting Recommendations Handling Questions Communicating Uncertainty Completeness Accuracy Validity Consistency Uniqueness Timeliness Data Quality Checks Metric Definitions Single Source of Truth Data Ownership Documentation Data Dictionary Report Ownership Sensitive Data Least Privilege Report Permissions Data Export Risks Secure Sharing Generative AI Fundamentals AI-Assisted Excel AI-Assisted SQL AI-Assisted Power BI Prompt Engineering for Analysts AI-Assisted Data Cleaning AI-Assisted Insight Generation Natural Language Analytics AI-Generated Summary Validation AI Privacy Repetitive Reporting Power Query Automation Python Automation Scheduled Refresh Concepts Automated Reports Alerting Concepts Stakeholder Interviews Dashboard Requirements Acceptance Criteria Avoiding Scope Creep Requirement Data Source Cleaning Modeling Analysis Dashboard Validation Stakeholder Review Publication Maintenance Professional Data Analyst Portfolio Enterprise Business Intelligence & Analytics Platform