Data Analysis with Microsoft Power BI.
18 october

Data analysis with Microsoft Power BI

The amount and complexity of data is constantly increasing, even in medium-sized companies. In order to draw the right conclusions from this data, there is no getting around the use of business intelligence tools. The focus is on fast and comprehensive data analysis. One of these tools is Microsoft Power BI.

0

Toolbox for data analysis

Microsoft Power BI consists of several tools for analysing business data. The application is made up of various components and is based on data processing in a central cloud. The data stored in the cloud analysed data can be graphically displayed and shared on various devices and platforms.

Numerous data sources possible

The sources that can be used for a data analysis with Power BI are manifold. These can be databases of all kinds, web services that pass on data records or individual Excel files that are imported. The local or cloud-based sources are connected via various gateways. Power BI already comes with a large number of connectors. This also includes, for example SAPHANA supported. However, you can also develop your own connectors to expand the basis of data analysis.

The most important components of Power BI

Power BI consists of various components. They are different services, gateways and tools, some of which are provided in the cloud and some of which are operated on end devices. The most important components of Microsoft Power BI include:

The various building blocks of Power BI, i.e. services, gateways and tools, are composed as follows

  • Power BI Desktop ? the Windows-based desktop application for PCs or notebooks for the transmission, transformation and modulation of data and the resulting creation of reports.
  • Power BI (Service) ? Power BI as Software as a Service from the cloud (originally called Power BI for Office 365)
  • Power BI Mobile ? Mobile apps for iOS, Windows and Android
  • Power BI Gateways ? Interfaces for the integration of external data
  • Power BI Embedded ? REST API to embed reports, dashboards or visualisations in other applications (e.g. SAP Business One).
  • Power BI Report Server ? for the storage and management of Power BI reports

Data analysis tool also for SMEs

Power BI is a tool that not only addresses analysts from large companies. It also has its justification and benefit for companies from the SMEs-sector who want to enter the world of business intelligence. The approaches that can be pursued with this are to be sought in the area of data analysis in the form of special queries, ad-hoc analyses. Equally, however, one can venture into the world of data discovery, where unknown data and correlations are waiting to be discovered.

SAP Business One Reporting

SAP Business One – Reporting

All sorts of requirements for SAP Business One - Reporting are what a user needs to do after the introduction of SAP B1...
Continue reading ?
MariProject Dashboards

Dashboard functions in MARIProject

SAP Business One has had distinctive functionalities for creating dashboards since version 9 at the latest. But also MARIProject, integrated project software ...
Continue reading ?
metrics

More key figures transparency in the ERP system

Many companies hope that the introduction of ERP software will bring more transparency to their key figures. However, it only becomes clearer...
Continue reading ?
Data Lake vs Warehouse

Data warehouse or data lake

Data lakes and data warehouses are buzzwords one hears when it comes to data retention in the context of big data...
Continue reading ?
Data analysis with Microsoft Power BI

Data analysis with Microsoft Power BI

The amount and complexity of data is constantly increasing, even in medium-sized companies. In order to draw the right conclusions from this data...
Continue reading ?
BIG DATA for SMEs

Big Data – Relevant for SMEs?

Big data is not relevant for small and medium-sized companies. Such an assessment can often be heard and read ...
Continue reading ?
DATA Science

Data analysis for SMEs

A critical analysis "Data analysis for SMEs" or "Data Science" should actually be one of the top issues for medium-sized companies. For it ...
Continue reading ?
Work 4.0: Faster, further, higher or deceleration?

Work 4.0: Faster, further, higher or deceleration?

The rapid automation of the working world has made many voices concerned and loud for deceleration. However, digital systems could still ...
Continue reading ?
Free MS Power Bi Ebook

Free MS Power Bi Ebook

Microsoft Power Bi is a business intelligence tool that can be used to dock different data sources. The data can be used by the Bi Tool ...
Continue reading ?
Power Bi course

Monthly update to MS Power Bi

Microsoft Power Bi monthly update has been released. Of particular interest is a function that allows users to explore new ways...
Continue reading ?
Update for the data analysis tool: MS Power BI

Update for the data analysis tool: MS Power BI

Microsoft is regularly expanding the functionality of MS Power BI. A new version offers a number of new features...
Continue reading ?
New Reports / Power Bi for SAP Business One

New Reports / Power Bi for SAP Business One

Power Bi is a tool that allows you to analyze and visualize data in the simplest way. Versino has...
Continue reading ?
0

Leave a Reply

Your email address will not be published. Required fields are marked *
You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>