<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi All!</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
We have tried Tableau and Looker Studio. </div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Currently we are setup to use <a href="https://lookerstudio.google.com/reporting/0a611cf2-b4f8-4e20-9222-962285e5d52b">
Looker Studio</a>. </div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
The key takeaway for both scenarios is the importance of building reports directly from the raw data to minimize the need for cleaning or reformatting each time you pull data. A colleague of mine has developed Python scripts to automate parts of this process.
However, if such tools are not available, it becomes even more critical to design reports around the raw data. Avoid renaming columns, altering column order, or modifying date timestamps—tools like Looker and Tableau can handle these adjustments dynamically. </div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
For example, we have a service that designates the date timestamp as text rather than a proper date field. This misclassification creates challenges when working with the data, but visualization tools are sophisticated enough to allow you as the report builder
to adjust column attributes and formats as needed, ensuring seamless analysis.</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
(You can technically make a copy of our report and update it to use your data. Happy to chat more 🙂 )</div>
<div class="elementToProof" id="Signature">
<div style="background-color: rgb(255, 255, 255); font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="background-color: rgb(255, 255, 255);">
<div style="direction: ltr; margin: 0px; font-family: Arial, sans-serif; font-size: 14px; color: black;">
<br>
</div>
</div>
<div><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt;">Andy Lechlak (he, him, his)</span> </div>
<div><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt;">Manager of Design and Analytics</span> </div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt;">
Toledo Lucas County Public Library</div>
<div><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt;"><i>Winner of the National Medal for Museum and Library Services</i></span><i> </i></div>
<div><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt;">419.259.5252 (office)</span> </div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt;">
<a href="http://toledolibrary.org/" id="OWAf3c64918-b9a2-60f4-dc08-0d1d8adb92e3" class="OWAAutoLink">Web</a> |
<a href="https://www.facebook.com/ToledoLibrary/?fref=ts" id="OWA725bd612-95e9-7b09-0d62-6f21722903b4" class="OWAAutoLink">
Facebook</a> | <a href="https://www.instagram.com/ToledoLibrary/" id="OWA0037b61c-34d5-b707-8863-70751f63ab16" class="OWAAutoLink">
Instagram</a> | <a href="https://www.youtube.com/user/tlcplibrary" id="OWA5d9180d0-0612-c114-5d00-09b9e2abc495" class="OWAAutoLink">
YouTube</a> | <a href="https://www.linkedin.com/company/toledo-lucas-county-public-library/" id="OWA4fe1c755-2e41-f6b5-a9bf-092aab4b0ed7" class="OWAAutoLink">
LinkedIn</a> </div>
<div style="background-color: rgb(255, 255, 255);">
<div style="background-color: white; margin: 0px;"></div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> OPLINLIST <oplinlist-bounces@lists.oplin.org> on behalf of Jennifer Fording via OPLINLIST <oplinlist@lists.oplin.org><br>
<b>Sent:</b> Tuesday, January 21, 2025 11:02 AM<br>
<b>To:</b> Ariel Jacobs <ajacobs@seolibraries.org><br>
<b>Cc:</b> oplinlist@lists.oplin.org <oplinlist@lists.oplin.org><br>
<b>Subject:</b> Re: [OPLINLIST] Data Visualization Services for Library Statistics</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div>We do something like this through Canva. I'm not sure if this is what you mean?</div>
<div><br>
</div>
<div>
<div dir="ltr" class="x_gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr"><b>Jennifer Fording</b>
<div><b>Director</b></div>
<div><b style="background-color:rgb(243,243,243)"><font color="#000000">Harris-Elmore Public Library</font></b></div>
<div><font color="#3d85c6">(419) 862-2482 ext. 101</font></div>
<div><font color="#3d85c6"><a href="mailto:director@harriselmorelibrary.org" target="_blank">director@harriselmorelibrary.org</a></font></div>
<div><font color="#3d85c6"><a href="http://www.harriselmorelibrary.org" target="_blank">www.harriselmorelibrary.org</a></font></div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
<br>
<div class="x_gmail_quote x_gmail_quote_container">
<div dir="ltr" class="x_gmail_attr">On Tue, Jan 21, 2025 at 10:24 AM Ariel Jacobs via OPLINLIST <<a href="mailto:oplinlist@lists.oplin.org">oplinlist@lists.oplin.org</a>> wrote:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<u></u>
<div>
<div>Morning, </div>
<div> </div>
<div>I would be interested in this as well. Currently, I present stats through Excel.
</div>
<div> </div>
<div>Ariel </div>
<blockquote type="cite">
<div>On 01/21/2025 10:07 AM EST Stephanie Freas via OPLINLIST <<a href="mailto:oplinlist@lists.oplin.org" target="_blank">oplinlist@lists.oplin.org</a>> wrote:
</div>
<div> </div>
<div> </div>
<div dir="ltr">
<div>Good morning library people of Ohio, </div>
<div> </div>
<div>We're looking to redo how we present our statistics (door counts, programming, circulation, website/social media use, etc) to incorporate a data visualization aspect through a service like Google Looker Studio or Microsoft Power BI. Has anyone else taken
steps to get here, and if so, can you share the data visualization service you use as well as any suggestions for a library going through this for the first time?
</div>
<div> </div>
<div>Thank you, </div>
<div>Stephanie </div>
<div> </div>
<div> </div>
<span class="x_gmail_signature_prefix">-- </span><br>
<div class="x_gmail_signature" dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<table style="color:rgb(34,34,34); border:none; border-collapse:collapse">
<colgroup><col width="169"><col width="551"></colgroup>
<tbody>
<tr style="height:97.5pt">
<td style="vertical-align:top; padding:5pt; overflow:hidden">
<p dir="ltr" style="line-height:1.2; margin-top:0pt; margin-bottom:0pt"><a href="https://muskingumlibrary.org/" rel="noopener" target="_blank" style="color:rgb(17,85,204)"><span style="font-family:Arial; background-color:transparent; vertical-align:baseline; white-space:pre-wrap"><span style="border:none; display:inline-block; overflow:hidden; width:139px; height:98px"><img width="139" height="98" style="margin-left:0px; margin-top:0px"></span></span></a></p>
</td>
<td style="vertical-align:top; padding:5pt; overflow:hidden">
<p dir="ltr" style="line-height:1.2; margin-left:4.5pt; margin-top:0pt; margin-bottom:0pt">
<span style="background-color:transparent; vertical-align:baseline; white-space:pre-wrap"><span style="color:rgb(68,68,68); font-family:"arial narrow",sans-serif"><strong>Stephanie Freas, MLIS</strong></span></span></p>
<p dir="ltr" style="line-height:1.2; margin-left:4.5pt; margin-top:0pt; margin-bottom:0pt">
<span style="color:rgb(68,68,68); font-family:"arial narrow",sans-serif"><span style="white-space:pre-wrap"><strong>Assistant Director
</strong></span></span></p>
<p dir="ltr" style="line-height:1.2; margin-left:4.5pt; margin-top:0pt; margin-bottom:0pt">
<span style="color:rgb(68,68,68); font-family:"arial narrow",sans-serif"><span style="white-space:pre-wrap"><strong> </strong></span></span></p>
<p dir="ltr" style="line-height:1.2; margin-left:4.5pt; margin-top:0pt; margin-bottom:0pt">
<span style="background-color:transparent; vertical-align:baseline; white-space:pre-wrap"><span style="color:rgb(68,68,68); font-family:"arial narrow",sans-serif">220 North Fifth Street</span></span></p>
<p dir="ltr" style="line-height:1.2; margin-left:4.5pt; margin-top:0pt; margin-bottom:0pt">
<span style="background-color:transparent; vertical-align:baseline; white-space:pre-wrap"><span style="color:rgb(68,68,68); font-family:"arial narrow",sans-serif">Zanesville, Ohio 43701</span></span></p>
<p dir="ltr" style="line-height:1.2; margin-left:4.5pt; margin-top:0pt; margin-bottom:0pt">
<span style="background-color:transparent; vertical-align:baseline; white-space:pre-wrap"><span style="color:rgb(68,68,68); font-family:"arial narrow",sans-serif">740.453.0391 Ext. 131</span></span></p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
_______________________________________________ OPLINLIST mailing list -- <a href="mailto:OPLINLIST@lists.oplin.org" target="_blank">
OPLINLIST@lists.oplin.org</a> <a href="https://lists.oplin.org/mailman/listinfo/oplinlist" target="_blank">
https://lists.oplin.org/mailman/listinfo/oplinlist</a> ****** Did you know that public libraries are eligible to receive discounts on internet connection, wireless access and hardware that supports internet access through the E-rate program? By filling out
a few forms you can get as much as a 90 percent discount on your bills. Learn more at
<a href="https://oplin.ohio.gov/erateinfo******" target="_blank">https://oplin.ohio.gov/erateinfo******</a>
</blockquote>
</div>
_______________________________________________<br>
OPLINLIST mailing list -- <a href="mailto:OPLINLIST@lists.oplin.org" target="_blank">
OPLINLIST@lists.oplin.org</a><br>
<a href="https://lists.oplin.org/mailman/listinfo/oplinlist" rel="noreferrer" target="_blank">https://lists.oplin.org/mailman/listinfo/oplinlist</a><br>
<br>
****** Did you know that public libraries are eligible to receive discounts on internet connection, wireless access and hardware that supports internet access through the E-rate program? By filling out a few forms you can get as much as a 90 percent discount
on your bills. Learn more at<br>
<a href="https://oplin.ohio.gov/erateinfo******" rel="noreferrer" target="_blank">https://oplin.ohio.gov/erateinfo******</a><br>
</blockquote>
</div>
</div>
</body>
</html>