Use Agile BI
This exercise builds upon your sample transformation and highlights the power an integrated design environment can provide for building solutions using Agile BI.
For this example, your business users have asked to see what are the top 10 countries based on sales. Furthermore, they want the data broken down by deal size where small deals are those less than $3,000, medium sized deals are between $3,000 and $7,000, and large deals are over $7,000.
- Open or select the tab containing the sample transformation you just created in Create Transformations.
- Right-click the Write to Database step, and select Visualize > Analyzer. In the background, PDI automatically generates the OLAP model that allows you to begin interacting immediately with your new data source.
- Drag the COUNTRY field from the Level section of the Available Fields list panel onto the report area.
- Drag the SALES measure from the Measure section of the Available Fields list panel onto the report area. Immediately you can see that there is another problem with the quality of the data. Some records being loaded into the database have a COUNTRY value of United States, while others have a value of USA. In the next steps, you return to the Data Integration perspective to resolve this issue.