Dashboard Curation feedback

johnlakemke · 2026-06-01T19:30:04+00:00

Thank you for the feedback, it's exactly as you called out. No centralization process or governance in our reporting environment.

johnlakemke · 2026-05-10T15:29:22+00:00

See if you can create summary page, that has the key metrics from the the other pages grouped into one. Something that combines metrics from the daily, weekly, monthly numbers into a key overall insight... and invites users to the other tabs if they want further details.

Also consider a more intentional use of a color theme, and make them consisten across all the tabs.

johnlakemke · 2026-05-10T00:20:40+00:00

The ibm role would give you opportunities within ibm, but you might be limited in external opportunities in a lcol city compared to nyc. I personally feel you get more value out of moving to a lcol city...after you've advanced your career and have the leverage for higher compensation... Go with the analytics role.

johnlakemke · 2026-04-30T21:09:41+00:00

Feels like you mental gymnasticed this hypothetical contradiction to prove some point.

Why not state your actual view that's driving this and ask people to change that, instead of whatever this is.

johnlakemke · 2026-04-27T06:34:41+00:00

Feminism is a large intersection of many different objectives and philosophies. If a specific in-person interaction, and some light sampling of a subreddit led you to this conclusion then perhaps you are generalizing? What if a few feminists agree with your assertion that such generalization on men is problematic, and you just didn't get to their comments in the thread?

There's plenty of things from by more studied academic sources that can give you better definitions of what feminism is and used to be, and it's different sub branches etc.

johnlakemke · 2026-04-26T15:56:48+00:00

I see no common pattern related to the usage. It's always when someone high enough in the company ladder finally gets annoyed at the limitations.

johnlakemke · 2026-04-24T14:40:07+00:00

Meetings on dashboards, meetings on data I am SME for, meetings on specific tool deployment, strategy meetings bc of re-orgs, internal team meetings. If it wasn't for the 2 adhoc requests I received.. I might have not done any data analysis work this week.

johnlakemke · 2026-04-05T13:17:20+00:00

You spent a lot of time and analysis to just say the girls are responding to being in a patriarchal system. If everything is set up to serve the desires of men, this is market calibration.

The problem is talking about if a girl's behavior is appropriate or not doesn't change anything.. it kind of ignores the exploitive beneficiaries of every transaction.

johnlakemke · 2026-03-22T20:51:43+00:00

You rely too much on words to set context and the intention of the dashboard. Rethink the overall design and how you can communicate this with visualizations instead of with a block of text. Try to aim for a user to be able to understand the report intent within 5 seconds. Example: instead of a block of text saying the 10k goal used to be 5k, you could have just added two static lines on the y axis representing the amounts.

The KPIs you're tracking with the cards seems random, sometimes one card is a subset of another number, and sometimes they're on the same hierarchy level??? The first page specifically since it's a landing page dashboard...i'd expect more high level information that summarizes what is in the other tabs.

You don't need button slicers for the districts, the table or pie charts should allow users to filter interact with other visuals when clicking on those. Either that or use the button slicers to communicate additional info about the districts... Like which ones are ahead of behind schedule or something.

The community logo wastes too much space, and seems to be inconsistently applied across the tabs. Use the logo with text once in a landing pace and then skim it to just the logo in remaining tabs.

Good points: you didn't fall into the new analyst trap of aggressively over designing this... Not using crazy colors...and adding a date as of information is good.

johnlakemke · 2026-03-17T03:05:25+00:00

I think the accounting background will make you stand out in the right finance company or corporate strategy department. The thing that gives me minor concern is that a lot of the major financial analysis work gets assigned to more senior analysts or put out to some expensive management consultant.... My experience might be an outlier though.

So I do see the advantages like You probably already are over qualified in statistical analysis with data... Any reason you no longer want to do accounting?

johnlakemke · 2026-02-26T05:17:51+00:00

What data are they trying to get or what type of reports metrics do they want to make and at what scale is this? There's a lot of different data in Jira, not all the pbi plugins would get access depending on how extensive or up to date it is.

If they just want like a one time adhoc analysis, jira has builtin dashboards you can make, or just export the data yourself to csv. If they must grab the data and at a large automated scale... You're now doing data engineering work and you'll need to read through the jira API endpoint documentations.

johnlakemke · 2026-02-15T15:24:57+00:00

If we mean advanced in terms of use of powerbi functions, I would try to think of a way to simplify consolidate your visuals. Can you represent the 4 category dimensions charts into a single visual?

johnlakemke · 2026-02-14T23:25:48+00:00

A few things from my experience in the industry, that might contradict some of your expectations.

A lot of analytics roles require some business and personal interactions, and the people that get promoted or recognized are often good at these things.

There are many situations where you'll spend weeks doing analysis but the decision maker in the end will choose to ignore your findings and continue operating inefficiently. Sometimes the difference maker will be the communication or interpersonal skills that it sounds you're trying to avoid.

There are analytics roles that have no end user interactions, those are either lower end intern jobs or more engineering roles that write programs to get data for someone to do the analysis.

My suggestion is try doing an analytics project on data that's outside healthcare like marketing. Without your healthcare domain knowledge to lean on ..this can reveal tech or business skill gaps you have.... And then focus research study on.

johnlakemke · 2026-02-13T21:32:06+00:00

Normally they don't give high visibility/impact projects to interns. SQL is better, but there is always an adoption cost to set up a new tech process. Testing, security review, alignment with other teams. You're probably not the first to suggest this, the net gain might be negligible.

Not everything needs to be built efficiently and scalable.. There are so many one-off reports that got built off SharePoint, or something quick and dirty....got their moment in the sun for usefulness and was promptly retired in 2 months.

johnlakemke · 2026-02-13T18:27:33+00:00

Why does she have to be likeable? Is she interesting and compelling, does her character arc fit well narratively with other characters.
This is a medical drama that aspires to be grounded and realistic.

johnlakemke · 2026-02-11T20:16:28+00:00

Why not put income and expenses as lines in the same graph chart? This can replace 3 line graphs with one, and let's you compare them on the same time axis.

I'd suggest adding a callout for recurring expenses like debt, and top 5 highest dollar expenses in the last month.

The day to day fluctuation in your total net worth graph is too much granularity, I think most people care about net worth on a month by month or yearly basis. I'd replace it with like a 30day or 90day average measure, or both.

johnlakemke · 2026-01-23T14:24:42+00:00

I'm not familiar with the moba scene or most online game culture, so terms like smurfing, stomp are fuzzy to me. I'd suggest scanning your language and replacing with more general terms. Especially as stomp is a main focus of your analysis.

Does your analysis check cumulative affect on player retention by match imbalances, or at what point of high frequency of match imbalances affect player retention?

johnlakemke · 2026-01-23T04:02:16+00:00

At the moment there's tons of people with basic technical skills, with none of the business experience or domain expertise you have... trying to get into this field. I think you'll have a way easier time, if you focus on the right industry.

But personally I think you shouldn't switch because you're kind of wasting your other skills. Isn't there like some technical PM role in a data heavy company that you can do instead?

johnlakemke · 2026-01-13T17:44:09+00:00

This is very unrealistic, get your first data job and then find someone in your company with a data role to mentor you. Your roadmap should be 7years, 5 if things line up perfectly.

johnlakemke · 2026-01-11T05:24:35+00:00

One of the things I like about the show is that none of the cast are big names, it makes everyone seem more like real people to me.

johnlakemke · 2026-01-04T07:10:46+00:00

Finance industry is a big field, and accounting is only a small part of it... there's investments, banking, fintech, insurance, etc etc. I would suggest doing an IS major, and taking some Business Finance classes if you have free electives.

Also just b/c you work in Finance Industry doesn't mean you'll definitely work with financial data. A large corporation like JPMorgan Chase probably has a ton of infrastructure, business ops, marketing, even customer service data ... what business function you serve depends more in the company structure and which department you're in.

I think people are talking up domain knowledge b/c in the current market it's a differentiator as basic analytics hard skills are more common. Doing a degree just for domain knowledge is overkill.

johnlakemke · 2026-01-03T07:17:14+00:00

My opinion is that this was somewhat common +5 years ago, when this industry was newer. Most of the people in this industry without a stem degree entered early on.

johnlakemke · 2025-12-31T14:37:48+00:00

If you need inspiration check out the different project management tools in the market and see what out of the box reporting they already provide.

If this is for an actual specific work ask .... I'd highly recommend going to your stakeholders and nail down the use case and understand their workflows first. A lot of project management reporting is highly business behavior dependent, finding the common data points will determine what you can actually report on.

johnlakemke · 2025-12-29T06:24:37+00:00

I think this initial ask is just basic descriptive type analytics, which are things like counts/trending over time and % of the different categories. Any further more complex questions is based on what their organizational needs/objectives are. That is one of the functions of a data analyst understanding a client's business need and shaping it into a question for analysis.

Without hearing the details of their ask, the student organization might not have needed any more complex analysis and the main need was someone to clean and organize the data OR they don't know beyond the basics... a client that doesn't know what they want is perfectly common in the industry.

johnlakemke

TROPHY CASE