* My share place
You landed on a data lover web page! Well done! I’m sharing my discoveries and thought about Microsoft Power BI, SQL Server and Data in general.
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
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
