100% tevredenheidsgarantie Direct beschikbaar na je betaling Lees online óf als PDF Geen vaste maandelijkse kosten
logo-home
WGU D211 ADVANCED DATA ACQUISITION 2025 $16.49
In winkelwagen

Case uitwerking

WGU D211 ADVANCED DATA ACQUISITION 2025

 0 keer verkocht
  • Vak
  • WGU D211 ADVANCED DATA ACQUISITION
  • Instelling
  • WGU D211 ADVANCED DATA ACQUISITION

WGU D211 ADVANCED DATA ACQUISITION 2025

Voorbeeld 2 van de 15  pagina's

  • 9 december 2024
  • 15
  • 2024/2025
  • Case uitwerking
  • Prof
  • A+
  • WGU D211 ADVANCED DATA ACQUISITION
  • WGU D211 ADVANCED DATA ACQUISITION
avatar-seller
YANCHY
D211 Advanced Data Acquisition


WGU D211 ADVANCED DATA ACQUISITION 2025



A1: Data Sets
The dashboard containing my data analysis is attached to this submission. I would’ve published it to
Tableau Public, but that appears to not be an option for this class. This data analysis is identical to the one
I performed in D210, and thus it makes use of materials generated for that project, though it accomplishes
this through a different means to satisfy the requirements of this particular project for D211. Again, two
datasets are used for this analysis:

• The WGU medical dataset, provided by WGU for several of the classes in the MSDA program
• The 2013-14 National Health and Nutrition Examination Survey (NHANES), provided by the
United States Centers of Disease Control & Prevention



A2: Dashboard Installation
The dashboard is provided in a .twbx format, which can be opened with Tableau Reader. Because
it is not clear to me what evaluators are or are not able to do with the virtual machines, I have included
instructions using either the D211.zip file submitted alongside this report (if the evaluator can easily
transfer this file to the virtual machine) as well as a link to an identical version of D211.zip that can be
downloaded via Google Drive to the virtual machine. Which process is used is up to the evaluator.
In order to do this on the Labs on Demand virtual machine, the evaluator must do the following:

• IF POSSIBLE: Take the D211.zip file included alongside this submission, and open File
Explorer in the virtual machine, navigating to ‘C:\Users\Public\Downloads’ and pasting the
provided D211.zip file to this folder.
• ALTERNATIVELY: CTRL+click on this link to download D211.zip from my Google Drive.
Click the download icon in the top right of the screen to download the file. Open File Explorer
and navigate to the Downloads folder where this file was saved. Right Click on D211.zip to cut
the file, and then navigate to ‘C:\Users\Public\Downloads’, where you’ll paste the file.
• Right click on D211.zip and select “Extract All…”. Extract the files to
‘C:\Users\Public\Downloads’.
• On the desktop, double click on pgAdmin to open it. In the left side navigation pane, navigate
down to the “medical_data” database (one level below “Databases”).
• Right click on the “medical_data” database and select Query Tool.
• When the Query Tool panel opens on the right side of the pgAdmin window, select the “Open
File” button (second button from left).
• In the Select File dialog box, navigate to ‘C:\Users\Public\Downloads’ and select the SQL
Commands.txt file.
o It may be necessary to change the bottom-right “Format” drop-down menu to reflect “All
Files”, rather than just SQL files.
• Once the Query Tool has imported the contents of the SQL Commands.txt file, hit the Play button
in the top right corner to execute the query.
• Once the query is complete (this may take several seconds), close pgAdmin and return to the
desktop.
• Double click on Tableau 2021.4 to open Tableau Desktop.

, D211 Advanced Data Acquisition


• At the top left, click File > Open and navigate to ‘C:\Users\Public\Downloads’. Select the
20230103 Dashboard.twbx file to open it.
• When prompted to sign in to complete the connection to a server, use the username “postgres”
and the password “Passw0rd!”


At this point, the dashboard is “installed” and may be interacted with.



A3: Dashboard Usage
After opening the provided dashboard, I suggest navigating to the “PRESENTATION” story tab
at the bottom of the screen. This can be made into a full screen presentation by using the projector screen
button at the end of the ribbon at the top of the screen. The two boxes at the top of the story can be
thought of as “tabs” like you may find in your web browser.
The “Dashboard 1” tab is an interactable dashboard that provides visualizations about the WGU
Hospital System’s patient demographics, such as patient age, number of children, or gender. This data can
be filtered in multiple ways. In the bottom right of this dashboard are filters for both age and gender. By
adjusting the age slider, the user can change the range of ages reported. For example, setting the slider to
40 – 50 will show the distribution of patients aged 40 – 50, the number of children for patients aged 40 –
50, and the genders of patients aged 40 – 50. Similarly, clicking on any gender in the gender filter (which
also functions as a lend) will update all of the visualizations to reflect only the selected gender.
Alternatively, clicking on a portion of the visualization will filter in the same way. For example, clicking
on the “male” portion of the pie charts visualizing patient gender will update all data in the dashboard to
reflect only male patients, similar to using the filter in the bottom right. Clicking on the “male” portion of
the pie chart (or on “Male” in the filter) will “release” this filter and return the visualizations to the
original view.
The “Dashboard 2” tab is another interactable dashboard, providing visualizations and data about
selected serious medical conditions observed in both the CDC NHANES dataset and the WGU dataset.
The rate of diagnosis for each medical condition is provided as a key performance indicator (KPI),
demonstrating how many patients amongst both the WGU and CDC datasets have this condition. This is
further broken down in the heatmap to the right of each KPI, demonstrating the raw count of patients with
that diagnosis by age group, for both the CDC and WGU datasets. For reference, the WGU dataset has
approximately 150% more observations than the CDC’s NHANES data (10,000 rows vs ~6,100). The
same filters for age and gender are provided in the top right of this dashboard, and they are used in the
same fashion as they were in the previous dashboard.



A4: SQL Code
/* Before dealing with external data, I need to clean up the medical data provided by WGU to be
in the format that I want it to be. That's going to primarily include editing certain Yes/No string
fields to instead be True/False booleans. */

-- Modify highblood pressure to boolean, fix 'hignblood' typo in column name

Dit zijn jouw voordelen als je samenvattingen koopt bij Stuvia:

Bewezen kwaliteit door reviews

Bewezen kwaliteit door reviews

Studenten hebben al meer dan 850.000 samenvattingen beoordeeld. Zo weet jij zeker dat je de beste keuze maakt!

In een paar klikken geregeld

In een paar klikken geregeld

Geen gedoe — betaal gewoon eenmalig met iDeal, creditcard of je Stuvia-tegoed en je bent klaar. Geen abonnement nodig.

Direct to-the-point

Direct to-the-point

Studenten maken samenvattingen voor studenten. Dat betekent: actuele inhoud waar jij écht wat aan hebt. Geen overbodige details!

Veelgestelde vragen

Wat krijg ik als ik dit document koop?

Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.

Tevredenheidsgarantie: hoe werkt dat?

Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.

Van wie koop ik deze samenvatting?

Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper YANCHY. Stuvia faciliteert de betaling aan de verkoper.

Zit ik meteen vast aan een abonnement?

Nee, je koopt alleen deze samenvatting voor $16.49. Je zit daarna nergens aan vast.

Is Stuvia te vertrouwen?

4,6 sterren op Google & Trustpilot (+1000 reviews)

Afgelopen 30 dagen zijn er 69411 samenvattingen verkocht

Opgericht in 2010, al 15 jaar dé plek om samenvattingen te kopen

Begin nu gratis
$16.49
  • (0)
In winkelwagen
Toegevoegd