u/Minute_Ingenuity_889

Hello everyone,

My company wants me to get the CPIM certification, and I’m trying to get a head start on studying.

A bit about me: I’m a junior consultant at a supply chain consulting firm. I have an industrial engineering degree and a Master’s in Supply Chain.

The issue is that my company hasn’t provided me access to any CPIM resources yet, so I currently have zero study materials or official access.

I’d still like to start preparing, but honestly I have no idea where to begin.

I’d really appreciate any advice on:

- Good study materials (books, courses, free resources, etc.)

- Recommended study plans / timelines

- How difficult the exam is

- Tips from people who recently passed

Any help or guidance would be greatly appreciated. Thanks!

Hi everyone,

I'm facing a Power BI modeling issue and would appreciate some advice.

I have 2 tables:

Sales table

The grain is SKU + Year.

https://preview.redd.it/5rd2b7ctdf6h1.png?width=552&format=png&auto=webp&s=4a2d92f173df8e3e76e1edc9bf7531a4852f40da

BOM table

The grain is SKU + Material + Supplier + Purch Cost + Production cost + Maintence cost

( It would be easier to sum the cost columns and aggregate the BOM table at the SKU + Supplier + Material level, but I'm not sure that's the best practice)

A SKU can have multiple materials, and the same material can have multiple suppliers with different costs.

https://preview.redd.it/i3iydgkzdf6h1.png?width=670&format=png&auto=webp&s=f4b8d43cbcd4fe5298f900bd664f8338cb95cb2b

The only common field between the two tables is SKU, so I created a SKU dimension table and linked both tables to it.

My goal is to show:

• Revenue (from the Sales table)
• Costs (from the BOM table)
• Margin

The challenge is that I need to calculate BOM costs using:

Cost × Quantity Sold

where Quantity Sold comes from the Sales table.

I also need:

• Analysis by Year
• Supplier filtering
• Correct revenue totals

I cannot merge the two tables because revenue would be duplicated for every BOM row and become overstated.

What would be the recommended data model and DAX approach to calculate BOM Cost × Quantity Sold while keeping Year analysis and Supplier filtering?

Thanks!