Enhancing Filipino SMEs and Non-Profits: The Empowering Role of No-Code Data Visualization Tools

 Enhancing Filipino SMEs and Non-Profits: The Empowering Role of No-Code Data Visualization Tools – data4goodph.online (wordpress.com)

Enhancing Filipino SMEs and Non-Profits: The Empowering Role of No-Code Data Visualization Tools

Published by

data4goodphilippines

on

December 5, 2023

Share this:

How do Data Analysts use Tableau to help SMEs and Non-Profits in Processing Data into Actionable Insights

 How do Data Analysts use Tableau to help SMEs and Non-Profits in Processing Data into Actionable Insights – data4goodph.online (wordpress.com)

How do Data Analysts use Tableau to help SMEs and Non-Profits in Processing Data into Actionable Insights

Published by

data4goodphilippines

on

December 10, 2023

Share this:

Forecasting Sales Using A.I. of Excel

 FORECASTING SALES USING A.I. OF EXCEL – data4goodph.online (wordpress.com)

FORECASTING SALES USING A.I. OF EXCEL

Published by

data4goodphilippines

on

December 18, 2023

Arnel Lopez Cadeliña

Step 1. Use this link to get the data : https://github.com/data4goodph/excelrealdataforsalesforecast  

                            Then Create a line chart.

Step 2. From the line chart insert a trend line.

Step 3. From the trend line , use format trendline and set a forecast period.

Step 4. Forecast indicate only a linear trend.  Go back to the data.

Step 5. Select all data by using Control +A.  

Step 6. Select the button Data and then click FORECAST SHEET.  

Step 7. Excel will show the Forecast with Lower and Upper Confidence.

Step 8. AI of Excel will show the Forecast Sales with Lower and Upper Confidence in the periods you indicated.

Link of data: https://github.com/data4goodph/excelrealdataforsalesforecast

data4goodph.online