The CSG Pro Blog

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

All you care about is understanding your data and making informed business decisions. Microsoft Power BI is a complex platform, with many features and user paths. You only need to know a few key components well to get the job done. The...

Your main concern is understanding data and making data-driven decisions. You don’t know the ins and outs of Microsoft Power BI, but you need this tool for all things data. The CSG Pro Business User Video Series is a Power BI tutorial...

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

MARK BRADFORD (Snowflake) - The Data Warehouse Built for the Cloud Mark demos the capabilities of the Snowflake Data Warehouse as a back-end solution for Power BI....

Ready to wrangle your data?