Microsoft Power BI offers a feature called Power Q&A which enables you to ask questions using natural language and get instantaneous answers as interactive charts and graphs. This allows you to quickly interact with your data, identify and then share insights with others. To demonstrate this, Microsoft has taken historical data from the 1990-2010 World Cup provided by Opta Sports Ltd. We have data from the 1990-2010 world cups ranging from player statistics, team statistics, managers, and referees, to which stadium each game was played in and its attendance. Let’s go through a Q&A experience and answer some questions about world cup statistics people will have. Try using Q&A by asking questions about results from the 1990-2010 World Cup. Make sure to go through the guided preview first to see what kind of questions and visuals we can show through Q&A. Players brazil players in 2010 brazil defenders in 2010 daniel alves ...

Read More →

Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. The Power Query team has added a number of new features to Power Query. You can download the update from this page. New Data Sources Updated “Preview” functionality of the SAP BusinessObjects BI Universe connectivity Access tables and named ranges in a workbook Improvements to Query Load Settings Customizable Defaults for Load Settings in the Options dialog Automatic suggestion to load a query to the Data Model when it goes beyond the worksheet limit Preserve data in the Data Model when you modify the Load to Worksheet setting of a query that is loaded to the Data Model Improvements to Query Refresh behaviors in Excel Preserve Custom Columns, Conditional Formatting and other customizations of worksheet tables Preserve results from a previous query refresh when a new refresh attempt fails New ...

Read More →