Database Design and BI
Business Intelligence
Business Intelligence (BI) refers to the technology-driven process for collection, integration, and presentation of business information in form of actionable intelligence.
BI development implies strong SQL knowledge, ability co develop complex custom queries for different data sources, analyze data.
Experience and competencies
- Database design using Microsoft SQL Server, MySQL (InnoDB, MyISAM), PostgreSQL, stored procedures, functions.
- Database scalability and performance tuning.
- Development of ETL processes, creation of packages using Integration Services (SSIS).
- SQL Server Reporting Services (SSRS).
- SQL Server Analysis Services (SSAS).
- Microsoft Power BI.