• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Business Dashboard/Reports for both Employees and Customers|Dashboards & Charts|Excel Forum|My Online Training Hub

You are here: Home / Business Dashboard/Reports for both Employees and Customers|Dashboards & Charts|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumDashboards & ChartsBusiness Dashboard/Reports for both…
sp_PrintTopic sp_TopicIcon
Business Dashboard/Reports for both Employees and Customers
Avatar
Michael Redfern

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
August 12, 2022
sp_UserOfflineSmall Offline
1
September 18, 2022 - 6:12 am
sp_Permalink sp_Print sp_EditHistory

Hello!

I'm posting here in the hope of some advise/direction with a business problem.

As an Analyst at an Automotive Training Centre, I use Excel and Power Query to collate a report about training attendance. This report is used by internal employees but I then use VBA to break this full Excel report up into pieces which are emailed each week to each Company who sends delegates for training with us (i.e. each external company listed on the full report, usually around 200).

So, I would like to find a better way for our external customers to view this information without having to use VBA and emailing.

I have so far explored and rejected the following:

1. Power BI - Our company doesn't encourage use of Power BI, not fully sure why. Also, licencing seems to be a nightmare when external customers need to view.

2. Tableau - Again licencing costs due to external customers needing to view.

Ideally, i'd like external customers to be able to view the report data only applicable to their company (data protection!) maybe via web browser? but without having to embed 200 separate reports.

Can anyone please help with suggestions/help?

Many thanks in advance!!

Mike 

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4447
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
September 19, 2022 - 4:02 pm
sp_Permalink sp_Print

Hi Michael,

Welcome to our forum!

Power BI is the tool designed for sharing specific data with different users as you describe above. The only alternative that I know of is to use Power Automate to automatically email subsets of the report to users. However, I'm not sure there's any advantage to this as you're already doing this with VBA. 

Mynda

Avatar
Michael Redfern

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
August 12, 2022
sp_UserOfflineSmall Offline
3
September 19, 2022 - 8:06 pm
sp_Permalink sp_Print

Many Thanks Mynda,

What type of Power BI would I need? Could I achieve this with Power BI Desktop without publishing public? I think our company wouldn't allow that due to data protection as my report contains personal information.

I have the option to embed the report in our Learning Management system and would need to research in Power BI how to apply views based on user viewing the report.

Many Thanks

Mike

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4447
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
4
September 20, 2022 - 9:24 am
sp_Permalink sp_Print

Hi Michael,

You and each of the customers accessing the reports would need a Power BI Pro license (which is US$10/month), so that you can use the Row Level Security feature.

If you're willing to create 200 separate Excel files, you could use Excel workbooks connected to the master data source file with Power Query filtering the data for each customer. Then create a sharing link for each Excel file allowing the customers to read their specific workbook. You would have to run a VBA routine or Power Automate script to open each file and refresh the queries as required.

Mynda

Avatar
Michael Redfern

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
August 12, 2022
sp_UserOfflineSmall Offline
5
September 21, 2022 - 3:04 am
sp_Permalink sp_Print

Many thanks Mynda! 🙂

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Shanna Getschel, Velouria, Lynnette Altomari, Roy Lutke, Jack Brett, Jeff Krueger, Darrell Hodge, Natasha Smith, Sopi Yuniarti
Guest(s) 12
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Sopi Yuniarti
sandra parker
LAFONSO HERNANDEZ
Hayden Hao
Angela chen
Sean Moore
John Chisholm
vexokeb sdfg
John Jack
Malcolm Toy
Forum Stats:
Groups: 3
Forums: 24
Topics: 6214
Posts: 27243

 

Member Stats:
Guest Posters: 49
Members: 31893
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.