All geek questions in one place

How can I architect and execute individual reporting on my own?

What type of architecture, design, and software will need to provide something similar to the excellent custom report features provided by google analytics. To be more specific, we want the user to be able to specify parameters and indicators from the list and create a report.

  • Do we need a data warehouse?
  • Do we need OLAP?
  • Will layer access require ORM, dynamic sql, or stored procedures?
  • Are there any 3rd party or open source products that can where we are?

Is there anyone else (company, developer) who even performed this function at the Google level? Example?

Note

I'm not interested in creating a competitor to Google Analytics. I am looking to apply ease of reporting to our own unique datasets.

thanks

+3
source share
2 answers

You definitely need a data warehouse with lots of ETL, agg, and pre-agg processes that work outside of business hours. OLAP cubes really don't scale for high volume web analytics.

, , MSMQ . Disk I/O - , , , , . Microsoft , . log parser) ETL .

, , . . , . , .

+1

, http://haveamint.com/. , , .

Piwik (http://piwik.org/) - .

Google Analytics, . , .

0

Source: https://habr.com/ru/post/1708760/

More articles:


All Articles