Tailoring the Solution to Your Needs
Company-wide Restrictions Make it Impossible to Use Data Sources Efficiently?
Data revolution can be kickstarted by Power BI processing of classic Excel solutions, where
exports from ERP applications to Excel (.xlsx), text files (.txt, .csv, etc.) or xml files will
be used as the data source.
As an improvised data warehouse for workgroup, an Access
database can be utilized where a linked table processed in Power Query would provide a data
pump. Corectness of the data will be secured by setting up rules of referential integrity in
Access data model. If the amount of data exceeds the Access capacity, SQL Server Express or
higher edition provided by your IT department can be used.
Are You Processing Reliable Data Sources with Secured Integrity of the data?
Ideal data soures for your Self-Service Power Business Intelligence solutions are relational
databases such as SQL Server, Oracle, SAP Business Objects, MySQL, MS Access etc. Data
warehouses with data model in shape of a star or a snowflake make analysis phase easier and are
more clear.
Power BI allows you to combine data sources and also processes SharePoint Lists
or can connect to SQL Server Reporting Services. Power BI can also load the data from cloud
data sources such as SQL Azure or from data feed from online sources.
