Regardless of which data warehouse paradigm you follow or have
heard of, Kimball or Inmon. We should all agree that the data
warehouse is often a requirement for business. Different people
want different things and they all want it from your data. The
data warehouse is not a new concept and yet they are over looked
at times. A warehouse is never complete, it is an evolving entity
that adjusts with the requirements it is given. It is up to us to
make sure that the access to enterprise data in an accurate and
timely manner is easy and the standard. MySQL can handle a data
warehouse perfectly.
MySQL databases are designed in numerous ways, some good some
bad. A warehouse can take that data and organize it for the best
use of others. What concerns or issues do you often hear when it
comes to gathering data from your database? It is easy for all of
your developers to query and get the same data? How many ways
does your company slice and dice data? …
This Thursday (July 2nd, 13:00 UTC), Roland Bouman will will take the Sakila sample database and explain how to design and load a data warehouse for it, and how to use that to create those reports and charts that make managers smile. Along the way, he'll explain often uttered terms and concepts such as dimensional model, denormalization, star schema, OLAP, data staging, business intelligence, ETL and data integration. Roland's session is titled Starring Sakila - A Data Warehouse Mini-Tutorial.
For MySQL University sessions, point your browser to this page. You need a browser with …
[Read more]This Thursday (July 2nd, 13:00 UTC), Roland Bouman will will take the Sakila sample database and explain how to design and load a data warehouse for it, and how to use that to create those reports and charts that make managers smile. Along the way, he'll explain often uttered terms and concepts such as dimensional model, denormalization, star schema, OLAP, data staging, business intelligence, ETL and data integration. Roland's session is titled Starring Sakila - A Data Warehouse Mini-Tutorial.
For MySQL University sessions, point your browser to this page. You need a browser with …
[Read more]