📔Data Profiling
Now that the data has been examined and some initial cleaning has taken place, it’s time to assess the quality of the characteristics of the dataset. This includes its structure, content, and relationships between variables. This step is important because it’s used to identify any issues or inconsistencies in the data. Data analysts can use these tools to examine the data and produce reports on key aspects, such as data types, ranges, distributions, and so on. To differentiate from data exploration, data profiling is focused on the quality of the data, whereas data exploration is meant to better understand the data.
Metabase
Metabase is an easy-to-use data exploration tool that allows even non-technical users to ask questions and gain insights. This business intelligence and user experience tool allows you to build interactive dashboards, models for cleaning tables, and set up alerts to notify users when your data changes. You can even connect directly to 20+ data sources to work with data within minutes.
Lightdash
A popular open-source business intelligence tool, Lightdash is designed for dbt (data build tool), and allows data analysts and engineers to control all of their business intelligence tools in a single place, bridging the gap between the transformation and visualization layers. The tool is a full-stack BI platform, so analysts can write their metrics in-house, enabling the entire business to work with the data with ease.
Perspective
Perspective is an interactive analytics and data visualization component, which is especially well-suited for large and/or streaming datasets. This tool allows users to create easily-configurable reports, dashboards, notebooks, and applications.
Apache Doris
Built on an MPP (massively parallel processing) architecture, this tool from Apache is a high-performance, real-time analytics database, known for speed and ease of use. Apache Doris can better meet the scenarios of report analysis, ad-hoc query, unified data warehouse, Data Lake Query Acceleration, etc. Users can build user behavior analysis, AB test platform, log retrieval analysis, user portrait analysis, order analysis, and other applications on top of this.
Last updated
