After three long years of pandemic, one of the world’s largest tech shows made a stunning come back this week as CES lit up Las Vegas with a flash of color and optimism.

The innovation was imaginative, presenting a vision of the future that may never see the light of day, but that didn’t stop the buzz from reaching a frenzy. With more than 100,000 thousand attendees and thousands of exhibitors scouring two million net square feet of exhibition space, there was a lot of excitement for what was being presented.

Here’s just a few of the products and experiences that stole the show.

BMW i Vision Dee

The color-changing concept car received an audible gasp during BMW’s cinematic keynote starring BMW Chairman Oliver Zipse, Arnold Schwarzenegger, David Hasselhoff, Knight Rider’s KITT and Herbie

Read More

Marketing Podcast with Marcel Petitpas

Marcel Petitpas, a guest on the Duct Tape Marketing podcastIn this episode of the Duct Tape Marketing Podcast, I interview Marcel Petitpas. Marcel is the CEO & Co-Founder of Parakeeto, a company dedicated to helping agencies measure and improve their profitability by streamlining their operations and reporting systems. Marcel is also the fractional COO at Gold Front and a speaker, podcast host, and consultant, specializing in Agency Profitability Optimization.

Key Takeaway:

The most profitable agencies have a winning formula that results in happy returning clients, steady growth, and continuous profit. In this episode, the CEO and Co-founder of Parakeeto, Marcel Petitpas, shares his insights on what that winning formula looks like and how agencies can optimize their businesses for profitability.

Questions I ask Marcel Petitpas:

  • [1:49] What should we be measuring if we want to optimize for profitability?
  • [4:14] When it comes to KPIs, how do we strike the right balance between too much
Read More
Combining X Number of Rows in Power Query for Power BI, Excel and Power Query Online

A while back, I was working on a project involving getting data from Excel files. The Excel files contain the data in sheets and tables. Getting the data from the tables is easy. However, the data in the sheets have some commentaries on top of the sheet, then the column names and then the data itself. Something like below:

Sample data
Sample data

This approach is pretty consistent across many Excel files. The customer wants to have the commentary in the column names when the data is imported into Power BI. So the final result must look like this:

Sample Data to be loaded into Power BI
Sample Data to be loaded into Power BI

The business requirement though is to combine the first 3 rows of data and promote it as the column name.

The Challenge

Let’s connect the Excel file and look at the data in Power BI Desktop.

Connecting to sample data from Power BI Desktop
Connecting to sample data from Power BI Desktop

As

Read More