About this course
Sally’s boss has asked her to build a website analytics report.
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.
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.
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.
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.
Learn whether your twits are having the impact.
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.
The more obvious it is for users to navigate a report the more likely all your dashboard data will be read.
Slicers provides report users with a mechanism to select data of interest for example dates, months, years or data categories.
Adding branding graphics to a dashboard enables authors to design unique reports.
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.
Sally’s boss thinks unhappy customers are not acknowledged. She’s confused and slightly worried…
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.
Sally's boss wants to evaluate whether the new customer service improvement program is reducing negative customer experiences over time.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.