Skip to main content

An Update on My Journey | September 2020


 It is time for another update on my Power BI journey.

In my last journey update, I thanked quite a few people who have been giving me the support and encouragement to continue on this journey.  I want to say thank you to all of them again as they never fail to provide the praise, encouragement, and help whenever I need it most.

Okay, so here is the update.  I have passed another certification!!!! A few weeks ago I took the PL-900 exam also referred to as the Power Platform Exam.  If anyone reading this blog now is thinking about taking this exam and wants to gain insight into the resources I used--- then keep reading.  In addition to passing another exam, I am now a fully-fledged official Microsoft Certified Trainer.  I just received the email this week from Microsoft and I am super excited to have reached this accomplishment within the first 6 months of beginning here at Pragmatic Works.

Most of my days are now filled with training sessions that have been developed and tailored intentionally for Humana employees.  It has been a blast teaching the employees at Humana how to make a Power App and how to analyze their data using Power BI.  As a teacher, I am always aware of the better connection you can make to a student the easier it is to learn.  My fellow trainers know this as well which is why they decided to make sure the training we delivered to Humana was personalized.  So the data we use in the training is actual Humana type data rather than just random sales data that you usually see in blogs or YouTube videos.  

On the days when I am not teaching, I am always trying to learn more.  My next project is to do a deep dive into Power BI data flows so I can record an On-Demand Class for others who are ready to continue their Power BI learning.

One of the things I was the most hesitant about switching careers is missing the interaction with my middle school students.  I knew that I thrived and fed off the energy of the students and loved it when I could see the light bulb turn on.  Luckily, I found that wonderful feeling again with the adults I train now.  I didn’t know that I could get the same gratification as I had previously in the past 16 years, but it turns out it feels just as good coming from adults.

If you made it this far in the blog, I want to share some of the resources I used to prepare for the PL-900 exam.  Fortunately for me, I have a leg up on most when it comes to learning the material needed for any of my certification exams.  That leg up is the on-demand training we record at pragmaticworks.  This is always the first place I go to start learning the basics and then advanced materials.  The PL-900 exam covers Power BI, Power Automate, Power Apps, and Power Virtual Agent.  Luckily we have over 20 courses devoted to those programs.  Once I felt I had mastered the lessons from our On-Demand Learning I then scoured YouTube for some channels that had great material covering the Power Platform.  I recommend the following YouTube channels and playlist for a start. 

 BrianKnight’s Power Apps Playlist 

PowerVirtual Agent Crash Course 

GuyIn A Cube 

Reza Dorrani's Channel

As always, thanks for following me on my journey from Algebra Teacher to Power BI trainer. I can't wait to see what happens next. 

Comments

Post a Comment

Popular posts from this blog

Best Practice To Trim Before Removing Duplicates or Merging In Power Query Editor

In last week’s blog, I wrote and did a video about how to remove duplicate records and keep the most recent entry as long as a date column was part of the data source.   I came across the scenario while giving training on Power BI with my company Pragmatic Works.   See the video below:     This week, while doing another two-day training I came across a different scenario from a follow-up conversation from day 1.   I had explained how to remove duplicate records and one of the students started working on a Power BI project she has for her company.   On day 2 the student informed me that her remove duplicates step was not working.   I said that is odd and I asked to see the data.   In one of her table visuals, I could see that it appeared that a few of the records had duplicates based on the name column.   After further investigation though, we figured out the culprit.     She had done all the steps correctly, but it was a data integrity issue.   In her data source, the perso
Post a Comment
Read more

The Power of CALCULATE in Power BI

Last week in my blog and video I discussed how Power BI could have made my life as a teacher much easier.  It is not that Power BI can do things that I could not on my own.  It is the fact that Power BI could have saved me so much time.   This led me to some thoughts and questions.   How could I have impacted the students more in the classroom with this extra time?  Would teachers who were not analyzing student data due to time constraints now start?  How can I make the data tell my students a story that gives them an accurate picture of their progress?   That last question is what leads to this week’s blog.   Many times the metrics (which is just a fancy word for "numbers") of what we want to show are easy to do by hand with a basic math background.  Although easy, it can be very time consuming when dealing with different groups of data: like 6 periods of students instead of 1 period. When we want to do these calculations quickly with minimal effort in Power BI it is not
7 comments
Read more

Relating "Related Tables" to Baseball because I Miss Sports

I miss sports. In particular, I miss baseball. Between learning more Power BI functions and the ins-and-outs of DAX, I've turned to Netflix to fill the deep caverns left in my soul since baseball season has been postponed. And as a result, I've thought more about tigers and big cats more than I ever have in my life. I know ALL about Carol Baskins and am fully on board for a spin-off centering on locating her lost husband. I've googled "is it really legal to own a tiger in a residential area?" Without baseball in April, I am barely hanging in there (kinda like Joe Exotic's eyebrow ring). So, I am filling the sports-sized hole by using baseball stats in Power BI to demonstrate pulling data from multiple tables and consolidating it into one table.  Some of the data we want to consolidate also has to have some aggregations (which is fancy for "calculations") performed on it.  In this demo I will attempt to break down what is really going on
Post a Comment
Read more