make simple competitor analysis with power bi and clickhouse
make simple competitor analysis with power bi and clickhouse
Embedded Files
Consider a scenario where we have competitors, and our aim is to comprehend and track how we share market volume with them. To meet this objective, we've identified key metrics that accurately capture the entire situation and provide a comprehensive explanation. In this hypothetical scenario, the 'Engagement' report from SimilarWeb emerges as the ideal solution, covering all our analytical needs
However, we require this data in raw form for several reasons:
To collect it as a contingency in case we no longer have access to SimilarWeb.
To perform additional calculations as needed.
To reuse the data in various reports.
To consolidate report generation in a single location
dataflow architecture
dataflow architecture
similarweb generate json data like most regular API's
store and transform in clickhouse
all scripts have placed to git hub https://github.com/yugin-pro/clickhouse
connect Power BI to clickhouse and create data model
create data visualisation and models
Conclusion: In my opinion, for tasks such as conducting market analysis, the technological combination of ClickHouse and Power BI is a considerable option. It provides possibilities to address issues related to collecting, transforming, and analyzing data in a short amount of time without requiring strong technical skills. Each tool is highly flexible and comes with powerful features
Page updated
Google Sites
Report abuse