Business intelligence on the Microsoft stack
A reporting practice built for scrutiny.
Numbers that reconcile to the ledger. Pipelines from more than 200 source systems. Governance your security team will sign. Delivered by a dedicated practice, not a rotating bench.
- 01
Sources
ERP, finance, CRM, HR, operations, files
- 02
Ingestion
Incremental pipelines, gateways, monitoring and alerting
- 03
Storage
Lakehouse or warehouse, layered from raw to curated
- 04
The semantic model
One definition per measure. Security applied once, inherited everywhere.
- 05
Consumption
Reports, paginated output, Excel, embedded, Copilot
Most reporting failures are decided in layers 01 to 04.
Most reporting budgets are spent on 05.
- source systems on our connectivity index
- 200+
- software and data projects delivered
- 125
- years of engineering, as a Roth&Co company
- 20+
When clients call us
Rarely for a first dashboard.
Our clients usually have reporting in place already, along with a data team and opinions. They come to us when the estate has to carry more weight than it was built for.
- 01
Several ERPs, one set of numbers
Consolidated reporting across entities and acquisitions that run on different systems and different charts of accounts.
- 02
An estate that has outgrown itself
Reports that take a minute to render, refreshes that fail overnight, a capacity running at its ceiling.
- 03
A move to Fabric, or off a legacy tool
Migration from SSRS, Tableau, Qlik or Cognos, with the numbers reconciled report by report before the old system is switched off.
- 04
Self-service without the sprawl
Hundreds of workspaces and no agreed source. Certified models, a workspace strategy and a center of excellence that outlasts us.
- 05
Analytics inside your own product
Power BI Embedded for your customers, with tenant isolation and your interface around it.
The practice
Six disciplines, and what you hold at the end of each.
| Discipline | What we do | What you hold |
|---|---|---|
| Data engineering | What we doIncremental pipelines from ERP and operational systems into a lakehouse or warehouse. Data Factory, Dataflows Gen2, on-premises gateways. | What you holdMonitored pipelines that alert on failure |
| Semantic modeling | What we doOne definition per measure, agreed with the people who own the number, then built as a star schema. Storage chosen table by table, so a report stays fast as the history grows behind it. | What you holdA documented model that ties to the general ledger |
| Performance | What we doIncremental refresh, aggregations, query and DAX tuning, capacity sizing against real workload. | What you holdBefore-and-after timings for every report we touch |
| Security and governance | What we doRow-level and object-level security, sensitivity labels, certified models, workspace and tenant design. | What you holdAn access matrix your auditors can read |
| Lifecycle | What we doDevelopment, test and production stages with deployment pipelines, source control and release checks. | What you holdA release process your own team can run |
| Reporting and enablement | What we doRole-based reports, paginated output, mobile layouts, embedded analytics, then training for authors and consumers. | What you holdReports people open, and staff who can extend them |
Connectivity index
215 systems. One model.
If it holds your data, Power BI can read it. What differs is the route, and the route decides refresh speed, cost and what breaks at upgrade time. Each system below is marked with the route we would normally take.
- Native
- A connector Microsoft lists for Power BI. Fastest to stand up.
- Database
- We read the SQL Server, Oracle or other database underneath the application.
- Driver
- The vendor's ODBC driver or OData feed, through Power BI's generic connectors.
- API
- A pipeline we build against the vendor's API, landing the data where Power BI reads it.
- Native9
- Database8
- Driver2
- Dynamics 365 Business CentralNative
- Dynamics 365 FinanceNative
- Dynamics 365 Supply ChainNative
- Dynamics NAVNative
- Dynamics GPDatabase
- Dynamics AXDatabase
- Dynamics SLDatabase
- SAP S/4HANANative
- SAP ECCNative
- SAP BW and BW/4HANANative
- SAP HANANative
- SAP Business OneDatabase
- SAP Business ByDesignDriver
- Oracle Fusion Cloud ERPNative
- Oracle NetSuiteDriver
- Oracle E-Business SuiteDatabase
- JD Edwards EnterpriseOneDatabase
- JD Edwards WorldDatabase
- PeopleSoftDatabase
- Native3
- Database13
- Driver8
- API4
- AcumaticaDriver
- Deacom (ECI)Database
- Epicor KineticDriver
- Epicor Prophet 21Database
- Epicor EclipseDriver
- Epicor BisTrackDatabase
- Exact OnlineNative
- Global Shop SolutionsDriver
- IFS CloudDriver
- Infor CloudSuite IndustrialDatabase
- Infor M3API
- Infor LNDatabase
- Infor VISUALDatabase
- Infor XADatabase
- JobBOSSDatabase
- MacolaDatabase
- OdooDatabase
- PlexAPI
- PriorityDriver
- QADDriver
- Sage X3Database
- Sage 300Database
- Sage 100Driver
- SYSPRODatabase
- Unit4API
- Workday FinancialsAPI
- CertiniaNative
- RootstockNative
- Native9
- Driver2
- API13
- AnaplanNative
- AvalaraAPI
- BillAPI
- BlackLineAPI
- BloombergNative
- BQE CoreNative
- CCH TagetikNative
- CoupaAPI
- ExpensifyAPI
- FactSetNative
- OneStreamNative
- Oracle EssbaseNative
- PlanfulAPI
- QuickBooks OnlineAPI
- QuickBooks EnterpriseDriver
- RampAPI
- Sage IntacctAPI
- Sage 50Driver
- SAP ConcurAPI
- SolverNative
- StripeAPI
- VenaNative
- Workday Adaptive PlanningAPI
- XeroAPI
- Native8
- Driver1
- API14
- Dynamics 365 SalesNative
- Dynamics 365 Customer InsightsNative
- FreshdeskAPI
- HubSpotAPI
- IntercomAPI
- LinkedIn Sales NavigatorNative
- PipedriveAPI
- SalesforceNative
- ServiceNowAPI
- SugarCRMAPI
- ZendeskNative
- Zoho CRMAPI
- ADPNative
- BambooHRAPI
- DayforceAPI
- PaychexAPI
- PaycomAPI
- PaylocityAPI
- SAP SuccessFactorsDriver
- SumTotalNative
- UKG ProAPI
- Viva InsightsNative
- Workday HCMAPI
- Native1
- Database6
- API7
- Blue YonderDatabase
- Cin7API
- DescartesAPI
- ExtensivAPI
- FishbowlDatabase
- Körber WMSDatabase
- Manhattan WMSDatabase
- McLeod LoadMasterDatabase
- MercuryGateAPI
- project44API
- SamsaraNative
- SAP AribaAPI
- ShipStationAPI
- Trimble TMWDatabase
- Native4
- Database9
- Driver1
- API5
- athenahealthAPI
- eClinicalWorksDatabase
- Epic ClarityDatabase
- FHIR serversNative
- InterSystems Health InsightNative
- MatrixCareAPI
- MEDITECHDatabase
- NextGenDatabase
- Oracle HealthDatabase
- PointClickCareAPI
- AppFolioAPI
- Autodesk Construction CloudNative
- BuildingConnectedNative
- CMiCDatabase
- MRI SoftwareDatabase
- ProcoreAPI
- Sage 300 CREDriver
- Viewpoint VistaDatabase
- Yardi VoyagerDatabase
- Native7
- Database2
- API11
- Adobe AnalyticsNative
- Adobe CommerceDatabase
- Amazon Seller CentralAPI
- BigCommerceAPI
- FunnelNative
- Google AdsAPI
- Google AnalyticsNative
- KlaviyoAPI
- LightspeedAPI
- LinkedIn AdsAPI
- MailchimpAPI
- MarketoNative
- Meta AdsAPI
- MixpanelNative
- ShopifyAPI
- SquareAPI
- SupermetricsNative
- SurveyMonkeyNative
- ToastAPI
- WooCommerceDatabase
- Native12
- Driver1
- API3
- AsanaNative
- Azure DevOpsNative
- CelonisNative
- ConnectWiseAPI
- DynatraceNative
- GitHubNative
- JiraAPI
- Microsoft IntuneNative
- Microsoft ProjectDriver
- Microsoft SentinelNative
- Monday.comAPI
- PlanviewNative
- QuickbaseNative
- SmartsheetNative
- SolarWinds Service DeskNative
- WrikeNative
- Native34
- Driver1
- Amazon AthenaNative
- Amazon RedshiftNative
- AtScaleNative
- Azure Cosmos DBNative
- Azure Data ExplorerNative
- Azure SQL DatabaseNative
- Azure Synapse AnalyticsNative
- ClickHouseNative
- DatabricksNative
- DenodoNative
- DremioNative
- ElasticsearchNative
- ExasolNative
- Fabric LakehouseNative
- Fabric WarehouseNative
- Google BigQueryNative
- IBM Db2Native
- IBM InformixNative
- IBM NetezzaNative
- ImpalaNative
- MariaDBNative
- MongoDB AtlasNative
- MySQLNative
- Oracle DatabaseNative
- Palantir FoundryNative
- PostgreSQLNative
- Progress OpenEdgeDriver
- SingleStoreNative
- SnowflakeNative
- SQL ServerNative
- SQL Server Analysis ServicesNative
- StarburstNative
- SybaseNative
- TeradataNative
- VerticaNative
- Native16
- Database1
- AccessNative
- Azure Blob StorageNative
- Azure Data Lake StorageNative
- CSV and textNative
- DataverseNative
- ExcelNative
- Exchange and OutlookNative
- Google SheetsNative
- JSON and XMLNative
- OneLakeNative
- Parquet and DeltaNative
- PDFNative
- SharePoint and OneDriveNative
- Any OData feedNative
- Any ODBC or OLE DB sourceNative
- Any REST APINative
- In-house and legacy systemsDatabase
The route shown is the usual one. The right one for you depends on version, hosting and licence, and we confirm it in the first technical session. Native status follows Microsoft's published Power Query connector list. Product names belong to their owners.
Not listed? Ask us about itGovernance and security
Designed to pass review, not to avoid it.
Your security, audit and IT teams will ask how this is controlled. These are the answers we build in from the first week, and document.
Access
Who sees which rows
Row-level and object-level security defined in the model and tied to your directory groups.
Lineage
Where every number came from
Each measure traced from the report back to source tables, with the business definition beside it.
Change
How a change reaches production
Separate development, test and production stages, with source control and a recorded release.
Classification
What may leave the building
Sensitivity labels that follow the data into exports, and certified models marked as the source to trust.
Operations
What happens when a refresh fails
Monitoring and alerting on every pipeline, so a stale dashboard is caught by us before a meeting catches it.
Continuity
What you own if we leave
The model, the pipelines, the documentation and the conventions, in your tenant, with your team trained on them.
We sign HIPAA business associate agreements, and your data stays in your own tenant, in the region you choose. Our engineering team works under an ISO 27001 certified information security management system.
Selected work
The fix is usually one layer below where it hurts.
Retail · NetSuite · Power BI
>90%
Refresh time cut from hours to minutes
The ERP's API returned a thousand rows per request. We replaced it with saved-search exports feeding the model directly. Data now refreshes every 15 minutes and the servers behind the old process were retired.
Read the engagementRetail pricing · Data platform
1B+
Price points collected across 6,000 sites
A competitive pricing platform covering 55 countries. Collection, matching and normalization run continuously, so pricing teams act on a competitor's move the same day.
Read the engagementSpecialty chemicals · Deacom · 1,000+ distillation jobs
97
Crude materials, each one now automatically costed from the ERP data
Crude goes through the still several times, and each pass yields several grades plus waste, so finance needed to see what every run produced and which crude it came off. The ERP's job records carry the output lines and nothing that points back to the material that went in. The costing figures were assembled by hand every month. We rebuilt that link for each item and put 1,000+ closed jobs and 3,000+ output lines, waste included, behind one costing report.
“At Roth&Co, a question used to take a day, because someone had to tie the numbers together first. Now the answer is there when the question comes up.”
Engagement
Four ways to work with the practice.
They differ in one thing: how much is already decided when we start.
Fixed scope
A defined build, at a stated price
You already know what you want built. You receive the architecture, the sequence, the timeline and the total cost before you commit to the build, then four fixed stages: assessment, modeling, build, rollout. The engagement ends when the scope is delivered.
Suits: a migration, a rebuild, a rescue.
Agreed outcome
You set the destination, we work out the route
You know what the reporting has to let you decide, but not what your systems will give up until somebody reads them. We estimate the whole as a range, price the first stage only, and cost the rest once discovery has turned the range into a plan. The engagement ends when the outcome is reached.
Suits: a first serious platform, or an estate that has grown past its original design.
Dedicated team
Named engineers, working to your backlog
You direct the work week by week, the same way you direct your own team. Senior engineers join your priorities, your branching rules and your release process, for as long as the roadmap needs them. It ends when you say it does.
Suits: a standing roadmap, and an internal team to run it with.
Managed service
We keep it running, you use it
The platform is built, and somebody has to look after it every day. We watch the refreshes, tune what slows down, manage capacity and add reports as the business asks for them. There is no end date and no project to run.
Suits: lean internal teams.
Related services
- Artificial IntelligenceAI grounded in your data and workflows: automation, prediction, and governed access to the models your team already uses.
- Cloud DevelopmentCloud infrastructure that scales with the business and costs less to run than the servers it replaces.
Next step
Request a technical briefing.
A working session with a practice lead, not a sales call. Bring your architecture diagram and the report that causes the most arguments.
- 01We review your sources and current estate with you.
- 02You hear plainly what the data can support today and what needs work first.
- 03You receive the architecture, the order of work and a price you can commit to, in writing.
Or speak with Chuck Gartenhaus, our Founder & CEO, directly: 718-975-5500 · hello@rothtech.io