Friday, 9 October 2015

Using RDF Data Cube Vocabulary to model sales data with Fluent Editor - Example.

RDF Data Cube Vocabulary is a way to represent data in popular format with link data paradigms. Linked data is an approach to publishing data on a web and this vocabulary makes it possible. There are numerous benefits to linked data. The individual observations, and groups of observations, become (web) addressable. This allows publishers ad third parties to annotate and link to this data. For example a report can reference the specific figures it is based on allowing for fine grained provenance trace-back. Representing any data set with these benefits is now possible with Controlled Natural Language in Fluent Editor and it has never been so easy.

In this article you will learn:

  • How to represent data set as an OLAP Cube when there is one or several measures included.
  • How to slice the cube with the help of RDF Data Cube vocabulary in Fluent Editor.
  • How to solve problems when there are multiple measures.
Using OLAP Cube with Fluent Editor and RDF Data Cube Vocabulary.

    Follow along: Single Measure Example.
    Let's introduce set of sales data.

    It is great array to analyse since it shows correlation between spending on advertisements in TV or the Internet. Therefore, column 'Online_Ad_Spend' and 'TV_Ad_Spend' can be thought of both: measure and dimension (but not in the same time).

    First we declare data structure and then we define it (first line). Definition of dimension and measure, according to official documentation, requires us to declare some blank nodes (Dimension-X and Measure-1 where X is an element from set {1,2,3,4}).

    It is clearly seen that we use references to RDF Data Cube Vocabulary by calling '[qb]'.

    We define dimensions as:

  • Ref-Week is the 'Week' column (dimension)
  • Ref-Store-Id is the 'Store id' column (dimension)
  • Ref-Tv-Ad-Spend is the 'TV_Ad_Spend' column (dimension)
  • Ref-Online-Ad-Spend is the 'Online_Ad_Spend' column (dimension)
  • Ref-Sales is the 'Sales' column (measure)

    Previously we said that we have a data structure but why? We have to define our data set and say that it has the same structure as we defined earlier. (fig-5)
Now we are defining slice key and correlate it with data structure.

    So we can say that our Week dimension is a slice key.

     The very first five lines are used to define that our data set really has components which has dimension which are indeed dimensions. But we need to do it explicitly.

     Then to each slice we assign observation. (O-XY where XY is two-element subset of a {0,1,2,3,4,5,6,7,8,9}).

     It is very important to insert sentences in fig-8 because of Open World Assumption paradigms.

    As we can see we assign to each slice a value of a dimension (week) and to each observation (mapped to proper slice) we assign values of dimensions we look at (there's only one for each dimension because of this specific data array).

    After that we assign to the observation the value of what we measure. (has-ref-sales)
How to interpret the results? Each slice just shows what is our sales value in respect to values of spending dimensions. Let's say we want to see how well the company did in a certain week.

    We see that Slice-18 contains corresponding week and it has one observation called O-181. With this information in mind let's ask again.

    As we can see Fluent Editor provides necessary tools to comprehensively analyse data.

But what if I treated spending and sales as a measure?

    This approach would allow us to look at data differently. We would perceive the data as if it was a function of time (week) and it would map to spending on advertisements on tv , spending on advertisements on the Internet and sales.
    We would need different approach if we were to do that. Follow along: Multiple Measure First Example

Handling multiple measurements.

    As we can see from the picture above all we did is define three measurements in our data structure. 

    Again the very first four lines are just to make sure we do everything with Open World Assumption paradigms. Then we proceed as in previous examples (O-X is an observation where X is a one-element subset od {1,2,3,4,5,6,7,8,9,0}).
but we simply make three measurements. However is this a good way to do it?

It is not possible to attach an attribute to a single observed value

We need to understand that these measurements are applied to the whole O-X observation. The best way to use it would be if the measurement would be for e.g indication who made the observation. Therefore, it is better to use a different approach.

Multiple dimension.

    There is a very clever way to solve the problem described above. We need to define an abstract dimension which values would be different measurements.

 As we can see we defined three separate measurements, however in addition to our components abstract dimension was defined ('Dimension-Special'). We used measure-type as an abstract dimension which automatically gets measures declared in data structure definition.

    As shown in the fig-13 we have defined observations and we can see that for each observation there is only one measure. Our problem is solved.

    How to interpret our cube? It is single dimensional therefore we can think of it as a sliced snake which has several values assigned to each slice.


    With Fluent Editor it is possible to use RDF Data Cube Vocabulary to describe any data set in natural way. Not only is it easy but also provides good foundations for our data set so it can be easily linked, annotated and referenced. For instance, if you are working in scientific community this is the way to publish data since it can be cited in great number of articles. 
    RDF Data Cube Vocabulary combined with Fluent Editor provides excellent, easy to use tools so you can benefit from them.


  1. Excellent post share college paper writing service reviews with us and this blog is impresses more people to reading that blog

  2. This approach would allow us to look at data differently. We would perceive the data as if it was a function of time and it would map to spending on advertisements on tv, spending on advertisements on the Internet and sales. After that we assign to the observation the value of getacademichelp . How to interpret the results? Each slice just shows what is our sales value in respect to values of spending dimensions.

  3. Thank you for the tutorial. There are tons of tools on the internet but for some reason only few have actual tutorials on how to use them. And since I often need to publish multi-dimensional data and link it to data sets and concepts, I can't afford to test out each of the tools I can find. the reviews on thesishelp do help a bit but they are no professionals in statistics.

  4. Thank you for this guide! I just got done with my cheap essay writing service UK based and now I am thinking to use Fluent Editor to model the sales data of my father’s business. But I just couldn’t figure how. But now with this guide, I think I can do it easily. Looking forward to it.

  5. I truly appreciate this post. I have been looking everywhere for this! Thank goodness I found it on Bing. You have made my day! leather aviator jacket

  6. RDF is a standard for data interchange that is used for representing highly interconnected data. wood floor water damage repair

  7. RDF is metadata (data about data). RDF is used to describe information resources. nj demolition

  8. Fortune Jackets care for your fashion Get Half Black Half White Leather Jacket In Just $99.99 Grab it fast.

    Half Black Half White Leather Jacket

  9. If you are pursuing in college to complete your higher studies, I think you must know the complications involved in the subjects. Irrespective of the effort you put in to acquire a vivid idea, you are likely to face difficulties while drafting an assignment. May you are searching for a good writer for college assignment help. For more information visit now! Our support is live 24/7 for better assistance.

    Our Services:

    Psychology Assignment Help | Honda Europe Case Study | Gillette Case Study | Nike Case Study | Marks and Spencer Case Study

  10. I am always looking forward to read the neat and clean quote. For this purpose, I found your content slogan effective and impressive. If we make to amicable environment to do work prosperity, then you attach with quotation of Assignment Help. In fact, it would be really helpful for you. Not only for you, but other people can access great knowledge with you.

  11. Wow! Great quality content. Are you also looking for Finance assignment help Canada because you do not know how to make top-quality projects? Take the academic writing assistance from professional writers and get the top-class projects written in the least amount of time.

  12. One approach for students to complete their assignments on time is to seek assignment assistance. Different solutions are available on assignment assistance websites, and some even provide services to do the homework in less than 24 hours. Students have the option of selecting "affordable research papers," and if they do, they will be allocated a personal research paper helper. This research paper will ensure that they write in the student's style, meet deadlines, and provide high-quality work.

  13. This is a fantastic post. We continue to offer only the most authentic and dependable coursework helper at reasonable prices to students. We continue to thrive on the trust that our customers have placed in us as we continue to provide them with security and privacy. They rely on us whenever they mention their payment information or when they require assistance with their assignments.

  14. The majority of people believe that hiring writing pros is outrageously expensive. However, because the majority of consumers are students on a restricted budget, such services are extremely affordable. As a result, everyone in need of academic aid can afford the services. If you want high-quality help with paper, engage a professional writer from a legitimate and reputable writing service, and you will never be sorry.

  15. Looking for Finance assignment help? Then, at that point, you are at the perfect location, we are one of the most mind-blowing finance task aides. The tasks concerning finance are specialized and need inside and out subject mastery commonly. That is the reason you want master proficient essayists for finishing your task.

  16. Incredible blog you posted and gives significant information to us. Like you I likewise need to share data about Assignment Help Online (what is it and why understudies choose online assignments). So visit our website and give us your important remarks.

  17. Make sure the surface where you are placing the printer is clean and close to Pc or laptop.Check the shipped components with your inkjet printer
    http //,
    https //ij.start.cannon

  18. Canon IJ Network Tool will get you through the network settings uninterruptedly. It is essentially required when you are attempting to get your printer connected to a different network because a new network tends to reset the printer’s existing network settings.The Canon IJ Printer Utility can be used to keep a check on your printer’s ink levels and cartridges and clean the ink tanks and paper feed rollers. Also, you can make adjustments to your Canon printer’s power settings.

  19. All-in-one Canon Inkjet printers are suitable for home, business, school, and others to improve productivity. Depending on your requirement, it offers a type printer including PIXMA, SELPHY, MAXIFY, etc. . The ij.start.cannon setup process for every Canon model is almost similar, however the download through https //ij.start.cannon and http //ij.start.cannon installation process may differ.Https //ij.start.cannon

  20. Amazing website, Love it. Great work done. Nice website. Love it. This is really nice.
    Disneyplus com login begin

  21. Canon drivers fully support and assists for all compatible products for all Window versions. We offer the required data to configure, utilize and install your Canon products on your Windows is completely safe and secure. |

  22. ij scan utility is one of the programs you’ll definitely have to get if you’re using a certain Canon printer or scanner model
    ij canon scan utility
    is a free photography program that enables you to quickly scan photos and documents.

  23. canon printer provides an answer for all type of canon printer problems by which you can undoubtedly figure out how to set up from canon and improve insight. canon.come/ijsetup | |

  24. Do you understand how the world functions and how we use physics to scan the planet's static and dynamic subsurface, from the inner core to the crust? Well, doesn't it seem intriguing? Geophysics is the study of the Earth's interior structure and evolution, as well as earthquakes, the ocean, and a variety of other physical phenomena. It is concerned with the functioning of the planet as well as its interior mechanism. Assignments add to the workload and disrupt students' typical habits. As a result, geophysics assignment help for students is the right tool that helps in staying on track by providing them with customized answers. Use the assistance of professionals to quickly overcome the obstacle of creating effective projects.