Often times reporting in Excel—especially when you are creating charts—is a non-flexible task. Each time you run the report with any kind of change in data requires a change in formulas. This process greatly limits automation. Solving the problem requires a bit of initial setup, but allows for a lot more flexibility down the road.
Category Archives: Beyond Analytics
Pro writing tip: your customer doesn’t care about your knowledge or credentials. They care most about themselves. Communicating about specialized marketing tools and services (like analytics) requires skill. You have to say it well or you’ll miss your target. But don’t worry, an ill-mannered old man with a penchant for insults can help with that.
Who would have ever thought the star actor in 80s movie comedies Teen Wolf and Back to the Future would become a champion for medical innovation? Thirty years later and Michael J Fox is head of an organization at the forefront of parkinson’s research. But just how is the Michael J Fox foundation benefitting Parkinson’s
A Geeky data analyst and a sports fan walk into a bar. Discussion ensues. The big question on the table: will analytics be the key to harnessing a team’s peak performance, or is it just jumbles of numbers? Well, it depends on who’s talking. Sports Analytics Conferences and the Movies [Read]: Sports Analytics are Here to Stay
Data with a Soul: 3 Surprising Things I Learned about Analytics from a Best Selling Empathy Researcher
I was reading Brene Brown’s book Daring Greatly recently and was struck by this quote: “Connection is what we are made for.” I’ve found that Brene Brown gets right to the heart of our purpose as humans. I love meaningful conversations with loved ones and friends. Sharing honest, personal, poignant and vulnerable stories about our struggles
When I was in college I joined an online dating site. This is a story about that experience, and how it helped me better understand data analytics. If someone asked me if I based my judgments on first impressions or on physical appearance I would say no, of course not. I believe character trumps beauty.
What if your life could be way more comfortable, and you didn’t have to do… anything? Imagine a world where machines took care of life’s mundane tasks. They’d hear, smell and see the world for themselves, and collect information so you didn’t have to. In your own personal life, you could save money and be
Analytics Weekly Roundup: Strong Innovators Love Data, Trending Halloween Candy, and a Philosophical Espresso Shot on the Internet of Things
Here at Analytics Pros, we’re constantly scouring the interwebs for all things analytics. In case you missed it, here’s a collection of helpful articles that caught our attention. The 50 Most Innovative Companies of 2014: Strong Innovators are Three Times More Likely To Rely On Big Data Analytics “Companies who are strong at innovation are
As Analytics Pros’ main mobile guy, I had the privilege of attending this year’s Google I/O Conference 2014. Google released many exciting new features for Android, so here’s what you need to know about Google Android’s latest features, and how you can use them to better understand your customers. Moving Forward with Apps In 2014,
Dear AP, Three years ago I began what I thought would be a long-term relationship with my partner, Classic Analytics. We met on a Google search page, and from that first implementation, it was love at first sight (or should I say, site). Working through cross-domains and self-referrals, Classic stood by my side, and I