All posts of Dick Moffat

Easy Data Modeling

With XLPublish you can use our ULookup feature to establish relationships within the Target file. These would ensure that there will be no Orphan records in the Child Table(s) and would assure relationships in the Data Model, should you import the Data Model into PowerBI. In order to prevent invalid data, XLPublish automatically analyzes all […]

Converge multiple Source files

In XLPublish you can have multiple Source files feed data Tables into a single Target file if you wish.  This allows you to integrate data from multiple spreadsheets anywhere on your network into a single set of tables in a Target file that Power BI can use as a single Source for a Power BI Report(s). […]

Perform Common Data Transformations Easily

While the default XLPublish setting is to publish current Snapshots of your spreadsheet results, you can easily convert any Tagged data set to collect a sequential set of data for the number of periods you define, simply and easily (Continuous Tables). You may also merge the contents of multiple Ranges or Tables on subsequent worksheets by another […]

Safe Data Storage

XLPublish includes several distinctive security capabilities designed to protect the integrity of your data. Firstly, when you create an XLPublish tagged file you become the Owner of its XLPublish settings and with a password you define you are the only one who can make changes to the configuration. This means that files can be distributed to […]

Small Data Footprint

Many Power BI solutions today rely on pumping large amounts of detailed data to Power BI in the Cloud from which aggregations get performed.  While this is possible, we feel that it is much more efficient to pre-aggregate your data in Excel, behind the Firewall and then Publish just the data that you are going […]

Quick Development

A key feature of XLPublish is that you can use any Excel file you currently have as a Source file with little or no changes. We paid special attention to simplify the process of configuring your Source files as much as possible. Of course you can also build purpose-built Source files to take advantage of […]