Case Study - Dashboard - Microsoft KPIs

From Displayr

This case study formed the 3rd part of the webinar DIY Market Research Dashboards - Building 4 in 40 minutes (webinar), originally presented on the 5th of December, 2017.

Overview

This case study illustrates methods for bringing in data using APIs, in particular Yahoo Finance and Google Trends, and using this to create time series charts. In this case study you will learn:

How to add stock price and Google Trends data.
How to link the data to interactive time series charts.
How to use boxes, shapes, and text to format the appearance of a page.

You can view the final dashboard here.

You can edit a copy of the final dashboard here.

Video

This case study links to the content of the third chapter in the webinar (recording here):

How to create the dashboard

All of the steps required to create this dashboard are described in this article from our blog.

Files

The only file used in the creation of this dashboard is the Microsoft Logo: .

Retrieved from ‘https://docs2.displayr.com/index.php?title=Case_Study_-_Dashboard_-_Microsoft_KPIs&oldid=6715’

Category:

Case Studies

Debug data:

[objectcache] MainWANObjectCache using store EmptyBagOStuff
Start request GET /wiki/Case_Study_-_Dashboard_-_Microsoft_KPIs IP: 10.244.2.99 HTTP HEADERS: HOST: docs2.displayr.com X-REQUEST-ID: 7ebee88dbfe28abac991533d87feb576 X-REAL-IP: 10.224.0.4 X-FORWARDED-HOST: docs2.displayr.com X-FORWARDED-PORT: 443 X-FORWARDED-PROTO: https X-FORWARDED-SCHEME: https X-SCHEME: https X-ORIGINAL-FORWARDED-FOR: 2a03:2880:f800:6:: VIA: HTTP/2.0 Azure X-AZURE-FDID: bebb35a5-cb5c-473d-9203-d4bc8eeb39b4 ACCEPT: */* USER-AGENT: meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler) X-AZURE-REF: 20250117T213212Z-1698bcdb8c7j9l52hC1BL1cpdn00000009p000000000b96v X-AZURE-CLIENTIP: 2a03:2880:f800:6:: X-AZURE-SOCKETIP: 2a03:2880:f800:6:: X-AZURE-REQUESTCHAINV2: hops=1 X-FORWARDED-FOR: 10.244.1.17 ACCEPT-ENCODING: gzip X-VARNISH: 3871107 (end headers)
[localisation] LocalisationCache using store LCStoreCDB
[session] SessionManager using store SqlBagOStuff
[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::open [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SET group_concat_max_len = 262144, sql_mode = ''
[DBReplication] Wikimedia\Rdbms\LBFactory::getChronologyProtector: request info { "IPAddress": "10.244.2.99", "UserAgent": "meta-externalagent\/1.1 (+https:\/\/developers.facebook.com\/docs\/sharing\/webmasters\/crawler)", "ChronologyProtection": false, "ChronologyPositionIndex": 0, "ChronologyClientId": false }
[DBReplication] Wikimedia\Rdbms\ChronologyProtector::getStartupMasterPositions: client ID is 4ac190de133d573137d8d0a631d0d3bc (read)
[DBReplication] Wikimedia\Rdbms\ChronologyProtector::getStartupMasterPositions: key is global:Wikimedia\Rdbms\ChronologyProtector:4ac190de133d573137d8d0a631d0d3bc:v2 (read)
[DBConnection] Wikimedia\Rdbms\LoadBalancer::lazyLoadReplicationPositions: executed chronology callback.
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: opened new connection for 0
[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::serverIsReadOnly [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT @@GLOBAL.read_only AS Value
[DBQuery] SqlBagOStuff::fetchBlobMulti [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT keyname,value,exptime FROM `dwobjectcache` WHERE keyname = 'displayrwiki-dw:MWSession:59i05msfsb396a5kmurn5dl5g8pgifsc'
[session] SessionBackend "59i05msfsb396a5kmurn5dl5g8pgifsc" is unsaved, marking dirty in constructor
[session] SessionBackend "59i05msfsb396a5kmurn5dl5g8pgifsc" save: dataDirty=1 metaDirty=1 forcePersist=0
[cookie] already deleted setcookie: "displayrwiki_dw_session", "", "1705613532", "/", "", "1", "1", ""
[cookie] already deleted setcookie: "displayrwiki_dwUserID", "", "1705613532", "/", "", "1", "1", ""
[cookie] already deleted setcookie: "displayrwiki_dwToken", "", "1705613532", "/", "", "1", "1", ""
[cookie] already deleted setcookie: "forceHTTPS", "", "1705613532", "/", "", "", "1", ""
[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::open [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SET group_concat_max_len = 262144, sql_mode = ''
[DBConnection] Wikimedia\Rdbms\LoadBalancer::getLocalConnection: opened new connection for 0
[DBQuery] Wikimedia\Rdbms\Database::beginIfImplied (LinkCache::fetchPageRow) [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: BEGIN
[DBQuery] LinkCache::fetchPageRow [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model FROM `dwpage` WHERE page_namespace = 0 AND page_title = 'Case_Study_-_Dashboard_-_Microsoft_KPIs' LIMIT 1
[ContentHandler] Registered handler for wikitext: WikitextContentHandler
[DBQuery] WikiPage::pageData [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM `dwpage` WHERE page_namespace = 0 AND page_title = 'Case_Study_-_Dashboard_-_Microsoft_KPIs' LIMIT 1
[DBQuery] Title::loadRestrictions [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT pr_type,pr_expiry,pr_level,pr_cascade FROM `dwpage_restrictions` WHERE pr_page = 692
[objectcache] fetchOrRegenerate(displayrwiki-dw:page-restrictions:v1:692:6715): miss, new value computed
Title::getRestrictionTypes: applicable restrictions to [[Case Study - Dashboard - Microsoft KPIs]] are {edit,move}
[DBQuery] MediaWiki\Revision\RevisionStore::fetchRevisionRowFromConds [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,temp_rev_user.revactor_actor AS `rev_actor`,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `dwrevision` JOIN `dwrevision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `dwcomment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `dwrevision_actor_temp` `temp_rev_user` ON ((temp_rev_user.revactor_rev = rev_id)) JOIN `dwactor` `actor_rev_user` ON ((actor_rev_user.actor_id = temp_rev_user.revactor_actor)) JOIN `dwpage` ON ((page_id = rev_page)) LEFT JOIN `dwuser` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE rev_id = 6715 LIMIT 1
[objectcache] fetchOrRegenerate(global:revision-row-1.29:displayrwiki-dw:692:6715): miss, new value computed
[DBQuery] MediaWiki\Revision\RevisionStore::loadSlotRecords [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT slot_revision_id,slot_content_id,slot_origin,slot_role_id,content_size,content_sha1,content_address,content_model FROM `dwslots` JOIN `dwcontent` ON ((slot_content_id = content_id)) WHERE slot_revision_id = '6715'
[DBQuery] MediaWiki\Storage\NameTableStore::loadTable [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT role_id AS `id`,role_name AS `name` FROM `dwslot_roles` ORDER BY id
[objectcache] fetchOrRegenerate(global:NameTableSqlStore:slot_roles:displayrwiki-dw): miss, new value computed
[DBQuery] MediaWiki\Storage\NameTableStore::loadTable [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT model_id AS `id`,model_name AS `name` FROM `dwcontent_models` ORDER BY id
[objectcache] fetchOrRegenerate(global:NameTableSqlStore:content_models:displayrwiki-dw): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:page-content-model:6715): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:page-content-model:6715): miss, new value computed
[deprecated] Setting $wgAllowImageTag to true is deprecated since MediaWiki 1.35
[MessageCache] MessageCache using store SqlBagOStuff
[DBQuery] SqlBagOStuff::fetchBlobMulti [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT keyname,value,exptime FROM `dwobjectcache` WHERE keyname = 'displayrwiki-dw:messages:en-gb'
[DBQuery] SqlBagOStuff::fetchBlobMulti [0.003s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT keyname,value,exptime FROM `dwobjectcache` WHERE keyname = 'displayrwiki-dw:messages:en-gb:status'
[DBQuery] SqlBagOStuff::lock [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT GET_LOCK('displayrwiki-dw:messages:en-gb', 0) AS lockstatus
[SQLBagOStuff] SqlBagOStuff::lock failed due to timeout for displayrwiki-dw:messages:en-gb.
[DBQuery] MessageCache::loadFromDB(en-gb)-big [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_title,page_latest FROM `dwpage` WHERE page_is_redirect = 0 AND page_namespace = 8 AND (page_title NOT LIKE '%/%' ESCAPE '`' ) AND (page_len > 10000)
[DBQuery] MessageCache::loadFromDB(en-gb)-small [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT /*! STRAIGHT_JOIN */ rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,temp_rev_user.revactor_actor AS `rev_actor`,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `dwpage` JOIN `dwrevision` ON ((page_id = rev_page)) JOIN `dwrevision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `dwcomment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `dwrevision_actor_temp` `temp_rev_user` ON ((temp_rev_user.revactor_rev = rev_id)) JOIN `dwactor` `actor_rev_user` ON ((actor_rev_user.actor_id = temp_rev_user.revactor_actor)) LEFT JOIN `dwuser` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE page_is_redirect = 0 AND page_namespace = 8 AND (page_title NOT LIKE '%/%' ESCAPE '`' ) AND (page_len <= 10000) AND (page_latest = rev_id)
[DBQuery] MediaWiki\Revision\RevisionStore::loadSlotRecords [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT slot_revision_id,slot_content_id,slot_origin,slot_role_id,content_size,content_sha1,content_address,content_model FROM `dwslots` JOIN `dwcontent` ON ((slot_content_id = content_id)) WHERE slot_revision_id = '8175'
[DBQuery] MediaWiki\Storage\SqlBlobStore::fetchBlobs [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT old_id,old_text,old_flags FROM `dwtext` WHERE old_id = 8060
[objectcache] fetchOrRegenerate(global:SqlBlobStore-blob:displayrwiki-dw:tt%3A8060): miss, new value computed
[ContentHandler] Registered handler for javascript: JavaScriptContentHandler
[DBQuery] MediaWiki\Revision\RevisionStore::loadSlotRecords [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT slot_revision_id,slot_content_id,slot_origin,slot_role_id,content_size,content_sha1,content_address,content_model FROM `dwslots` JOIN `dwcontent` ON ((slot_content_id = content_id)) WHERE slot_revision_id = '6266'
[DBQuery] MediaWiki\Storage\SqlBlobStore::fetchBlobs [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT old_id,old_text,old_flags FROM `dwtext` WHERE old_id = 6236
[objectcache] fetchOrRegenerate(global:SqlBlobStore-blob:displayrwiki-dw:tt%3A6236): miss, new value computed
[DBQuery] MediaWiki\Revision\RevisionStore::loadSlotRecords [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT slot_revision_id,slot_content_id,slot_origin,slot_role_id,content_size,content_sha1,content_address,content_model FROM `dwslots` JOIN `dwcontent` ON ((slot_content_id = content_id)) WHERE slot_revision_id = '5328'
[DBQuery] MediaWiki\Storage\SqlBlobStore::fetchBlobs [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT old_id,old_text,old_flags FROM `dwtext` WHERE old_id = 5325
[objectcache] fetchOrRegenerate(global:SqlBlobStore-blob:displayrwiki-dw:tt%3A5325): miss, new value computed
[DBQuery] MediaWiki\Revision\RevisionStore::loadSlotRecords [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT slot_revision_id,slot_content_id,slot_origin,slot_role_id,content_size,content_sha1,content_address,content_model FROM `dwslots` JOIN `dwcontent` ON ((slot_content_id = content_id)) WHERE slot_revision_id = '3693'
[DBQuery] MediaWiki\Storage\SqlBlobStore::fetchBlobs [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT old_id,old_text,old_flags FROM `dwtext` WHERE old_id = 3690
[objectcache] fetchOrRegenerate(global:SqlBlobStore-blob:displayrwiki-dw:tt%3A3690): miss, new value computed
[DBQuery] SqlBagOStuff::updateTable [0.005s] wikideveus101mysql-server.mysql.database.azure.com:3306: REPLACE INTO `dwobjectcache` (keyname,value,exptime) VALUES ('displayrwiki-dw:messages:en-gb','�W]r�6�~�)P:�R�EYRc;R��;n�ZJ�>e`��QS��R4��I�-�c�i:S�5\"��ŷ��|x2�h��á7V˥��od �]]��i��[��=��ggن��W|\Zi�[��-�Z�)��,U<�1�+�8$��0�1��z�r�(UB��m��]6Nx��M�Uy\'�s��bs��,�+��Vf��:��,QKQ��՚��B�z�x{�G�x�\\w�нz�[��/�b��0/�67�n��y�K��|��H-�S�{�7�V�T��\'yY)z�;�Y�3N�ˌ�2�eE��¢MC�.��A��y��3��qʍ <��\\�Ϙ/��ː!�m��}�!�E��Tp��.�CG:�q�� \"��~εej�\"n�BU�5�\0��$��v3J�߰�`J/x&\r�\n]�N\Z\n\"�+��7n�%��yq��q*f��6a<c\nTZI��LY�{a,!/�� b#�9��F��(�֊k6��2lv��~��\0B�Y�-�S�-��)��Ç�Y��ˎ.��8�u��ڞ��*��_9-�iG2�Mqc��Ã-��x˴��>_��Ɂ��>Ig�}��]뮦��n�ҩ�\n��n�P�Z�R��=�L��m�`� K�-X��w=yyq=��\\p8�,X\'2JX��*2k�4Ja��Vx2��J�ڸ��YP�!��t��0�\0��0��K�e��U�/r��:�� \r��jw�s�\n91�D)YӰ��i�q��]��:\'��,V�0U��:JBHŇ�y��&��KVt\Z>>��;��S��L��9�n�J��M�hS��\Z��E#�N��-�#�r务̸HSx�%0@��5ygpx�oD�C�$��Y��\rp� f��,��U��֍��C��U�A��5ѿ�<��бef,��ēk� c~Pz��\Zdʝ�+��s^��J��G��Np�Igq5��p\\(��u<�p��(p��7$6VQ��j��v�\nz|��\"��>��i!F�F��x\0G�<Y�׻��ޘ��/��Ǿ-#h��O��w��AǗJ;�-\\��1��g-8�8�\Z�\" �]�_��dhkKi[_��/�I�wsuB�\\V3�`�J.Q�.��s��T�J��\rB�p/�.j�6�ptJ�LIL�YY�I8Vi�s��n65.uY썱�@1]�f��3��,M��n.�\\$)��^�r�wR�ap#pD��@��9�z��W{ �&��(=d�r�z��W9�i�g��9u��:��Q*�ۦ<��AO��Ê��r��H��I,Jd\Z�ˠF��\r8x�<�U��:p��ǯI��%�.)*��p��lJY)!�\Z�;��z�a![_��L��5��|�)��~��.S�#�F�Y`�?��\\_O^�~��]��5w��ܯD��^�Mb� t\r�qN6��s��6CB\\ݧe�v*\'��~s�Ɛ��g��|z��~��x��v�nNk�� k��S��ӎ��L�\Z0�\\i4z��\0��H._\\��Wo�^M��q~�\\O/�^{#9�C��M�iq\0P�\'��\'GG��G��b0��O�K��{��o��8��z\'�ޠ��{��\0','20380119031407')
[DBQuery] SqlBagOStuff::unlock [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT RELEASE_LOCK('displayrwiki-dw:messages:en-gb') as lockstatus
[MessageCache] MessageCache::load: Loading en-gb... local cache is empty, global cache is expired/volatile, loading from database
ParserFactory: using default preprocessor
Unstubbing $wgLang on call of $wgLang::unstub from ParserOptions->__construct
[caches] parser: SqlBagOStuff
[objectcache] fetchOrRegenerate(displayrwiki-dw:page-content-model:6715): miss, new value computed
Article::view using parser cache: yes
[DBQuery] SqlBagOStuff::fetchBlobMulti [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT keyname,value,exptime FROM `dwobjectcache` WHERE keyname = 'displayrwiki-dw:pcache:idoptions:692'
[objectcache] fetchOrRegenerate(displayrwiki-dw:page-content-model:6715): miss, new value computed
[DBQuery] MediaWiki\Storage\SqlBlobStore::fetchBlobs [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT old_id,old_text,old_flags FROM `dwtext` WHERE old_id = 6660
[objectcache] fetchOrRegenerate(global:SqlBlobStore-blob:displayrwiki-dw:tt%3A6660): miss, new value computed
Article::view: doing uncached parse
[DBQuery] SqlBagOStuff::fetchBlobMulti [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT keyname,value,exptime FROM `dwobjectcache` WHERE keyname = 'displayrwiki-dw:pcache:idoptions:692'
[Preprocessor] Cached preprocessor output (key: displayrwiki-dw:preprocess-hash:99d387c549874b2c6ca6d8ae1521b529:0)
[DBQuery] LocalFile::loadFromDB [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT img_name,img_size,img_width,img_height,img_metadata,img_bits,img_media_type,img_major_mime,img_minor_mime,img_timestamp,img_sha1,comment_img_description.comment_text AS `img_description_text`,comment_img_description.comment_data AS `img_description_data`,comment_img_description.comment_id AS `img_description_cid`,actor_img_user.actor_user AS `img_user`,actor_img_user.actor_name AS `img_user_text`,img_actor,img_metadata FROM `dwimage` JOIN `dwcomment` `comment_img_description` ON ((comment_img_description.comment_id = img_description_id)) JOIN `dwactor` `actor_img_user` ON ((actor_img_user.actor_id = img_actor)) WHERE img_name = 'Microsoft-logo.png' LIMIT 1
[objectcache] fetchOrRegenerate(global:displayrwiki-dw:file:e4fd14747a08c2c748460f2beb9a41f1a645274c): miss, new value computed
TransformationalImageHandler::doTransform: creating 219x82 thumbnail at mwstore://local-backend/local-thumb/3/33/Microsoft-logo.png/219px-Microsoft-logo.png using scaler client
TransformationalImageHandler::doTransform: returning unscaled image
TransformationalImageHandler::doTransform: creating 219x82 thumbnail at mwstore://local-backend/local-thumb/3/33/Microsoft-logo.png/219px-Microsoft-logo.png using scaler client
TransformationalImageHandler::doTransform: returning unscaled image
TransformationalImageHandler::doTransform: creating 219x82 thumbnail at mwstore://local-backend/local-thumb/3/33/Microsoft-logo.png/219px-Microsoft-logo.png using scaler client
TransformationalImageHandler::doTransform: returning unscaled image
[Preprocessor] Cached preprocessor output (key: displayrwiki-dw:preprocess-hash:99d387c549874b2c6ca6d8ae1521b529:0)
[DBQuery] LinkHolderArray::replaceInternal [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_namespace,page_title FROM `dwpage` WHERE (page_namespace = 0 AND page_title = 'DIY_Market_Research_Dashboards_-_Building_4_in_40_minutes_(webinar)')
Saved in parser cache with key displayrwiki-dw:pcache:idhash:692-0!canonical and timestamp 20250117213212 and revision id 6715
[DBQuery] SqlBagOStuff::updateTable [0.005s] wikideveus101mysql-server.mysql.database.azure.com:3306: REPLACE INTO `dwobjectcache` (keyname,value,exptime) VALUES ('displayrwiki-dw:pcache:idhash:692-0!canonical','��<�O:8:\"stdClass\":2:{s:14:\"__svc_schema__\";s:11:\"DAAIDgoKAQw\";s:8:\"__data__\";s:3182:\"�Z�n�F��z�-��Z ��O��!��ڽ�6b�Eq8�+r%mMqY�Ҳ��p�p�xOr3�K��h�i�?\n�@b�;;;��2��й��d�e��B9aw��&�^�,oؽr�e�\r��9��7�.ID%#R��D�d1Q�F�<&��3�bS�Ҝ�Q��-�<yK�[�&�d4��S*�SA�XNړ�\n��<�O��N��d��B19��r��!��;��^��E6�H��H��t]by�\r��309��\"r>��$Y�,�N��ˈT��h�S��/��z��Q\'��P�h|��;��c��%TJ�9��mJ��*.R�М�vB�,IX<]�;�U�H��FQTg|�S�%Q��vF��N�}�iZ(�\\�aJ�� m��]�j��c.��T��!�#ym�z�! M��K��琘��N�r�l��w%>�`�Tɣ��Ɍ�{��K`��[�o��&��G�M\0��E��%��-aw,i{�>J��l/��;��q�r�L��3��dO�L�qɠ��p� r�u9~�1��?.��u ��j��$��Ul�a>�˼yX��q��\'�G�O�:��O��[��5�\0zX��r��tt��X��Dn�-��s �1�� h\0�,�ʪ\0�:��;AĽֈ�ހ�|~ˣ\\H1S��W��l;v�:�m� ;��j@s�$�T9Ep[2��Od�C�\"��TQRH|z G��w��<*�@��B��\Zp0��iL��,��_��\nO��/A��s8<Z\0Gy@�SCU�q-\n��AI�P��B�\r�\re��8�j��&1��U��?�6�@Ix��r\nV�k�o�A�b��0�S.hƬ��B��%U��e �6��T��1��M#��ظq:�[gx�l��/؜%p?��H��\0�Ne9��y�P*�a��X��\"��Ta�w�P��l��`��=dݨ��6�X��3^��a2��l[d�8-2%��eU𙄿�ם*��]�\r;�=!--�n��3%�_�}j6b4��A�E�v,��Y��A�f`%L�z��M�\"��-�mX��HF9��y��Ju��Rq�M��J܁��S��x��H�fPy�u\n��B5ܞ��͔�^�j�y��_�E��D�E��2وF2� \0�c��|x�r�5v�\0|O)O��^��St~{�\0X�.��/T�Av� ��?!�\'E\08\\�X- �fPN��+��yjx=za>��{�P�>r�C��P�ƟT,��<��Ɗ�Zz��83t,��j��w��vuZ��m�X?�Œ��D�? �l��u�?��ۇq\0�� m��k/l�\Z�R�\0�ݜ�F��Bp�ۃ�\0aE��눃�j��9s�=�rNh��&Z��M*;A\'�:MT1@�\"ѱ��!:�\0��8Y\'ܱ3�u�Q�З�6i]��+��L�uB��]�B��\\��^�{�Y#�>��:$�~�u[��.yT�gHf4��u\"�Y�#mL��ur��B��&�\\h�c��;ˣj�\n��EĤ�b��p��<��v<W��T��AL��x\Z%��I�o��d��\Z�u�@L�*�ϋ%�3��IE4S��zu�1x�%L��|2+R��V:��k�O��X:*�:�<�ZͶ�7��3�Y��m��\r�8�T��6�iS\Z��o�~��/\"��e��&��\\�<�=��>�D�5�3 b��t��84ܷlMJ��oǫ0��!��:a��/�b�)DCb�5�M*��v�K/��\Z��-��\r��C\Z��o�`̓��k.��p��^�A&� zA��9,�1F��\\��`�]Ng�Q�d ��>\nZ\n�r��-��B�9�4(T��>��\"��8Mv��n�k��ޟǵ��E��Ǝð ��y�iS��1�Zks��n\Z��~Ő(}�� z8�:P��8�W>�fr>�z��,��:��ѽ\Z�݁k-��^y�3�<o\0K�X�k#��G�6V��A��pe�a��ӯ))\0��N!��3��0V.��\0�,_o�=��У��V�E��VA��\Z+�ݥ��Hg|�#�w��LGτ�+�� PH��Vv�[&��`帢42�l��)�J�$�zG500 l��5r`�Ә��߁�X��y\\\r(4ެ!��p��U\0LJ�@�\"��w-�o·�u!�=�>�:�[MX6\rX��~��g�q0��>��#�w��A��-\\v��[��lZ��r��6(��<�w�=�7�}(��*��΂�`��7Z�>0��S��m�_��ض��~Cw�̀��~��*�ӄ]^�?/K��w�_`%��4��r��_F�G��^��t�\nX��Qo�#~��\'<�+��zn��kh�vV��.��=��Z�ەW��;�n�Z�d�8��;�:Sˤ�SAO�T��y��F�-(R[��V8��5��S�¦�\r\0_��5�T��,��O�h��.U]�V+�o��uML�X��¶�܂�W��R�S��(�\"�+��)\na��~�<H[�j\Z��[��&(^�N]{�f�UN3��y\'��^��>��n��TI��^�m��/�WoG@n{!�!�ı>��_;t#��E�.��g%�v\\X)å<�%��3��1�v�� QLdո��h&�6�r�P�X��cW�j��Ѡ��Ѹ��D&A��\r��6��e��\'o��\r��wO��B�d��em�`��ٍ�n�\0�z��a��ًc�í-J��z�g�gk�\'O��jG��m\0<��?\\��ZUWw�pZs2��?*��&�sL��d�V��mN��z��\'�A�\Z��9��6\'��c:��־!��bNlo��A#3}�Hn��)`qh\'��r(��\n��\Z�rs�:��-9��]�Q�#� X��)��\"�!�G�0��d�t_�� ?~2N��;vw��%��+�!��P�=D\\��F�W��Hs��wШ�}K��D?��w��)�;�۽>��bm�6C�0�W^�\r��1�P�W��0��/^��i��z�ya`k�cY��`��ݪ\Z�߮�l\rB��/��#/�2S�}g��!��?��\";}','20250118213212')
[DBQuery] SqlBagOStuff::updateTable [0.008s] wikideveus101mysql-server.mysql.database.azure.com:3306: REPLACE INTO `dwobjectcache` (keyname,value,exptime) VALUES ('displayrwiki-dw:pcache:idoptions:692','m��r�0�E��4�2C��Y��SI�H2�f��Y-rӇ>٣swu�j��R�k]�p@��T�}��<��;��Vb��Q�+�sU��G�[��w>�+T\"�)��fh� �@\"��v?��f�H��׮��}l��&�P�6��<��`�/ߣ5��rϨ� �V�ӠO|[�{��t\r? ��h��I��JEN��;�$��r�_ O�r��#��hD��r��ݯ�;g<��t��tk��!�74$�q2�8��[��L�$�\"�Q�!9Yw��9��,J�I�Wt��%)\'�~{p�ϰӞ�<��N+�/��-Ћ�}mt ��׾��-U!i��Z�<�,��b.�D\nɧr��V��UM�r\\�f{8c�e��Ws��','20250118213212')
[DBQuery] Wikimedia\Rdbms\DatabaseMysqlBase::serverIsReadOnly [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT @@GLOBAL.read_only AS Value
[objectcache] fetchOrRegenerate(global:rdbms-server-readonly:wikideveus101mysql-server.mysql.database.azure.com%3A3306:displayrwiki:): miss, new value computed
[DBQuery] OutputPage::addCategoryLinksToLBAndGetResult [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_namespace,page_title,pp_value FROM `dwpage` LEFT JOIN `dwpage_props` ON (pp_propname = 'hiddencat' AND (pp_page = page_id)) WHERE (page_namespace = 14 AND page_title = 'Case_Studies')
[objectcache] getWithSetCallback(global:rdbms-server-readonly:wikideveus101mysql-server.mysql.database.azure.com%3A3306:displayrwiki:): process cache hit
[DBQuery] MediaWiki::preOutputCommit [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: COMMIT
MediaWiki::preOutputCommit: primary transaction round committed
[DeferredUpdates] DeferredUpdates::run: started MWCallableUpdate_WikiPage->doViewUpdates #682
[SQLBagOStuff] MainObjectStash using store ReplicatedBagOStuff
[objectcache] getWithSetCallback(global:rdbms-server-readonly:wikideveus101mysql-server.mysql.database.azure.com%3A3306:displayrwiki:): process cache hit
[DeferredUpdates] DeferredUpdates::run: ended MWCallableUpdate_WikiPage->doViewUpdates #682
MediaWiki::preOutputCommit: pre-send deferred updates completed
MediaWiki::preOutputCommit: session changes committed
[DBReplication] Wikimedia\Rdbms\ChronologyProtector::storeSessionReplicationPosition: DB 'wikideveus101mysql-server.mysql.database.azure.com:3306' touched
[DBReplication] Wikimedia\Rdbms\ChronologyProtector::shutdown: no master positions to save
MediaWiki::preOutputCommit: LBFactory shutdown completed
OutputPage::haveCacheVaryCookies: no cache-varying cookies found
[DBQuery] Wikimedia\Rdbms\Database::beginIfImplied (ArticleFeedbackv5Permissions::getProtectionRestriction) [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: BEGIN
[DBQuery] ArticleFeedbackv5Permissions::getProtectionRestriction [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT pr_level,pr_expiry FROM `dwpage_restrictions` WHERE pr_page = 692 AND pr_type = 'aft' AND (pr_expiry = 'infinity' OR pr_expiry >= '20250117213212') LIMIT 1
[DBQuery] Title::getParentCategories [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT cl_to FROM `dwcategorylinks` WHERE cl_from = 692
[DBQuery] LinkBatch::doQuery (for Skin::preloadExistence) [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_namespace,page_title FROM `dwpage` WHERE (page_namespace = 1 AND page_title = 'Case_Study_-_Dashboard_-_Microsoft_KPIs') OR (page_namespace = 4 AND page_title IN ('Privacy_policy','About','General_disclaimer') )
[DBQuery] Title::getParentCategories [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT cl_to FROM `dwcategorylinks` WHERE cl_from = 692
[DBQuery] Title::getParentCategories [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT cl_to FROM `dwcategorylinks` WHERE cl_from = 593
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'Learning_Displayr' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:9bd0a96e849e9bc1fb25f9a018eae046f39b9357): miss, new value computed
[DBQuery] Title::getParentCategories [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT cl_to FROM `dwcategorylinks` WHERE cl_from = 625
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'Displayr' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:fa3f009a19aa2309efb4e48e4eb08dd5e78b0dca): miss, new value computed
[DBQuery] Title::getParentCategories [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT cl_to FROM `dwcategorylinks` WHERE cl_from = 32
[DBQuery] MediaWiki\User\TalkPageNotificationManager::dbCheckNewUserMessages [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT user_ip FROM `dwuser_newtalk` WHERE user_ip = '10.244.2.99' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page-content-model:6715): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:page-content-model:6715): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Nstab-talk' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:8eee482d2898cbd9f8b29a97b443fa65d3e25f93): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f8335355660183b6a287c77e3fef979a:Nstab-talk): miss, new value computed
[DBQuery] SqlBagOStuff::fetchBlobMulti [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT keyname,value,exptime FROM `dwobjectcache` WHERE keyname = 'displayrwiki-dw:messages:en'
[DBQuery] SqlBagOStuff::fetchBlobMulti [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT keyname,value,exptime FROM `dwobjectcache` WHERE keyname = 'displayrwiki-dw:messages:en:status'
[DBQuery] SqlBagOStuff::lock [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT GET_LOCK('displayrwiki-dw:messages:en', 0) AS lockstatus
[SQLBagOStuff] SqlBagOStuff::lock failed due to timeout for displayrwiki-dw:messages:en.
[DBQuery] MessageCache::loadFromDB(en)-big [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_title,page_latest FROM `dwpage` WHERE page_is_redirect = 0 AND page_namespace = 8 AND (page_title LIKE '%/en' ESCAPE '`' ) AND (page_len > 10000)
[DBQuery] MessageCache::loadFromDB(en)-small [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT /*! STRAIGHT_JOIN */ rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,temp_rev_user.revactor_actor AS `rev_actor`,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM `dwpage` JOIN `dwrevision` ON ((page_id = rev_page)) JOIN `dwrevision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `dwcomment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `dwrevision_actor_temp` `temp_rev_user` ON ((temp_rev_user.revactor_rev = rev_id)) JOIN `dwactor` `actor_rev_user` ON ((actor_rev_user.actor_id = temp_rev_user.revactor_actor)) LEFT JOIN `dwuser` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE page_is_redirect = 0 AND page_namespace = 8 AND (page_title LIKE '%/en' ESCAPE '`' ) AND (page_len <= 10000) AND (page_latest = rev_id)
[DBQuery] SqlBagOStuff::updateTable [0.005s] wikideveus101mysql-server.mysql.database.azure.com:3306: REPLACE INTO `dwobjectcache` (keyname,value,exptime) VALUES ('displayrwiki-dw:messages:en','��\n�@��e�`w�O��,�m�(�X��-X[��{��a\n��=��4�(��|��~��F� ��[�P\"��Zg��q�К7��\"h�,Ӻ?\"�@Y��t*NE)��','20380119031407')
[DBQuery] SqlBagOStuff::unlock [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT RELEASE_LOCK('displayrwiki-dw:messages:en') as lockstatus
[MessageCache] MessageCache::load: Loading en... local cache is empty, global cache is expired/volatile, loading from database
[DBQuery] LinkCache::fetchPageRow [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Nstab-talk/en' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:6144e8cf16ba4bba07bd834794833f94656643d1): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f6c4f725a607bfe8fa0cf0c05ee4f470:Nstab-talk/en): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Displayruser-view-view' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:b708c9d486cfda34a2b018aca6b8977265cde8df): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f8335355660183b6a287c77e3fef979a:Displayruser-view-view): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Displayruser-view-view/en' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:3d77914926621e1adecc30dd4e0baaa56e506f85): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f6c4f725a607bfe8fa0cf0c05ee4f470:Displayruser-view-view/en): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Displayruser-action-viewsource' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:938d7d980de7efcc44d88cf73b0aee9c916d39fa): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f8335355660183b6a287c77e3fef979a:Displayruser-action-viewsource): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Displayruser-action-viewsource/en' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:16ebad24db6caa1f04e6a89af50cc3bb549466a4): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f6c4f725a607bfe8fa0cf0c05ee4f470:Displayruser-action-viewsource/en): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Displayruser-view-history' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:69932966a6b08fbf6b927d0b92a077178326faab): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f8335355660183b6a287c77e3fef979a:Displayruser-view-history): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Displayruser-view-history/en' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:b0c9625514330ac9b36469100edaf877e2ad7455): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f6c4f725a607bfe8fa0cf0c05ee4f470:Displayruser-view-history/en): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Http://www.displayr.com' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:347c824cac60bffafcb4e0c416b0673b315b037e): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f8335355660183b6a287c77e3fef979a:Http%3A//www.displayr.com): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Http://www.displayr.com/en' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:336ce677904b65dc7f75177715f2c6875dd065ea): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f6c4f725a607bfe8fa0cf0c05ee4f470:Http%3A//www.displayr.com/en): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Back_to_Displayr_home_page' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:f4527ac7dbe23c0e8a4cbf45830d6c9ae1939b01): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f8335355660183b6a287c77e3fef979a:Back_to_Displayr_home_page): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Back_to_Displayr_home_page/en' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:147d0eab2295760e7632d432e4a0882522b7430c): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f6c4f725a607bfe8fa0cf0c05ee4f470:Back_to_Displayr_home_page/en): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Main_Page' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:8f9e9b397d590520d0938b3a063c1c0b58ba8445): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f8335355660183b6a287c77e3fef979a:Main_Page): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Main_Page/en' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:a51dc04dd9ac432abbba7646f47831357f3d6995): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f6c4f725a607bfe8fa0cf0c05ee4f470:Main_Page/en): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Wiki_home_page' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:aa97b17d87f1db0c9a13497ecdf296861e87a75a): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f8335355660183b6a287c77e3fef979a:Wiki_home_page): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 8 AND page_title = 'Wiki_home_page/en' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:8:a09c62712f558d3ce502a02ed539afe03db2db32): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:messages-big:f6c4f725a607bfe8fa0cf0c05ee4f470:Wiki_home_page/en): miss, new value computed
[DBQuery] CategoryTree::renderChildren [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_namespace,page_title,page_is_redirect,page_len,page_latest,cl_to,cl_from,cat_id,cat_title,cat_subcats,cat_pages,cat_files FROM `dwpage` JOIN `dwcategorylinks` FORCE INDEX (cl_sortkey) ON ((cl_from = page_id)) LEFT JOIN `dwcategory` ON ((cat_title = page_title) AND page_namespace = 14) WHERE cl_to = 'Displayr' AND cl_type IN ('page','subcat') ORDER BY cl_type, cl_sortkey LIMIT 200
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model FROM `dwpage` WHERE page_namespace = 0 AND page_title = 'Edit_Mode_and_View_Mode' LIMIT 1
[DBQuery] LinkCache::fetchPageRow [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model FROM `dwpage` WHERE page_namespace = 0 AND page_title = 'Find_and_Replace' LIMIT 1
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model FROM `dwpage` WHERE page_namespace = 0 AND page_title = 'JavaScript' LIMIT 1
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model FROM `dwpage` WHERE page_namespace = 0 AND page_title = 'Learning_Displayr' LIMIT 1
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model FROM `dwpage` WHERE page_namespace = 0 AND page_title = 'Release_Notes' LIMIT 1
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model FROM `dwpage` WHERE page_namespace = 0 AND page_title = 'Security_Statement' LIMIT 1
[DBQuery] LinkCache::fetchPageRow [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model FROM `dwpage` WHERE page_namespace = 0 AND page_title = 'Supported_Browsers' LIMIT 1
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'Administration' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:b8be3d1264310c3b8c848d4b90d5206179a40cc4): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'Basic_Data_Analysis' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:c23ed52d95d0a9df866ab7aef857efce37ef0d3c): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'Charts_and_Visualizations' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:f268e6a4b6b15fd5fada6175d45c13e8e5dcba75): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'Definitions' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:15225baac48fc3d689cb2b0f74b936eff4339ff7): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'Displayr\'s_Object_Model' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:5b9a225eb5073068a0368b9045cffbd974bfa60c): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'Experimental_Design' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:0300d39f06630224d2445305c4a006d2cafccc36): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'MaxDiff' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:23971d509c08c72603d846ee6585d5c63ab790a1): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'Principal_Components_Analysis' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:252361b9aa9d8ae36a436fb6ebc34ca280a03ac7): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'R' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:06576556d1ad802f247cad11ae748be47b70cd9c): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0.001s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'Regression' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:1eb1498dac3539eb922647f7dc4e358f9465b670): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'Supported_Data_File_Types' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:b1739427ccdf305f0e0a7714f37e9b822fcbaaa2): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'Tests_of_Statistical_Significance' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:08741c9d41c9a73ff266ce59396f1e21a0adf369): miss, new value computed
[DBQuery] LinkCache::fetchPageRow [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_id,page_len,page_is_redirect,page_latest,page_restrictions,page_content_model,page_touched FROM `dwpage` WHERE page_namespace = 14 AND page_title = 'Weights' LIMIT 1
[objectcache] fetchOrRegenerate(displayrwiki-dw:page:14:c4f103df2a6e39414ee0d1e52d7fd716157ea60b): miss, new value computed
[DBQuery] ResourceLoaderWikiModule::preloadTitleInfo [0s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT page_namespace,page_title,page_touched,page_len,page_latest FROM `dwpage` WHERE (page_namespace = 8 AND page_title IN ('Common.css','Displayruser.css','Noscript.css','Print.css') )
[objectcache] fetchOrRegenerate(global:resourceloader-titleinfo:displayrwiki-dw:8dea2afc424ca147784d7c9e3335e2a8af1a75a2): miss, new value computed
[objectcache] fetchOrRegenerate(global:resourceloader-titleinfo:displayrwiki-dw:da39a3ee5e6b4b0d3255bfef95601890afd80709): miss, new value computed
[objectcache] fetchOrRegenerate(displayrwiki-dw:page-content-model:6715): miss, new value computed
Title::getRestrictionTypes: applicable restrictions to [[Case Study - Dashboard - Microsoft KPIs]] are {edit,move}
User::getBlockedStatus: checking blocked status for 10.244.2.99
[DBQuery] MediaWiki\Block\DatabaseBlock::newLoad [0.002s] wikideveus101mysql-server.mysql.database.azure.com:3306: SELECT ipb_id,ipb_address,ipb_timestamp,ipb_auto,ipb_anon_only,ipb_create_account,ipb_enable_autoblock,ipb_expiry,ipb_deleted,ipb_block_email,ipb_allow_usertalk,ipb_parent_block_id,ipb_sitewide,comment_ipb_reason.comment_text AS `ipb_reason_text`,comment_ipb_reason.comment_data AS `ipb_reason_data`,comment_ipb_reason.comment_id AS `ipb_reason_cid`,actor_ipb_by.actor_user AS `ipb_by`,actor_ipb_by.actor_name AS `ipb_by_text`,ipb_by_actor FROM `dwipblocks` JOIN `dwcomment` `comment_ipb_reason` ON ((comment_ipb_reason.comment_id = ipb_reason_id)) JOIN `dwactor` `actor_ipb_by` ON ((actor_ipb_by.actor_id = ipb_by_actor)) WHERE ipb_address = '10.244.2.99' OR ((ipb_range_start LIKE '0AF4%' ESCAPE '`' ) AND (ipb_range_start <= '0AF40263') AND (ipb_range_end >= '0AF40263'))
[objectcache] fetchOrRegenerate(displayrwiki-dw:page-content-model:6715): miss, new value computed

Case Study - Dashboard - Microsoft KPIs

Contents

Overview

Video

How to create the dashboard

Files

Navigation menu

Search