Category Archives: Uncategorized

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.

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!
  7. List of Microsoft Teams connectors

Excel Table AutoFill Formulas not working

Table has many benefits. One of them is Table AutoFill Formulas. If you add a formula in any table column, it copies the formula automatically. Further editing of the formula also is automatically copied to all other cells in the column. Sometimes, the AutoFill stops working. How to re-enable this feature? Here are the instructions
(Reading time 3 min)

Continue reading Excel Table AutoFill Formulas not working

Power BI Natural language Q&A – Type a question and create a report

Power BI Portal offers an amazing new way of creating reports. You can just type a question like “show total amount by country and by year”. Power BI now analyzes the raw data and creates a visual report instantly. No drag drop required. It needs to be seen to be believed.  Take a look at this video:

This video is part of my new Power BI course on Udemy – Pivot Table to Power BI.  This is my first online course and therefore the learning curve has been very steep.  However, I am just about done with content creation and the course will be launched very shortly.  Stay tuned for further announcements!

How to Eliminate VLOOKUP using Relationships in Power BI

VLOOKUP is one of the most commonly used functions in Excel.  However, it comes with its own set of problems:

  • It increases the file size
  • It consumes lots of processing power, making things slower
  • It is limited to a single table.  This means you cannot use VLOOKUP to search for a value in a different table or sheet
  • It only looks right
  • It can only handle a single criteria
  • If the lookup column contains duplicate values, it will match the first value only

Continue reading How to Eliminate VLOOKUP using Relationships in Power BI