Hi everyone,
Cris here, with my very first steps in PowerBI. I'm a self-taught Excel-fan and consider myself at an average level. I got fascinated by PowerBI and want to improve the way I present my data (Sales & Marketing) within my company (truth is that I do all this cause I simply have fun learning new stuff).
I think I have a tables-structure issue and why I "solved" this in Excel with brutal copy/paste, it's time for me to dig into that and do things properly. Here's my problem:
I have market data for a certain product, a very simple table composed by Country (rows, in variable number depending on the actual market evolution) and product categories (columns, fixed number).
Then, I have the very same table but with our company market data. Structure is the same, as we receive the info from an authority. Same rows, same colums*
The issue started when I wanted to create what in Excel is called combo-chart, showing total market data (vertical bar, divided by product categories) as well as a line chart showing our market share.
As said, I can do it (the old brutal way) in Excel but I think it's time for me to dig into tables structures and profit from the "power of BI".
Any suggestion/recommendation on how to properly structure the database? I tried to look online for some tutorials but possibly I'm not using the correct keywords (I'm not an English native speaker)
* Actually, data received from the authority are more raw. We get one single table where countries are still in rows but product categories and our sales of each category are all columns, one after the other, like:
ProductA | /* | ProductB | /* | ProductC | /* | ....
(where "/*" is our sales on the product on the immediate left. I do correct data and split into either two tables, or one master table with proper column naming)
Look forward to learning from you guys,
Cris
Cris here, with my very first steps in PowerBI. I'm a self-taught Excel-fan and consider myself at an average level. I got fascinated by PowerBI and want to improve the way I present my data (Sales & Marketing) within my company (truth is that I do all this cause I simply have fun learning new stuff).
I think I have a tables-structure issue and why I "solved" this in Excel with brutal copy/paste, it's time for me to dig into that and do things properly. Here's my problem:
I have market data for a certain product, a very simple table composed by Country (rows, in variable number depending on the actual market evolution) and product categories (columns, fixed number).
Then, I have the very same table but with our company market data. Structure is the same, as we receive the info from an authority. Same rows, same colums*
The issue started when I wanted to create what in Excel is called combo-chart, showing total market data (vertical bar, divided by product categories) as well as a line chart showing our market share.
As said, I can do it (the old brutal way) in Excel but I think it's time for me to dig into tables structures and profit from the "power of BI".
Any suggestion/recommendation on how to properly structure the database? I tried to look online for some tutorials but possibly I'm not using the correct keywords (I'm not an English native speaker)
* Actually, data received from the authority are more raw. We get one single table where countries are still in rows but product categories and our sales of each category are all columns, one after the other, like:
ProductA | /* | ProductB | /* | ProductC | /* | ....
(where "/*" is our sales on the product on the immediate left. I do correct data and split into either two tables, or one master table with proper column naming)
Look forward to learning from you guys,
Cris
