Business Intelligence Consulting

About Robert

Robert is a Business Intelligence Consultant helping businesses extract insights from their data. Robert has worked through the whole Business Intelligence workflow, within various industries such as manufacturing, education, recruitment, finance, and retail.

Robert has gathered and developed requiremnt specifications for business intelligence projects, designed and created data models for data warehouses and BI reports, built ETL/ELT pipelines and data integrations, as well as created data analysis and reports for decision making.

For designing and developing a data warehouse Robert has mainly followed Kimballs methodology working bottom up and with denormalized data models. The development of ETL/ELT flows have mainly been done with tools such as Azure Data Factory, Logic Apps and Azure SQL or SQL Server. Data Factory has handled moving integrating data through extraction and loading and orchestrate pipelines. Logic apps have mainly been used for connecting to API:s and setting up smaller tasks such as customized email notifications. Last but not least Azure SQL or SQL Server has been used for enabling metadriven parameterized solutions in Data Factory and Logic Apps with control tables in SQL Server or Azure SQL.

Typically Azure Storage and Data Lake Gen 2 has been used as a date storage and data lake for extracted data that has been further loaded into a staging area in a Azure SQL or SQL Server database for the actual Data Warehouse. Even though Data Factory has mainly been used for moving data, transformations has primarily been done using stored procedures in our Database for our Data Warehouse.

After the transformations is done and the data is loaded into the data model and informational layer it is used for creating ad hoc analysis and creating views for supporting star schemas building Business Intelligence applications and reports in Power BI. Robert thus typically does not use Power Query to a great extent, and focuses on creating KPI:s analysis and data visualizations using DAX as well as integrating power BI solutions to action plans for supporting users everyday work life and decision-making.

Robert has worked in both larger teams with more established working methods, processes and methodologies such as Scrum, as well as in smaller projects with greater direct contact with the customer and immersion in requirements specifications, where he has had to organize and structure a lot of the work by himself.