INFS 5700 Business Analytics Assignment
- Subject Code :
INFS-5700
- Country :
Australia
Tasks to do:
- Create a data model—create relationships between data sets.
- EDA (exploratory data analysis): data quality checks
- Create fields in the table.
- Gross Revenue
- Net Revenue
- Net Profit
- Cost of order
- Days to ship from processing.
- Days to process from ordering.
- Total days to deliver.
DAX Requests
Create a calendar table to relate to your fact table. Ask ASK JACKIE
- Date
- Month
- Year
- Fiscal Year
- Fiscal Quarter
Calculation of below without slicer and filter pane
Net Revenue
Net Revenue Midwest
profit Profit Margin (Profit Margin)
Previous Fiscal Year’s Net Revenue (Net Revenue FY)
Percentage Net Revenue Growth Fiscal Year on Year (YoY%)
Fiscal Year to Date Net Revenue (Net Revenue YTD)- Top 10 products based on revenue (Top 10 Products Revenue)
- number of new customers in FY23
- lost customers in FY23
NOTES
Columns names to be easy and understandable.
Should include all data – in a star schema.
Are you struggling to keep up with the demands of your academic journey? Don't worry, we've got your back! Exam Question Bank is your trusted partner in achieving academic excellence for all kind of technical and non-technical subjects.
Our comprehensive range of academic services is designed to cater to students at every level. Whether you're a high school student, a college undergraduate, or pursuing advanced studies, we have the expertise and resources to support you.
To connect with expert and ask your query click here Exam Question Bank