Last Blog I demonstrated the data pipeline we can use CrUX to analyze the site performance. This is from a BI developer perspective.
However, for a company, especially the leadership team, what they want is the final dashboard that generated from BI department, so management plan can be gained.
So this blog I will show you what kind of dashboard we can generate after the steps of data collection from Google public dataset and ETL.
What data visualization tool we need to use?
There are bunches of data visualization tools we can use, e.g., Data Studio, Power BI etc. This time I take Tableau for an example.
And there are 4 sheets on a dashboard, i.e., Slow FCP Percentage, Fast FCP Percentage, Fast FID Percentage and Slow FID Percentage.
What they actually mean?
- Slow FCP Percentage(the percentage of users that experienced a first contentful paint time of 1 second or less)
- Fast FCP Percentage(the percentage of users that experienced a first contentful paint time of 2.5 seconds or more)
- Fast FID Percentage(the percentage of users that experienced a first input delay time of 50 ms or less)
- Slow FID Percentage(the percentage of users that experienced a first input delay time of 250 ms or more)
After this graph, we can roughly see that flightcentre has a higher site speed than rentalcars in user experience.
What we can do in the next step?
After that, we can inform devs and communicate impact according to show exactly the area that the site is falling down. We can point to the fact that it’s from real users and how people actually experiencing the site.
The second part is the data strategy lifecycle in a company.
What is the data strategy lifecycle in a company?
Develop the strategy->Create the roadmap->Change management plan->Analytics lifestyle->Measurement plan
- Scope and Purpose: What data will we manage? How much does our data worth? How do we measure success?
- Data collection: Archiving, what data where and when, single source of truth(data lake), integrating data silos
- Architecture: Real time vs Batch, data sharing, data management and security, data modelling, visualization
- Insights and analysis: Data Exploration, self-service, collaboration, managing results
- Data governance: Identify data owners, strategic leadership. data stewardship. data lineage, quality, and cost
- Access and security: RBAC, encryption, PII, access processes, audits, regulatory
- Retention and SLAs: Data tiers and retention, SLA’s to the business
This post explored the CrUX dashboard BI team can generate and the data strategy in a company. In the future, I will write more.
If you are interested in or have any problems with CrUX or Business Intelligence, feel free to contact me.
Or you can connect with me through my LinkedIn.
Originally published at http://jacquiwu.com on May 20, 2020.