Bits of BI – June 29

In accordance with Thomas LaRock I decided to also start my round-up of news from around the block of SQL Server, Technology or anything vaguely related to BI. And I might include some other things as well if I feel like it.
My plan is to do a weekly round-up, let’s see how that works out.
My latest post was 2 weeks ago, but here’s a new one! As we’re starting to go into summer and holidays, I might skip one edition in August also.

But for now, here’s the next edition of Bits of BI!

• SSMS 17.8 is now available by Pam Lahoud (sqlgoddess)
  Download SSMS 17.8 or review the Release Notes to get started.
• Does It Matter Which Field Goes First in an Index? by Brent Ozar (@BrentO)
  Some index 101 knowledge, but thoroughly explained. And as Brent says: index field order matters a LOT.
• Biml Express 2018 is here!
  It includes support for VS 2017, SSIS package import and many other things. Cathrine (@Cathrine) and Andy (@AndyLeonard) also blogged about it. Go download Biml Express 2018 or check the change log for all updates.
• Announcing the GroupBy September Lineup by Brent Ozar (@BrentO)
  The next (online and free) GroupBy conference is on Friday September 7, and will contain mainly SQL sessions this time.
• Stairway to Azure DataBricks by Leila Etaati (@leila_etaati)
  Leila already started with Part 1 and Part 2, Part 3 will follow later. She starts with adding a Databricks environment with a Workspace and a Cluster. In Part 2 she goes more in-depth with uploading data to Azure Data Lake Store, clean the data with Scala and use R to visualize it and do predictive analytics. In Part 3 Leila will show the result in Power BI.

That concludes this edition of Bits of BI, feel free to share it with others!
@NickyvV

Bits of BI – June 15

In accordance with Thomas LaRock I decided to also start my round-up of news from around the block of SQL Server, Technology or anything vaguely related to BI. And I might include some other things as well if I feel like it.
My plan is to do a weekly round-up, let’s see how that works out.
My latest post was 2 weeks ago, but here’s a new one! As we’re starting to go into summer and holidays, I might skip one edition in August also.

So here’s the second edition of Bits of BI!

• 24 Hours of PASS: Summit Preview 2018 was held on June 12 and 13.
  24 1-hour sessions on Performance Tuning, Azure Data Lake, Digital Storytelling, Advanced R, Power BI and more. The recordings will be posted on the Learning Center.
• New Stack Overflow Public Database Available (2018-06) by Brent Ozar (@BrentO)
  There is a new (and bigger) version of the Stack Overflow database available for export which you can use to play with, tune queries or do demo’s on.
• Use Outlook Shortcuts to organize your favorite Power BI Reports and Dashboards by Chris Finlan (@cmfinlan)
• Advice from a tech Mom on getting teens to learn to code by Jen Stirrup (@jenstirrup)

That concludes this edition of Bits of BI, feel free to share it with others!
@NickyvV

Bits of BI – June 6

In accordance with Thomas LaRock I decided to also start my round-up of news from around the block of SQL Server, Technology or anything vaguely related to BI. And I might include some other things as well if I feel like it.

My plan is to do a weekly round-up, let’s see how that works out.

So here’s the first edition of Bits of BI!

• Query Folding in Power BI
• Power BI Desktop June Feature Summary
• Subscribe others to email subscriptions in Power BI
• Microsoft + Github = Empowering Developers
• Announcing: The SQL Server Execution Plan Reference

I hope you found this edition of Bits of BI useful, feel free to share it with others!

@NickyvV

My Data & BI Summit Recap

I finally came around to writing a wrap-up for the Data & BI Summit in Dublin last month.
No fancy pictures or colors, just a to-the-point summary.

New features

• Incremental refresh – Premium (included in May update as preview feature)
• Drillthrough with current filters and parameters (included in May update)
• Common Data Service For Analytics (preview live)
• Theme file additions coming soon:
• Theme export
• Background added to themes
• Table/matrix headers
• Persistent filters (per user) in the service
• Buttons to trigger action (included in May update)
• Q&A and linguistics
• App workspaces without Office365 group

Modelling

• Optimize your model (size)
• Make use of Query folding in Power Query
• Applies to Import mode only
• Filter first, Transform later
• Use supported transformations first, non-folding steps at the end
• Writing a SQL query in Get Data prevents folding
• Create a blank query with #shared to show a document library of all M functions (Blog)

Visualization

• Choose a theme
• Report theme generator at PowerBI.tips
• Color Theme Creator at Aka.ms/pbitheme
• Outlining
• Canva.com
• PowerPoint
• PowerBI.tips
• Storytelling, with:
• Custom visuals (e.g. Timeline Storyteller)
• Bookmarks
• Tooltip pages
• PowerApps visual
• Drillthrough
• Syncing slicers

Governance

• Use App Workspaces for DTAP
• DEV_Finance
• UAT_Finance
• Finance
• Use Onedrive for Business for versioning your pbix-files, with the same folders as the App Workspace
• Use the API’s with PowerShell to copy resources between workspaces
• Chriss Webb (@cwebb_bi) wrote a successful script in response to a video from Adam Saxton (@GuyInACube)

Best practices and notes

Visualization | Model

• Driving table for measures
• Hide unused columns
• Totals in matrix and tables insensitive to row filters
• Uniform naming of measures and calculations
• Sync slicers
• Add descriptions where possible
• Make sure filters are not hardcoded

Governance

• Add an about page with last refresh date time and description of Model
• Version the Model
• Schedule datasets using Admin account for one place to monitor failure notification emails
• Use one drive as source control
• Golden dataset

Further reading

• Power BI Whitepapers
• PowerBI.tips
• Power BI User Voice

@NickyvV