Analytics

BRIAN GRANT (CSG Pro) - DAX: The Language of Summarization You've certainly heard of DAX and you've probably made several measures before; but chances are good that if you were asked to define either of them, you probably couldn't give a very good...

BEN VEGA (Umpqua Bank) - UX Design for Power BI Mobile The 2019 release wave for Power BI Mobile delivered on their promise for “simple, fast, and intuitive report experiences.” Ben will provide an overview of the Power BI mobile desktop application. Learn how...

Along with the rest of the world, we have been closely watching and feeling the impacts of COVID-19. Stress and emotions are running high, and at times like this, we like to go back to the data. We have distilled the situation...

KIRILL PERIAN (Pragmatic Works) - Untangling Nested Headers in Power Query We have all seen those pivot tables with multiple headers that make us pause, scratch out heads and wonder how in the world are we going to consume such a monster into...

MATTHEW MITCHELL (Central City Concern) – Driving Organizational Change with Power BI Have you created beautiful dashboards but are struggling to create a data-driven culture? Do your business leaders have access to robust reports but not seeing business results? This is the story...

DAVID BERGLIN (BBSI) - How to Reverse Engineer a Power BI PBIX File You and your team build great Power BI reports: complex, insightful, and beautiful reports. On Tuesday, the team is out for an extended lunch (tacos) when the boss asks for...

RADU BOBIRNAC (Malarkey Roofing Products) - Scraping Data The Easy Way With Power Query Using BeautifulSoup library in Python can give you a lot of flexibility. The downside is, if you don't have them already installed, is needing a pip install for soup,...

SHERRY PARKER (The Greenbrier Companies) – A Table of Measures When replicating business reports in Power BI it often comes up that we need to display a group of measures in a table view.  It is not possible to simply drag a variety...

According to a 2018 study from Best Innovation Group and OnApproach, 45 percent of credit unions do not currently have an analytics strategy in place. Over half of those allocating budget to analytics were planning to spend less than $100k. Only 15 percent planned...

MAOLOUD DABAB (Portland State University) - Visualizing Sustainability Practices in Power BI   Maoloud is the Campus Sustainability Office's first Sustainability Data Analyst at Portland State University. Using his expertise to translate sustainable development concepts into practice, his goal is to accelerate a culture...

Working off of an Excel data dump can be a great way to get started building a report while the more official SQL table gets built. The problem is that when you are done, repointing from Excel data to SQL data is...

Ready to wrangle your data?