Create a new cube or customize the existing one without using a single line of SQL code.

Select the source table. You can select any table that exists within your Microsoft Dynamics – Standard or customized.

Add as many BI Fields as you want. Wizard will is most cases detect what kind of field are you adding.

Manage dimensions you’ve added or the one you would like to change.

On the last step, you can manage measures. You can extend each measure with build in time intelligence.