By using this website, you agree to the use of cookies as described in our Privacy Policy.
Sundsvall | Härnösand | Kramfors - Sweden

My experience from Business Intelligence for the last 15 years involves mainly

  • Microsoft SQL Suite  - SQL, SSIS, SSRS, SSAS [olap/tabular], PowerBI
    I have designed and maintained a complete data warehouse from scratch including both olap an tabular cubes.
    Back in the days, all reports were built in Reporting Services (called Paginated Reports now a days).
    But PowerBI is really the tools everyone likes to use now.

  • Data Warehousing in SQL/Azure Synapse environments but sources from all possible places
    In my current role as BI-developer I am maintaining and extending an enterprise data wahouse with more than 15 ERPs flowing it's data to the DW in SQL Synapse (formerly SQL Data Warehouse).

  • Data Vault 2.0
    The last project involves modeling all source data into a Data Vault 2.0 which feels like a fresh solution that is close to only inserts to the database.

  • Star schema marts
    Consumers like to pull their data from start schemas which is more or less self described. And a good choice to provide self service within the business.

  • Automation Tools for ETL generation (Bimlflex, Darwin) even though I've created bunch of solutions manually too

  • Azure Data Factory
    ADF is a pretty good engine to move data in the azure envionment and allows for a streight forward CI/CD using DevOps.

  • Logic Apps
    When sending messages between BI-environments in the cloud Logic App is a streigth forward and pretty easy tool to setup APIs in.

  • CI/CD in Devops (release pipelines)
    Development in dev-env, tests in test-env then deploy to production is the only way to run your continous development

  • Currently evaulating Microsoft Fabric using delta-parquet for a replacement of the current Azure Synapse DW

Contact me if need any help of want to discuss opportunities.

Det finns inga artiklar i denna kategori. Om det finns underkategorier på den här sidan kan de innehålla artiklar.