NYS Ed Data in Salesforce

228,000 records in. Here’s the view for my high school, Smithtown East

Sleuthing Office 365 Sway Viewing

Screebsgit

In general, Office 365 Admin tools make me feel 7 feet tall. When I publish a Sway embed in WordPress, I get viewing notification emails from Azure Active Directory (AAD). I’m not surprised that the viewer is anonymous – requiring authentication would drive my “I’m outta here” bounce rate up.

If you want content viewed, don’t put up any more obstacles than are necessary.

Still, because the notification didn’t tell me which Sway was viewed, only the fact that there had been a Sway viewing — it wasn’t a perfectly satisfactory state of affairs. Until I happened to notice a link in the notification…

Search the Audit Log for this Item

ss of Azure Activity Audit
Clicking through on the audit log….

Here, where you get a link that identifies which Sway.

Security And Compliance Screenshot

So it looks like I need to hit the documentation and start building up a more robust if still imperfect analytics understanding.

ss
Click the image to visit the DOCS site. I know I will.

Trusty Apex Dataloader

A client of mine in Education Services is uploading a large amount of data published by NYS Department of Education about some 7,000 schools & hierarchical entities related (Districts, Charter Schools, Charter Operators) in NY State.

A few more similarly granular objects to go…

The ETL professional in me likes large numbers. But the SF Admin in me is wondering about a performance hit. Also, hoping to upload this to an Enterprise org I have with Einstein Analytics licenses for the soothing transformations when selecting subsets of the data. Stay tuned.

Einstein Analytics Data Import

We still have a few more child objects off the account to go, and I’m wondering if this is a good case for using Big Objects or an external data source. Suggestions welcome!