BI Consulting with measurable results
Implement true "self service BI" with load times under 3 seconds. Your users do not need to acquire any technical knowledge about the business intelligence tool.
We optimize your business intelligence holistically
Support of various systems, languages and tools for extraction, transformation and loading of data
Case studies
SITUATION
Updating of Power BI dashboards was done by manually extracting the relevant data from various operational systems as csv files, which after manual transformation steps on the users' local desktop were imported as tables directly into Power BI Dataset in Power BI Desktop. More than a thousand individual Power BI Measures existed for report generation.
This resulted in a complex, slow, and high-maintenance data model in Power BI Dataset, which also suffered from a lack of data traceability and data confidentiality. The loading time of the visualizations in the report pages ranged from 7 seconds to several minutes.
SOLUTION
- Simplification of the previous data model and Power BI Measures
- Pre-aggregation of frequently used data through the Power BI report
- Refinement of access control with Power BI's Row level security feature
- Separation of data level from visual level in Power BI service using provided functions
- Elimination of manual CSV exports/imports on local users' desktops by introducing automated ETL processes in the data warehouse
IMPACT
- True self-service BI for business users without further technical knowledge of Power BI.
- Reduction of data model complexity and improvement of maintainability
- Reduction of loading times of visualizations to max. 3 seconds from previously several seconds to minutes by aggregation of frequently used data
- Improvement of data order and confidentiality of data
- Cost optimization of data transfer between cloud and on-premise environments
SITUATION
For years, Logoipsum manually tracked marketing metrics using Excel, Google sheets, and complex macros
SOLUTION
Logoipsum partnered with T2D3 to document their entire customer journey and map metrics at each stage
IMPACT
Logoipsum increased data accuracy by 76% and decreased manual data collection time by 4 hours per week
SITUATION
For days, HubSpot manually tracked marketing metrics using Excel, Google sheets, and complex macros
SOLUTION
Logoipsum partnered with T2D3 to document their entire customer journey and map metrics at each stage
IMPACT
Logoipsum increased data accuracy by 76% and decreased manual data collection time by 4 hours per week