by ·0 Comments

Learning to use data visualization programs


Gartner Magic Quadrant for data visualization programs

          Imagine spending countless hours analyzing your data and finding a meaningful insight that can help shape direction of your business – the only missing piece is convincing functional stakeholders that your analysis is in fact valuable. In this article we will discuss learning resources offered by leading tools that help us communicate our data findings. In fact, no analysis no matter how thorough and complex it might be could yield any real value if the compelling recommendation is not provided to help company leadership take further action. This is exactly where data visualization comes into play: this software allows us to connect to disparate data sources, wrangle our data, perform ad-hoc analyses, distill a powerful data story and even build dashboards to enable further analysis by other folks in our organizations.

          According to Gartner’s Magic Quadrant for Analytics and Business Intelligence Platforms (1) the list of leaders in the data visualization fields include Microsoft Power BI, Tableau and Qlik . In an apparent effort to grow their user base and democratize data analytics, all of these providers offer fully functional versions of their programs free of charge or in case of Microsoft with an affordable subscription plan. Even better, these vendors formalized their knowledge base via various free online learning options.
Continue reading

by ·0 Comments

Getting started with Microsoft Power BI using Google Merchandise store data.


Getting started with Microsoft Power BI using Google Merchandise store data

          While I’m as loyal to Excel as the next analyst, when it comes to data visualization and interactive dashboards, Tableau is my tool of choice. If I need to analyze large data sets, I prefer to get cozy with the data by writing SQL queries in whichever database environment such data might be stored. In the meantime, the world does not stand still, and Microsoft has been making substantial progress with a product offering they called Power BI . In fact, this tool offers data preparation, data discovery, dashboarding and custom visualization features starting with a free version for up to 1 GB of stored files and a modest $10 monthly plan for the beefed up PRO version. It’s definitely long overdue, but I finally got around to playing with both: Power BI desktop and cloud-based versions, all while using publicly available data from nonetheless, but Google’s merchandise store. , available through their demo Google Analytics account. Which other etailer can boast growing their Cyber Monday sales by 274% to $54K, while keeping their marketing advertising budget under $ 100?

Continue reading