Show up in a powerful fashion: even when remote
tech, life Fred Kaffenberger tech, life Fred Kaffenberger

Show up in a powerful fashion: even when remote

On the podcast, Pfeffer gave a couple of people as examples: one was a tall woman, who also wore heels. The other was a short man, who commanded a room as if he were much taller. While both of these examples are height related, they also emphasize leveraging your strengths is a persuasive way. They also connect with another rule, which is to create a powerful brand. It seems to me that in-person will always be more powerful than remote, but even so, there are things I do to show up in a powerful fashion in a remote workplace.

Read More
Anti-LGBTQ bills in Missouri express the beliefs of conservative Christians
LGBTQ Fred Kaffenberger LGBTQ Fred Kaffenberger

Anti-LGBTQ bills in Missouri express the beliefs of conservative Christians

As of March 17, 2024: 16 lawmakers have sponsored 26 anti-LGBTQ bills in the Missouri legislature. 94% (15/16) of the sponsoring lawmakers are men. All sponsoring lawmakers are Christian and Republican. Most are evangelical Christian but 2 are explicitly Catholic. Half (8/16) have active leadership roles in their church: pastor, deacon, chaplain, lay minister, etc.

Read More
Open letter to Ambassador Allan Katz and the Board of American Public Square
American Public Square Fred Kaffenberger American Public Square Fred Kaffenberger

Open letter to Ambassador Allan Katz and the Board of American Public Square

I am concerned about the increase in violence against LGBTQ persons— as well as the rise in hostile rhetoric and laws targeted at making life more difficult, or even impossible for them. With such hostility on the rise, it makes sense to evaluate which events will contribute to reasoned discourse and greater understanding and acceptance, and which events are likely to deepen polarization and make public life less safe for people.

Read More
Poetry about work: Information Desk by Robyn Schiff
poetry Fred Kaffenberger poetry Fred Kaffenberger

Poetry about work: Information Desk by Robyn Schiff

Last week, a video popped up in my YouTube feed, from the Metropolitan Museum in New York. I’ve long been interested in poetry about work, so I ordered it right after watching the video. I’m also familiar with the Met from living in and visiting NYC. I loved the fact that the Met invited her back to her old workspace to read from her book. …

Read More
A victory for civil dialogue: American Public Square postposes their panel, “Exploring Gender and Identities”
culture, transgender, American Public Square Fred Kaffenberger culture, transgender, American Public Square Fred Kaffenberger

A victory for civil dialogue: American Public Square postposes their panel, “Exploring Gender and Identities”

American Public Square (APS) was planning to hold a panel discussion of trans rights. Today, I am glad to see that the event was postponed. While I am glad that it has been postponed, I will be happier when it has been canceled. It was a bad panel and the timing couldn’t be worse, immersed as we are in a moral panic about trans people.

Read More
Some context for the upcoming discussion of trans rights, presented by American Public Square
life, culture, transgender, American Public Square Fred Kaffenberger life, culture, transgender, American Public Square Fred Kaffenberger

Some context for the upcoming discussion of trans rights, presented by American Public Square

The scope of American Public Square's panel on "Gender and Identity" is balancing rights of trans people with protecting women and children in the context of anti-trans laws in Missouri and Kansas. This scope is bad because it pits trans rights against the needs of women and children. We need to go deeper.

Read More
Barbie: let’s not settle for the appearance of happiness
life Fred Kaffenberger life Fred Kaffenberger

Barbie: let’s not settle for the appearance of happiness

I don’t like knowing too much about a film before seeing it. I crave new stories, new takes, and I dread having to sit through a movie I’ve already seen before, with a different title. When a new movie comes out that looks interesting, I’ll try to find out just enough to see if I want to see it in the theater or not. …

Read More
Making work visible with our family Kanban
adhd, life, tech Fred Kaffenberger adhd, life, tech Fred Kaffenberger

Making work visible with our family Kanban

Our family just started using Kanban in the house. Kanban is a project management tool useful for prioritizing tasks as they come up. It’s typically used in work situations like maintenance, where emerging issues might pop up. I’ve been wanting to try Kanban for our household, and finally got it done. …

Read More
Summer Update
life, LGBTQ Fred Kaffenberger life, LGBTQ Fred Kaffenberger

Summer Update

Not only did I do the week-long class and test for the Microsoft DP-500, but I also did another class and test for the SAFe Agile Practitioner certification. I’m learning lots about Oracle reporting tools as well. Between that and Tears of the Kingdom, I haven’t had as much time for blogging. I plan to post more soon. […]

Read More
Cloud data warehouses: SCD Type 2 connected directly to the fact table
tech Fred Kaffenberger tech Fred Kaffenberger

Cloud data warehouses: SCD Type 2 connected directly to the fact table

In the section of Azure Power BI D5-500 training, I was surprised (and delighted) to see that Slowly Changing Dimension (SCD) Type 2 is presumed as the format for dimensions— and that these historical dimensions were connected directly to the fact tables. Up to this point, most data warehouses I have run into have used SCD Type 1 as the default, and then required analysts to do gymnastics to connect to a historical dimension. [I also include a link for what to do if this is not the design of your data warehouse]

Read More
Better user interface through DAX: Always show only 4 quarters in Power BI
tech Fred Kaffenberger tech Fred Kaffenberger

Better user interface through DAX: Always show only 4 quarters in Power BI

Simplicity is key to increasing usability. I want to enable report consumers to explore the data without having to think about the process of exploration. With this solution, a consumer can move back in time one quarter in time or jump from the current quarter to to the same quarter last year while keeping as much the same as possible, making it easier to think about comparisons.

Read More
Power BI tile error: Couldn't retrieve the data for this visual. Please try again later.
tech Fred Kaffenberger tech Fred Kaffenberger

Power BI tile error: Couldn't retrieve the data for this visual. Please try again later.

This error, “couldn’t retrieve the data for this visual”, can be a frustrating one. Like other tile errors, it only shows as a broken tile with the message “can’t display the visual” until you click to see details. If we consult the official Power BI documentation on tile errors, the documentation currently says: “This issue is usually transient. If you try again later and still see this message, contact support.” I’ve seen the error in three situations: the most common is that a report consumer lacks build access to a report built on a DirectQuery over Power BI dataset connection.

Read More
DAX measure basics in Power BI or Excel data model
tech Fred Kaffenberger tech Fred Kaffenberger

DAX measure basics in Power BI or Excel data model

I decided to share my tips for learning DAX. 1. Learn about filter context; 2. use variables to debug measures, and 3. understand how CALCULATE works. At the end, I link two of my blog posts: one which applies the concepts of coordinates and values to the different visualizations available in Power; the other is how to troubleshoot the trickiest visual of them all: the table visual.

Read More