1. User Interface: Metabase has a simple and clean user interface that caters more towards beginners and non-technical users, while Periscope offers a more advanced and feature-rich interface that is preferred by data analysts and experienced users.
2. Connectivity: Metabase has a limited number of data source connectors available compared to Periscope, which has a wide range of integrations with various databases and tools, making it more versatile for different use cases.
3. Collaboration Features: Periscope provides more robust collaboration features such as commenting, sharing dashboards, and scheduling reports, allowing teams to work together seamlessly, while Metabase lacks some of these advanced collaboration functionalities.
4. Customization Options: Periscope offers more options for customizing and designing dashboards and reports according to specific requirements, whereas Metabase has fewer customization capabilities, limiting the flexibility in visualizing data.
5. Data Transformation: Periscope has more advanced data transformation features like SQL editor, advanced analytics, and machine learning integrations, allowing users to manipulate and analyze data in more sophisticated ways compared to Metabase.
6. Cost: Metabase is an open-source tool with a free version available, making it more cost-effective for smaller organizations or individuals, while Periscope is a paid platform, which might be more suitable for larger enterprises with advanced analytics needs.

In Summary, Metabase is a beginner-friendly and cost-effective option with limited customization and collaboration features, while Periscope offers advanced functionalities for data analysts and teams at a higher cost.