09/07/2024
Reach out me to resolve your needs.
Mush Aziz
Share
Contact information, map and directions, contact form, opening hours, services, ratings, photos, videos and announcements from Mush Aziz, Tutor/Teacher, Central Etobicoke, ON.
09/07/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/
Mushtahir Aziz Rahman, CPIM - Supply Chain Coordinator - DYMON Storage | LinkedIn 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.
Part 8 | Data Analysis and Dashboard Building Using Microsoft Excel | Intermediate Excel Training 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/
Part 7 | Data Analysis using Excel Pivot Tables | Intermediate Excel Training 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.
Part 6 | Data Analysis using Excel Pivot Tables | Intermediate Excel Training 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
Part 5 | Learn to Use Vlook up, Xlook up, Index Match and Iferror formula in the Same Example 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.
Part 4 | Data Analysis using Excel Pivot Tables | Intermediate Excel Training 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.
Part 3 | Data Analysis Using Excel Pivot Tables | Intermediate Excel Training 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...
Want your school to be the top-listed School/college in Central Etobicoke?
Click here to claim your Sponsored Listing.
Click here to claim your Sponsored Listing.
Location
Category
Culinary Team
Attire
Website
Address
Central Etobicoke, ON