Contents tagged with BI
-
Why I love my job: Quick Start engagements
One of the best parts of my job as a Business Intelligence consultant is what happens when I get a new customer. Often our first engagement with a customer that is challenged by their BI or reporting capability is a PowerBI Quick Start. This is typically a two-week intensive engagement where an Imaginet consultant (like me) embeds themselves into a team in the organization and helps the customer determine what their needs are, where they would like to be, and to discover a path to get there.
-
Power Query to Promote Headers and removing Special Characters
I had an Excel spreadsheet that had "nicely" formatted column headers that made the text appear on separate lines (ie. the text included Alt-Enter linefeeds). I wanted to use it as a source for Power Query (and PowerBI), but remove the linefeeds in the names before promoting them to the column header.