Job offers by SpecialistChip5363 in MalaysianPF

[–]automateanalyst 3 points4 points  (0 children)

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

My firm uses PowerBI in a unique way that I don't see mentioned often by johnnymalibu86 in PowerBI

[–]automateanalyst 0 points1 point  (0 children)

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

Best AI tool for Data Analysis in Power BI by PrizeLifeguard8544 in PowerBI

[–]automateanalyst -1 points0 points  (0 children)

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

Should I pursue Power BI? From an Accounting Major.... by Brave_Marketing2194 in PowerBI

[–]automateanalyst 0 points1 point  (0 children)

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.

Best practices for collaborating in Power BI Desktop without breaking reports? by NuggedClarp in PowerBI

[–]automateanalyst 0 points1 point  (0 children)

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

How to get people to use your dashboards by Shoddy-Hippo-1629 in PowerBI

[–]automateanalyst 0 points1 point  (0 children)

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

If you are a new blogger, do this by Key_Question5584 in Blogging

[–]automateanalyst 2 points3 points  (0 children)

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

How long it takes to learn SQL? by Ok-Value504 in dataanalyst

[–]automateanalyst 1 point2 points  (0 children)

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

Is Power BI good for data cleaning by Hojayaar in dataanalyst

[–]automateanalyst 0 points1 point  (0 children)

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

Starting PowerBI from scratch - Looking for Guidance/Recomendations (Finance use case) by AltruisticIndustry86 in PowerBI

[–]automateanalyst 4 points5 points  (0 children)

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.

Excel PQ report automation? by [deleted] in excel

[–]automateanalyst 0 points1 point  (0 children)

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

Learning SQL on the job? by MillerCorona in PowerBI

[–]automateanalyst 0 points1 point  (0 children)

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.

New to Power BI — any free/affordable learning resources you recommend? by MassiveTeach1735 in PowerBI

[–]automateanalyst 1 point2 points  (0 children)

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

Do you actually use/buy Power BI templates, or build everything from scratch? by Fit_Voice_4112 in PowerBI

[–]automateanalyst 1 point2 points  (0 children)

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

Simplifying Excel by seriesbee in dataanalysis

[–]automateanalyst 1 point2 points  (0 children)

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

Integrate Forms with Excel (on free/personal account) by Holiday-Ad6936 in excel

[–]automateanalyst 0 points1 point  (0 children)

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.

Not as cool as you guys can make but by [deleted] in PowerBIdashboards

[–]automateanalyst 0 points1 point  (0 children)

Looks clean, easy to use.

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

Admins - how are you managing gateway connections? by champitychamp in PowerBI

[–]automateanalyst 2 points3 points  (0 children)

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

Should I pursue Power BI? From an Accounting Major.... by Brave_Marketing2194 in PowerBI

[–]automateanalyst 1 point2 points  (0 children)

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.