Technical References

The following links are technology references, not related to the business at all.

Calgary Power BI User group

Here are some links I’ve been keeping, that I will likely reference as we begin to build out some themes on this site.

Data Sources for the city of Calgary Hackathon

Energy efficiency, courtesy Barend.

Platform Analysis

Power BI references

  • DAX Studio – A very useful tool for looking at DAX query plans and execution statistics.
  • DAX Formatter – A handy tool for formatting DAX and embedding it in HTML
  • DAX hints
  • Dustin Ryan – Independant analytic consultant references
  • Data savvy – Independent analytic consultant references
  • DAX patterns
  •  – She has a good reference on how to scale up sharing in powerBI
  • Kasper on BI

Tableau repositories


  • SQLML – Summary of stats, algos, and maths related to machine learning and the MS stack.
Far better an approximate answer to the right question, which is often vague, than the exact answer to the wrong question, which can always be made precise. -John Tukey
The plural of anecdote is not data. - John Myles White

Recent Posts

RSS PowerBI blog

  • Optimize your Processes and Gain Deep Insights with Process Mining  January 25, 2022
    Process mining, provides direct data insights across an organization’s daily business processes, helping identify inefficiencies to improve how they work. Now with the preview of process mining in process advisor, leveraging Power BI Embedded , you can use your business data to produce analytics and detailed process maps, gleaning new insights into ways to optimize your business processes.
  • Power BI Report Server January 2022 Feature Summary January 24, 2022
    We’re excited to bring you a new version of Power BI Report Server this Winter! With the January 2022 update, we have a variety of new enhancements, including page and bookmarks navigators, new sorting options for legend, new formatting options for text, pie and donut chart rotations and many more.
  • Deployment pipelines- Azure DevOps extension, multiple pipelines working together, Dataflows GA January 19, 2022
    This month we have released highly-anticipated features for deployment pipelines: Azure DevOps extension, to automate your deployments and pipeline creation using Tasks in your Azure pipeline. Multiple pipelines working together, to sync the connections between items managed in different pipelines. Dataflows GA and support for linked entities