* My share place
Hi, I’m Arnaud Gastelblum. I’m a Belgium data fan who likes sharing stuff about Microsoft Power BI and SQL Server.
Checkout my toolbox here. CU soon!
DAX
Download LazyDAX and practice DAX from example. It’s a free Power BI Desktop file with multiple Measure in it.
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
Club Power BI Youtube Channel (French)
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
