New To PowerBI: Daily Dashboard Email Updates Via Subscription

I’ve written a lot about PowerBI, both on this blog and in my previous role at St Andrew’s College and one of the things I love most about the product is the current speed of development. Significant new features are added monthly, often in response to user requests (hint, if you want to see a new feature submit it here) and today I saw announced a great new feature.

Daily Dashboard Email Subscriptions is a new feature allowing your PowerBI users to subscribe to a company or individual dashboard and receive daily email snapshots of this critical data.

PowerBI

An example email of a dashboard overview emailed daily to the recipient

For users that are used to Microsoft SQL Server Reporting Services (SSRS) this feature could not come soon enough. It is super easy for your end users to sign up themselves for these daily emails, they simply go to the dashboard of their choice (or make a custom dashboard by pinning the visuals they want to track) and hit subscribe:

PowerBI 2.jpg

Note: if your data does not change regularly, then will not be bombarded with daily emails that were identical to the previous day. The updates come via email only as regularly as your data refreshes but no more than once a day. Therefore, if you have non-critical data that only refreshes once a week, you will only receive an email once a week.

It looks like the PowerBI team isn’t stopping there when it comes to email subscriptions, with new features coming soon that include:

In an education context I can see this being super helpful for Executive and Enrollment Teams where they need to track time sensitive data e.g. how many beds remain in the boarding house? What is the gender split in Year 10? How many students have passed their internal assessment before the end of the year? Lots of possibilities exist for daily emails of key dashboards.

Autopilot – Even Easier Device Enrollment & Deployment In Windows 10 Out Of The Box


UPDATE 10th July: Information on how to add devices to Autopilot via the Windows Store For Business / Education can be see here


UPDATE 3rd July: More technical information on Autopilot is available here, including example PowerShell scripts on how to collect the hardware identifier for existing devices you may want to enroll into Autopilot.


With Windows 10 Creators Update you can now configure and deploy devices even easier, thanks to the newly announced Autopilot and Intune (part of the EMS suite).

Autopilot is similar to Apple’s Device Enrollment Program (DEP), in that you can pre-register a unique hardware identifier before the device is even turned on. When the device is shipped to the end user (think either a teacher or student purchasing a BYOD laptop), as soon as they connect their new laptop to a wireless network, it will be registered by Autopilot and provide:

  • A custom set up experience as determined by the school’s ICT department (or their partner), this could include skipping steps in the device setup that are unnecessary or confusing for end users
  • Branded setup, showing the school name and logo so the student/teacher can be confident in the security of the device and trust the setup process
  • The option to enter their school email address/password which would automatically enroll the device into Intune (or Intune for Education), resulting in the correct applications and settings being pushed to the device

Microsoft’s blog announcing Autopilot described it as follows:

With Windows AutoPilot, IT professionals can customize the Out of Box Experience (OOBE) for Windows 10 PCs and enable end users to take a brand-new Windows 10 device and—with just a few clicks—have a fully-configured device ready for business use. There are no images to deploy, no drivers to inject, and no infrastructure to manage. Most importantly, users can go through the process independently, without making any decisions and without needing to involve IT.

Some of the benefits of Microsoft Autopilot include:

  • Intune can push policies, settings, and configuration to the device, and install Office 365 and other apps without IT ever having to touch the device or apply a custom image to the device.
  • Intune can configure Windows Update for Business to apply the latest updates.
  • The device can automatically upgrade from Windows 10 Pro to Windows 10 Enterprise seamlessly using AAD–no product keys to manage, no reboots, no prompts for the user (Requires a Windows 10 Enterprise E3 subscription)

Here is how you can set up the Autopilot program and see it in action:

This slideshow requires JavaScript.

The setup process when using Autopilot – note the branded sign-in page with logo and organisation name

My Point Of View:

I see Autopilot as a tremendously helpful tool for IT Admins in education as it will allow them to be more hands-free on the configuration and deployment of devices. Many schools love the simplicity of Apple’s Device Enrollment Program and now Autopilot enables similar functionality with full Windows 10.

An additional benefit is theft protection – if a device was enrolled into Autopilot and was later stolen, then even if it was wiped, it could not be used by the thief because as soon as it is connected to the internet the hardware identifier will enroll it into Autopilot again and start the school’s setup process – this can not be avoided until the device is un-enrolled by the school itself.

The other area where I see Autopilot adding significant value is BYOD. If a school uses an education partner and parents purchase their child’s BYOD device through the partner’s portal, then the hardware identifier could be registered with the school at the time of sale. As a result, when the student turns it on at home it is automatically connected to the school’s environment and has all of the apps, setting and network credentials pushed to it, ready for the first day of school – no more “onboarding days” at the school to get connected!

Even though this was just announced today, as ZDNet astutely picked up, this functionality was included in the Creators Update released back in April – just one more reason for schools to keep their computers updated on recent Windows 10 builds.

Microsoft Teams For Education Is Here – And It Is Awesome

Big news from over the weekend is that Microsoft Teams, already available in commercial Office365 Tenants, has arrived in Education with all of the new features dedicated to making this app the “one stop shop” for students and educators.

Read the official launch blog post here.

There are a number of major differences in Teams for Education (which replaces the Microsoft Classroom app that was in public preview) and these are designed to streamline the workflows for students and teachers.

Assignments:

Teams Assignments 1

From assigning, through to submission and marking, assessment can be completed directly within the Microsoft Teams app.

Persistent Conversations:

Teams Persistent Conversations.png

These allow students and teachers to share ideas on the fly, from anywhere and any device (iOS/Android/Windows Phones supported, along with native apps for Win10/MacOS and Browsers)

As a trained teacher, I can really see the benefit of setting up various channels for persistent conversation where links could be dropped for future reference/revision, video links for homework viewing and even just a fun channel where only semi-related content could be shared e.g. if you’re teaching a history class interesting facts about different periods of history that students enjoy but are not being covered in class could be shared.

What’s more, you can moderate content being shared in Teams persistent conversation to keep everyone safe. (Click here to learn how to run a Content Search on Teams. Click here to read ICT Admin FAQ for Teams).

Given students will be able to contribute to persistent conversations from any of their devices this opens up great opportunities for learning outside the classroom such as sharing a photo of your backyard if school is closed for snow; or take a selfie photo during term break and play “where in the world is….” with students guessing the location of each other.

Deep Integration With Other Products:

OneNote Class NoteBooks are, of course, built straight into the Teams app and this will likely be the central hub of Teams for many classrooms, with teachers populating content and students contributing their ideas and work into the Collaboration Spaces and their own sections.

However, one of the best parts about Teams is the ability to extend it with third party apps to plug in as Tabs in your team:

Teams Add Apps

Examples of some of the available apps already, with new, education focused apps being added regularly.

As blogged about earlier, the Meet Now function within Teams allows for both scheduled and ad-hoc video conferencing between students and staff.

Additionally, there are various types of Teams that can be set up and used and teachers and students can seamlessly switch between each team:

Teams Create

When creating a new Team you’re prompted for what type of Team you’re wanting to bring together to collaborate with.

The PLC (Professional Learning Communities) Team is based on the same structured inquiry based learning that was available in Groups and with the ability to add external team members from outside of your school/organisation coming before the end of the year, then these will be perfect for teachers that participate in cross-school professional development such as the Communities of Learning in New Zealand.

Omaha Schools District Case Study:

“Our students interact and socialize with a larger circle of influence than what we’ve ever had as a society. And when you look at how we prepare students for that type of environment, digital citizenship and literacy really come to the forefront. With technology in the classroom, we focus on the 4Cs – communication, collaboration, critical thinking, and creativity. Microsoft Teams really does all of them.”

I really like that focus on the “4Cs” when it comes to the use of technology in schools and using this as a way to evaluate the usefulness and effectiveness in the classroom:

  • Communication
  • Collaboration
  • Critical Thinking
  • Creativity

Ready To Get Started?

Teams Getting Started.PNG

If you’re ready to get started with Teams, then do check out this overview for ensuring Success With Teams or click one of the specific links below:

 

Case Study: Jumeirah English Speaking School & The Value Of OneNote & Surface Pro

Video

Located in Dubai, JESS is a full K-12 school with around 2,200 students running the International Baccalaureate program. The school has deployed Surface Pro and Office365 at a Grade 7 level and are using OneNote Class NoteBooks, OneDrive, Sharepoint, Office Mix, Sway and Microsoft Classroom (soon to be replaced with Microsoft Teams)

Read the full case study here

Some of the teachers interviewed in the video above were very specific about the value they see from Surface Pro and OneNote e.g.

The advantage of the Surface Pro 4 is that it combines the ability to write text with all the computing power of a laptop, and that is a game changer.

I do encourage you to watch the video and read the case study above and learn more about how JESS started their Digital Transformation journey.

Accessibility Is At The HEART Of Microsoft & Office365

Update 23rd June:

Since writing this blog I see that the Microsoft Garage have also released a new product called MS Dictate which is a plugin for Outlook, Word and Powerpoint that allows you to dictate text using the same speech-to-text engine used by Cortana. You can download it for free here.

Recently I’ve been working with a partner that has a school for deaf and hearing impaired students as a customer. It’s been really interesting exploring how technology is used in environments like this, where the need for video communication to enable sign language is paramount.

As a result, I’ve been digging into the accessibility options within Microsoft’s Windows 10 and Office365 products and it has reinforced the observations I’ve noticed already since joining Microsoft at the start of the year: accessibility and inclusive design really is at the heart of all Microsoft products.

blog 1.png

Accessibility is a priority for Microsoft for three key reasons:

  1. We cannot realise our mission to empower every person and organisation to achieve more without accessibility
  2. Accessibility is our path to innovation
  3. Our public sector customers are required to procure accessible products

At every major internal Microsoft event I’ve attended this year there has been automatic transcription / captioning of speakers so that deaf or hearing impaired employees can follow along. 5% of the world population (around 360 million people) have some form of hearing difficulty, so the need to use technology to include them in business activities is very real.

However, hearing impediments is not the only area where accessibility in Windows 10 and Office365 is helping:

blog 3

As I’ve researched more about the various accessibility features I’ve come across some great customer testimonials and case studies about how Windows 10 and Office365 are making a big difference for them on a daily basis. Below is one about Ted Hart who works at Microsoft and was part of the team that improved Skype Translator for English captions/subtitles resulting in deaf people being able to take part in conversations normally:

The next case study is entitled The Power Of Visual Communication showing how Skype video allows students with disabilities to be able to communicate with each other, even when on work experience. The visual nature of Skype means they can use both sign language and also read body language:

Finally, Al Amal School for Deaf Students in the United Arab Emirates shares how the use of tools like Office Mix and video recording in OneNote is proving valuable with their students:

There are numerous blogs from Microsoft that focus on specifically on accessibility  and Microsoft has a dedicated Disability Help Desk that supports video calling with American Sign Language:

blog 4.PNG

Marlee Matlin, the only deaf performer to win an Academy Award for Best Actress, demonstrated how the help desk works:

Translator Tools:

Microsoft have leveraged a number of translator tools that use Machine Learning and the Intelligent Cloud to provide greater accessibility support for all users, particularly those that are hard of hearing:

  1. Skype Translator: not only does this do real-time translations between different languages it can be re-purposed to provide an effective transcription of an English to English conversation to support deaf participants.
  2. Microsoft Translator phone app: Similar in functionality to Skype Translator, this app for your phone allows you to do transcriptions and translations (over 60 languages) and you can do multi-person chats on the same device or with up to 100 participants by sharing a conversation code.
  3. Presentation Translator: A project from the Microsoft Garage, this looks to be a plugin for PowerPoint that will provide real-time captioning on the PowerPoint itself from the speech of the presenter. This is not available yet but is coming soon in a beta trial.
  4. Skype Broadcast: The premier Skype meeting tool (available in O365 E5 plans), this will provide real time transcription of the Skype meeting so all participants can follow along.

Other Tools:

Outside of the straight translation tools above, Microsoft are building accessibility into a range of other products that are available now to customers:

  1. Video Indexer: This was formerly know as Video Breakdown in the Azure Media Analytics Suite and is currently in free trial. This tool allows you to automatically transcribe speech in a video, OCR scan text contained within the video, provide facial recognition and then index and search across all this content. It’s incredibly powerful.
  2. Microsoft Stream: Announced only today from Microsoft as being Generally Available (GA), this is built right into Office365 subscriptions and is a video library tool that also offers speech-to-text, facial recognition and searchable indexes. With granular sharing permissions this is a powerful tool.
  3. Accessibility Checker: Build directly into Office365, this tool scans your documents and identifies ways you can make them more user friendly for all users, but specifically those that may fact accessibility challenges. There is no need for a third party plugin to achieve this – it’s baked in by default!
  4. Learning Tools / Immersive Reader: Hugely popular in education already, this started as an extra plugin for OneNote Desktop, before being built in directly and also supported in the Web/Online versions in a browser as well. This tool will read text back to the user, highlight adjectives/nouns/verbs and provide coloured overlays to assist dyslexic users.
  5. Office Accessibility Center: The one stop shop for Microsoft accessibility content and ideas.
  6. Surface Hub: When it comes to providing the best hardware / software combination for collaboration for deaf customers, I think the Hub the best choice given the fully integrated camera experience will provide the ability to use sign language to communicate easily and effectively with remote users. Two videos below show the ease of meetings in with Surface Hub:

It is not just Surface Hub that is helping deaf students, the Surface Pro was highlighted in a video showing how deaf students playing American Football used it to communicate and develop game strategy:

blog 2

Accessibility examples from Windows 10

As you can see, there is a huge amount of work being done to support all users to make Windows and Office365 a totally accessible product. One small thing I really like is the ability to replace audio cues with visual or text notifications in Windows, an invaluable addition to the user experience for a deaf person.

If you think I’ve missed something or have other suggestions feel free to drop a note in the comments below.

 

Planning To Deploy MS Teams? Check This Resource First

With many businesses already deploying Microsoft Teams, and many educational institutes looking to follow along once Teams for Education in Office365 is officially launched, the following website is a great starting point to successfully start planning:

Success With Microsoft Teams

The website aims to provide practical guidance on best practice tips for deploying Teams and includes:

  • A link to download planning resources
  • Video tutorials including an overview/introduction, guide for deploying/operating teams, tips for ensuring success with Teams in your organisation and a bandwidth calculator to identify what impact Teams may have on your network
  • A link to download the Teams application for all the supported platforms including Windows, MacOS, iOS, Android and Windows Phone (and of course web browser platforms).

Teams Calculator.PNG

Screenshot of the bandwidth calculator provided on the Success With Teams website

It is good to see Microsoft putting together companion websites for a new tool like Teams to ensure that organisations can introduce it smoothly. Here’s the other info from the website:

Teams.PNG

Screenshot of the help topics available

Using “Meet Now” In Microsoft Teams

Video

I just learnt about this feature in Microsoft Teams – the ability to “Meet Now” and have a spontaneous video conference with the added ability to do screen sharing within it.

Given that Microsoft Teams is going to be replacing Microsoft Classroom (previously in public preview for the last six months) this looks like a very handy feature for students to collaborate remotely with.