Starting a new video series on Power BI. Here is the first video: Power BI Data Import.
We spend lot of time in data cleaning. But there is no simple definition of exactly what clean data means. Therefore, I created a simple 10 item checklist. If all 10 items are correct, data is clean. Simple and easy to use.
10 rules for Clean data
Remember, here we are talking about input data – not output (reports).
- Each column must have a heading
- No blank headings
- No duplicate headings
- No formulas in headings
- No merged cells
- Each column must have ONE meaning
- Each column must have ONE type of data
- No subtotals or grand totals
- Formatting should not be used instead of data
- Data must grow vertically, not horizontally
Convert clean data to a Table
If you are using Excel, as soon as data is cleaned, convert it into a Table. Why? Here are the benefits of using Excel Tables – 13 articles.
This year, I thought of posting many simple, but highly efficient best practices as New Year Resolutions on LinkedIn.
Here is the list. Each one is just one image and a brief description. Have a look and let me know your feedback.
This is a jump start for using Office efficiently. It is called Office Efficiency Crash Course because it contains 120 “must know” things across Word, Excel, PowerPoint, Outlook, OneNote and OneDrive.
This session was conducted for 400+ MBA new joiners at WeSchool, Mumbai.
3 hr, 20 min video. Fast paced. With lot of demos.
Office Efficiency Crash Course Table of Contents
It is a long video. You may want to see a particular product. Here is the product specific Table of Contents. Click on the link to jump to that part in the video.
120 topics are covered. Here is the detailed table of contents. Continue reading Office Efficiency Crash course
This is a recording of the session conducted at WeSchool – Welingkar Institute of Management, Mumbai on 23rd Jun 2019. All business users will find this video useful. Work Efficiency Transformation using Office 365 is relevant to any organization using the Office 365 platform.
Duration: 3 hr 12 min
This video demonstrate efficient usage of various tools including Outlook, Excel, Power BI, OneDrive, Teams and Planner.
The audience consisted of 200+ working professionals pursuing the WeSchool MBA course. Smart and attentive audience. In spite of it being a Sunday, everyone was fully engrossed and interested in learning more. Special thanks to Prof. Pradeep Pendse who invited me to conduct the session, it was a pleasure addressing such a large and intelligent audience.
Table of Contents
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.
- What is Microsoft Teams
- When to use Microsoft teams
- When NOT to use Teams
- Notice the notifications
- How to reply in Teams – Common Mistake
- One person Team – how to use Teams alone!
- List of Microsoft Teams connectors
- How to handle too many Teams
- Use Teams Zoom
- Teams Call Mute Shortcut Shift + Ctrl + M
- Minimize button in Teams Screen Sharing
- Teams Private Channels Best Practices
- SharePoint vs. Teams
- Where to store files with Office 365
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)