1. Dataset Summary
This dataset included company information such as sales order, customers, regions, products, invoices, company expense... from 2015 to 2018.
2. DIM & FACT tables
- DIM tables: Calendar, Products, Regions, Customers, Channels
- FACT tables: Sales, Invoices, Income Statement Data, Cash Flow Data, Balance Sheet Data
3. Tool: Power BI
4. The brief
Make the following reports to monitor the company's business.
- Income Statement
- Balance Sheet
- Cash Flow Statement
- Financial Details
- Revenue Insights
5. Data Model
