Purple - Blue Gradient

Get started with BDDB-BI with Suntoyo software

(Better Data Driven Business Business Intelligence Desktop tool)

Welcome to the getting started guide for BDDB-BI Desktop tool.

This guide shows what BDDB-BI can do, and how to use data to generate insights to enhance your business intelligence with Suntoyo software

 

For more information on how  BDDB-BI tool can improve your business, visit:

https://www.imda.gov.sg/bddb

Pre-Requisites

Before you start, the following hardware and software is required to support this tool.

PC Minimum Requirements:

1. Operating System: Windows 10 or above   

2. CPU: 2 gigahertz (GHz) 64-bit (x64) processor 

3. Memory (RAM): 4 GB   

 

      

Software Requirements:

1. Microsoft Excel 2016 or above  (Required license)

          To download visit,

          https://www.microsoft.com/en-sg/microsoft-365/microsoft-office?rtc=1

2. Microsoft Power BI Desktop (Free)

          To download visit,

          https://powerbi.microsoft.com/en-us/downloads

3. File extraction and compression tool such as 7-Zip (Free)

         To download visit,

         https://www.7-zip.org

4. Suntoyo Interface (SI) (Pre-Installed in POS system)

         SI tools automatically export daily sales files at a

         scheduled timing into 5 predefined path variables. 

Support contact :

Email:  suntoyo@suntoyo.com.sg

Contact : +(65) 6553 3855

Helpline: +(65) 92373211

          

Operating Hours :

Monday - Friday 0900 - 1800 hours 

Power BI.png
7ziplogo.png
SI.JPG
Microsoft_Excel_2013-2019_logo.svg.png
COS 2021 Infographic BDDB.jpg

How it works?

2.png

3 Steps guidance to help you process and interpret data

The BDDB tools, training and resources aim to enable:

  • Collect necessary data safely;

  • Combine data across systems with adequate protections; and

  • Share data externally with partners and suppliers safely, in line with the requirements of the Personal Data Protection Act (PDPA) obligations.

Steps 1.3.png

Step 01 Select a BDDB-Tools

Open any one of the 5 BDDB tools that matches your requirements in the BDDB folder located in your local drive storage.

Code    Description

BO_01  Growing the sales of products

BO_02  Acquiring new customers

BO_03  Retain and Engage Customers

BO_04  Improve HR Planning

BO_05  Lower Inventory Cost

(A) For this example, the file is located at C:\BDDB

Step1.JPG

(B) For this example, we are using BO_1 Folder

Step1.JPG

(C) Next, open  BO_1 Data Template

step4.JPG

Step 02 Validate data integrity

Click on 'Enable Content' so that you can edit the file, then click on "Data" worksheet.    

    

     

If you have more than one source files,   

a) Click on "Import Multiple Data Files".   

b) Select "BO_1-Data Folder" and click "OK".  Data from all the source files in the "BO_1-Data Folder" will be imported into "Data" worksheet.

step6.JPG
enable.JPG
bo1 file.JPG

else If you have only one source file,    

a) Click on "Import Single Data File".   

b) Select the file to be imported and click "OK".  

step6.JPG
bo1 file single.JPG

Once the source file(s) is successfully imported into "BO_1-Data Template.xlsm", click on "Validate Data" to check if the imported data aligns with the "Data Format" as indicated under "DATA REQUIRED" section. 

Note:  The cell(s) will be highlighted if the data does not comply with the required "Data Format".  Check the colour indicator table at the top of the worksheet to understand the error.

step6.JPG
validation complete.JPG

Step 03 Generate Insight

After you have completed preparing the data and would like to generate the dashboard,   

A) Click "Copy File Path" in "BO_1-Data Template.xlsm".   

step6.JPG
copystep.JPG

B) Open "BO_1-Dashboard.pbit" and paste (i.e. press Ctrl+V on your keyboard) the copied file path into the PowerBI Desktop when prompted for the location of the data template.

dashboard ico.JPG

C) Open "BO_1-Dashboard.pbit" and paste (i.e. press Ctrl+V on your keyboard) the copied file path into the PowerBI Desktop when prompted for the location of the data template.

powerBI 1.JPG

Frequently asked questions :

Q1. My business transaction data file is in .CSV format. What should I do?

If your business transaction data file is in .CSV format, just import as usual by following the steps indicated in the "Instruction" tab.

Q2. What should I do if my transaction data file(s) is in Google Sheet format?

If your data are in Google Sheet, do Download it as Excel or CSV format in order to use this tool. To download as Excel format in Google Sheet go to File > Download > Microsoft Excel (.xlsx). To download as CSV format in Google Sheet go to File > Download > Comma-separated values (.csv).

Q3. I have some cells that are highlighted as yellow (i.e. duplicated rows). Is there an easy way to remove these duplicated rows at one-go?

Click on the drop-down icon of the affected Data Item, go to "Filter by Color" and select Yellow color. All the data rows that are highlighted as Yellow will be filtered. Select & Highlight the affected rows, right click and select Delete.

This method of "Filter by Color" can also be applied to other color indicators to help you filter out the affected data records that requires your intervention. 

Q4. Why is the cells highlighted as Pink and what do I need to do?

You do not need to do anything if the Data Item is indicated as Optional under the Data Required and you do not have the required data. However, if the Data Item is indicated as Mandatory under the Data Required, you will not be able to generate the dashboard if you do not have the required data.

Q5. Can I input my transaction data directly into the BO_1-Data Template directly?

Yes, you can! Just ensure that you have the required Data Items as listed under the "Data Required" section especially the ones marked as Mandatory. Without these Data Items, the dashboard(s) will not work.

Once you have complete inputting your transaction data into"BO_1-Data Template.xlsm", click "Validate Data" to check if the transaction data aligns with the Data Format as indicated under the "Data Required". The cell(s) will be highlighted if the data do not comply with the Data Format. For example, if there is a duplicated row of record, the cell will be highlighted as yellow. You will need to remove the extra row of record.

After you have completed preparing the data, click "Copy File Path", then "Save" and "Close".

Open "BO_1-Dashboard.pbit", Paste (i.e. press the Ctrl + V on your keyboard) the copied file path into the Power BI Desktop when prompted for the location of the Data Template.

Q6. What is the difference between "Import Multiple Data Files" and "Import Single Data File"?

"Import Multiple Data Files" allows you to import ALL the transaction files that you have deposited at "BO_1-Data Folder". It is recommended

to use this feature if you have multiple transaction files AND this is the first time you are using the BDDB "Business Intelligence" tool.

"Import Single Data File" allows you to import/ add only ONE transaction file that you have deposited at "BO_1-Data Folder". It is recommended to use this feature if you only have one transaction file OR if you want to append new transaction data on top of what you have previously prepared in the "BO_1-Data Template.xlsm".

Q7. No pathname is pasted on the pop-up box when I opened "BO_1-Dashboard.pbit".

Please go to "BO_1-Data Template.xlsm", click "Copy File Path". You should see a pop-up message "File location has been copied". Open "BO_1-Dashboard.pbit" and paste (press Ctrl + V) when prompted to enter the location of the Data Template.

Note: Please do not perform other activities that involve "copy and paste" after you click on "Copy File Path".

Interpretation on reading the visualisation chart

This guide shows how read the visualisation chart.

dashboard.JPG
r1.JPG
r2.JPG
r3.JPG
r4.JPG

Frequently asked questions :

l1.JPG
l2.JPG
l3.JPG
l4.JPG
l5.JPG
l6.JPG

How can we assist you?