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.
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.
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.
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.
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.
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
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