Hands-On-Lab: Web and Social Analytics Dashboard in Power BI

Online marketing is perhaps the most important channel for the modern marketer. This marketing dashboard examines the correlation between website performance and social performance. This is an important activity, as too often social marketers focus on their success on a particular platform instead of seeing their performance within larger context. In the first exercise, we will look into importing data into Power BI. In the second exercise, we’ll visualize popular hashtags. In the third exercise, we’ll visualize Unique visits per Device. In the fourth exercise, we will look into Twitter sentiment Analysis.

Exercise 1: Import Data in to Power BI
Exercise 2: Visualize Popular Hashtags
Exercise 3: Unique Visits Per Device
Exercise 4: Twitter Sentiment Analysis.

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.

Get weekly learning resources from SQLMaestros, right in your inbox. Subscribe to our Bulletins.