Power BI Workshop

Saturday, 26 May, 9 am to 5 pm, Mumbai

Waterstones Hotel, behind The Lalit Hotel, near International Airport, Mumbai
INR 20,000 + taxes per participant

Limited seats. 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. Practice 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. Importing and cleaning up data using Power Query
  6. Get and Transform features
  7. Web data import and live refresh
  8. Combining data from files in a folder
  9. Combining data from multiple sheets
  10. Eliminating the use of VLOOKUP
  11. Large data handling using Power Pivot
  12. Creating dashboards using Power View
  13. Power BI Desktop usage scenarios
  14. Power BI portal
  15. Choosing the right visualization
  16. 3D maps using Power Map
  17. Sharing reports
  18. English language Q&A
  19. Bookmarks and storytelling
  20. 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 processes and legacy charts to the modern process of data visualization and interactive analysis 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.

Transforming Shadow Analytics

This content is relevant only if you are a CIO (or IT decision maker). Here is the video of the session I conducted at CIO Power List event on 4th May, 2018, at Conrad, Pune. Shadow Analytics has been around ever since “shadows” – also called end users – are around. Everyone knows about. Some people tried to eliminate it. Nobody succeeded.

This 30 minute video explains how to use Shadow Analytics as an opportunity to empower rather than restrict users and improve effective utilization of data.

Demos Included

The demos included in this Shadow Analytics video are:
Flash Fill, Insights, Explain the increase and Q&A.

Insights option in Insert menu of Excel

What is Shadow Analytics?

It is all kinds of data capture, clean-up, manipulation and report generation performed by end users without IT intervention.

If you generate a report from a business system (which is built or managed by IT), it is alright. But if you copy paste data from multiple such reports into Excel and then generate a new report, it becomes “Shadow Analytics”.

As you can imagine, it is difficult to eliminate it. Irrespective of how much time and effort you have spent on creating the most flexible ad-hoc reporting systems, it is impossible to provide every possible variation that users want. Therefore, Shadow Analytics has always been there and is likely to survive in the foreseeable future.

Problems associated with Shadow Analytics

Primarily two problems. It is extremely error prone and time consuming. There are lots of related problems. The root cause is that data is handled in a casual manner without regard for its recency and in a completely undocumented manner.

This can lead to wrong decisions, delayed decisions, increased operational risk and enormous wastage of precious time.

Summary

It is impossible to handle and correct the data sources and deliver data to users in a manner which is so easy that they stop doing the manual capture and clean-up altogether.

Once clean, accurate and updated data is available as input, creating reports can be done by end users in a more informed and productive manner.

Left hug Computer Right hug

Events from email in Outlook

This is a very convenient feature available in Outlook. You may be using it even without knowing about it. Outlook can analyze your incoming emails and create calendar entries (events) based upon them. Four categories are understood as of now, flight bookings, hotel reservations, car bookings and package delivery.

This is based upon machine learning algorithms – no human is looking at your emails. Once a mail is detected as an event, a calendar entry is created automatically. Here is an example of a travel booking.

image

This mail was automatically processed by Outlook and the following calendar event was created:

SNAGHTML533814b  image 

Check-in reminder

In addition, it created a reminder 3 hours before the departure time. That’s nice but there is more. Exactly 24 hours before the flight departure, I received an email reminder for checking-in. This reminder did not originate in my calendar. It came from a generic reminder service.

SNAGHTML5374b92

Customize automatic processing

To change these settings, go to Outlook web access – Options (the gears wheel) – Automatic processing. Notice that the Package Delivery option is not selected by default.

image

Although it sounds fairly simple, the internal working of this feature is quite complex. Why? Because there are thousands of different formats for hotel and flight booking mails. It has to understand the relevant fields and create the calendar events. This is where machine learning is helping us – behind the scenes.

Airplane

PowerPoint icons to shapes

PowerPoint provides 500+ icons in SVG format. I recently published a blog which has a downloadable version of all icons in a PPTX file. Scalable vector graphic format icons cannot be edited inside PowerPoint. You cannot treat them like any other PowerPoint shape. But now, we can convert icons into shapes. Once converted to shapes all the PowerPoint shape features available. You can also use the Merge Shapes option to combine or subtract shapes. Here is how you do it:

insert a new shape,  resize it as required , right click on it  and choose Convert To Shapes. 

image

Read the dialogue which appears and click  Ok.

2018-03-12_11-28-55

The icon may get converted to one or more shapes. If it has more than one shape, it will be in a grouped state. So it is a good idea to right click on it and try Ungroup. If Ungroup option is inactive, there is only one shape.

image

Here we have three shapes. Now the shapes can be used like any other PowerPoint shape.

What to do with the shapes?

Once Icons are converted to shapes, there are few things which can really add value. Color and animation. I will write separate blog for this but here is an example.

The icon above is from the Analytics category. It is a speedometer icon which is often used in performance management. Management dashboards showing KPIs often use this type of speedometer graphic. Here is how we can enhance the speedometer icon after it is converted to shapes.

image

With Animation, the needle can be made to move to show the current state of performance.

More stuff on icons coming soon…

What is Microsoft Teams

May be you already know this. But still, read for just 2 minutes more to clarify your thoughts.  Teams is an app which streamlines teamwork. That is the obvious definition. But this is an incomplete description.

Coordinating with multiple persons is Teamwork. Agreed. But there are a plethora of apps available to collaborate with others. What is special about Teams?

Teams is an app which helps you work with all types of Technologies. So it is not just teamwork with other people, it is with multiple technologies as well.

Continue reading What is Microsoft Teams

Microsoft Teams: Knowledge Pack

Here is a list of articles I have written so far about effective usage of Microsoft Teams.
If you would like me to cover some missing topic or a specific area of your interest, please post it as a comment. This is a live book. As I add more articles about Teams, this list will be updated.

image

  1. What is Microsoft Teams
  2. When to use Microsoft teams
  3. When NOT to use Teams
  4. Notice the notifications
  5. How to reply in Teams – Common Mistake
  6. One person Team – how to use Teams alone!

Microsoft Teams Conversation common mistake

Microsoft Teams is a convenient way of working with colleagues without cluttering mailboxes. You post a conversation inside the Teams app and others can reply to it.

The common mistake is that instead of replying to your question, people start a new discussion. Here is how you prevent the mistake. Click on the Reply button.

Teams - How to reply

Learn more about Microsoft Teams – Knowledge Pack.

Missing messages in Teams? Follow the channels.

Notification icon animation - showing the number bouncing to attract attention. If you are trying to use Microsoft Teams, you will face this practical problem. The problem is that all your team members must notice the messages that are posted in the Teams app. Nothing is visible in the Inbox. This may lead to missed messages and delayed responses.  Start noticing the notification!

 

Three steps

Continue reading Missing messages in Teams? Follow the channels.

When NOT to use Microsoft Teams

See this article to know When to use Microsoft Teams first. This article lists scenarios where using Teams is counterproductive or plain simple wrong!

Do not use teams if one or more of the items listed below are true.

  1. If there are too many people involved, do not use Teams. Technically, the limit is 2500. But you decide practically. Teams is designed for extensive interaction between team members. If there are lot of people, you cannot expect extensive interaction. Think about using Yammer. It is good for predominantly push and interaction-on-demand kind of functionality.
  2. If the team means the whole department and you already have a departmental Team Site in SharePoint. Use that site. Do not use Teams to create another Team. Why? Because, behind-the-scenes it creates another SharePoint site. Defeats the purpose.
  3. This one is obvious but still makes sense to mention it: If all team members do not have access to the Teams app, do not use Teams. In this case, you will need to do double communication manually. I will not call it inefficient usage – it is misuse.
  4. If the communication and coordination with the team is required but not critical, do not use Teams. Non-critical, but functionally necessary stuff can continue using traditional email.
  5. Do NOT use Teams unless every member is aware about its actual benefits. If you try to force it on ignorant people (Ignorant about Teams, I mean!) , it will not work. Educate them first. The best way is to show a nice and compelling demo.
    If only few people in the team use the Teams app and others do not, it defeats the purpose.
  6. If all members have not understood that they have to check the Teams app as frequently as they check for mails in the Inbox.
    The benefit of Teams is that it does not send anything to your inbox. Conversations and communication happens within the Teams app. If some members forget to see the activity in the app, they are effectively not working as a team.

That is all I can think of as of now. If you know more scenarios where Microsoft Teams is contraindicated, post them as comments.

 

 

 

 

Testing Quiz Feature. Pls Ignore.

 

Take Our Survey