Forum Discussion

cosmos's avatar
cosmos
Regular Visitor
10 years ago

Is PowerBI the tool for me?

A current recurring task we have is that we get nightly sales reports via FTP which are loaded in to SQLServer. This data is then manipulated through SQL views and exported into Excel where graphs, c...
Need Help
a_mixed_life's avatar
a_mixed_life
Icon for Resolver I rankResolver I
10 years ago

I would ask them what their business case would be on why the reason for wanting it on Excel? To have the ability to manipulate data on excel?

 

Also, if I could ask, what ERP are you running?

cosmos's avatar
cosmos
Regular Visitor
10 years ago

The business requirement is that we can't lose any existing functionality and thats how its currently delivered and the recipients actually really like that functionality. Regardless of whether it makes sense, its the way it is. :(

  • a_mixed_life's avatar
    a_mixed_life
    Icon for Resolver I rankResolver I
    10 years ago
    cosmos wrote:

    The business requirement is that we can't lose any existing functionality and thats how its currently delivered and the recipients actually really like that functionality. Regardless of whether it makes sense, its the way it is. :(

    Those are the phrase we hate the most whenever we go through Change Management or as a Project Manager and Director of IT, "That's how we've always done it".

     

    There were some who swears on Excel, in Dynamics, we use Jet Reports since it lives in Excel and have similar functionalities as PowerBI on their latest release. It does have the ability to connect to SQL even if you're not using Dynamics ERP.