Mush Aziz

09/07/2024

Reach out me to resolve your needs.

05/03/2024

To learn about Excel, please reach out. I can teach you both Basic and Advanced Excel

03/09/2024

Using PowerBI, analysts and planners can see inventory Onhand and Sales side by side. We often want to see Inventory Onhand of bestsellers or sales of products we have high/low inventory of. In this video, we have the Onhand table, which shows how much of each SKU we have in stock at each location. We also have the Sales table, which has sales of each SKU at different locations.

First we create a visual for Onhand and Sales by dragging Location, Product Description, Quantity on Hand and Quantity Sold parameters

As there is no relation between the two tables yet, PowerBI starts showing the same quantity sold for all the locations.

To create relation for each SKU and location, we use the DAX formula "Concatenate" and combine Location and SKU. The newly created Locationsku column acts as the common column between the two tables.

Using the Relationship view, we connect "Locationsku". As PowerBI now understands the relation, it starts showing the right Quantity Sold.

We create a Pie chart and show the revenue contribution percentage by product.

We create a date slider. PowerBI automatically connects the slider with other visuals. As we move the slider and change the date, we see sold quantity and revenue percentage change.

This way we can see Onhand, Quantity Sold and Dollar Sales Amount for all products at any location within any timeframe.

02/29/2024

Analysts can use PowerBI to monitor key sales parameters. BI tools are very helpful to gain insight very quickly. Those who are proficient in Excel can find many similar features in PowerBI.

In this video, I have created a PivotTable (Matrix) inside PowerBI which shows sales by location and by associate. As the revenue amount was not in proper format in raw data, I went to the source table and selected the $ currency format.

Then I created a column chart showing sales by region to identify the besting to worst performing stores. PowerBI automatically sorted the sales numbers. I turn the data labels on.

Next, I created a pie chart showing revenue contribution by each sales rep. As I already have the dollar amount, I only kept the percentage of contribution.

PowerBI usually takes the entire date range if not specified. Here I only wanted first quarter of 2023. So I created a date slider and from the calendar view, I selected Jan 1, 2023 to March 31, 2023.

01/03/2024

Need help in 👨‍🏫 Excel from a Microsoft Certified Excel Expert? Reach out to me to learn 25 formulas, Pivot Tables, charts, data validation, formatting and more in 2.5 hours🚀. I offer both standard and customized lesson at $90. Learn virtually or On-site in Etobicoke.

09/28/2022

https://youtu.be/dVRdJwtpr0c

After watching the part 10 of the Data Analysis Using Excel Pivot Tables video series, you will learn to use timeline and slicers This video is part of the Advanced Microsoft Excel Training series which is essential for building a career in inventory management and data analysis. In this Advanced Excel Tutorial video, you will learn to accomplish the following

Convert data range to table
-Use slicer to select year
-Use slicer to select quarter
-Use slicer to select month
-Use timeline to select time range

This video is an essential part of learning how to build dashboard using Microsoft Excel. Please consider following me on Linkedin and subscribing to my Youtube Channel.

My Linkedin: www.linkedin.com/in/mushaziz/

View Mushtahir Aziz Rahman, CPIM’S profile on LinkedIn, the world’s largest professional community. Mushtahir Aziz has 5 jobs listed on their profile. See the complete profile on LinkedIn and discover Mushtahir Aziz’s connections and jobs at similar companies.

09/07/2022

After watching the part 8 of the Data Analysis Using Excel Pivot Tables video series, you will learn to calculate sales by salesperson, commission and create pivot chart to show the information. This video is part of the Advanced Microsoft Excel Training series which is essential for building a career in inventory management and data analysis. In this Advanced Excel Tutorial video, you will learn to accomplish the following

-Apply "If" formula for commission. 4.5% for $150+, 3% for anything less.

-Use fill to calculate commission for each line

-Calculate and categorize sales by salesperson using Pivot Table

-Use a pivot bar chart to show commission by salesperson

This video is an essential part of learning how to build dashboard using Microsoft Excel. Please consider following me on Linkedin and subscribing to my Youtube Channel.

After watching the part 8 of the Data Analysis Using Excel Pivot Tables video series, you will learn to calculate sales by salesperson, commission and create...

08/28/2022

After watching the part 7 of the Data Analysis Using Excel Pivot Tables video series, you will learn to calculate gross profit, margin rate and create pivot chart to show the information. This video is part of the Advanced Microsoft Excel Training series which is essential for building a career in inventory management and data analysis. In this Advanced Excel Tutorial video, you will learn to accomplish the following

-Calculate Gross Profit for each Product

-Use "Calculated Field" to calculate Margin Rate

-Use Combo pivot chart to show Margin and Margin Rate

This video is an essential part of learning how to build dashboard using Microsoft Excel. Please consider following me on Linkedin and subscribing to my Youtube Channel.

My Linkedin: www.linkedin.com/in/mushaziz/

After watching the part 6 of the Data Analysis Using Excel Pivot Tables video series, you will learn to calculate gross profit, margin rate and create pivot ...

08/24/2022

After watching the part 6 of the Data Analysis Using Excel Pivot Tables video series, you will learn calculating cost information and creating pivot chart. This video is part of the Advanced Microsoft Excel Training series which is essential for building a career in inventory management and data analysis. In this Advanced Excel Tutorial video, you will learn how to answer the following questions.

-Calculate total cost for each product type

-Sort products by cost

-Calculate % of cost by product

-Calculate cumulative % of cost by product

-Create a pivot pie chart for different types of cost

This video is an essential part of learning how to build dashboard using Microsoft Excel. Please consider following me on Linkedin and subscribing to my Youtube Channel.

After watching the part 6 of the Data Analysis Using Excel Pivot Tables video series, you will learn calculating cost information and creating pivot chart. T...

08/18/2022

After watching the part 5 of the Data Analysis Using Excel Pivot Tables video series, you will learn to Vlook up, Xlook up, Index Match and Iferror fomula in the same example. This video is part of the Advanced Microsoft Excel Training series which is essential for building a career in inventory management and data analysis. The video will also help you to answer Pivot table related interview questions. In this Advanced Excel Tutorial video, you will to do the the following tasks

- Use Vlook up from different sheet in Excel to get unit cost

- Use Xlook up to get unit cost. Understand the difference between Xlook up and Vlook up in Excel

- Learn Index-Match formula with example and get the same unit cost

- Use If-Error formula to set condition for value not found

This video is an essential part of learning how to build dashboard using Microsoft Excel. Please consider following me on Linkedin and subscribing to my Youtube Channel.



https://www.youtube.com/watch?v=2bXxNx9OcZo

After watching the part 5 of the Data Analysis Using Excel Pivot Tables video series, you will learn to Vlook up, Xlook up, Index Match and Iferror fomula in...

08/16/2022

After watching the part 4 of the Data Analysis Using Excel Pivot Tables video series, you will learn ranking and filtering top items. This video is part of the Advanced Microsoft Excel Training series which is essential for building a career in inventory management and data analysis. In this Advanced Excel Tutorial video, you will learn how to answer the following questions.

- Rank products by Turns
- Rank products by sales
- Only display top 6 in terms of sales

This video is an essential part of learning how to build dashboard using Microsoft Excel. Please consider following me on Linkedin and subscribing to my Youtube Channel.

After watching the part 4 of the Data Analysis Using Excel Pivot Tables video series, you will learn ranking and filtering top items. This video is part of t...

08/06/2022

After watching the part 3 of the Data Analysis Using Excel Pivot Tables video series, you will learn how to calculate Sales, Percentage of Sales and Cumulative Percentage. This video is part of the Advanced Microsoft Excel Training series which is essential for building a career in inventory management and data analysis. In this Advanced Excel Tutorial video, you will learn how to answer the following 3 questions.

- How much sales does each product generate?

- What is the percentage of sales for each products?

- What is the cumulative percentage of Sales for all the products?

This video is an essential part of learning how to build dashboard using Microsoft Excel. Please consider following me on Linkedin and subscribing to my Youtube Channel.

After watching the part3 of the Data Analysis Using Excel Pivot Tables video series, you will learn how to calculate Sales, Percentage of Sales and Cumulativ...