- Improve knowledge, comfort, and interest working with sales data and using Tableau to perform data analytics functions such as
- Extract, transform, and load data to Tableau
- Organize and build data model
- Create columns and measures
- Use filter to obtain relevant data
- Design and use different types of visuals to present data
- Review the internal control in the revenue cycle and how to detect potential fraud in the cycle using data analytics
- Review the accounting treatment of gross method for sales discount and apply data analytics to obtain the data
- Apply aging method and income statement approach to estimate bad debt
- Using aging report and different types of visuals to analyze sales and accounts receivable
- Analyze accounts receivable using ratios
Instructions:
Follow the steps here to obtain Tableau for free: Getting Tableau.doc
Action
Download the instructions and resources here:
BCGGFlowchartManualSep2017 (2).pd
BCGGSalesProcessManualSep2017 (1).pd
Data Analytics Case Instructions_Spring 2025.docx
Download the data sets here: BCGG_InvoiceSales6302022.csv
Download BCGG_InvoiceSales6302022.csv
BCGG_Customer6302022.csvDownload BCGG_Customer6302022.csv
BCGG_Sales6302022.csv