ETL | Data Warehouse | Tableau
About Brindle Solutions
Solving problems with data.
I created Brindle Solutions to help small businesses do more with data. We are surrounded by data. All day, every day, we create and consume vast quantities of data. Doing nothing with your data is no longer an option. You either benefit from data, learn from data and learn to drive your business forward with data or you squander your most valuable resource. Data is THAT important. I can help.
I Collect Data
Data lives in collections, tied together in databases. Sometimes that works in our favor, but often we need to combine data in new ways to get the answers we need. I can help you untie those bundles and combine all that data so it can actually be used.
I Organize Data
Most databases are setup to make data capture incredibly efficient. This is great for systems that capture data, it’s not so great for creating reports and data visualizations. I can help you optimize your data for analytics.
I Visualize Data
Traditionally, business reporting is based on huge tables of data. Endless columns and rows that blur together and make loving data hard. I want you to see data the way I do. Data only reaches it’s full potential when it is visual, intuitive, interactive and bubbles up unexpected insight.
I Build Analytic Teams
Data is your most valuable resource. Without a great analyitcs team you will squander that resource. I want to help you get the most from your team. I can help you choose the right people and then we can train, coach and mentor them so they can see data the way I do.
I’m the guy to call when you’re ready to get real with your data. Bad reporting is a waste of time and money. Good analytics can surface unexpected insights and drive innovation. I live for those moments. Those Aha! moments that bring the big picture into focus.
Here are some of the things I’m good at …
- Moving data with SQL Server Integration Services
- Automating data validation and cleanup
- Building databases optimized for analytics
- Recognizing and fixing poorly designed analytics databases
- Tableau development, support and training
- Teaching business teams how to benefit from analytics
- Tableau administration
- Building analytics teams
- Looking sharp in a stingy brim fedora
Short answer? I help small to mid size businesses do more with data. I do that in three ways.
- I move data from all the places it lives in your environment into a central database so we can work with it.
- I store data. I do this by designing databases optimized for the kind of reporting you need and the tools and people in your business that will be using your data.
- I share data. In my way of thinking, the best way to share data is in a form that is visual, interactive, intuitive and inviting. You should WANT to interact with your data. I design data visualizations, charts, graphs and dashboards with Tableau.
In a nutshell, I will do whatever it takes to bring you from no analytics to strong analytics while always keeping in mind that your data environment has to fit YOU. Everyone uses data differently. I am very pragmatic in the choices I make to ensure your data is ready to work for you.
I’m so glad you asked. Let’s make a list!
- I love lists. They keep me focused and they keep everyone on the same page. I use Trello to manage all my lists. Work with me and I’ll show you how Trello helps me get things done.
- I hate meetings. I think most meetings can be replaced with an email, annotated screen shot or the occasional short video walk through. I’d rather get things done than talk about getting things done.
- I love working sessions. As a remote consultant, I probably spend about 80% of my time working from my office, that other 20% though … that’s where the magic happens. I love a good working session where everyone rolls up their sleeves and gathers around a white board. Meetings are a waste of time; working sessions are the opposite. Working sessions are collaborative, inspirational and motivational. Working sessions are where all the little monsters that lurk in the shadows of the requirements document are coaxed into the light and grappled into submission.
- I build everything with an eye on how it will be supported. I don’t want to build anything that can’t be supported by any other mid to senior level business intelligence pro. It makes me angry when I find solutions that others have left behind that have to be rebuilt because the only person that can support it is developer / architect that created it. The mark of a great project is when the designer that built it put enough thought, time and effort into it so that anyone that looks at it later would say ‘oh, I see … of course. simple! I see what he did here. I can handle this.’
This is the most common question I get. At the end of the day, if the value received doesn’t outweigh the cost of a project then that project shouldn’t be started. In general I charge $150/hour plus travel and expenses. I like to work in 3 phases.
- Phase 1 (Usually 40 hours) In this phase I get familiar with the data, the business and the project goals. Whenever possible I try to deliver a proof of concept dashboard or a plan for a dashboard, database or data transfer process.
- Phase 2: We take what we learned in phase 1 and re-evaluate the original request to refine it based on actual conditions found in the data environment and come up with an estimate to achieve the desired goal.
- Phase 3: I transition support and ongoing maintenance to people within your organization or we establish an ongoing support and maintenance agreement and I block time going forward to make sure you are well taken care of.
I don’t have a good answer for this one yet. As long as it takes? Longer than you think but less time than you fear? Honestly, every project is different. I can say that I have a lot of tools in my toolbox that help me work faster than the average data architect. The simple fact is that the clients I’m drawn to usually don’t have a well established data environment. It will take time to build it and build it right. The good news is, once it’s built the cost to produce new analytics drops substantially. It’s much easier and significantly more cost effective to build analytics on a strong platform of well maintained data.
Prepare Your Data For Tableau
I wrote this book for the business professional that wants to do more with data. In these pages I show you step by step how I see data, what problems to look for and how to correct them. I walk you through the same steps I use in every project to make sure my data foundation is strong BEFORE I build anything in Tableau.
Data Professionals at Work
I am SO PROUD to have been featured in this book! In these pages you will find in depth interviews with the leaders in the data community (and me!). I love the perspective each brings to their work. Each is a master of their trade and I look up to every one of them.