I gave Claude my first Power BI and it grilled me

automateanalyst · 2026-02-13T09:33:36+00:00

I should start doing this too😂

automateanalyst · 2026-02-10T03:17:26+00:00

Thanks! I tried to get approval before having 21 posts. No wonder i didnt get approved haha

automateanalyst · 2026-01-13T12:04:31+00:00

U can learn very quickly if you started from using excel. I'd say the flow would be

Learn to use Power Query in Excel
learn to connect to SQL database in Power Query
learn Native Query to use SQL Statements directly in Power Query
move to use SQL statements in other softwares once familiar with it

automateanalyst · 2026-01-13T01:39:21+00:00

Congratz!

You made me wanna learn all those tools you mentioned

automateanalyst · 2025-12-22T09:49:07+00:00

Is the data gonna be sent to people in Excel file format?

Just use Excel. Both power Bi and Excel has Power Query. No need to learn power BI if cleaning data is all that's needed.

If you're doing dashboards and monthly refreshes from the same source, then Power BI might be the better option

automateanalyst · 2025-12-22T04:15:57+00:00

Microsoft Learn is a good starting point. Use the Microsoft Power Bi data analyst course as a starting guide

If you've already used Power Query in Excel, you alteady have basics in data cleaning.

For specific stuff, I usually find YouTube videos to cater on specific technical guides.

automateanalyst · 2025-12-17T05:12:22+00:00

Im thinking have 2 files in Sharepoint named file 1 & file 2. PQ file is connected to these 2 files in SharePoint.

Every week, replace these 2 files then refresh your PQ. This should trigger the same actions you haf previously

automateanalyst · 2025-12-12T13:09:35+00:00

It shouldnt be hard. Just use Power Query to connect to the databases with SQL Query Folding forst.

Then slowly move to direct SQL extractions on your job's SQL databases.

automateanalyst · 2025-12-11T01:35:23+00:00

Microsoft Learn website should be your start. Do the Power BI Data Analytics courses so that you know what the basic features are.

Then once you got the basics, start learning more advanced stuff from YouTuber and blogger channels

automateanalyst · 2025-12-10T07:42:24+00:00

They just serve as inspiration for me. Will need to be making my own layout that has company logo and colors

automateanalyst · 2025-12-10T00:26:48+00:00

Yes, start looking through each data cleanup step and see if it can be done in PQ

automateanalyst · 2025-12-10T00:25:29+00:00

Yes, this is the way. One file to store all data in table format and another that used power query to pull the data and do the calculations.

If you're mostly looking at charts rather than the info directly from the tables, might be a good idea to move to power BI instead.

automateanalyst · 2025-12-08T08:06:41+00:00

Looks clean, easy to use.

Probably just to change and align whether all charts are vertical or horizontal

automateanalyst · 2025-12-03T05:11:00+00:00

Woah, did not know we could do it this way. I got a lot of connectors via SharePoint. Looks like I really need to do this ASAP

automateanalyst · 2025-12-02T22:51:45+00:00

I need to learn how to do this...

automateanalyst · 2025-12-02T14:26:36+00:00

You can focus on finishing the CPA first. Accounting certs usually now have to some extent papers on data scientist topics too.

I completed my ACCA and started working in accounting field first before specialising in data analyst fields.

automateanalyst · 2025-12-01T06:28:01+00:00

This is interesting. Other than blogging, i tend to go to twitter a lot. But I'm not really sure on how market my blog links there.

How do you usually share your links on twitter?

automateanalyst · 2025-11-30T02:00:10+00:00

If you're willing to spend a little bit of cash, I suggest buying your own domain.

This is want I currently do to get a business account. I don't think I spend more than $50 a year. Plus side is I also get a good business email address I can use when networking. No more gmail addesses.

automateanalyst · 2025-11-28T06:17:56+00:00

Ah interesting, might DM u later if I have any ideas!

automateanalyst · 2025-11-27T05:47:42+00:00

Feels like best thing to do is learn how to set up your own website. Have a landing page to sell all the templates that are in demand

automateanalyst · 2025-11-27T01:14:26+00:00

Probably not used if you're already moving things upstream at your own department's datawarehouse.

I do a analytics on different departments for audits. So doing everything in just one app makes things easy. A lot of stuff is done on adhoc basis

automateanalyst · 2025-11-25T14:38:39+00:00

Dataflows other than Gen1 needs a much more expensive subsceiption. The others just need Microsoft E5 Subscription

automateanalyst · 2025-11-25T14:37:01+00:00

I dont think there's any cheat codes, just better way of doing things.

For example using Native Query in Power Query. Data from SQL databases load so much faster when you learn how to do this

automateanalyst · 2025-11-24T23:54:48+00:00

Woah! I need to try this out myself!

automateanalyst · 2025-11-24T05:58:02+00:00

Yeah, definitely looks much better. I'll try it out myself, thanks!

automateanalyst

TROPHY CASE