All posts by Dr Nitin Paranjape

Enable Office 365 MFA and be safe

Quick guide for Office 365 MFA. Includes admin and user tasks in brief.

Admin: Enable Office 365 MFA

  1. Go to Admin Portal 
  2. Users – Select the user
  3. Office 365 MFA option in User properties
  4. Select user(s) again and click the Enable button
  5. That’s it. Now it is the user’s turn to take the next steps

User: Enable Office 365 MFA – first time only

  1. You must go to a browser – incognito / InPrivate / private mode
  2. Go to https://portal.office.com
  3. Login as usual.
  4. Click Next in the Additional Information dialog
  5. Now there are many options and this can be a confusing step
  6. Open the dropdown choose Mobile App and Choose Receive Notifications for verification option

    Choosing the Mobile App autentication option

  7. Click the Set Up option. After some processing, it will show a QR code
  8. Now it is time to download and install the Microsoft Authenticator App on mobile (Android and iOS)
  9. Open the app and from the top right menu, choose Add Account – Work or School Account
  10. Scan the QR code
  11. Now it will register the account on the mobile and you will see a 6 digit code which keeps changing every 30 seconds (does not require internet connection)

    Mobile account registered showing authentication code

  12. Now click Next on the browser side.
  13. You will now receive an notification on the mobile phone.
    Choose the Approve option.

    image

  14. Now the MFA is configured.
    Please note, the displayed 6 digit number is NOT REQUIRED to be entered anywhere. This is because, we are using the Receive Notification for Verification option.
  15. In the next step, it will ask another number for verification in case you lose your mobile. Add a different number here.  Click Next.

Special password for Outlook and Skype for Business

Outlook client and Skype FB does not support MFA. Your regular account password will stop working as soon as MFA is configured. Outlook will keep asking for your password and your regular password will not work. Now you have to use a special password.

That is the one shown to you in the next dialog as Step 4. Copy that password and use the same password it for Outlook and SFB. Use one password for laptop and one for desktop / mobile, etc.

If you use any ActiveSync client on mobile, that will also require a password. Technically you can use this password, but it is better to create another one.

How to do that? Go to Portal.Office.com, click on your photo, go to My account – Security – You will see a Create App Passwords option. Create a new one from there and use it.

User: Regular Office 365 MFA login

Now onwards, MFA is enabled. Now login using two steps

Step 1: Login using UID PWD as usual.

Step 2: Immediately, you will receive the Approval notification on mobile.

Congratulations

Chances of your account being hacked reduced by 99% now.

Share this with everyone you love and make their digital lives also safer.

Lock picture

Internet speed test with Fast.com

Very short blog. Speedtest.net or dslreports.com are commonly used for checking Internet speed. Here is https://fast.com as a quick and ad-free alternative. Try it out. I find it to be the best Internet speed test out there.

It is created by Netflix. They wanted users to have a quick way to check bandwidth with no bloatware around it. It also performs what is called as a “Loaded latency” test – a modified Ping test.

fast.com speed test results

Click Settings to adjust how long it tests the speed. This is useful if you expect fluctuation in the speed over time.

Power BI Workshop : 13 Oct 2018, Mumbai

Announcing second Power BI Workshop.

Saturday, 13 Oct 2018                9 am to 5 pm, Mumbai

Waterstones Hotel, behind The Lalit Hotel, near International Airport, Mumbai

INR 22,000 + taxes per participant

Register Here

Amazing Value
  1. Full, 6-hour video recording of the entire session which can be used to train more people internally
  2. Email support for 2 months
  3. Exercises with sample files
  4. Online, 2-hour follow up session
  5. Work with your own data

You must bring your own laptop. Additional software needs to be installed BEFORE arriving for the event.

Power BI Workshop Content
  1. Disadvantages / Pitfalls of data analysis in traditional Excel
  2. Understanding the Data Model
  3. Good vs Bad data
  4. Good data checklist
  5. Data Import and Cleanup
  6. Web data import
  7. Combining data from folder files
  8. Combining data from sheets
  9. Eliminating VLOOKUP
  10. Handling millions of rows
  11. Data modeling
  12. Creating Relationships
  13. Creating Interactive Dashboards
  14. Grouping
  15. Time Intelligence
  16. Introduction to DAX
  17. Power BI portal
  18. Choosing the right visualization
  19. 3D maps using Power Map
  20. Sharing reports
  21. English language Q&A
  22. Bookmarks and storytelling
  23. Custom visuals
Who should Attend?
  • Anyone who spends lot of time with Excel creating reports, charts and analyzing data.
  • If you use any other BI tools like Tableu, Qlik, BO, Cognos, etc.
  • If you work extensively with Pivot Tables
Who should NOT attend?

If you want to learn DAX language, specifically, you should NOT attend this workshop.
This workshop is designed for people who have no exposure to Power BI in the past. The objective is to migrate them from the painful manual Excel based processes and legacy charts to the interactive data visualizations  and dashboards using Power BI.

Learn from the Guru

Dr Nitin Photo for Power BI Workshop

Dr. Nitin Paranjape has coached over 330,000+ professionals across 18 countries. He is recognized as the Most Valuable Professional by Microsoft, for 15 years. Dr. Nitin is a coveted speaker with a unique humorous and motivating style of teaching. Detailed profile

Dr. Nitin’s work on Analytics

50+ Data Analytics Blog articles
Power BI video for beginners
Shadow Analytics video for CIOs
Data Analytics Webinar
Power BI for developers video

You will be able to …
  1. Create your own interactive dashboards using Power BI
  2. Understand data quality problems and clean up data efficiently
  3. Combine data from multiple sources and create an optimal data model
  4. Choose the right visualizations to represent data in a meaningful way
  5. Design interactions within the data to simplify and amplify the usefulness of data
Venue

Waterstone Hotel
Behind The Lalit, Near International Airport, Mumbai.
Valet Parking Available

Power BI Workshop is subject to cancellation due to inadequate number of participants or factors beyond our control.

In case of cancellation, full refund will be provided.

Store files in Office 365 – Best Practices

(Reading time 3 min ) This article provides concise instructions on where to store files when you have Office 365 E3 or above in your organization. There are multiple places and apps within Office 365 where files can be stored. But there is no clarity about which file goes where.  Here is a simple guide for everyone.

where to store files poster

Continue reading Store files in Office 365 – Best Practices