Wouter

Financial with a passion for data | Join me in my journey into data science.
Tweeting about what I think will be helpful to others who aspire a career in data.

[Wouter @theWouter]

That's a wrap!

If you enjoyed this thread:

1. Follow me @theWouter for more of these
2. RT the tweet below to share this thread with your audience

[Wouter @theWouter]

How to use loc and iloc in Python Pandas?

A 🧵..

[Wouter @theWouter]

How to use loc and iloc in Python Pandas?

A 🧵..

[Wouter @theWouter]

For more info about indexing and selecting data check out the documentation:
https://t.co/9Yxi03fDEb

[Wouter @theWouter]

Any book recommendations when learning Python for Data Science?

[Wouter @theWouter]

Sometimes you got to take some risk in life.

If it wasn’t the right decision after all, things will find its way as well.

Don’t overthink a decision, but be aware and don’t make steps blindly.

[Wouter @theWouter]

Should you switch jobs to boost your income?
A 🧵

[Wouter @theWouter]

And if things feel good, nice manager, good benefits that you value, friendly colleagues and reasonable working hours then take that boost in salary and enjoy it!

You’re not married to your current company and they certainly aren't too you.

[Alex Hormozi @AlexHormozi]

How to get what you’ve always gotten:

Be reasonable.

[Wouter @theWouter]

Should an accountant be able to code?

Accountants and financials more often cooperate with BI teams and coders.

Understanding technical concepts, speaking their language and being the linchpin between finance and data teams can be a very powerful asset in organizations.

[Wouter @theWouter]

3. DQ outperforms IM in most cases. DAX and M script under-perform when compared to database engines. Database engines keep track of changed data in order to reuse query results.
In corporations DQ is most common in order to connect to a larger database such as SAP HANA.

[Wouter @theWouter]

1. A few differences between Import mode and Direct Query mode in Power BI.

Import mode:
- Stores data into model
- Fast with less volume
- Supports all Power Query transformations & DAX
- Automatic refresh can be turned on
- Compatible with every type of data source

[Wouter @theWouter]

2. Direct Query mode in Power BI:
- Doesn’t store data in model
- Supports database server type of data source
- Faster when proper indexes are created in database
- Data is fetched from server when user opens report
- Only transformations which are supported with SQL queries