MS Power BI
Text

The Ultimate Guide to building a social media dashboard without coding.

12 Lessons Easy

About this course

Sally’s boss has asked her to build a website analytics report.

Website report criteria

He wants to see which social media channel has the most customer interactions, the value and total number of session per day, how many of them are current and new customers. He wants interactions to be broken down by affiliates, paid search, social, organic, direct sessions and which browser application do their customers use the most.

Sally builds the report using MS Power BI default visuals see the below image.

How to collect the data

  • Power Bi has a connector for Google Analytics, once logged in the trick is understanding which fields to use.
  • For this report: day by session, hour by session, date and source by users, date and browser by users

Conclusion

As you have seen there is real potential to produce reports to fit your specific requirements .

You really don’t need to always pay for data or use a paid application to able to produce reports you require.  

Thank you for viewing.

Course Structure

ONLY FOR LOGGED-IN USERS

Secret Hacks to Build A Social Media Dashboard in 60 Minutes.

You may be afraid setting up a personalised dashboard to monitor your social media activities could be frustrating and to technical a faraway dream, but it is closer than you think. Let me show you how.

ONLY FOR LOGGED-IN USERS

See How Easily You Can Build This Social Media Dashboard

Dispel your cynicism.

You may be thinking why build your own dashboard? After all, you can easily use a paid application.

Some are expensive and complicated to understand. Managing and monitoring may take more time than you are willing to give. Lastly, they may not offer you the flexibility you require.

ONLY FOR LOGGED-IN USERS

Lazy Person’s Way to Build a Twitter Analytics Feed.

Learn whether your twits are having the impact.

ONLY FOR LOGGED-IN USERS

Secret Hacks to Build A Social Media Trip Advisory feed.

Assuming you do not have a business listed on Trip Advisors website then gathering data is a little more challenging. Web scraping (capture website data) is an option.

ONLY FOR LOGGED-IN USERS

Using buttons to switch report tabs

 

The more obvious it is for users to navigate a report the more likely all your dashboard data will be read.

 

ONLY FOR LOGGED-IN USERS

Creating Slicers

Slicers provides report users with a mechanism to select data of interest for example dates, months, years or data categories. 

ONLY FOR LOGGED-IN USERS

Social Media Analytics graphic.

Adding branding graphics to a dashboard enables authors to design unique reports.

ONLY FOR LOGGED-IN USERS

What Everybody Ought to Know About Building a Twitter Dashboard

Insights from Twitter can be helpful when you want to identify trends and or build an audience for example what day of the week or hour do you get the best engagement.

ONLY FOR LOGGED-IN USERS

Discover whether twits are negative, neutral or positive.

Sally’s boss thinks unhappy customers are not acknowledged.  She’s confused and slightly worried…

ONLY FOR LOGGED-IN USERS

How to build Facebook report without coding.

Sally’s boss was impressed and pleased with Sally’s Twitter report. However, he remains agitated. So, he asks Sally to develop a Facebook report.

ONLY FOR LOGGED-IN USERS

Secret Tricks To Extract Meaningful Facebook Data

Sally's boss wants to evaluate whether the new customer service improvement program is reducing negative customer experiences over time.

ONLY FOR LOGGED-IN USERS

See How Easily You Can Build A Website Report

Required Insights

  • Identify which browsers applications do website visitors use?
  • Categorise how visitors find the website.
  • Comprehend the day and time of visitor sessions
Powered by Thrive Apprentice
Pen
>