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
You must bring your own laptop. Additional software needs to be installed BEFORE arriving for the event.
Power BI Workshop Content
Who should Attend?
Who should NOT attend?
If you want to learn DAX language, specifically, you should NOT attend this workshop.
Learn from the Guru
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
You will be able to …
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.
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.
As discussed in the earlier article, we can now Change Pivot Defaults. Here is a detailed video which covers how to change defaults.
In addition, learn a new, smart way of keeping commonly used pivot layouts in a simple Excel file and use them on demand. Something like a Pivot layout template.
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)
As you know, I recently published a Power BI Desktop course on Udemy. A few days ago, I received a message from a potential student, Andrew, asking whether taking this course would help him. He wanted to know why Excel-based Power BI is not covered in my course.
Date grouping offers lots of flexibility which would satisfy your business needs. Learn how to group dates by different levels of granularity (year, quarter, month, week, day, hour) without adding more functions in Pivot Table.
July is almost over. Which means that today is the last chance to get the Amazing Mouse ebook for $4.95 with the promo code JULYPROMO.
Buy The Amazing Mouse here
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!
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
The Amazing Mouse eBook
Learn 300+ powerful ways to use the mouse efficiently with
MS Office. Save at least 10 minutes & reduce the risk of arthritis!
PDF format, 2 MB