cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Power BI Implementation across multiple companies

I have between 5-100 companies (range given to see if impacts suggestions) and would like to implement Power Bi across them to provide:

  • Monitoring of how each individual company is performing
  • Consolidation results for all companies in a dashboard format

 

Does anyone have any recommendations on how to achieve this?

 

Thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Power BI Implementation across multiple companies

@BigBadBob it is very vague information but best practice would be to have one centralize dataset from all the companies, and implement Row Level Security, so the users from individual company see their own data and with elevated permission, management can see all companies data. 


There are many ways to handle this but I think this is a good starting point. Feel free to reach out if you have further questions.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Highlighted
Post Prodigy
Post Prodigy

Re: Power BI Implementation across multiple companies

@BigBadBobI worked in a very similar situation, where a company had many acquisitions and all of them came with their own ERPs and systems.

 

Basically, this is what we did.

1. Set up a common business intelligence datawarehouse - can be platform of choice. We just used SQL Server.

2. Build common data structures for sales, finance, operations etc - most of these are very standardized and reference implementations are available. Additional fields such as Company/Brand etc helps identify specific group company

3. Bult integration jobs from each of the source systems into the warehouse.

4. Built a set of common reports on top of the consolidated tables.

5. Adjusted for any idiosyncracies or special business requirements of any group company. One can always build a specific report as needed.

 

Hope this is helpful 🙂

View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Power BI Implementation across multiple companies

@BigBadBob it is very vague information but best practice would be to have one centralize dataset from all the companies, and implement Row Level Security, so the users from individual company see their own data and with elevated permission, management can see all companies data. 


There are many ways to handle this but I think this is a good starting point. Feel free to reach out if you have further questions.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Highlighted
Post Prodigy
Post Prodigy

Re: Power BI Implementation across multiple companies

@BigBadBobI worked in a very similar situation, where a company had many acquisitions and all of them came with their own ERPs and systems.

 

Basically, this is what we did.

1. Set up a common business intelligence datawarehouse - can be platform of choice. We just used SQL Server.

2. Build common data structures for sales, finance, operations etc - most of these are very standardized and reference implementations are available. Additional fields such as Company/Brand etc helps identify specific group company

3. Bult integration jobs from each of the source systems into the warehouse.

4. Built a set of common reports on top of the consolidated tables.

5. Adjusted for any idiosyncracies or special business requirements of any group company. One can always build a specific report as needed.

 

Hope this is helpful 🙂

View solution in original post

Highlighted
Frequent Visitor

Re: Power BI Implementation across multiple companies

Thank you very much for the below response. It gives a nice structure to how this was achieved. 

 

It would be interesting to chat to you more about this. Would it be possible to private chat? Thanks again Andrew

Highlighted
Super User IV
Super User IV

Re: Power BI Implementation across multiple companies

@BigBadBob Sure, my email is in my signature, please feel free to reach out. Cheers!!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors