How do I start building database with analytics?

Question

As a newbie, I've built three websites. Now I want to start building web apps with databases and analytics, that will help users make informed decisions. Which programming language would be best for this kind of project? Secondly, what other things should be put into consideration?

Any suggestion is highly appreciated.

Answer 1

You should have a good understanding of datawarehouses, regardless of any programming language, and the concepts of dimensions and metrics. For the actual loading and reporting, you'll need SQL for sure. Plus, almost any programming language can help you build the ETLs, and HTML+CSS+JS could help you build the reporting.

Answer 2

sql