Very short blog. Speedtest.net or dslreports.com are commonly used for checking Internet speed. Here is https://fast.com as a quick and ad-free alternative. Try it out. I find it to be the best Internet speed test out there.
It is created by Netflix. They wanted users to have a quick way to check bandwidth with no bloatware around it. It also performs what is called as a “Loaded latency” test – a modified Ping test.
Click Settings to adjust how long it tests the speed. This is useful if you expect fluctuation in the speed over time.
Here is a list of Macros I have written for various Office tools. Usually we feel that any repetitive task requires a macro. That is a wrong concept. Typically, repetitive tasks indicate that the method you are using is inefficient. Usually there is an efficient way to do the same job – which eliminates the repetition.
Continue reading Macros Knowledge Pack
Recently a customer asked me to compare SharePoint vs. Teams. Customer found my reply clear and concise explanation of the key points. Therefore, I am posting it as an article. (Reading time 4 min) Continue reading SharePoint vs. Teams
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
- Full, 6-hour video recording of the entire session which can be used to train more people internally
- Email support for 2 months
- Exercises with sample files
- Online, 2-hour follow up session
- 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
- Disadvantages / Pitfalls of data analysis in traditional Excel
- Understanding the Data Model
- Good vs Bad data
- Good data checklist
- Data Import and Cleanup
- Web data import
- Combining data from folder files
- Combining data from sheets
- Eliminating VLOOKUP
- Handling millions of rows
- Data modeling
- Creating Relationships
- Creating Interactive Dashboards
- Time Intelligence
- Introduction to DAX
- Power BI portal
- Choosing the right visualization
- 3D maps using Power Map
- Sharing reports
- English language Q&A
- Bookmarks and storytelling
- 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 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 …
- Create your own interactive dashboards using Power BI
- Understand data quality problems and clean up data efficiently
- Combine data from multiple sources and create an optimal data model
- Choose the right visualizations to represent data in a meaningful way
- Design interactions within the data to simplify and amplify the usefulness of data
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.
While working with Power BI we often need to convert Seconds to Duration. This is easily done in Excel just by applying the formatting code “HH:MM:SS”. Unfortunately in Power Query or DAX, this is not possible. Here is the solution:
Continue reading Power BI Seconds to Duration
(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.
Continue reading Store files in Office 365 – Best Practices
Grouping means combining multiple items into fewer items. It helps us consolidate and summarize things to understand them at a higher level of granularity. Let us see how to use Power BI Grouping done easily and quickly. This is useful for Ageing Analysis, Bin or Bucket Analysis, week / custom date range analysis.
Continue reading Power BI Grouping
Simple but useful stuff. Now, Outlook supports Three Time Zones in the Calendar. To set the time zones, right click on the time display in Calendar and choose Change Time Zone… or go to File – Options – Calendar – Time Zones. If you work with customers or your own teams globally, this can be a very useful feature.
Continue reading Three Time Zones in Outlook
This workshop was conducted on 26th May 2018 at Mumbai, India.
35 participants from 12 organizations participated in the program.
The average feedback was 4.7 out of 5.
Continue reading Power BI Workshop
This is a commonly asked question. I will try to answer it in the simplest possible manner. Of course, this is as of May 2018. Things change very fast. So please check online for the latest status. Power BI Free does exist. In two forms. One is built into Excel and one is a subscription option. Continue reading Is Power BI Free ?