- 15
- 900
SMB Insights
เข้าร่วมเมื่อ 15 ก.ค. 2022
Welcome to SMB Insights
-----------------------------------------------
The main purpose of this channel is to help small and medium business owner to grow by using Data Analytics.
-----------------------------------------------
I share tips and tricks related to Data Science and Data Analysis related to small and medium businesses. I create short tutorial on how to use simple spreadsheets and bring necessary insights from Sales, Customer or Inventory Data.
------------------------------------------------
Follow for more useful content and subscribe.
-----------------------------------------------
The main purpose of this channel is to help small and medium business owner to grow by using Data Analytics.
-----------------------------------------------
I share tips and tricks related to Data Science and Data Analysis related to small and medium businesses. I create short tutorial on how to use simple spreadsheets and bring necessary insights from Sales, Customer or Inventory Data.
------------------------------------------------
Follow for more useful content and subscribe.
Showing Highest and Lowest Point on a Line Chart
Showing Highest and Lowest point on a line chart is very useful.
You can easily find out which month is your most profitable one
and which month is your least profitable one.
By identifying these two points, you can do further analysis to find out why....
But for any kind of business, you have to explore or find out the anomaly first.
After that you can take further action.
So, do not just show trends/ Try to show highest and lowest points to tell the clear picture.
Here is a demonstration video how they look and how you can create this in power BI.
#powerbi #linechart #tutorial
Facebook
📘 rayaaal/
Instagram
📸 zakirreyal
LinkedIn
💼 www.linkedin.com/in/md-zakir-hussain-khan-smb-insights
WhatsApp
📱 +8801922283313
Email
📧 kmdzakir92@gmail.com
You can easily find out which month is your most profitable one
and which month is your least profitable one.
By identifying these two points, you can do further analysis to find out why....
But for any kind of business, you have to explore or find out the anomaly first.
After that you can take further action.
So, do not just show trends/ Try to show highest and lowest points to tell the clear picture.
Here is a demonstration video how they look and how you can create this in power BI.
#powerbi #linechart #tutorial
📘 rayaaal/
📸 zakirreyal
💼 www.linkedin.com/in/md-zakir-hussain-khan-smb-insights
📱 +8801922283313
📧 kmdzakir92@gmail.com
มุมมอง: 4
วีดีโอ
Exploratory Data Analysis on Titanic - Part 1 | Extract Insights from Data
มุมมอง 31หลายเดือนก่อน
In this video, I perform Exploratory Data Analysis on Titanic Dataset. By watching this video you can understand how to extract insights from data. I have used Microsoft Excel to get the insights from Data. Facebook 📘 rayaaal/ Instagram 📸 zakirreyal LinkedIn 💼 www.linkedin.com/in/md-zakir-hussain-khan-smb-insights WhatsApp 📱 8801922283313 Email 📧 kmdzakir92@gmail.com...
Understanding CALCULATE Function in 10 Minutes!!!
มุมมอง 962 หลายเดือนก่อน
In this video, You are going to learn how CALCULATE changes the filter context compared to other DAX code #powerbi #dax #datanalysis
Don't just show Trend --- Try to tell a clear story through your visual
มุมมอง 92 หลายเดือนก่อน
Using a line chart is one of the best ways to show trends over time But simply presenting a chart is rarely enough. Today’s stakeholders have busy schedules, and they need insights that go beyond just data points. If we only give them a standard line chart, someone else might be needed to interpret what it means for the business. The true value of data visualization is unlocked when we tell a s...
Master Excel INDEX & MATCH in Bangla
มุมมอง 943 หลายเดือนก่อน
In this video, I have explained Exact match, approximate match, one way lookup and two way lookup using INDEX and MATCH function. In this 14 minute long video you will understand each and every concept clearly. I have used PowerPoint blackboard presentation and animation to make each and every concept more lucid. #excel #index #match #indexmatch #excel365
Extract Product and Price using Microsoft Excel 365 in Bangla | XLOOKUP, TEXTBEFORE, TEXTAFTER
มุมมอง 1534 หลายเดือนก่อน
In this video you are going to learn about how you can extract Product and Price from Delimiter using Microsoft Excel 365. You will know about latest formula such as XLOOKUP for lookup value and TEXTBEFORE, TEXTAFTER for extracting value from delimiter. Please like, share and subscribe to my TH-cam channel for more Microsoft Excel and Power BI content.
Tutorial: How to Highlight Store in Power BI in Bangla | Power BI এ ষ্টোর গুলো কিভাবে Highlight ??
มุมมอง 1004 หลายเดือนก่อน
In this video, you are going to learn about Filter context, DAX, relationship and many more. Please watch the till the end for better understanding each concepts. Please let me know your opinion in the comment section. Please hit like, share & Subscribe to my TH-cam Channel. Thank you!
Power BI: Show only Selected Item on a Bar Chart
มุมมอง 614 หลายเดือนก่อน
𝐈𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈, 𝐢𝐟 𝐲𝐨𝐮 𝐬𝐞𝐥𝐞𝐜𝐭 𝐚 𝐬𝐢𝐧𝐠𝐥𝐞 𝐢𝐭𝐞𝐦 𝐟𝐫𝐨𝐦 𝐚 𝐬𝐥𝐢𝐜𝐞𝐫 𝐢𝐭 𝐰𝐢𝐥𝐥 𝐟𝐢𝐥𝐭𝐞𝐫 𝐭𝐡𝐞 𝐯𝐢𝐬𝐮𝐚𝐥 𝐚𝐜𝐜𝐨𝐫𝐝𝐢𝐧𝐠 𝐭𝐨 𝐭𝐡𝐞 𝐬𝐥𝐢𝐜𝐞𝐫 𝐢𝐧𝐬𝐭𝐞𝐚𝐝 𝐨𝐟 𝐡𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐢𝐧𝐠 𝐭𝐡𝐞 𝐯𝐢𝐬𝐮𝐚𝐥. But in this video, I have shown you that when I select any region or more than one, it will highlight only the stores which are located in that region. 𝐇𝐨𝐰 𝐭𝐨 𝐚𝐜𝐡𝐢𝐞𝐯𝐞 𝐭𝐡𝐢𝐬: 𝐅𝐢𝐫𝐬𝐭, create a separated table for the region which is not connected with the 𝐅𝐚𝐜𝐭...
Select all occurrences of current selection in Power BI
มุมมอง 185 หลายเดือนก่อน
If you want to select all occurrences of current selection in power bi this quick tutorial is for you. Here in this video, I have used keyboard shortcuts to select all occurrences of current selection. First you have to select the current line. After that press Ctrl Shift L together. All the occurences will be selected. You can then edit the current selection or replace from the entire DAX code.
Solving the 1st Monday Fiscal Year Challenge in Power BI | DAX & Calendar Table Tutorial
มุมมอง 715 หลายเดือนก่อน
Financial Year Starting on the 1st Monday Instead of January 1st? Here's How I Solved It! In this video, I dive into a unique challenge I faced while working on a Power BI project. A client needed a dashboard where the financial year starts on the first Monday of every year, rather than the usual January 1st. After some trial and error, I found a solution that perfectly met the requirement. 🔍 W...
Coffee Shop Dashboard
มุมมอง 325 หลายเดือนก่อน
In this Dashboard you can explore trends and patterns by simply select the store location. ✓ Explore Revenue trend by month ✓ Number of Transaction by Day of Week and by Hour in a day. ✓ Number of transaction by product category. ✓ Top 15 Product. Here are some additional insights that could be drawn from the dashboard, if it included more data: ✓ Customer demographics ✓ Inventory management ✓ ...
US Labor Statistics
มุมมอง 65 หลายเดือนก่อน
No power query has been used in this project. I have used Excel formula and different functionalities to showcase my work here. What I have learned: ✓ Very important functions such as SUMIFS, COUNTIFS, AVERAGEIFS etc. ✓ Form Control in the Developer tab in Excel ✓ Data Validation tricks ✓ Correct use of pie chart ✓ Instead of using secondary axis place another chart at the top.
Maven Toy - Regional Revenue Dashboard
มุมมอง 85 หลายเดือนก่อน
What I have learned from this dashboard: ✓ Only number is not enough to understand what is happening in the business. We should add some context to better understand the data. Adding ΔMoM and ΔYoY can give that context. ✓ Revenue trend to better understand the pattern. ✓ Adding ΔMoM along with the bar chart will give us the context. ✓ Adding conditional formatting in the table will give a visua...
Mastering Data Normalization with Maven Coffee Shop Dashboard | PowerQuery, PowerPivot, StarSchema
มุมมอง 1656 หลายเดือนก่อน
Welcome to my latest tutorial on data normalization using the Maven Coffee Shop dashboard! In this video, I’ll guide you through the entire process, from importing and cleaning data in Excel using Power Query, to building fact and dimension tables, and finally creating a star schema in Power Pivot. What You'll Learn: Data Import and Cleanup with Power Query: Learn how to import and clean raw da...
Excel Table is not Taking New Rows!!!
มุมมอง 536 หลายเดือนก่อน
Are you struggling to incorporate new rows in Excel table? Just see this video about how you can turn on the functionality to make tables grasp automatically new rows. #dataanalytics #exceltips #exceltricks
Voice is very low and less confident. A feedback
Thanks for the feedback. I will work on that.
thanks alot , please where is the second part after making modeling ?
You comment inspired me to make the second part. Thank you!
Awesome
❤❤❤
Good Going!
Thanks!!!
Nice
Jazakallah Khair ❤
Blog Post Link : medium.com/@kmdzakir92/financial-year-starting-on-the-1st-monday-instead-of-january-1st-40d7e2699aeb
Superb
Reyal vai go ahead.
Thank you! Doa koris.