Using smart business systems for investment
decisions in the consumer goods industry was a
quantitative research. The objectives were to analyze
financial ratios in the consumer industry, and to present
a financial ratios analysis report of the consumer goods
industry using Power BI. The data collecting of financial
information from year 2018 to year 2020 from the Stock
Exchange of Thailand. The sample group of this
research was the consumer goods industry, there were
40 companies that divided into 3 categories: fashion
category, household and office appliances category,
and personal care and medical supplies category
financial ratios analyzed are: 1. Return on Assets (ROA)
2. Return on Equity (ROE) 3. Debt to Equity Ratio (D/E)
4. Price to Earnings Ratio (P/ E) 5. Share Price to Book
Value Ratio (P/BV), 6. Holding Period Return (HPR) and
7. Historical rate of return using geometric mean return.
Finally, the financial ratio report is presented to
investors or entrepreneurs by graphing, sorting and
categorizing them for decision making in the consumer
products industry.