Lightnews — Scholar-powered news

Wyn - Power BI & Excel

@wynhopkins.bsky.social

860 followers 170 following 760 posts

📘 https://pbi.guide/book 🧑🏻‍🎓 https://pbi.guru/training Microsoft Ⓜ️VP | Author | Speaker | Power BI & Excel Developer & Instructor 🌐 https://accessanalytic.com.au/

pbi.guide

Posts Media Videos Starter Packs

Wyn - Power BI & Excel @wynhopkins.bsky.social · 11h

The #FixExcelTables campaign has begun

#Excel Tables are fantastic but could be so much better!!

www.linkedin.com/posts/jankar...

#excel #tables #microsoft | Jan Karel Pieterse | 23 comments

The Fix #Excel #Tables Campaign starts today! To my Excel friends out there. I often advise "If it looks like a table, Format As Table". Tables are great for so many reasons. But tables are a bit ha...

www.linkedin.com

Wyn - Power BI & Excel @wynhopkins.bsky.social · 21h

Just when I thought I couldn't respect Power Toys any more...

Wyn - Power BI & Excel @wynhopkins.bsky.social · 21h

an elderly woman is holding a megaphone in her mouth and says can you hear us ?

ALT: an elderly woman is holding a megaphone in her mouth and says can you hear us ?

media.tenor.com

Wyn - Power BI & Excel @wynhopkins.bsky.social · 21h

Welcome to the fan club!

Check out the #PowerQuery feed : bsky.app/profile/did:...

#PowerQueryEverything

1 1

Wyn - Power BI & Excel @wynhopkins.bsky.social · 21h

Yay.. Jeff in the Feed!

1 4

Wyn - Power BI & Excel @wynhopkins.bsky.social · 1d

All quality though!

a man wearing a watch holds his nose while watching a masterchef argentina show

ALT: a man wearing a watch holds his nose while watching a masterchef argentina show

media.tenor.com

2 2

Wyn - Power BI & Excel @wynhopkins.bsky.social · 1d

Speak of the devil - it’s just shown up now

Reposted by Wyn - Power BI & Excel

Nikola Ilic @datamozart.bsky.social · 1d

NEW BLOG POST!

Dataflows were (rightly?) considered "the slowest and least performant option" for ingesting data into #PowerBI #MicrosoftFabric. However, things are changing rapidly, and the latest DF enhancements may change the way we play the game.

data-mozart.com/from-dataslo...

From 'Dataslows' to Dataflows: The Gen2 Performance Revolution in Microsoft Fabric - Data Mozart

Dataflows were (rightly?) considered "the slowest and least performant option" for ingesting data into Power BI/Microsoft Fabric. However, things are changing rapidly and the latest Dataflow enhanceme...

data-mozart.com

1 2 8

Wyn - Power BI & Excel @wynhopkins.bsky.social · 1d

Not shown up in my Power BI feed nor the Microsoft Fabric feed

1 1

Wyn - Power BI & Excel @wynhopkins.bsky.social · 1d

I never knew this was a thing...

Leading zeros causing issues

YouTube:
youtu.be/cTmHyI3vkNU?...

#Excel

2 2

Wyn - Power BI & Excel @wynhopkins.bsky.social · 1d

Oh that triggers a flashback to a client that had same issue, I really had to work hard to get IT to sign off on it 😆

Wyn - Power BI & Excel @wynhopkins.bsky.social · 1d

Affirmation of the day...
You don't need to know SQL to create valuable Power BI reports

Most Power BI users don't have SQL data sources, and even when they do Power Query does a fine job of extracting required data from those too.

#PowerBI

Reposted by Wyn - Power BI & Excel

Matt Cowgill @mattcowgill.bsky.social · 2d

probably my most deeply-held belief: it is not possible for a slide deck to be both (1) a good presentation aide; and (2) a standalone document that can be read and understood in isolation.

25 47 360

Wyn - Power BI & Excel @wynhopkins.bsky.social · 2d

Just had a quick scroll

Posts by Satya, Jeffrey Wang, Excel Team, Microsoft Learn, Mim, Chandeep, Fabcon, Fourmoo, MVP Communities

Plus then my local rugby team and more new outlets.

1 2

Wyn - Power BI & Excel @wynhopkins.bsky.social · 2d

Would help a bit if the Microsoft teams posted here.

My attempts to get others to sign up has met little success as it’s just “another platform to post to”, unless they have the motivation to leave twitter.

1 5

Wyn - Power BI & Excel @wynhopkins.bsky.social · 2d

Nice one Reza

1 1

Wyn - Power BI & Excel @wynhopkins.bsky.social · 2d

Power BI
bsky.app/profile/did:...

Power Query
bsky.app/profile/did:...

Excel
bsky.app/profile/did:...

Wyn - Power BI & Excel @wynhopkins.bsky.social · 2d

Should be working now, had to pay $30 a year for service to have all posts rather than a sample included.

#GiveThisManABluePeterBadge

1 2

Wyn - Power BI & Excel @wynhopkins.bsky.social · 2d

Yep, all the socials have their own biases and I’ve given up trying to solve what works where.

1 1

Wyn - Power BI & Excel @wynhopkins.bsky.social · 2d

Just testing the #Excel and #PowerBI feeds

2 1 5

Wyn - Power BI & Excel @wynhopkins.bsky.social · 2d

Same. Had 10,000 followers on there, but hardly any were real people

1 1

Wyn - Power BI & Excel @wynhopkins.bsky.social · 3d

It’s certainly an engagement machine.

1 2

Wyn - Power BI & Excel @wynhopkins.bsky.social · 3d

It took me a while to get my head around it, but it does look useful for those with non-standard calendars

Wyn - Power BI & Excel @wynhopkins.bsky.social · 5d

If you haven’t listed before… this is a great episode to start with 😃

Unpivot @unpivotshow.bsky.social · 5d

Special guests Deb Ashby and Leila Gharani

🚩Red Flags

🦹Serial Killer Tips?

🤖 Excel Agent Mode

➡️ Swipe Left?

❓Excel Autocomplete

🏃‍♀️‍➡️ Is Speed Good?

🔢 Prompt Bingo

🍓Strawberry Laces

🩳Short Shorts?

🎛️ Video Editor Tips

#Excel
youtu.be/Zarf72iei9g?...

Deb and Leila plus the Humble MVP

YouTube video by Unpivot

youtu.be

Wyn - Power BI & Excel @wynhopkins.bsky.social · 8d

Come and learn #PowerQuery with me in 2 x 3 hour sessions on 16 & 17 October

For complete beginners in #Excel

globalexcelsummit.com/product/powe...

10% off with WYN10

Power Query in a Day | Global Excel Summit | Microsoft Excel Conference

Master the core elements of Power Query and start converting messy data into clean tables for analysis.

globalexcelsummit.com