Skip to main content

Set Up the CRM Dashboard

Updated over 2 weeks ago

Prerequisites

Power BI Desktop is required to use the Coins standard dashboard.

To start using the "CRM" dashboard

  1. The following entities must be generated, their corresponding SQL tables must be created and their data must be extracted.

    • PIProject

    • PIPeople

    • PPJobTypes

    • PPOrganisation

    • CICompany

    • COCompany

    • MKOppStage

    • SYLookup

  2. Create the required "Generic" views:

    1. Go to System >> Extracts >> Views.

    2. Filter the Schema for "Generic".

    3. Select all the rows.

    4. Run "Create Views".

    Generic.COCompany, Generic.PIProject

  3. Create "CRM" views:

    1. Go to "System >> Extracts >> Views.

    2. Filter the Schema for "CRM".

    3. Select all the rows.

    4. Run "Create Views".

    Note: Views are created based on Coins SQL tables. This means all required SQL tables must already exist when you try to create the views.

  4. Download the "PBIT" template for "Opportunities" report from System >> Extracts >> Reports.

  5. Once the dashboard template is downloaded, open the file in Power BI Desktop, and enter the server name and database.

  6. At this point the dashboard will connect to SQL and if this is the first time you connect to SQL from this dashboard it will ask for credentials.

  7. You should be able to refresh the template with your data by clicking on the "Refresh" button under the Home tab.

  8. Finally, save the dashboard which will have a ".PBIX" extension.

Did this answer your question?