Tips: Analyze and Visualize Data (Power BI)

This is the third course in the Microsoft Professional Program for Data Science. You can ought to choose between Analyzing and Visualizing Data with Excel or Power BI or do both. Of course it is better if you take both options but in my case, due to the limited amount of time that I have, I chose to take Power BI first then maybe take the Excel one when I still have time for this particular course run (until June).

So far personally this is my favorite. I have used Power BI before but not extensively so this course made me appreciate data even more because of the powerful visualizations Power BI provides. It has nine modules and has knowledge checks and lab exercises for each one except for the last module. They are all graded and unlike in the previous course in TSQL, most questions give you up to two attempts– which I find generous and lenient.

What I did was take notes in every video instead of actually trying out the things they do while watching it. I will have the chance to try Power BI hands-on anyway when doing the lab exercises so I can just focus on listening to the instructors and take down notes. In this way, if I forget the steps they did in, say, creating a particular chart, I won’t have to re-watch the video when answering the knowledge checks and lab exercises. It has no final exam by the way.

See you in the next module and happy studying!

Tips: Query Relational Data

This is the second course in the Microsoft Professional Program for Data Science. It is about Transact-SQL and the laboratory exercises in every module is done in an external site, i.e., DataCamp wherein you have to complete the SQL queries to gain the needed XP points. The last time I wholeheartedly used SQL was 2 years ago and before taking up this course I can say that I only know the basics– say, SELECT ___ FROM ___ WHERE. Right now I can say that my T-SQL skills have leveled up even though the exercises aren’t enough for me to fully practice.

The lab exercises and final exam are graded so only one attempt to answer per questions is allowed. I suggest take notes on where to use some of the queries and what will be the outcome when using different functions. The final exam doesn’t purely focus on the syntax– some questions will make you recall the concepts or the use of a particular SQL command that was brought up in the video so be patient in the modules (they’re 11!). Save the SQL queries / your answers in the lab exercises to a file because they might come in handy in the next questions.

See you in the next module and happy studying!

Tips: Data Science Orientation

This is the very first course in the Microsoft Professional Program for Data Science. All of the questions are not graded (except for the surveys) but I suggest you take each questions in the exercises seriously.

Module 1 explains how the courses run and gives us an overview (and inspiration) of what data scientists do.

Module 2 is about data science fundamentals. Listen carefully while the instructor is talking about Excel. Take note when the different Excel visualizations are best used, addressing common issues when dealing with data, knowing which charts should be used in various scenarios, and how to interpret the result chart/graph/visualization. Those will help you answer the questions at the end of the module.

Module 3 helps us understand basic statistics because the examples used are easy to grasp. There is a handout at the end of this module that summarizes the statistical concepts discussed. Make sure you understand the concepts, at the very least, since those will be the type of questions at the end.

In the Lab Exercise, you will be given a file wherein you have to follow the instructions so you can answer the questions afterwards. If you took note of what’s in modules 2 and 3 then you’re good.

See you in the next module! Happy studying!

Road to Microsoft Professional Program Certificate in Data Science

Hey everyone! This is my first post here and as the title suggests, I am currently taking up the Microsoft Professional Program for Data Science. For those who don’t understand Data Science, if I’m going to explain it in my own words, I’d say it is making the most out of the data available around you! Data Scientists aren’t just developers; they’re also great storytellers and visualizers. Basically, data scientists are an amalgam of various skills– including statistics and even art!

I, myself, aspire to be a Data Scientist. I just love looking at and analyzing huge amount of data and find out what can be discovered from those. It’s like treasure hunting with all the data as your map, and finding gold bars with other precious gems in a treasure chest is just so fulfilling. I believe what I currently know about college statistics and machine learning aren’t enough. There’s more to Data Science so as a first step, I’m taking the said program.

Microsoft Professional Program for Data Science includes the following courses:

  • Data Science Orientation
  • Query Relational Data
  • Analyze and Visualize Data
    • Excel (and/or)
    • PowerBI
  • Understand Statistics
  • Explore Data with Code
    • R (and/or)
    • Python
  • Understand Core Data Science Concepts
  • Understand Machine Learning
  • Use Code to Manipulate and Model Data
    • R (and/or)
    • Python
  • Applied Data Science
  • Final Project

I chose the April-June 2017 course run (with the Final Project to be done in July). I will be publishing posts for every course to give some tips and reflections of what I’ve learned and maybe I could help aspiring Data Scientists, like myself, in their journey.