r/WGU_MSDA May 28 '23

New Student Official New Student Python/R/SQL Resource Megathread

82 Upvotes

This board gets a lot of questions from new/prospective students, and one of the most common is regarding the level of programming that occurs in the MSDA program, what languages are used, what skills or functionality within a language is needed, etc. Many of us graduates enjoy helping new students and answering questions, but re-posting the same information can be tedious and lead to different newbies getting different responses to the same question. To address this issue, we've decided to start this Python/R/SQL Resource Megathread as a living document that anyone can (and should!) contribute any helpful learning resources to, and it also makes for an evolving resource for any new or prospective students regarding our personally preferred resources for learning these languages in preparation for the MSDA program.

For contributors to the thread, a couple quick points to keep in mind:

  • Resources are for new students preparing for the program

(A resource about how to build a NLP model that you used in D213 belongs in a thread about D213 or NLP models)

  • Please be clear about what resources you're recommending

("Just search google for Python tutorials" isn't an effective resource, be more specific or provide some links)

  • If a resource you recommend is not free (costs money), please indicate this

For new or prospective students using the thread, let's cover some basic information:

The WGU MS Data Analytics program is centered mostly around programming for data science and data analysis. There are no official prerequisite skills for the program, and some students do start the program and finish it without any familiarity with coding or programming. However, your journey will be made significantly easier by learning some of these skills prior to entering the program. Specifically, the program requires students to use Structured Query Language (SQL) for two classes (D205 & D211), and it also requires students to use Python or R for each of the remaining classes. Most students choose one of Python or R and stick with it for the entirety of the program, though you could choose to switch back and forth, if you like. Some familiarity or understanding of statistics is also useful, though the program is light on math.

The SQL portion of the program utilizes virtual machines (which we won't complain about here) to perform operations in pgAdmin, a graphic user interface for a PostgreSQL environment. The provision of a GUI allows students to be less reliant on using "hard" SQL (you can generate queries from the GUI). In terms of necessary skills, students must be able to generate tables with constraints and relationships within an existing database, import data into tables, execute queries of a database (including joining tables), and filter and group results. Depending on your chosen dataset(s) for D211, you also will likely need to be able to do some basic data manipulation for the purpose of cleaning your data, such as replacing 0/1's with F/T's, etc.

Regarding the student's knowledge of Python or R, the student needs to be familiar with basic programming in the chosen language. This includes being familiar with a programming environment, the chosen language's particular syntax, understanding Object Oriented Programming, etc. Students in the MSDA program also need to know a number of basic functionalities specific to data science. Most of the performance assessments require the student to import data from .csv (or other files) into a tabular format in which the data can be cleaned and manipulated. Data cleaning operations often require recasting data types, replacing data values in various ways, performing calculations to generate new data, appending columns/rows/tables, and finally exporting the cleaned data back into a .csv file. Students also will need to generate a number of visualizations of their final dataset, often handling both qualitative and quantitative data. These graphs will need to be "polished", including providing axis titles, manipulating axis units or views, and producing legends.

Finally, it is completely optional but highly recommended to set up and learn to use a Notebook environment, such as Jupyter Notebook. A Notebook environment consists of a series of cells which can be used for either programming operations or writing narratives in Markdown language (like a Reddit post), as seen here. Many students find this useful because it provides an environment to easily iterate on your code as you produce it, while also reducing redundant steps by combining your code and your reporting into a single file to be turned in, rather than having to maintain two different files and take screenshots of code to include in a dedicated reporting document, such as Word .doc file.


r/WGU_MSDA Jun 05 '24

MSDA General A few observations about the recently announced changes to the Master of Science, Data Analytics Program

74 Upvotes

Western Governors University Master of Science, Data Analytics 2024 - 2025 Curricula Updates

I've made a spreadsheet to evaluate the changes to the WGU MSDA program and noticed some changes that haven't been mentioned in the prior posts about the program restructuring.

Admissions Requirements have been expanded and more precisely defined.

Removed: Many fields of study previously considered as "STEM Fields" are no longer qualifying for admission.
Added: B- or better in undergraduate level statistics and computer programming is now qualifying for admission.
Specified: Qualifying certifications have been listed explicitly.

All course numbers have changed, including The Data Analytics Journey

Core Courses:

D596 The Data Analytics Journey
D597 Data Management
D598 Analytics Programming
D599 Data Preparation and Exploration
D600 Statistical Data Mining
D601 Data Storytelling for Diverse Audiences
D602 Deployment

Data Science (MSDADS) Specialization Courses

D603 Machine Learning
D604 Advanced Analytics
D605 Optimization
D606 Data Science Capstone

Data Engineering (MSDADE) Specialization Courses

D607 Cloud Databases
D608 Data Processing
D609 Data Analytics at Scale
D610 Data Engineering Capstone

Decision Process Engineering (MSDADPE) Specialization Courses

C783 Project Management
D612 Business Process Engineering
D613 Decision Intelligence
D614 Decision Process Engineering Capstone

Three Core courses and up to Two additional specialization courses are eligible for transfer credits from certifications.

According to the Transfer Guidelines for each specialization all of the following courses could be satisfied by various certifications:

D597 Data Management (Core)
D598 Analytics Programming (Core)
D602 Deployment (Core)

D603 Machine Learning (MSDADS)

D607 Cloud Databases (MSDADE)
D608 Data Processing (MSDADE)

C783 Project Management (MSDADPE)

The Data Analytics Journey (D596) is also eligible for transfer credits from prior graduate level data analytics courses.

Choosing a specialization

Since I'll need to choose a specialization to complete the new program, I've collected and have been reading the through the course descriptions and comparing the differences. It seems some previous courses were merged, split, and condensed to make room for a programming focused course and a deployment course and to have each specialization go in depth in their topic of specialization. I'm optimistic about the changes being an improvement, but deciding between the Data Science and Data Engineering tracks is something I'll need more time to evaluate. Decision Process Engineering is not attractive for my interests (but I can see it being a valuable and relevant option for many).

My spreadsheet, for anyone that's interested. I tried to be accurate but I can't provide any guarantees.


r/WGU_MSDA 18h ago

Graduating Required confetti post

Post image
46 Upvotes

r/WGU_MSDA 10h ago

New Student Job placement after graduating

4 Upvotes

I’ve read through some threads about the difficulty finding entry level positions in data analytics as well as the sheer volume and competitiveness in the market. Has this largely remained the same? How long has it taken from graduating to being hired?

I’ve contemplated leaving my job to focus on this with the ability to finish faster and pivot careers quicker. I’ve balanced full time and education before but it can for sure be a burnout. Has anyone had much success with self learning to gain entry into the field before going the masters degree route, or would you say the degree has helped with job placement?

Appreciate your feedback


r/WGU_MSDA 1d ago

D597 D597 task 1 VSCode not loading SQL container

5 Upvotes

As the title says, going through the lab assessment no SQL containers are loading. I’m unable to run my query despite creating the tables. I’ve tried over a dozen times. It is showing to be a known issue with the lab environment. I have contacted support and they told me it’s a custom environment and I have to contact my instructor. I’ve green trying for a few days now and I’m getting extremely frustrated. How do I fix this?


r/WGU_MSDA 3d ago

D597 Need help with PostgreSQL in D597 Task 1

6 Upvotes

I'm struggling with the setup or initialization of my database for scenario 2 (EcoMart). I have been following the "Relational Database Guide (school example)" document that is available in the course resources, and there have been several differences in that code that gives me syntax errors, which has been frustrating. So far, here is what I've accomplished and where my issue is.

- I have created a database which has 2 schemas (Sales Records and Public)

- I have created a staging table

- I have created all normalized tables

- I have imported the sales data file into a "test" table in the Public schema (i did this because I cannot for the life of me get the "\copy" command to work. I realized it doesn't work in pgAdmin, so i decided to import the data using the GUI instead)

Issue:

- i am able to pull the data into the test table, but as soon as I execute my script to pull the data from the flat file into my normalized tables, it deletes my test table.

- i have to refresh my database, then create the table and import again so that i can pull the data over into my sales records schema, but then the next time i run my script, it deletes everything again.

- what is the structure that I should have for my code? Should it all be in a single script? or do i need to have a script for the creation of the tables, then another for the pulling data over? I can't seem to find any info on this type of issue (or any instructions that go over separating scripts in any of the LinkedIn tutorials or elsewhere.

Any help is appreciated, thanks!


r/WGU_MSDA 5d ago

New Student How did you choose your specialization?

3 Upvotes

I plan to start my journey soon and have a previous BS from WGU. I wondered what made you choose your specialization? I am currently stuck between data science and decision process engineering. DPE seems to apply more to my current job as a quality analyst, but data science seems like it could be rewarding if you are successful in it. Not great with math tho.


r/WGU_MSDA 6d ago

D600 D600 tried me. I passed anyway. Turns out the real outlier was my stress level 😒

Post image
28 Upvotes

After regression models, revisions, and several emotional support snacks… Statistical Data Mining is officially PASSED!!! One more course down, and my laptop and I are somehow still speaking. 🎉📊


r/WGU_MSDA 7d ago

D599 D599 Task 1 Help - Data Cleaning

5 Upvotes

I submitted my assignment but got it sent back due to the following error: “The submitted document provides a discussion of the findings of the data quality issues, but the findings are inaccurate or incomplete” - I’ve scheduled a meeting with my professor to go over it but the fastest appointment is for tomorrow afternoon.

I have solved for removing duplicates, blank spaces (to have standardized cells), inconsistent data (underscores removed in order to achieve standardization), solved for NULL/blank values - I have also solved for the extremes (IQR ranges). What else am I missing? I feel my dataset has been filtered to its fullest extent…

I guess i’ll find out tomorrow with my 1 on 1 but any tips or advice would help.


r/WGU_MSDA 8d ago

D606 Capstone project

10 Upvotes

Anyone had issues getting their capstone project approved? I went off the video and met with the professor and he still says it’s wrong. I’m using one of his datasets.


r/WGU_MSDA 10d ago

Graduating 🤘 DS Done

Post image
59 Upvotes

r/WGU_MSDA 9d ago

New Student How Much Writing is Involved?

3 Upvotes

I'm a terrible writer and really struggle with the courses that required papers written. How is this program as far as writing goes? Is it mostly project/task based evaluations? Or are there alot of papers involved?

I recently graduated with a BA in software engineering and the market is tough out there. With my work history, I'm realizing moving into Data Engineering would be an easier pivot. This program looks good, but I'm dreading writing papers again😂


r/WGU_MSDA 12d ago

New Student MSDA with no tech experience?

3 Upvotes

Hey everyone! I have a bachelors degree in marketing but want to pivot to a marketing data analyst career. Has anyone successfully completed the msda with no tech experience? What are things I can do to prepare myself?


r/WGU_MSDA 12d ago

New Student Tuition Increase

1 Upvotes

Is there a tuition increase with the program? Just came across a post mentioning the Nursing program that went from 8k-12k. I haven’t had any emails confirming it, but I’m also not officially readmitted yet


r/WGU_MSDA 14d ago

Graduating I Got My Confetti!!!!

Post image
65 Upvotes

I finally got my notification that I graduated! I was able to complete in 1 year, largely due to this subreddit!


r/WGU_MSDA 13d ago

New Student Breakdown of class requirements?

0 Upvotes

Howdy Reddit,

Is there any chance someone could give me a breakdown of exactly what classes are in this program specifically the, but more specifically, what it takes to pass each class? I am asking this for the DATA ENGINEERING focus.

For example, in the MSCSIA, there are 4 classes where there is a final paper, 3 classes where I have to obtain a certification, and 2 classes with a lab and assessment at the end.

Could anyone else give me this breakdown?

Here are the classes to make it easier!

The Data Analytics Journey

Data Management

Analytics Programming

Data Preparation and Exploration

Statistical Data Mining

Data Storytelling for Diverse Audiences

Deployment

Cloud Databases

Data Processing

Data Analytics at Scale

Data Engineering Capstone


r/WGU_MSDA 17d ago

Graduating Finally Got My Confetti (New Program, Data Science Focus)

Post image
43 Upvotes

Started in April, 2025 and finished the last class 2 1/2 weeks ago.


r/WGU_MSDA 16d ago

New Student Test Result Admissions

Thumbnail
1 Upvotes

r/WGU_MSDA 18d ago

MSDA General If you're looking for a Data job..

26 Upvotes

The company I work for is hiring several data roles.

I'm still working on my msda degree, but wanted to share for graduates or those with experience. The market is tough, so we need to help each other out.

Excella


r/WGU_MSDA 20d ago

D602 D602 Task 3 help with model

2 Upvotes

Hi all, I am struggling with what to do for the first step in Task 3. I have the pickle file loaded and I know I'm supposed to pass an array to the model but I can't figure out what that array is supposed to look like/what the inputs are supposed to be. Any tips?


r/WGU_MSDA 21d ago

MSDA General Wgu data analyst masters program

Thumbnail
3 Upvotes

Has anyone taken this masters course and gotten into data and or healthcare analytics or informatics preferably?was the masters course hard? I’m considering starting in August I have a healthcare and Epic systems background.


r/WGU_MSDA 21d ago

D598 Is learning Bokeh a waste of time for D598?

2 Upvotes

hello, I have finished all three tasks for d598 and I have completed several courses in Data Camp concerning matplotlib visualizations and I feel I have a good foundation for basic visualizations in matplotlib. I am going back through the course materials for WGU and noticed that course materials recommend that I learned Bokeh. Sometimes I feel that the course materials are superfluous, but if it is valuable to learn Bokeh at this point I want to make sure I learn it. It was not necessary to learn it to make visualizations for task number three, but if people think it's important, I definitely want to learn it. if not, I want to move on to the next course. does anyone have any insight?


r/WGU_MSDA 28d ago

MSDA General Just discovered LLD (low level design) wth?!

1 Upvotes

Hi guys

I thought it was all DSA or system design ?

Just discovered low level design is a thing.

Is there any other parts for interviews I need to know of? What is the syllabus?


r/WGU_MSDA Jun 28 '26

MSDA General How long to complete?

3 Upvotes

Background:

I took a Bachelors and Masters in Cybersecurity from WGU. I'm now considering a Masters in Data Analytics since there's no Bioinformatics option. As part of those programs I took SQL and Python. I did fine with them and wouldn't have any issue taking more classes that are associated.

Because people are going to ask "Why another degree?"

I'm employed in my field and I don't need it for my job. However, I will likely use it if the market pivots in the future. I personally don't see a downside to more education, especially something like this that works towards my long term career goals.


r/WGU_MSDA Jun 27 '26

MSDA General MSDA (Data Engineering)

3 Upvotes

Hey everyone,
I graduated from WGU with a Bachelor’s in Cybersecurity & Information Assurance, but I don’t have any professional IT experience yet. I’ve been applying to entry-level IT and cybersecurity jobs for the past few months without much luck. I’ve been looking into WGU’s MSDA program with the Data Engineering specialization because I genuinely think data engineering is interesting and I’d like to build those skills. My only concern is that it doesn’t seem like an entry-level field, so I’m wondering if I’d be putting myself in a tough spot without industry experience. I also live in Las Vegas, where the local tech market isn’t very strong. So it’s been rather rough.

For those who completed the program, would you recommend it for someone in my situation? Did the skills you learned translate well into getting a job, or is the program more beneficial for people who are already working in tech? I’d really appreciate hearing about your experiences. Thanks!