Pyramid software data collection

Here are the first files for your home hands-on case study.   To get started with the solution, please use the videos made available online by the vendor. The  video  here gives you the first basic steps as well. Beyond this, the logic will always be the same and using right clicks should give you access to all relevant menu. Know that discovery and learning by doing is an essential part of your data journey.   Let’s get to the case itself. Building Blocks to insight Lego has been around for 60 years. After decades of growth, it almost went bankrupt. And then it recovered by fixing it operations, being a bit opportunistic and finally capturing new markets. What do numbers tell us? Read the article:  How Lego Made a Huge Turn Around  and see how you can illustrate it by the numbers over the next 2 weeks.   Your goal for this week is to load the data in your analytics/BI solution and get a first take at the fact table:  set.csv . It contains all the sets since the creation of Lego.   Once loaded, run a few analysis such as the ones on the video. Try to start with a question. A few things you will see:

· You can rapidly get to a very clean representation of your data

· 11k rows is a very small dataset that runs smoothly

· You see that 2 types of data are available: Facts (that you measure) and Dimensions (that you structure the data with) and most of them can be switched, provided you give them the right aggregation method.

· The available metrics must be adjusted to remain meaningful when aggregated

After a few iterations, you’ll see short-comings:

· You need more details

· Data would be relevant if connected with more information

· Data can’t really be grasped as it is very granular 

A complementary data set will be shared next week to take you to the next steps, once you get acquainted with the process. Gauthier