Materialized Views Do Not Exist in MySQL.
Flexviews has been recommended in the DBA StackExchange before
Since you have it already, some due diligence and elbow grease on your part may be necessary to get going on using it (if you haven't already done so)
You might look into setting up Summary Tables. You are going to need to index your base tables in order to support aggregation before building Summary Tables.
Here is an old post from http://www.materialized.info/ which has a more down-to-earth strategy that looks intriguing. It involves using triggers. Looks like it could be fun ...
If your base tables are not that big and you can live with querying entire tables once a week, try the
User Comments section of the MySQL Documentation on CREATE VIEW for ideas. Search for word
materialized on that page.