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