William Kiarie

Helping you everything data analysis & visualization in Excel | Power BI | Google Sheets -via training

[William Kiarie @BillWilliamsK]

You can reduce your reporting workflows --> REFRESH
...so you can focus on digging for insights as opposed to repetitive report preparation cycles at end month.
Watch the full video here and start winning with #powerbi and #powerquery

https://t.co/RbXACWG5Lv

[William Kiarie @BillWilliamsK]

@AlinurMohamed_ I do Power BI Report Development. Interested to automate those weekly/monthly reports? Let's connect

[William Kiarie @BillWilliamsK]

97% of working professionals don't know these Pivot Table features!

Here are a few that instantly level up your analysis.

Let's connect on YouTube https://t.co/JeHx2of6UL

Catch me on LinkedIn
https://t.co/yzqac3wuuJ

#Excel #PivotTables #DataAnalysis #Analytics

[William Kiarie @BillWilliamsK]

Using AI?

[Peter Girnus 🦅 @gothburz]

Last quarter I rolled out Microsoft Copilot to 4,000 employees.

$30 per seat per month.

$1.4 million annually.

I called it "digital transformation."

The board loved that phrase.

They approved it in eleven minutes.

No one asked what it would actually do.

Including me.

I told everyone it would "10x productivity."

That's not a real number.

But it sounds like one.

HR asked how we'd measure the 10x.

I said we'd "leverage analytics dashboards."

They stopped asking.

Three months later I checked the usage reports.

47 people had opened it.

12 had used it more than once.

One of them was me.

I used it to summarize an email I could have read in 30 seconds.

It took 45 seconds.

Plus the time it took to fix the hallucinations.

But I called it a "pilot success."

Success means the pilot didn't visibly fail.

The CFO asked about ROI.

I showed him a graph.

The graph went up and to the right.

It measured "AI enablement."

I made that metric up.

He nodded approvingly.

We're "AI-enabled" now.

I don't know what that means.

But it's in our investor deck.

A senior developer asked why we didn't use Claude or ChatGPT.

I said we needed "enterprise-grade security."

He asked what that meant.

I said "compliance."

He asked which compliance.

I said "all of them."

He looked skeptical.

I scheduled him for a "career development conversation."

He stopped asking questions.

Microsoft sent a case study team.

They wanted to feature us as a success story.

I told them we "saved 40,000 hours."

I calculated that number by multiplying employees by a number I made up.

They didn't verify it.

They never do.

Now we're on Microsoft's website.

"Global enterprise achieves 40,000 hours of productivity gains with Copilot."

The CEO shared it on LinkedIn.

He got 3,000 likes.

He's never used Copilot.

None of the executives have.

We have an exemption.

"Strategic focus requires minimal digital distraction."

I wrote that policy.

The licenses renew next month.

I'm requesting an expansion.

5,000 more seats.

We haven't used the first 4,000.

But this time we'll "drive adoption."

Adoption means mandatory training.

Training means a 45-minute webinar no one watches.

But completion will be tracked.

Completion is a metric.

Metrics go in dashboards.

Dashboards go in board presentations.

Board presentations get me promoted.

I'll be SVP by Q3.

I still don't know what Copilot does.

But I know what it's for.

It's for showing we're "investing in AI."

Investment means spending.

Spending means commitment.

Commitment means we're serious about the future.

The future is whatever I say it is.

As long as the graph goes up and to the right.

[William Kiarie @BillWilliamsK]

@MrBeast Congratulations Mr. 👏👏
Interested in data issues? Let's get this to xB views https://t.co/K5MI5iZv2s

[William Kiarie @BillWilliamsK]

@KRACare Why do I feel this system was jammed internally as opposed to heavy traffic 😫

[William Kiarie @BillWilliamsK]

@MrBeast Wo wo wo. Ru kidding me. Bravo

[William Kiarie @BillWilliamsK]

Check my top 10 features here:
https://t.co/bAoXzxK0Ch

[William Kiarie @BillWilliamsK]

Did you miss it?

Every now and then Excel gets new features.

On of these is plotting a chart based on a dynamic array formula.

Want to see it in action?

That is what this video is all about.

Link to my TOP 10 new features in the comments.
🔁 Please share 🙏

[William Kiarie @BillWilliamsK]

@MrBeast great you kept going. who would inspire us today?

[William Kiarie @BillWilliamsK]

📌 𝐂𝐫𝐞𝐚𝐭𝐢𝐧𝐠 𝐚 𝐖𝐚𝐟𝐟𝐥𝐞 𝐂𝐡𝐚𝐫𝐭 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈

Looking to add an 𝒆𝒚𝒆-𝒄𝒂𝒕𝒄𝒉𝒊𝒏𝒈 𝒗𝒊𝒔𝒖𝒂𝒍𝒊𝒛𝒂𝒕𝒊𝒐𝒏𝒔 to your next Power BI reports?

Make your data pop with 𝒅𝒚𝒏𝒂𝒎𝒊𝒄 𝒘𝒂𝒇𝒇𝒍𝒆 𝒄𝒉𝒂𝒓𝒕s

Video link 👉 https://t.co/XS6SnbI834

[William Kiarie @BillWilliamsK]

@MrBeast You inspire me very much @MrBeast
I endeavour to grow this my channel https://t.co/QnRiP1gE4H with big plans underway, hoping one day I can increase my support to the vulnerable in society.

[William Kiarie @BillWilliamsK]

@dkmaraga It's a sad time to be a Kenyan right now. We're watching and we're seeing.

[William Kiarie @BillWilliamsK]

A step by step guide to spotlight the top N items in an excel chart -works in all versions!

Check it out here:
https://t.co/dvJGty4cMX

[Larry Madowo @LarryMadowo]

Elsaphan Njora snapped.

"We did that!"

[Okiya Omtatah Okoiti-Commentary @RealOmtatah]

Aoko is controversial, that's true.

You may not like her,

But remember, fighting for her is not personal,

It is a greater fight for justice in a country where people disappear and mysteriously turn up with body parts chopped up!

It is not about the person of Aoko, but the continuous clamour for justice and a safer country.

Join in! Let's find Aoko.

Where is Aoko?

#FreeAoko

Retweet widely.

[William Kiarie @BillWilliamsK]

@scherargei How are you thinking? Majoring on minors while you know it ain't going to change anything. If only you guys had the goodwill for the greater good

[William Kiarie @BillWilliamsK]

@HonOscarSudi Very soon you will know mmeguza

[William Kiarie @BillWilliamsK]

@RealOmtatah He's such a disgrace. And this is a tip of the iceberg. He ought to be investigated and recalled, nkt

[William Kiarie @BillWilliamsK]

@mohamudnurr Great opportunity to learn! All the best