Business 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...

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...

Do we need a data warehouse or a data lake? It's a fair question, because often there is a lot of confusion in the marketplace about which option is best. When it comes to your organization’s data, the last thing you want is...

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?