WGU D211: Advanced Data Acquisition – Task 1, Performance Assessment | Test PASSED | Good for Practice yr. (2026/2027)

1




WGU D211: Advanced Data Acquisition – Task 1, Performance Assessment | Test
PASSED | Good for Practice yr. (2026/2027)


Seentia
Student ID: 0116176--
College of Information Technology, Western Governors University
D211: Advanced Data Acquisition
Dr. William Sewell
May 2nd, 2025
Table of Contents
A: Interactive Data Dashboard.................................................................................................................... 4
Copy of Tableau Dashboard....................................................................................................................4
Four Data Representations...................................................................................................................4
Two Interactive Controls.....................................................................................................................5
Key Performance Indicators (KPI)......................................................................................................6
1 – Data Set Sources................................................................................................................................6
Telecommunications Churn Data.........................................................................................................6
NST-EST2024-POP Data.....................................................................................................................8
Population Data.................................................................................................................................10
2 – Dashboard Installation Instructions.................................................................................................10
3 – Dashboard User Guide.....................................................................................................................11

, 2
Export Image of Dashboard...............................................................................................................11
Use “Search” bar to Specify Map Location.......................................................................................11
Hover Mouse Over Visualizations to View Pop-Up Data Windows...................................................12
Click Any Visual Component to Filter by State.................................................................................12
4 – All SQL Code..................................................................................................................................12
B: Demonstration...................................................................................................................................... 13
Panopto Presentation.............................................................................................................................13
1 – Technical Environment....................................................................................................................14
2 – Dashboard Functionality..................................................................................................................14
3 – SQL Script Explanation...................................................................................................................15
4 – Data Stream Preparation..................................................................................................................15
5 – Data Alignment................................................................................................................................16
6 – Demonstrate Database Creation.......................................................................................................16
7 – Explain Referential Integrity............................................................................................................17
C: Reflection Paper....................................................................................................................................17
1 – Purpose & Function of Dashboard...................................................................................................17
2 – Business Intelligence Tool Justification...........................................................................................17
3 – Data Preparation Steps.....................................................................................................................18
4 – Dashboard Creation Instructions......................................................................................................20
5 – Results.............................................................................................................................................22
6 – Data Analysis Limitations................................................................................................................22
3


D: References & Sources...........................................................................................................................22

, A: Interactive Data Dashboard
Copy of Tableau Dashboard
The following link will open the Tableau Dashboard that was created for this exercise:
D211_SI Tableau Public




Four Data Representations
Data Representation Description Visualization Type
2024 U.S. Population & # of This map depicts the total Symbol Map
Loyal Customers by State population of each U.S. in 2024
using Census data (United States
Census Bureau, 2024). It also
includes the Telecommunication
Company’s number of loyal
customers (customers who did
not churn) by state (WGU, 2025).
Average Monthly Charge ($) by This text table includes the Text Table
State average monthly cost ($) of