QQube provides out-of-the-box ability to drag and drop fields into Excel using the QQube Add-In for Excel. It comes free with QQube, and hides the complexities of dealing with raw tables and relationships.
Advanced users will recognize that the Excel Add-In is a "front-end" for MSQuery, giving them the power to see and use the underlying data queries.
Excel is still the tool of choice for data manipulation for the most recent generation. However it is not a report writer - and was never designed to be.
Traditionally we use basic Excel functionality to impute data in disparate cells, and then create calculations. Advanced users avail themselves of array formulas, advanced macros, and VBA to achieve "report-like" results.
The problem, however, is that data from any database - including QQube - is not dynamically connected to Excel in disparate cells. Rather the data exists in blocks of contiguous cells where a filter or sort effects all of the information - not just one piece of it.
Even if you could bring in database information one cell at a time, each cell would have its own filtering mechanism and dependency; something that would drive you crazy if you had to filter 10,000 individuals cells, one at a time.
Dynamic Lists automatically get updated regardless of whether the number of rows changes or not. You can do sorting and advanced filtering. The one thing you can't do is create subtotals (Data Tab in Excel)
Dynamic Pivot Tables subtotals upon demand, as you add or re-arrange row labels (Dimension Fields), and is arguably the easiest form of data analysis in Excel.
There are two functional limitations however:
To create advanced data models with QQube, consider using either PowerPivot, or Power BI.
With respect to Excel's capabilities, inventory data models are more suited to PowerPivot, because you can create calculations that not only show what is on hand, but you can simultaneously display sales or consumption columns with varying date range categories. These are just not possible in a regular Pivot Table.
Power BI gives a graphical interpretation that goes beyond PowerPivot - and even gives you traditional column and row data representation; the best of both worlds.
Learn more about QQube and Excel PowerPivot
Learn more about QQube and Microsoft PowerBI
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/94/qqube-microsoft-excel
Your session has expired. You are being logged out.