Analytics
Multi-Language Support Capabilities in Power BI
JEREMY BLACK & KIRILL PERIAN (Data Driven Solutions) Creating a multi-language reporting solution in Power BI presents a number of challenges along the way. Our team would like to share our experience with these challenges and some ways to overcome them, while highlighting...
23 January, 2019
Order of Evaluation in DAX & Variables
RACHEL DYER (CSG Pro) Rachel Dyer is the Vice President of Analytics at CSG Pro with in-depth expertise of the Microsoft BI stack and dimensional modeling. She has a broad management background and strong communications skills, coupled with considerable technical experience in platform...
23 January, 2019
Introduction to M Programming for the Power BI Warrior
TED PATTISON (Critical Path Training) In this user group talk, Ted Pattison will deliver a fast-paced primer on the fundamentals of the M programming language. This session aims to provide a solid foundation for writing M code in the Advanced Editor when designing...
28 November, 2018
How to Present Information for Effective Dashboard Design
RON BARRETT (Audigy Group) Oracy is the ability to express oneself fluently and grammatically in speech. Literacy is the ability to read, write. Numeracy the ability to understand and work with numbers. Graphicacy is defined as the ability to understand and present information...
24 October, 2018
Dial Sparklines for Table Visualizations
BRIAN GRANT (CSG Pro) In this presentation local DAX obsessive Brian Grant will show you how to use a CSG built Dial sparkline measure to quickly display goal to actual information in a highly compressed manner that will be an excellent addition to...
26 September, 2018
My Transition to Business Intelligence
I have been fully immersed in the healthcare industry for the past six years, having finished my masters in health care management at Johns Hopkins Carey Business School and working in roles from physician scribing to health insurance operations. The common denominator...
23 April, 2018
CSG’s Manufacturing Operations Data Solutions Specialty
CSG has served many manufacturing clients over the years, but since early 2017 we have expanded our work with production data systems, applying Power BI and cloud databases in interesting new ways. For example, we have been developing an increasing array of...
27 November, 2017
Removing Excess Spaces Between Words AKA Inner Trim (Power BI)
Text.Trim() does an excellent job of getting rid of things like " leading spaces" and "trailing spaces " but unlike its' Excel cousin it doesn't handle "excess inner spaces" at all. Granted...
09 May, 2017
Annotating Charts for Specific Events in Power BI
Line charts are the ideal way to show historical data when 'understanding the trend or path of a metric' is what your decision maker is after. Like most good visualizations they can be extremely data dense, showing lots of information in a...
18 April, 2017
Turning 445 Summary Tables into Usable Calendar Tables in Power BI
If you're used to working in Excel you're quite familiar with the idea that there's about a dozen ways to do anything. In this video we look at yet another approach to creating a 4-4-5 fiscal calendar table from a summary table....
12 April, 2017
Better Chart Backgrounds for Visual Clarity in Power BI
The art of visualization layout is a tricky one. Once you start throwing more than one or two charts onto a page it can start to turn into a tricky-to-navigate hodgepodge of lines and bars where it's hard to get a sense...
04 April, 2017