Haris Mehmood Zaman

If you are in the business of eCommerce then you definitely run your ads with Facebook. So, for this time I have covered the Facebook Ads with StitchData. Let's dive into it.

- Ads Insight
To get the data of Facebook Ads insight, I have used the StitchData to fetch the data from Facebook and dump into Azure SQL Data Warehouse. For this, I have used the SQL Data Warehouse from the Azure portal. The integration that I have made to get the final data of Facebook Ads, I build the… Show more

If you are in the business of eCommerce then you definitely run your ads with Facebook. So, for this time I have covered the Facebook Ads with StitchData. Let's dive into it.

- Ads Insight
To get the data of Facebook Ads insight, I have used the StitchData to fetch the data from Facebook and dump into Azure SQL Data Warehouse. For this, I have used the SQL Data Warehouse from the Azure portal. The integration that I have made to get the final data of Facebook Ads, I build the connection between StitchData and Azure SQL Data Warehouse. In this, StitchData will fetch the data from Facebook Ads API and dump into SQL Data Warehouse. Then the other connection that I have made is in between the SQL Data Warehouse and Power BI. In this, Power BI will fetch the data from SQL Data Warehouse. Now we have the final data in our hand so on top of the page in cards I have shown the numbers of impression, reach and clicks and all of these three things are also slit by all the campaigns. And yet all of the campaigns also have the breakdown with the amount of spend that they have.

Tool utilized;
- Azure Portal
- Microsoft Power BI
- Aure SQL Data Warehouse
- StitchData
- Facebook Ads Insight API Show less

Google analytics is one of the major analytics dashboards for eCommerce. It has a very detailed analysis of each and every audience. Let's connect the Power BI with Google Analytics.

- Audience by Sale
The audience we named as customers so on the top page in cards we show the customers, new customers, current year and last year sales and the growth as well. The pie chart is best to show the percentages of customers with local and international and also with new and returning… Show more

Google analytics is one of the major analytics dashboards for eCommerce. It has a very detailed analysis of each and every audience. Let's connect the Power BI with Google Analytics.

- Audience by Sale
The audience we named as customers so on the top page in cards we show the customers, new customers, current year and last year sales and the growth as well. The pie chart is best to show the percentages of customers with local and international and also with new and returning customers. Current year and last year sales also have a breakdown with all the categories that they have. We show the count of the item in each order as well so that we know out of all how many customers in percentage buy only one item or buy only two items or more. The world map is the one that shows the whole pictures of their sales with new and returning customers in one eye. We also have the breakdown of customers with devices as well.

Tool utilized;
- Microsoft Power BI
- Google Analytics and its API Show less

- Audience Overview
This report is different from "Audience by Sale", in this we will show the actual users, not the customers. In simple words, I have replicated the whole Google Analytics into Power BI. Like, visitors, new visitors, no. of sessions/user, avg. session user, bounce rate etc. Have a breakdown with local and international and also with new and returning visitors. All the main cards have a split in local and international till the city level. Everything is also segmented with… Show more

- Audience Overview
This report is different from "Audience by Sale", in this we will show the actual users, not the customers. In simple words, I have replicated the whole Google Analytics into Power BI. Like, visitors, new visitors, no. of sessions/user, avg. session user, bounce rate etc. Have a breakdown with local and international and also with new and returning visitors. All the main cards have a split in local and international till the city level. Everything is also segmented with the device as well and at the end, we have shown the trend of all the users that they have on their website.

- Shopping Behaviour
Out of all the Google Analytics report, shopping behaviour is one of the best report that I'm proud of. In this, I have shown the whole trend of the purchase from start to end. The flow goes as All Sessions then Product View then Add to Cart then Checkout then Transaction. Each and every step have a percentage of in and out. Like, how many percentages of people are flowing from step one to step two and from step two to further and out of all these how many of them are gone and at what stage they have gone from the site. In this, the simple thing is showing is Cart Abandonment % and Checkout Abandonment %.

Tool utilized;
- Microsoft Power BI
- Google Analytics and its API Show less

Inventory and its management are one of the major things for any retail business. I'm very keen to learn and develop the report for the inventory. So, I dig into the knowledge with my lead for the inventory report and here they are;

- Inventory Overview
Business type, Regions and stores, Categories and their subcategories, these are the major segment for the inventory report. We have shown the quantity, cost and also the value of their inventory by these segment. Value is further… Show more

Inventory and its management are one of the major things for any retail business. I'm very keen to learn and develop the report for the inventory. So, I dig into the knowledge with my lead for the inventory report and here they are;

- Inventory Overview
Business type, Regions and stores, Categories and their subcategories, these are the major segment for the inventory report. We have shown the quantity, cost and also the value of their inventory by these segment. Value is further categorized in Retail value, Value with tax and without tax. Have also calculated the inventory days and the turn over ratio, inventory days are like the on-hand inventory for the number of days. Then we have shown the movement of Quantity, Cost and Value of their whole business by all the categories and stores. Visualization of cost and value with the contribution of all their business type and also with all their categories were also there.

- Stock View
Compare the sales with the stock is the beauty of this report. Eye target cards were shown the current on-hand value, on-hand quantity with the sales of current and last year. Then we have the visualization of quantity and value by their categories, size and colours. Stores were also be shown in quantity sold and also with the percentages of their sold quantity. Each and every store have it's own stock days calculation with the flush out rate.

- Stock Aging
Stock Aging, as the name says it shows the age of all the stock that they have on their stores, it's on the basis of FIFO. We have made the days bucket as 1-15 days, 15-30 etc. this thing has been shown with all their stores and categories. The bucket has the value for visualization as quantity, cost and value.

Tool utilized;
- Microsoft Power BI
- Microsoft Dynamics Show less

- Overall Summary
First, let's dig into the Overall Summary report for the Executive Level. On the top, we have cards that show the whole business in front of the eye. The card's shown Sales, Gross Profit, Sale Growth, Growth of Gross Profit, etc. all these things are shown in term of value and also in terms of percentages as well, all these values are in comparison with the last year data too. Then we have the Monthly Overview of the Sales with Targets. We also have sales with Discounted… Show more

- Overall Summary
First, let's dig into the Overall Summary report for the Executive Level. On the top, we have cards that show the whole business in front of the eye. The card's shown Sales, Gross Profit, Sale Growth, Growth of Gross Profit, etc. all these things are shown in term of value and also in terms of percentages as well, all these values are in comparison with the last year data too. Then we have the Monthly Overview of the Sales with Targets. We also have sales with Discounted and Non-discounted days. The sales numbers are also shown by their Categories and also by their Regions, by the way, Regions and Categories also have the target comparison too. As this is the eCommerce so we have segmented all the measures with the local and international and the international will also have the drill down to the city level. Then we have the Gross Profit breakdown by their Categories and at the end, I have shown the current sales number in Line Chart with the comparison of the last year sales number of that same day and at the hover of that Line Chart, they will get the breakdown of their sale numbers by their categories.

- Detail Analysis
Now we have the detail analysis tab. In this, I have shown the Sales, Sales Growth, Gross Profit and Gross Profit Growth by Category, all these things are shown to the subcategory level 1, subcategory level 2 till the bar code level. Quantity and Price analysis by Categories is also the main thing in this and it is shown by the value and also by the percentages. We have also shown the average selling price of each of the bar code and how the change in price make an impact in quantity and sale. Campaign analysis with discounted and non discounted days was also there, we have also shown the average daily sale of the regular and the discounted days. Gross profit is also been segmented by discounted and non discounted days.

Tool utilized;
- Microsoft Power BI
- Microsoft Dynamics
- Microsoft Excel Show less

- Elasticity
Elasticity is like the brain of all reports, it has all the major KPI's in it. Sales detail with discount slabs, we have made discount slabs and shown quantity, sales, gross profit and sales contribution with some extra measures as well. We have also created the price slabs and segmented the previous measures by categories. With the price slabs, we have also give sales percentage, by this they can easily understand that on which price slab they were getting the highest sale and… Show more

- Elasticity
Elasticity is like the brain of all reports, it has all the major KPI's in it. Sales detail with discount slabs, we have made discount slabs and shown quantity, sales, gross profit and sales contribution with some extra measures as well. We have also created the price slabs and segmented the previous measures by categories. With the price slabs, we have also give sales percentage, by this they can easily understand that on which price slab they were getting the highest sale and this same case have to be done with discount slabs as well so that they will easily understand which discount slab is giving them the highest sale with highest gross profit. There was a timeline of their whole fiscal year that shows everything in just a couple of seconds. We have one graph in it that shows sales, quantity and gross profit with discount slabs, in this visualization they will get to know which slab is giving them the highest profit with less sale and quantity, also there are many combinations that can be visualized with these three measures as well.

- Sales Analysis
Sales analysis is the report in which they will check the sales against return and we have also calculated the sales return ratio as well. With all the categories we have also seen the quantity sold, quantity sold percentages, sales, stock days and the flush out rate that we have against that category. In this, we have also shown the average selling price too. Visualization of the local and international sales was also there, they also have the eCommerce affiliate that you can say, like Daraz etc. so they were checking the sales number by those affiliates too. Cart value and the number of products on an average each cart have were also there with local and international. You can easily guess the analysis in your mind now!

Tool utilized;
- Microsoft Power BI
- Microsoft Dynamics
- Microsoft Excel Show less

It's been my luck that I got the chance to design the Dashboard for one of the biggest retailer in Pakistan. All the dashboard's in this project are in comparison with the previous data, I mean the last year data. I have designed several reports in this project so let's get into it.

- Overall Summary
First, let's dig into the Overall Summary report for the Executive Level. On the top, we have cards that show the whole business in front of the eye. The card's shown Sales, Gross Profit,… Show more

It's been my luck that I got the chance to design the Dashboard for one of the biggest retailer in Pakistan. All the dashboard's in this project are in comparison with the previous data, I mean the last year data. I have designed several reports in this project so let's get into it.

- Overall Summary
First, let's dig into the Overall Summary report for the Executive Level. On the top, we have cards that show the whole business in front of the eye. The card's shown Sales, Gross Profit, Sale Growth, Growth of Gross Profit, etc. all these things are shown in term of value and also in term of percentages as well, also all these values are in comparison with the last year data too. Then we have the Monthly Overview of the Sales with Targets. We also have sales with Discounted and Non-discounted days. The sales numbers are also shown by their Categories and by their Regions, by the way, Regions and Categories also have the target comparison too. Then we have the Gross Profit breakdown by their Categories and at the end, I have shown the current sales number in Line Chart with the comparison of the last year sales number of that same day and at the hover of that Line Chart, they will get the breakdown of their sale numbers by their categories.

Tool utilized;
- Microsoft Power BI
- Microsoft Dynamics
- Microsoft Excel Show less

- Detail Analysis
Now we have the detail analysis tab. In this, I have shown the Sales, Sales Growth, Gross Profit and Gross Profit Growth by Categories, all these things are shown to the subcategory level 1, subcategory level 2 till the bar code level. Quantity and Price analysis by Categories is also the main thing in this and it is shown by the value and also by the percentages. We have also shown the average selling price of each of the bar code and how the change in price make an impact… Show more

- Detail Analysis
Now we have the detail analysis tab. In this, I have shown the Sales, Sales Growth, Gross Profit and Gross Profit Growth by Categories, all these things are shown to the subcategory level 1, subcategory level 2 till the bar code level. Quantity and Price analysis by Categories is also the main thing in this and it is shown by the value and also by the percentages. We have also shown the average selling price of each of the bar code and how the change in price make an impact in quantity and sale. Campaign analysis with discounted and non discounted days, have also shown the average daily sale of the regular and the discounted days. Gross profit is also been segmented by discounted and non discounted days. Top and bottom 10 stores have been shown by their sales, sales in growth, quantity that they were sold and also the contribution that they have in the overall business.

- Sales and Gross Profit by Region
In this report, I have segmented the sales and gross profit by their categories, stores and regions. We have also shown sales growth and profit growth as well. All the stores were listed with the sales number, gross profit, per day sale of that store has, what sort of growth that they make and their targets that were provided by the company. Targets were also shown by their achievement value and achievement percentages. Rent to sale ratio of all the stores is also the thing that has to be considered for this, I have also calculated the sales per square foot for all the stores as well. Basket value and basket size are also been shown so that they will get the better idea of the footfall that they have and the average selling price that they get by their customers. All the stores also have the breakdown of their sales and sales growth by category.

Tool utilized;
- Microsoft Power BI
- Microsoft Dynamics
- Microsoft Excel Show less

- Elasticity
Elasticity is like the heart of all the reports, it has all the major KPI's in it. The visualization of Sales detail with discount slabs was shown quantity, sales, gross profit and sales contribution with some extra measures as well. We have also created the price slabs and segmented the previous measures by categories. With the price slabs we have also give sale percentage by this they can easily understand that on which price slab they were getting the highest sale and this… Show more

- Elasticity
Elasticity is like the heart of all the reports, it has all the major KPI's in it. The visualization of Sales detail with discount slabs was shown quantity, sales, gross profit and sales contribution with some extra measures as well. We have also created the price slabs and segmented the previous measures by categories. With the price slabs we have also give sale percentage by this they can easily understand that on which price slab they were getting the highest sale and this same case we have done with discount slabs as well so that they will easily understand which discount slab is giving them the highest sale with highest gross profit. There was a timeline of their whole fiscal year that shows everything in just a couple of seconds. We have one graph in it that shows sales, quantity and gross profit with discount slabs, in this visualization they will get to know which slab is giving them the highest profit with less sale and quantity, also there are many combinations that can be visualized with these three measures.

- Campaign Analysis
Campaign analysis is one of the best challenges for us. It's like the two-time table hitting the same sales table and shows the result with different angles. They don't have any fix date for the launches of any campaign. Now, when they want to see the sale, they want to be by date and also by the campaigns. By campaign means, compare the day one with day one of the same campaigns. They also want to see the per day sale by date and by the campaign and this same case goes with the category and region as well. In this one, the sale KPI is split the data into regular and discounted days and also split them by all the campaigns as well.

Tool utilized;
- Microsoft Power BI
- Microsoft Dynamics
- Microsoft Excel Show less

- Return on Investment (ROI)
This report is only set for the Outlets that they have. They have the separate categories of outlets, like Mall Outlets, Standalone Outlets and Franchises etc, they have seen all their major KPIs by these categories. They also have their internal Store Status and Store Profile by time and store potential.

- Sales Analysis
Sales analysis is the report in which they will check the sales against return and we have also calculated the sales return ratio as… Show more

- Return on Investment (ROI)
This report is only set for the Outlets that they have. They have the separate categories of outlets, like Mall Outlets, Standalone Outlets and Franchises etc, they have seen all their major KPIs by these categories. They also have their internal Store Status and Store Profile by time and store potential.

- Sales Analysis
Sales analysis is the report in which they will check the sales against return and we have also calculated the sales return ratio as well. With all the categories we have also seen the quantity sold, quantity sold percentage, sales, stock days and the flush out rate that we have against that category, we have also shown the average selling price too. Sales and return are also shown by the regions as well as by the stores so that we can easily check on which store we have the highest number of returns and on which store we have the highest number of sales. If there is the highest number of returns in any of their specific store then they will set the team to check all the things so that they can make it better.

Tool utilized;
- Microsoft Power BI
- Microsoft Dynamics
- Microsoft Excel Show less

In this POC, we have built the multiple Dashboard on Power BI. All the dashboards cover the detail with respect to last year and also these dashboards are only for the executive level.

- Sales Dashboard
It covers the total sales, number of invoices, basket value, their targets, total discounts they gave and what's their gross profit etc. Some of the calculation are in percentages as well.

- Basket Value
It has the trend of basket value on a daily basis so that they can… Show more

In this POC, we have built the multiple Dashboard on Power BI. All the dashboards cover the detail with respect to last year and also these dashboards are only for the executive level.

- Sales Dashboard
It covers the total sales, number of invoices, basket value, their targets, total discounts they gave and what's their gross profit etc. Some of the calculation are in percentages as well.

- Basket Value
It has the trend of basket value on a daily basis so that they can easily get the idea of their basket value when they run the campaigns. The basket value and the basket size also have the calculation by Regions and by their stores.

- Sales Detail
It has the daily sales trend, sales with respect to each and every store, it also the show's the sales by their category. The main thing that was shown in this dashboard is that we have shown the sales with the price slabs so that they can get better ideas of their pricing. It also covers the sales contribution by their stores and by their categories.

- Sales VS Target
The KPI's that this dashboard has, sales vs targets by category, sales vs targets by regions and stores. We have also done the calculation of targets achievement percentage so that they will know how much they have achieved so far. We have also listed their top and bottom stores with respect to target achievement.

- Gross Profit
This dashboard covers their gross profit with COGS, shows the gross profit by region and stores. It also shows the gross profit and COGS by their categories. The contribution of gross profit is also shown by the regions and also by their categories.

- Inventory
Inventory dashboard covers the total values of their inventory that were currently kept in their stores or their warehouses, it also covers the total quantity as well. Both value and quantity are segmented by categories and categories within stores.

Tool utilized;
- Microsoft Power BI
- Microsoft SQL Server Show less

Here, I work as a trainee so I'm not authorized to work on a project solely. My seniors give me some data of the Telecommunication company and guided me to design the Ware House for that given data. It took me 3 attempts to design the Ware House, the data was in Excel of some limited period. In that data, it almost covers all the Dimensions rules like SCD, Role Playing, Degenerate, Confirmed, Junk etc. I have also run the ETL for this data as well, for the ETL I have used the Microsoft SQL… Show more

Here, I work as a trainee so I'm not authorized to work on a project solely. My seniors give me some data of the Telecommunication company and guided me to design the Ware House for that given data. It took me 3 attempts to design the Ware House, the data was in Excel of some limited period. In that data, it almost covers all the Dimensions rules like SCD, Role Playing, Degenerate, Confirmed, Junk etc. I have also run the ETL for this data as well, for the ETL I have used the Microsoft SQL Server and SSIS. In SSIS, I have almost used all the transformation arithmetic, emails etc.

Tool utilized;
- Microsoft SQL Server
- Microsoft SQL Server Integration Service (SSIS)
- Microsoft Excel Show less

We all, the lover of cricket and we all want to know the news of about any of our favourite player
or team and from that news, our main interesting part is to know the Rating or How he/she is
playing within or outside the team. There were hundreds or even thousands of sites that can
give us the result of what we want about any of our favourite Cricket Player, but the way that we
show is totally different. Our aim and focus are to display the result/data in a Visual or… Show more

We all, the lover of cricket and we all want to know the news of about any of our favourite player
or team and from that news, our main interesting part is to know the Rating or How he/she is
playing within or outside the team. There were hundreds or even thousands of sites that can
give us the result of what we want about any of our favourite Cricket Player, but the way that we
show is totally different. Our aim and focus are to display the result/data in a Visual or Graphical
format because now a day’s this is a very interesting thing to show any sort of result or
report.

We have divided our report into Two sets. The first set of a report is showing the Career
Summary of the Player and the other one is showing the Comparison of the Two Players. For
the first set of the report, we have specifically defined the Cricket Players to whom we want to show
the data. Whereas, for the second set of a report we have specifically defined the set of
comparisons that we will do between the two players (including players and the comparisons).

There were so many Comparisons and the Analysis that we can see or do in a Career Summary
report and even in the Comparison level report as well. So, in a Career Summary report, we will
be going to compare;

Batting and Bowling Average by Years
Runs and Hundreds by Playing with Team
Batting and Bowling Average by Venue
Wickets and Runs by Years
Batting Rating
Bowling Rating

And now, in a Comparison level report, we have subdivided this into Three more levels. The first
one is having the report of All Rounder Players, the second one is having the report of Batsman and
the last third one is having the report of Bowler.

Tool utilized;
- Microsoft Power BI
- Microsoft Excel Show less