Biz_Excel

Digging into Olympic history datasets.
The female and male participant across the Summer and winter.
The records of the country with highest successful participant in all categories of the events schedule by the Olympics.
The most successful Athletics based on the country represented.
All the task being analyzed and visualized on a Dashboard.

Wow 😲 Am happy to close first deal with the client.
He asked me to help him dig deep on data comprises of 4 agents across the region in the state stating he wish to know how the agents drive in sales in respect to each of the year from 2015-2018 knowing the type of products and how the customer which to pay for the product.

.

Quick tips on Sumifs/sum-if function in Excel?
Sum-if allow to sum a value/measure on a single category while Sumifs allow to sum in multiple categories.
The syntax is
Sum-if =(Sum-range, Criteria-range,range)
Sumifs =(Sum-range, Criteria-range, range1,...., Criteria-range (n), range (n) ).
Sumif/Sumifs it's like calculate in Dax function.