* My share place
Hi, I’m Arnaud Gastelblum. I’m a Belgium data specialist and I’m sharing here Data – Microsoft -Power BI and SQL Server tips.
I also have a youtube channel where you can found some quick tips.
DAX
Learn DAX from example with LazyDAX. It’s a free Power BI Desktop file with multiple Measure in it. Download it and give me your feedbacks
Point in time with DAX. Create a time machine for your historised data
Data Preparation
Data Visualisation
Please do not use Pie chart, I’m explaining here the reason.
Power BI in general
SQL Server - SSIS
- List all executing queries with SP_WHO3
- SSIS Export Catalog Environment
- SSIS Log execution
- Management Studio: Use Query shortcut
- Management Studio: Faster with multiple select
Office
Microsoft Teams: Stay always available with Excel
External links
It exists many different articles on internet, I’m keeping here the most important for me. I’m convinced that it can help you too.
Power BI in general
Microsoft White Paper Planning a Power BI Enterprise Deployment
Download Power BI Desktop (Latest / Current version)
External Tools
- Power BI.tips Business Ops (Install them all)
- DAX Studio
- Tabular Editor
- Power BI Icon Library – Marc Lelijveld
