Power BI data & visualization reporting
All data holds a story.We help you tell it.
ChemSights builds executive dashboards and Power BI reporting systems that turn scattered data into a clear, decision-ready story, from the numbers your leadership team checks every morning to the science that's harder to explain.
Featured: NSW Broadscale Microplastic Assessment · 120 estuaries, seven pages, one coastline
Explore the live reportBuilt on Power BI
Native Microsoft stack, with no third-party lock-in.
Any data source
ERP, CRM, APIs, spreadsheets, or cloud apps, modeled cleanly.
End-to-end delivery
From data model to dashboard, handled by one team.
Training included
Your team can extend and own the reports after handover.
What we build
Reporting systems, not one-off charts.
Every engagement covers the full path from source data to a dashboard your team trusts and keeps trusting six months later. For scientific and environmental data, that also means turning static findings, such as the tables and figures locked inside a published paper or report, into a dashboard people can actually explore.
Dashboard design & build
Power BI reports built around the metrics that matter most to your business, designed for the decisions your team actually makes rather than just the data you happen to have.
Data modeling & integration
We connect and model data from your ERP, CRM, APIs, spreadsheets, and other systems into a clean, governed semantic model, so numbers match across every report.
Managed & embedded reporting
Ongoing maintenance, refresh scheduling, row-level security, and embedding dashboards into your intranet, SharePoint, or client-facing portals.
Training & enablement
Hands-on Power BI training for your team, plus documentation for every model, so reports keep evolving after we hand them over.
Live reports
What a ChemSights report looks like.
Real Power BI dashboards we've built: a look at the reporting style, chart choices, and layout you can expect for your own data.
NSW Broadscale Microplastic Assessment
Microplastic hotspots, coverage and trends across NSW waterways.
Dance With Me Bachata Move Library
Bachata moves by type and difficulty, with class video for each.
Salsa Practice Library
Salsa moves by type and difficulty, with class video for each.
Olist Brazilian E-commerce Analytics
Brazilian e-commerce orders modelled as a multi-table star schema.
US Superstore Sales
Sales performance on the classic US Superstore dataset.
Global Box Office Report
Global box office performance built from IMDb and TMDB data.
The Last Count
An interactive globe of 63 threatened species: where they live, how many are left and where their numbers are heading.
Want to see this built with your own data? Let's talk.
How we work
Four steps, one point of contact.
Discover
We map your data sources, current reporting pain points, and the decisions each dashboard needs to support.
Model
We build a clean semantic data model, the foundation that keeps every report fast, consistent, and easy to extend.
Build
We design and build the Power BI reports, from wireframe through to a polished, on-brand dashboard.
Support
We hand over documentation and training, then stay on for maintenance, data refreshes, and new report requests.
Why Power BI
One platform, from a single dashboard to an enterprise model.
Fits your existing Microsoft stack
Power BI sits naturally alongside Excel, SharePoint, and Azure, with no separate BI platform to license, secure, and maintain.
Scales with you
Start with one team's dashboard and grow into a governed, enterprise-wide semantic model without changing platforms.
Your team can own it
Power BI's learning curve is low enough that, with the training we provide, your team can extend reports themselves.
Enterprise power, not enterprise pricing
Power BI licensing runs a fraction of the cost of tools like Tableau or Qlik, so growing businesses get enterprise-grade reporting without an enterprise budget.
About
Meet the person behind ChemSights.
I'm Remi Rouquette, founder of ChemSights. I started out as a scientist, with a PhD in physical chemistry, before moving into data, then added an MBA to sharpen the business and strategic side of that work, so I read a dataset the way a scientist does and a decision the way an operator does. My focus now is simple: turn data into clear insight, and help the people who own that data get better at working with it themselves. I build Power BI dashboards and train the teams behind them, with particular depth in environmental and scientific data, though the same rigor applies just as well to corporate and business reporting.
Outside of client work, I'm always curious to hear how people ended up in their field, especially anyone moving between science, data, and consulting. Feel free to say hello if you'd like to swap notes.
Resources
Resources for Power BI builders.
Community challenges to practise on, plus reference tools we've built ourselves.
Challenges
We follow these Power BI-specific community challenges, and sometimes enter them ourselves. They're a good way to sharpen report-building skills and see how other analysts approach the same dataset.
Workout Wednesday: Power BI
WeeklyA weekly rebuild challenge for Power BI, ranging beginner to advanced, where you recreate a published report to sharpen DAX, visuals, and layout skills.
Visit siteFP20 Analytics Live Challenge
MonthlyA monthly Power BI competition built around a fresh business dataset, where you build a report, get feedback, and see how others approached the same brief.
Visit siteOnyx Data: DataDNA Challenge
MonthlyA monthly dataset-driven challenge popular with the Power BI community, where you build a report or dashboard and submit it to a shared portfolio.
Visit sitePower BI DataViz World Championships
AnnualMicrosoft's own global Power BI contest, with multiple qualifying rounds on curated datasets, judged by community vote and culminating in a live finale.
Visit siteEnterprise DNA Challenges
OngoingA long-running series of numbered, hands-on Power BI analytics projects across domains like retail, healthcare, and logistics.
Visit siteOther resources
Reference material and tools that sit outside the challenge circuit.
DAX Cheat Sheet
ReferenceAn interactive reference of common DAX functions, searchable by keyword, intent, or function name, with arguments and examples for each.
Open cheat sheetGet in touch
Turn your data into a dashboard your team actually trusts.
Share where your reporting stands today, whether that's spreadsheets, an existing BI tool, or nothing at all. I'll come back with what a Power BI system could look like for your team, and what it would take to get there.