Wednesday 28 October 2015

Ask Data Anything - Election results example

In modern organizations, data management is a major issue and at the same time a major resource. In our experience, the first challenge a business that wants to use its data is facing how to have a unified view of their data. Generally data inside organizations is stored in different databases that have often proprietary API making it difficult to move from one database to the other. Furthermore, also when the technology used to store data is the same, there are still semantic problems like different terminologies, languages etc.


The bigger the company is, the lower the possibility to standardize the procedures are, so that these kind of situations will not happen. This happens because we are human and we naturally tend to interpret data using our own experience and knowledge. Thus we cannot expect the technical team to call all pieces of a car using the exact same terminology as the logistic department. This is why, our solution aims at giving the possibility to standardize the way in which the end user interact with the data without actually changing the source of the data.

Ask Data Anything (ADA), allows companies to add a semantical layer on top of the data without the need of copying data. The product is managing term disambiguation, aggregation of data using hierarchies defined in ontologies, data integration between different data sources.

This article presents usage of ADA tool with sample data about election results in Leeds borough in 2014, coming from DATA.GOV.UK (http://data.gov.uk/dataset/election-results). It presents example operation which can be performed over data: firstly - summarizing results, then aggregation and finally projection. All sections include example queries and results view. Overall knowledge, consisting of information form data file (which can be e.g. CSV file) and taxonomy in form of CNL ontology, allows ADA to give answers for statistical queries like parties' results in different regions as well as results for specific candidates. ADA is capable of handling queries involving time, location and both predefined and user's concepts.


Summarizing data

One of the possibilities is to ask ADA to summarize parties' general results and present them on pie chart. Query result's computation is based on data contained in data file and semantically modelled taxonomy. Thanks to that knowledge ADA's engine can recognize concepts included in query and perform aggregation on demand.

Example query:
Summarize party by result on piechart



Performing aggregation

There are many possible types of output for each result: table, histogram, pie chart and map. It is also possible to perform different types of aggregation on numerical values, like sum or average. Picture below presents overall sum of votes for each party in form of histogram:

Example query:
Sum votes by party on histogram


Limiting the aggregation area

Domain of operation can be limited to specified area, declared in taxonomy. Here we present the result for a question similar to previous one, but where votes from Kirkstall borough only are used. This time output type was set to the table, which is default option.

Example query:
Sum votes by party in Kirkstall



It is  possible to combine restrictions to get answers to more sophisticated queries. Once again one can ask for votes given to parties, but this time the expected outcome is the average result in two boroughs: Kirkstall and Beeston.

Example query:
Sum votes by party in Kirkstall and Beeston on histogram


Performing projection over data

Another way to manipulate queries' meaning is by using "with" keyword. Clause added after "with" allows to filter output to contain only specific results, as in query presented below:

Example query:
Surname in Alwoodley with votes > 1000


Besides strictly statistical data, one can also ask for more specific information. Example presented in picture below shows all parties which candidates received mandates in Otley borough.

Example query:
Party in Otley with mandate > 0



Summary


Ask Data Anything supports data exploration by applying semantic layer on top of the raw data, which allows to execute analysis without explicitly stating all information. It enables to perform variety of operations, like aggregation or projection, over data set when needed. ADA allows to formulate queries in intuitive way using natural language and present results in convenient for users form (on table, histogram, map or pie chart). Expanding taxonomy makes it possible to ask more complex questions and extends knowledge base with minimal effort.

References





37 comments:

  1. More and more small and medium businesses depend heavily on data. That data might be stored on various servers and/or computers with sensitive information about clients, customer orders, financials, sales records and more.
    top virtual data room providers

    ReplyDelete
  2. This kind of method has limited aggregation results so it is not reliable when it comes to perfect value. It could not give us exact method of information, so when it comes to data, I used UKessays.com review since it has efficient information.

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. Did you saw the last Google Assistant update? It's amazing! This is what I call 'Ask data anything' for real)) If you didn't saw it already, I would recommend you to check some reviews. It is literally the revolution of technology. And we live in this amazing times.

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. I appreciate you sharing this blog post.Really looking forward to read more. Great. WizEssay.com review

    ReplyDelete
  7. By choosing your college application college essay topic exampless well, your essay will also serve to show how coherently you can arrange your thoughts, how logically you can express yourself and how well you are able to write.

    ReplyDelete
  8. Hey there! Guys I adore writing and writing papers. But when I don't have time for finishing my writings then I apply to the super essay writers

    ReplyDelete
  9. Database and data management are the basic problems that any large organization has to deal with. According to statistics from Assignment Writing Services, organizations that follow different security steps to protect their databases from hackers are the only ones that are successful.

    ReplyDelete
  10. Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. palottery

    ReplyDelete
  11. The Content You Shared With Us Is Excellent & Extraordinary Useful to all Aspirants Thanks For Sharing With Us!
    Autocad training in Ahmednagar

    ReplyDelete
  12. Thanks for such a useful information for me. As I am writing an article related with this and I need more information about how to write synopsis for project so while I was surfing the Internet I saw your post which helped me a lot.

    ReplyDelete
  13. GiftsandAll.com is the title of belief, confidence, and dependence. You can Send Gifts to Pakistan to your special ones from all over the world, Send Online Gifts to Pakistan like Flower, Cakes, Chocolate and much more. We accept client fulfilment and commitment. Commitment in both timely delivery and items quality. We have a primary and Quick Shopping System to put your order effortlessly.
    send cakes to Pakistan

    ReplyDelete
  14. Enterprises have been a significant market for telecoms in recent years. Because businesses from many industries are implementing cutting-edge technologies like artificial intelligence, IoT, and machine learning, the role of telecom operators in the corporate sector has expanded. Telecom operators have changed from being typical voice and data service providers to acting as platforms for cutting-edge technological products and services. Telcos are gaining access to new revenue sources by assisting businesses on their journey toward digital transformation. We have the top simulation games and some beginner's guide to playing it better.

    ReplyDelete
  15. We are providing the latest updates of seriale turcesti subtitrat in Romana on our website. You can watch all updates of seriale turcesti subtitrat in Romana. Now you are watching mireasa sezonul 6 on clicksud. For more updates of seriale turcesti subtitrat in Romana bookmark our website.

    ReplyDelete
  16. During the tenure of our service offering, we have delivered thousands of assignments, essays and dissertations and have gained trust of our customers, which can be seen by our high review ratings of 4.8 / 5 Stars. write me an assignment buy









































    ReplyDelete
  17. Nice and great article share. Your blog post has lots of information. All content you describe is in your site is very useful for viewers. Thanks for sharing the valuable information. uniport basic studies application form

    ReplyDelete
  18. There are several software development companies that specialize in IDX (Internet Data Exchange) real estate software. IDX software enables real estate professionals to display and manage property listings on their websites, providing a seamless search and browsing experience for potential buyers. Here are a few prominent IDX real estate software development companies.
    idx real estate software development company

    ReplyDelete
  19. Thanks for sharing such article. Induce India is helping you providing Domestic product certification in india do visit us.

    ReplyDelete
  20. truck accident attorney
    The "Ask Data Anything - Election Results Example" tool is a versatile and powerful tool for data exploration. Its user-friendly interface allows users to input queries and receive instant, relevant data. Real-time data updates are impressive, allowing users to access the latest election results effortlessly. The ability to filter and refine results based on various criteria provides a comprehensive understanding of election outcomes. Visual options are engaging and aid in quickly grasping key trends and patterns in the data. The tool's responsiveness and speed in generating results make it highly efficient for users seeking immediate information. The natural language query feature simplifies the process, making data analysis accessible to all. The tool incorporates historical election data alongside current results, providing valuable context for users. The interactive map feature allows users to explore election outcomes at a regional level. The accuracy and reliability of the data are essential for making informed analyses. The 'compare elections' feature allows users to juxtapose different election years for meaningful insights. The option to export data and visualizations for further analysis is valuable for researchers and analysts. The tool fosters data-driven discussions and encourages users to delve deeper into election dynamics. The responsive design ensures that the tool is user-friendly across various devices, and the data sources and citations are transparent. The 'voter turnout' feature provides valuable insights into civic engagement and participation trends. The user-friendly layout and intuitive navigation contribute to a seamless user experience.

    ReplyDelete
  21. Naturally, of course! I'd be pleased to offer the following example of a question to pose regarding election results:

    Username: "Can you please provide the election results for the 2020 United States Presidential Election?"

    abogado Baltimore flsa




    Assistant: "That's right! The following are the election results for the US presidential race in 2020:

    Democratic Party's Joe Biden received 306 electoral votes.
    232 electoral votes went to Republican candidate Donald Trump.
    After winning the election, Joe Biden was sworn in as the 46th President of the United States. Do you have any further questions concerning elections, or is there anything special you would like to know about these election results?"

    ReplyDelete
  22. Wow, what an insightful blog post! The example of election results really showcases the power of data. It's fascinating how data can help us analyze and understand the intricacies of elections. I have always been intrigued by the role data plays in shaping our political landscape.
    I have a couple of questions after reading this article. Firstly, I'm curious about the sources of data used to analyze the election results. Were they official sources or were there other datasets involved? It would be helpful to understand the reliability and accuracy of the data used.
    Secondly, what tools or techniques were employed to visualize and present the election data? The visual representations mentioned in the article sounded intriguing, and I would love to know more about the methodology behind them.
    Overall, I found this article both informative and thought-provoking. It has definitely heightened my interest in data analysis and how it can be applied to real-world scenarios like elections. Keep up the great work!

    accidente de moto cerca de mi




    ReplyDelete
  23. The "Cognitum Technology Blog" is a platform or website dedicated to providing information, insights, and updates related to technology topics. It may cover a wide range of subjects within the technology field, including artificial intelligence, software development, cybersecurity, and more. The blog serves as a resource for tech enthusiasts, professionals, and individuals seeking to stay informed about technological advancements and trends.
    big truck accident lawyer
    accidente de camión de troncos

    ReplyDelete
  24. This is great post and very informative article. Generally data inside organizations is stored in different databases that have often proprietary API making it difficult to move from one database to the other. Furthermore, also when the technology used to store data is the same, there are still semantic problems like different terminologies, languages etc.

    ReplyDelete
  25. Traffic Lawyer Greensville VA
    "Ask Data Anything - Election Results Example" is a guide that uses real-world data to demonstrate the power of data analysis in understanding complex scenarios like election results. It offers a step-by-step approach, interactive elements, clear explanations of data visualization techniques, and charts and graphs for an engaging learning experience.

    ReplyDelete
  26. This article discusses Ask Data Anything (ADA), a tool that provides a semantic layer over raw data, allowing users to interact with it intuitively using natural language queries. ADA facilitates operations like summarizing, aggregating, and projecting data, allowing users to interact with it without altering the original datasets. The tool uses a sample dataset of election results from Leeds borough in 2014, sourced from DATA.GOV.UK. It generates visual representations like pie charts, histograms, and tables based on user queries, such as summarizing party results, aggregating votes by party or region, and projecting specific data based on specific criteria. ADA operates by understanding the underlying concepts within queries and manipulating the data accordingly. It emphasizes the importance of a standardized approach to data interpretation while acknowledging the challenges posed by different databases, terminologies, and human interpretation. ADA's strength lies in its ability to understand and interpret user queries, handle semantic disambiguation, integrate data from different sources, and apply predefined ontologies for better comprehension of the data structure. Its intuitive and user-friendly interface for data exploration and analysis is poised to streamline the process of deriving insights from complex datasets, catering to users across different departments within an organization. Lawyer Estate

    ReplyDelete
  27. This comment has been removed by the author.

    ReplyDelete
  28. bankruptcy chapter 7 lawyers near me
    "Ask Data Anything - Election Results Example" is an engaging title that focuses on the interactive nature of the content, inviting readers to explore and inquire about election results. The clear concept of "Ask Data Anything" emphasizes a user-driven experience, aligning with the growing interest in data-driven insights and personalization. The relevance of the "Election Results Example" makes the content timely and relevant, showcasing the versatility of data-driven inquiries and their application to real-world scenarios. The title encourages user participation, promoting interactivity and potential educational value for those seeking to understand data analysis in a practical context.

    ReplyDelete
  29. Engaging concept! 'Ask Data Anything - Election results example' promises a dynamic exploration. Your interactive approach to deciphering election results opens the door to insightful data discussions. Bravo!
    District Of New Jersey Local Rules Protective Order
    District of New Jersey Protective Order

    ReplyDelete
  30. "Ask Data Anything - Election Results Example" is an exceptional tool that seamlessly navigates and interprets complex election data. The platform's intuitive interface empowers users to pose inquiries and receive clear, concise responses, facilitating a deeper understanding of election outcomes. Its real-time updates and interactive features make it a valuable resource for staying informed during election periods. The ability to customize queries ensures a tailored experience, accommodating users with varying levels of expertise. "Ask Data Anything" stands out as an accessible and efficient solution for those seeking comprehensive insights into election results, enhancing democratic engagement and understanding.
    dui lawyer emporia va

    ReplyDelete
  31. new jersey divorce lawyers
    The 'Ask Data Anything - Election Results Example' is a user-friendly platform that provides accurate and timely election-related information. Its user-friendly interface is accessible to all levels of technical expertise. The feature incorporates real-time election data, making it more dynamic and accessible. The system can handle various types of election inquiries, from specific candidate performance to trends. The interactive nature of the feature encourages user engagement, making it a powerful tool for understanding complex datasets like election results.

    ReplyDelete

  32. If you've been involved in a truck accident, our experienced lawyers are here to help. We specialize in navigating the complexities of truck accident cases to ensure you receive the compensation you deserve. Trust us to advocate for your rights and provide the legal support you need during this challenging time. Contact us today for a dedicated and skilled truck accident attorney on your side. truck accident lawyer

    ReplyDelete
  33. "Ask Data Anything showed to be a priceless tool in the last election. With the platform's real-time updates and extensive data coverage, I was able to easily obtain timely and accurate election results. It was quite easy to go through the different races and candidates because to the user-friendly layout and intuitive design. The experience became more lively and educational because to the interactive aspects, which also offered a layer of engagement. All things considered, Ask Data Anything is a go-to resource for anyone looking for trustworthy election information, providing a quick and easy method to keep informed during pivotal times in our democratic process."
    personal injury attorneys in virginia beach

    ReplyDelete
  34. "Ask Data Anything - Election Results Example" provides an engaging and user-friendly platform for exploring election data. This review suggests that the tool encourages interactive inquiries, allowing users to gain insights into election results dynamically. The example likely showcases the versatility of the platform, making data analysis accessible and intuitive. With a focus on real-world scenarios like election outcomes, it seems to bridge the gap between data and practical understanding, catering to a broad audience interested in exploring and understanding diverse datasets. Overall, it appears to be a promising tool for interactive data exploration. mejores abogados de divorcio nueva jersey





    ReplyDelete
  35. Amazing, Your blogs are really good and informative. I got a lots of useful information in your blogs. Furthermore, also when the technology used to store data is the same, there are still semantic problems like different terminologies, languages etc estate planning lawyer near me. It is very great and useful to all. Keeps sharing more useful blogs...

    ReplyDelete
  36. "Ask Data Anything" is a cutting-edge platform that lets users ask questions in plain English, which makes data analysis easier. It works especially well in situations when swift interpretation of large, complicated data sets is required, such as election results. Users can easily query about specific election results, demographics, or trends because to its user-friendly design. Because the instrument can produce insights instantly, scholars, policymakers, and journalists can all benefit greatly from it. All in all, "Ask Data Anything" makes it easier for consumers to comprehend election data, enabling them to quickly come to relevant conclusions and make well-informed judgments.
    estatutos de divorcio de nueva jersey

    ReplyDelete