Missing Stop Sign

Started using the system that the City has for reporting issues.  It is clunky, but a means, I suppose.

The first request was for the Stop sign that has been missing for the last few years, ever since someone ran it down.  I also turned in a couple of street lights that were out over by the community center.

Request: The STOP sign for southbound traffic on N.K was damaged in an accident a few years ago and was never replaced ... not sure if that is by design, but it continues to create hazardous conditions for those traveling east-west on NW.Terr.

Someone from their office responded today, after about a week.

I have reviewed the City's traffic code and there is no ordinance for a stop sign at this location. I will review the area to see if a stop sign is warranted.

I have no idea what this person is talking about.  There has been a stop sign there for the last 50 years, until that accident.  

Team Players Report

The Team Players report monitors observations of Team Players and Dream Slayers behaviors, tracks coaching and observation activity, reviews feedback trends, evaluates observation quality through IOA scoring, and supports training and performance-improvement initiatives.

Overview

The Overview page serves as the primary dashboard for Team Players observation activity. It provides a consolidated view of observations, feedback, coaching activity, IOA scores, potential misconduct reports, and recommended training trends.

The page allows users to:

• Review overall observation activity.
• Monitor Team Players and Dream Slayers trends.
• Review coaching participation.
• Monitor IOA scores.
• Review potential misconduct reports.
• Monitor recommended training activity.

Team Players

The Team Players page serves as the primary analysis page for positive Team Players behaviors observed during coaching and observation activities. It focuses on behaviors that support dignity, respect, autonomy, and positive interactions.

The page allows users to:

• Review Team Players behavior observations.
• Monitor positive feedback trends.
• Analyze observed Team Players skills.
• Review behavior frequencies across observation periods.

Dream Slayers

The Dream Slayers page serves as the primary analysis page for negative or concerning behaviors observed during coaching and observation activities. It helps identify behaviors that may require coaching, training, or intervention.

The page allows users to:

• Review Dream Slayers behavior observations.
• Monitor corrective-feedback trends.
• Analyze observed behavior concerns.
• Identify recurring behavior patterns.

Shared Observations

The Shared Observations page serves as the observation-quality and collaboration page for Team Players observations. It focuses on observations involving multiple observers and supports review of observation consistency.

The page allows users to:

• Review shared observations.
• Monitor interobserver agreement activity.
• Review consolidated observation data.
• Evaluate observation consistency.

Additional Questions

The Additional Questions page serves as the review page for supplemental information collected during observations. It focuses on additional training needs, concerns observed, and follow-up information added to the observation process.

The page allows users to:

• Review concerns observed during coaching activities.
• Monitor recommended training activities.
• Review supplemental observation responses.
• Identify potential follow-up opportunities.

IDT Summary

The IDT Summary page serves as the executive and interdisciplinary team review page for Team Players observations and coaching outcomes. It consolidates key metrics used for operational review and discussion.

The page allows users to:

• Review key Team Players metrics.
• Monitor observation and coaching outcomes.
• Review performance trends.
• Support IDT discussions and decision making.

Version Notes

The Version Notes page serves as the technical and administrative reference page for the report. It documents report enhancements, data-source changes, calculations, maintenance history, and report administration information.

Create a Due Date based on a Date

Yet another Power Query note for Power BI. 

I have a string of dates in which I need to create a due date as the 5th of the following month.

In Power Query,

1. Choose the Date Column
1. Choose Add Column Tab
1. From Date & Time
1. Date > Month > Month
2. Go to the formula box and change
1. "Month" to "NextMonthDate"
2. "Date.Month([Date]" to "Date.AddMonths([Date],1"
3. Change NextMonthDate column to a Date type, if is not already
4. Choose the NextMonthDate Column
1. Choose Add Column Tab
1. From Date & Time
1. Date > Month > Month
5. Add Column Tab
1. Custom Column
1. Name = Fifth
1. = 5
6. Choose the NextMonthDate Column
1. Choose Add Column Tab
1. From Date & Time
1. Date > Year > YEar
7. Select Columns for Month, Fifth, Year
1. Transform to Text type
8. Add Column
1. Custom Column
1. Name = "DueDate"
2. [Month]&"/"&[Fifth]&"/"&[Year]
9. Select DueDate Column
1. Transform to Date type

There may be a more effective way, but this method seems to work perfectly.

TMO Survey Report

 

The TMO Survey report captures and summarizes feedback from Team Member Orientation participants. It helps Training leadership evaluate orientation effectiveness, measure participant satisfaction, identify improvement opportunities, analyze survey responses over time, and review participant comments.

Overview

The Overview page serves as the primary dashboard for monitoring Team Member Orientation survey results. It provides a summarized view of participant responses and overall satisfaction trends across survey categories.

The page allows users to:

• Review overall survey results.
• Monitor average scores across survey questions.
• Analyze survey trends by reporting period.
• Evaluate participant perceptions of orientation effectiveness.
• Compare results across survey topics.

Categories

The Categories page serves as the detailed analysis page for survey response categories. It allows Training leadership to review responses by individual survey topic and identify strengths and improvement opportunities within the orientation process.

The page allows users to review survey responses related to:

• Welcome experience.
• Productivity and preparedness.
• Responsiveness of support staff.
• Classroom training effectiveness.
• On-the-job training effectiveness.
• Confidence in performing job duties.
• Training level appropriateness.
• Additional learning needs.

Comments

The Comments page serves as the qualitative feedback review page for Team Member Orientation surveys. It provides visibility into participant comments and written feedback collected through the survey process.

The page allows users to:

• Review participant comments.
• Identify recurring themes.
• Evaluate recommendations for improvement.
• Monitor participant concerns and successes.
• Support continuous improvement initiatives.

Version Notes

The Version Notes page serves as the technical and administrative reference page for the report. It documents report enhancements, data-source changes, maintenance history, and report administration information.

Classroom Evaluations

The Classroom Evaluations report provides analysis of classroom training evaluations submitted by participants. It helps Training leadership evaluate course effectiveness, instructor performance, training relevance, participant satisfaction, and opportunities for improvement. The report updates nightly.

Overview

The Overview page serves as the primary dashboard for classroom training evaluation results. It provides a summarized view of participant ratings and overall training performance across courses and reporting periods.

The page allows users to:

• Review overall classroom evaluation scores.
• Monitor average training satisfaction ratings.
• Analyze evaluation trends over time.
• Compare training performance across courses.
• Identify strengths and improvement opportunities.

Categories

The Categories page serves as the detailed analysis page for classroom evaluation categories. It groups survey results into the three evaluation areas defined by the Training Department: Course, Instructor, and Time & Space.

The page allows users to review feedback related to:

• Course
• Training objectives were clearly defined.
• Materials and handouts were helpful.
• Topics were relevant.
• Content was organized and easy to follow.
• Training will be useful in the participant's work.
• Instructor
• Trainer knowledge of the subject matter.
• Trainer preparation and organization.
• Training objectives were met.
• Participation and interaction were encouraged.
• Time & Space
• Time allotted for training was sufficient.
• Meeting room and facilities were adequate and comfortable.

Comments

The Comments page serves as the qualitative feedback review page for classroom training evaluations. It provides visibility into participant comments regarding what worked well and what could be improved.

The page allows users to:

• Review participant comments and suggestions.
• Identify recurring themes across training events.
• Evaluate recommendations for course improvement.
• Monitor participant feedback regarding instructors and course content.
• Support continuous improvement initiatives.

Version Notes

The Version Notes page serves as the technical and administrative reference page for the report. It documents report enhancements, data source changes, maintenance history, and report administration information.

This Semantic Model leverages a single data table.

Classroom Evaluations

 

The Classroom Evaluations report provides a centralized view of classroom training evaluation results, enabling users to monitor participant satisfaction, analyze rating trends, and review feedback comments for completed training sessions.

Overview

This page displays the main evaluation results across time. It includes a trend-style visual for average scores by quarter, along with a detailed table showing monthly average scores for each evaluation question, including objectives, participation, relevance, content, materials, usefulness, trainer knowledge, trainer organization, objectives met, time, and facilities. The page also includes filters for Date, Instructor, and Training.

Categories 

This breaks the evaluation results into grouped reporting categories. It includes visuals for Overall, Course, Instructor, and Time & Space, allowing users to compare how different parts of the classroom training experience are rated over time. The Course category includes objectives, materials, relevance, content, and usefulness. The Instructor category includes trainer knowledge, trainer organization, objectives met, and participation. The Time & Space category includes training time and room/facility adequacy.

Comments 

A simple page displaying open-ended evaluation feedback from participants. Available comment fields include Suggestions and Likes, allowing users to review qualitative comments tied to classroom training evaluations.

Onboarding Survey Report

The Onboarding Survey report monitors new employee onboarding feedback and satisfaction. It helps Training leadership evaluate onboarding effectiveness, identify improvement opportunities, measure employee perceptions of training and support, and review participant comments and recommendations.

Overview

The Overview page serves as the primary dashboard for onboarding feedback and satisfaction trends. It provides a summarized view of survey responses and overall onboarding performance across reporting periods.

The page allows users to:

• Review overall onboarding survey results.
• Monitor average onboarding scores.
• Analyze survey results by reporting period.
• Evaluate overall onboarding satisfaction.
• Identify onboarding trends over time.

Categories

The Categories page serves as the detailed analysis page for onboarding survey topics and response categories. It allows Training leadership to identify strengths and opportunities within the onboarding process.

The page allows users to review feedback related to:

• Feeling welcome within the organization.
• Productivity during onboarding.
• Supervisor responsiveness to communication.
• Classroom and online training effectiveness.
• On-the-job training effectiveness.
• Confidence using required tools and systems.
• Training appropriateness and sufficiency.
• Remaining learning needs.

Comments

The Comments page serves as the qualitative review page for onboarding survey feedback. It provides visibility into participant suggestions, concerns, and recommendations for improving the onboarding experience.

The page allows users to:

• Review participant comments.
• Identify recurring feedback themes.
• Evaluate onboarding improvement recommendations.
• Monitor participant concerns and successes.
• Support continuous improvement efforts.

Version Notes

The Version Notes page serves as the technical and administrative reference page for the report. It documents report enhancements, data-source changes, maintenance history, and report administration information.

Semantic Model relies upon a single table of data.

Missouri Lewis & Clark Expedition

Wandering up to Lewis & Clark State Park seemed a good way to waste an afternoon when others were mired in the usual Labor Day activities.  There is not a lot to see there beyond a huge compass and a mostly dried up and overgrown lake bed. Google Maps displays much more water in their aerial view, labeled as having been taken in 2024.  Where did it all go?  The Missouri State Parks web site indicates the water has disappeared entirely due to prolonged drought conditions in the area.

The lake was not even a high point in the Lewis and Clark Expedition, excepting that they named it Gosling Lake and that they explored it on the 4th of July in 1804.  Beyond that, it is little more than a note in their long adventure.  It was an equally interesting distraction for us, with typical wetland growth in full depth, though beginning to wind down for the season.

Meriwether Lewis and William Clark would have enjoyed the nice paved path representing the Interpretive Trail out to the compass overlook.  Connecting with the Gosling Lake Trail, it turns to gravel and completely gives up on anything but a mowed path for the Independence Trail, bordered by sunflowers reaching as high as 5 meters..  This latter is not even listed on the Missouri State Parks web site, so must be a late addition.