PowerBI - database modeling and reports
Creation of reports and indicators for PowerBI and datawarehouse modeling
Description
This solution is the design of a database to be used as Datawarehouse for PowerBI and also the creation of reports and dashboards.
The data may come from different sources among them Excel itself, SQL Databases, etc.
The Database can be Microsoft's SQL Server or Oracle's MySQL.
For this kind of development, the company will need to own or acquire licenses for the Database of choice.
It will be necessary also a PowerBI licence from Microsoft.
Typical Phases
- Requirement gathering
- Analysis and Design - creation of the tables in the Database
- Implementation - Development of reports and DAX formulas
- Testing - key users tests
- Deployment - migration to production