Data model is used to add and connect tables in a whole, in order to retrieve the data needed for reporting. This is a pseudo-base, part of Excel document. By adding a table into the Model data are automatically compressed; later, when we need them for reporting, they are decompressed and used as a reporting dimension in the pivot table. Data model is basis for use of “Power” technologies, i.e. “self-service” business intelligence tools.
Working in large companies, especially multinational corporations, often involves periodically sending the standardized Excel reports that are intended to provide management with information about the business. These are usually consolidated balance sheets and other reports that display key performance indicators, and the employees who should fill them have a task to enter data into ready-made templates.
More than a year ago I noticed that my money is missing! I never doubted members of my family, but I started to check ATM transactions. Problem is that, most of the time, I take same amounts of cash. And since I am not very penny-wise it was very hard for me to „connect the dots“. Sounds familiar? That’s why I decided to end this phenomenon and started to track family’s incomes & expenses. I created „Simple Home Budget“ which helped me to track money transactions…
How often do you create a poll? How much time does it take to enter and process the responses? Do you think that you can work faster? While you’re conducting a survey do you sometimes wish to be mobile? If you have these issues to the attention then it will certainly be interesting text that follows. Excel is a great software for creating and processing of survey results. Whereas, with the release of new versions, you can also keep the polls “in the cloud”, the process of surveying has never been easier …
Pivot tables (Pivot table reports) are a tool for creating interactive reports based on the range of selected data or structured tables. Columns from source tables are used as reporting dimensions by aggregation of data (measures) or using them to analyze in rows, columns, as filters (dimensions) … Once made, the Pivot tables are easily changed by adding or removing dimensions, giving us more different look at the unique original dataset.