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

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