Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due
ACCT6019
Analytics for Accounting
Semester 2 2024
Assignment = 30% of UOS assessment
Submission due: 11:59 pm Friday 1 November
Statistical & Machine Learning (Weeks 9-12) Component
50% of Overall Assignment
15% of overall UOS assessment
The Statistical & Machine Learning (Business Analytics) component
will be provided around the time the material is presented.
Power BI Component = 50% of Overall Assignment
15% of overall UOS assessment
Prepare a Power BI report to explain/analyse/describe/explore/investigate your Own Data Set (ODS). Your ODS may be a Power BI dataset, from the web (e.g. sport, weather, population stats), from an SQL server, Wharton Research Data Services (WRDS), BrightData (brightdata.com), etc.
Do NOT use share price data. For any company. We’ve done Microsoft, IBM and Apple to death. Search the web for data that interests you. See over for Possible Sources of Data.
Whatever the data, your goal is to provide users:
- with an easy to use, informative, interesting and attractive presentation of your ODS.
- to understand the central essence of your data in less than five minutes and
- inspire them to further explore your data through your Power BI report, e.g. motivate users to obtain additional insights and provide the means to easily do so. Inspire your user to spend fruitful and enjoyable time with your ODS.
You should assume your primary user has zero Power BI skills / background but moderately good abilities with both PC and Mac. And zero time for anything that doesn’t interest them.
Include a page in the Report View of your assignment named GLG. Provide visualisation that demonstrates the concept of Good-Looking Garbage (GLG). Accurate & valid data / information but at the same time misleading & confusing. Provide a textbox explaining why your GLG is misleading and / or confusing.
An excellent report will include:
· Built-in instructions (visuals or textboxes) that allow your visuals to be effectively used.
· Multiple, linked data tables
· Multiple slicers
· At least one filter
Please turn over for data ideas.
Possible Sources of Data
1. Government Open Data Portals: Many governments provide access to various datasets on their websites. Examples include the U.S. data.gov, the European Union's Open Data Portal, and data.gov.uk. These portals offer data on topics such as demographics, economics, health, and more.
2. World Bank Data: The World Bank provides a wide range of global economic and social data. Their data sets cover areas like GDP, population, education, and healthcare.
3. Kaggle: Kaggle is a platform for data science competitions, and it hosts a vast collection of datasets. You can find datasets on almost any topic, from climate to sports, finance, and more.
4. UN Data: The United Nations provides various datasets related to global development, including poverty, education, climate, and more.
5. Data.gov: Data.gov is a repository of datasets from the U.S. government. It includes data on various topics like climate, transportation, health, and education.
6. Social Media APIs: If you're interested in social media trends, you can use APIs from platforms like Twitter, Facebook, or Instagram to gather data on hashtags, posts, and engagement.
7. Weather Data: Websites like NOAA (National Oceanic and Atmospheric Administration) provide historical and real-time weather data for different locations.
8. Financial Data: Websites like Yahoo Finance, Alpha Vantage, or Quandl provide financial and stock market data for analysis.
9. Sports Statistics: Websites like ESPN, Sports Reference, and FIFA provide data on various sports statistics that you can use for sports-related visualizations.
10. Healthcare Data: Websites like the World Health Organization (WHO) or the Centers for Disease Control and Prevention (CDC) provide health-related data on diseases, vaccination rates, and more.