In this video Brian Grant will walk you through just how easy these can be to create a Local ID in Power Query.
In this video Brian Grant will walk you through how you can leverage some more advanced features of the Power Query M language to combining conflicting customer names.
This session starts with an introduction to dataflow, what it is, and how it can be helpful.
BEN LAWRENCE (DataDx) – Visualizing Anomaly Detection and Interactive Documentation in Power BI Anomaly detection can be a confusing concept and is hard to present to users in a meaningful way. In this presentation, see how DataDx has leveraged the isolation forest
MARK WALTER (Industrial Finishes and Systems) – Learn How to Track Errors with a Power Query Error Table Power Query is a remarkable ETL tool within Power BI; however it is all too easy to overlook errors that might be buried within
People ask me all the time which M script calendar table I use in Power Query. Honestly, most of the time I just grab the most recent one I’ve used and add/remove columns as needed. Though I thought it might make sense
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
ROBIN ABRAMSON (Pragmatic Works) – Dynamic Columns for Dynamic Visualizations in Power BI Empower your users through dynamic visualizations in Power BI. In this short, 30 minute session we’ll go over a technique to allow your users to choose the attribute contained
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
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
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
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
Subscribe to CSG Pro. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.
Since 1993, CSG Pro has built modern, scalable software and data solutions. Our data analytics consultants solve problems and ignite victories. We help you understand your data so you can make smarter business decisions. We build custom software applications that strengthen your process and your team.
©1993‐2021 CSG Professional Services, Inc. | Privacy Policy