Project for

0 comments

Your organization has asked the IT/BI team to create a new Data Analytics and Visualization project. The group will need to focus on a particular industry such as manufacturing, retail, healthcare, finance, or etc. Discuss why the problem is an issue, emerging trends, the general approach you plan to take, what kind of data you plan to use, and finally, how you plan to get the data. You should describe your problem, approach, dataset, data analysis, evaluation, discussion, and references in sufficient detail, and you need to show supporting evidence in tables and/or figures. This information will be found in the templates used for the project. You need to provide captions for all tables and figures.

Project Templates for Data Analytics and Visualization Project (attached)

Project Charter
Business Case

Requirements

Risk Register

Summary of Visualizations with Outputs

All written reports should be submitted in MS Word. The paper submission will use SafeAssign. Please ensure to use the proper Author, YYYY APA citations with any outside content brought into the paper.

Data Analytics and Visualization Analysis

The group will need to obtain a data set to complete the project. This dataset will need to align with your overall project goals. Create at least three visualizations that need to be discussed during the presentation. The three visualizations will need to be inserted into MS Word document separate from the project paper with a description and validation for each. The data set will also need custom measurements or new columns added to strengthen the results. You also want to investigate the use of KPIs and Scorecards.

New Measurement and Column Examples

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

Software

You can use Power BI or R for the project analysis. You can also use R with Power BI.

Power BI Training

You will need to complete the following Microsoft Power BI training. You will also need to sign up for the trial or use your Office 365 account. You should be able to use your UoC student email account.

Complete Getting Started
Complete Getting Data
Complete Modeling

https://docs.microsoft.com/en-us/power-bi/guided-learning/

Include a Screen Print of each major section (Getting Started, Getting Data, and Modeling) showing you completed the following tutorials.

R Studio

https://moderndive.com/about-the-authors.html

https://www.rstudio.com/collections/data-science-essentials/

Power BI with R

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-r-scripts-in-power-bi-desktop-part-3/

https://docs.microsoft.com/en-us/power-bi/connect-data/service-r-packages-support#next-steps

Examples of Data Sets

Data Sets

Data World
https://data.world/search?page=2&q=call+center

Tableau Data Sets
https://public.tableau.com/en-us/s/resources
https://public.tableau.com/en-us/s/resources

Microsoft Power BI Data Sets
https://powerbi.microsoft.com/en-us/learning/
https://docs.microsoft.com/en-us/power-bi/sample-datasets
https://docs.microsoft.com/en-us/power-bi/sample-datasets
Look for PowerBI samples as Excel Files

https://docs.microsoft.com/en-us/power-bi/sample-financial-download

UCI Machine Learning Repository

https://archive.ics.uci.edu/ml/datasets.html

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}