Google Sheets was not originally created as a data visualization tool, but it has been flexible enough that many people use it for dashboarding. But with recent and ongoing improvements to Data Studio, including unlimited free reports, Data Studio has become a real contender against Google Sheets.
Which tool should your organization use for dashboarding? Each has its own pros and cons. Deciding on which tool to use depends on your role within your organization and your business needs. Are you a marketing executive looking for an intuitive tool to display high-level metrics? Or are you an analyst that will need to incorporate advanced calculated metrics in a dashboard?
The following checklist of benefits can help you make a decision. Continue reading >
This post is an introduction to the topic of “Create Your Own Custom Social Engagement Rate – A How To” which we will jointly discuss in our webinar with Sweetspot Intelligence on June 15, 2017 at 1pm EST. Sign up HERE if you would like to learn more.
Lynette Chen is a senior analytics consultant with a passion for telling interesting stories with data and visualizations. She has experience creating web and social data analyses as well as reporting dashboards for clients across various industry verticals. Continue reading >
The power of data comes from the analysis itself. However, the power of the analysis depends on how that data is presented. An analyst can pour hundreds of hours into the depths of Excel madness, but ultimately all that matters are the insights that are delivered to the business leaders. Good data visualizations have the ability to convey key insights more effectively, while bad visualizations have the ability to derail a presentation. Or worse – inaction on critical learnings.
Excel will forever be king. It’s accessibility and ease of use for performing all types of calculations makes Excel the most widely utilized tool for analysis in most companies. Despite the rise of other software programs such as Tableau for specific needs, it does not appear that Excel is going anywhere. Many clients still require that deliverables are sent in Excel format. One particular client MaassMedia worked with was using Tableau to manipulate SQL data with calculated fields and then copying and pasting monthly updated data back into a formatted Excel dashboard for distribution reasons. In other words, Tableau was being used as a medium to transform and prepare the data for the Excel dashboard. While Tableau does have basic export Excel functions, its limitations caused us to find a better solution–Microsoft Power BI.