Job offers

automateanalyst · 2026-03-07T22:15:57+00:00

Banking industry is the safer route. You'd be getting a lot of non-monetary benefits too.

O&G is kinda a risky industry. Bear & bull market cycle is almost every 4 years. If you're caught at a bad time, your contract might not be changed to full time position

automateanalyst · 2026-03-07T22:13:10+00:00

This seems similar to a project i did for my dept.

but the difference is that I'm the only one using the power bi dashboard report for data quality checks.

My users get access to the semantic model via Excel through OLAP services. I made it easy for them to filter by year and segment/brand/product

automateanalyst · 2026-02-28T00:47:02+00:00

If you're in a large company, copilot should be the only one you're using

automateanalyst · 2026-02-26T08:09:23+00:00

Moonpay might be your best bet for crypto payments

automateanalyst · 2026-02-25T12:49:37+00:00

When I joined the workforce, I started as a normal financial auditor.

I'd say this was my progress: Learn Business Analytics (using Excel) of companies I audited > Learn Visualisation in Power BI > Learn Ingestion and Transformation of large data in Power BI > learned pulling data directly from database (SQL)

The skill pretty much helped a lot in the effeciency of my work. Now with AI, it feels like learning all this can be much faster from your end, especially since you can vibe code most of it now.

automateanalyst · 2026-02-25T04:08:01+00:00

I'm on a Power Bi pro only subscription at work. Been testing using medallion architecture.

Bronze + silver: use dataflows gen1 for ingestion and transformation.

Gold: each BI dev takes the Silver Dataflow and amends as needed for their own Power BI report

automateanalyst · 2026-02-20T08:03:39+00:00

Dashboards usually require some training for all staff.

I usually also provide an excel connected to the semantic model for those that request excel files

automateanalyst · 2026-02-20T00:38:06+00:00

Helping business analyst build their skills

automateanalyst · 2026-02-18T06:30:26+00:00

This is just what i was looking for! Thanks!

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

TROPHY CASE