![Arpita's Tech Corner](/img/default-banner.jpg)
- 130
- 206 983
Arpita's Tech Corner
United Kingdom
Registrace 17. 07. 2015
A great man once said, “Dream is not that you see in sleep, dream is something that does not let you sleep“. This line has been etched in my mind ever since childhood. Probably it is this ability to dream that gave me the courage and inspiration to pursue a post-graduation in data science years after completing my engineering degree while juggling motherhood and work. While pursuing my higher education, I realised my love for writing, and my blogs became my respite. I am a passionate content creator and a busy mother. My friends, family members and my little child are my sources of inspiration and motivation. Their appreciation keeps me going and tells me that my path may seem difficult, but it is worth the effort.
I believe my learnings and experiences are my greatest asset, and sharing that with others through my blog helps me grow and nurture them. I love technology and I would love the world to know more about it. Your feedback would be imperative in helping me pursue my dream.
I believe my learnings and experiences are my greatest asset, and sharing that with others through my blog helps me grow and nurture them. I love technology and I would love the world to know more about it. Your feedback would be imperative in helping me pursue my dream.
9 Microsoft Fabric : ETL Process with Dataflow Gen2 & Data Pipeline | #microsoftfabric #powerbi
The primary objective of this video is to learn the following things
How to
1. Create a Lakehouse
2. Create Dataflow Gen2
3. Create a Data Pipeline
4. Automate the ETL process and Load Data
----------------------------------------------------------------------------------------------------
You can download the data files from the below location.
Data Files: github.com/arpitag1/Microsoft_Fabric_Material/tree/main
------------------------------------------------------------------------------------------
To find more details, click the below link
Office 356 License link: www.microsoft.com/en-gb/microsoft-365/enterprise/office365-plans-and-pricing?rtc=1
Fabric Tutorial link: learn.microsoft.com/en-us/fabric/
Fabric Self-Placed Learning Path (Certification): learn.microsoft.com/en-us/credentials/certifications/exams/dp-600/
Fabric Community / Role Guidance: community.fabric.microsoft.com/t5/custom/page/page-id/CareerHubPage?ocid=fabric24_careerhub_fabriccomm_banner_clp
-----------------------------------------------------------------------------------------
Medium: arpita-ghosh.medium.com/
LinkedIn: www.linkedin.com/in/arpita19sep
-------------------------------------------------------------------------------------------
#powerbi #dataanalysis #datavisualization #dataengineer #microsoftfabric #microsoft #datapipeline #etl
How to
1. Create a Lakehouse
2. Create Dataflow Gen2
3. Create a Data Pipeline
4. Automate the ETL process and Load Data
----------------------------------------------------------------------------------------------------
You can download the data files from the below location.
Data Files: github.com/arpitag1/Microsoft_Fabric_Material/tree/main
------------------------------------------------------------------------------------------
To find more details, click the below link
Office 356 License link: www.microsoft.com/en-gb/microsoft-365/enterprise/office365-plans-and-pricing?rtc=1
Fabric Tutorial link: learn.microsoft.com/en-us/fabric/
Fabric Self-Placed Learning Path (Certification): learn.microsoft.com/en-us/credentials/certifications/exams/dp-600/
Fabric Community / Role Guidance: community.fabric.microsoft.com/t5/custom/page/page-id/CareerHubPage?ocid=fabric24_careerhub_fabriccomm_banner_clp
-----------------------------------------------------------------------------------------
Medium: arpita-ghosh.medium.com/
LinkedIn: www.linkedin.com/in/arpita19sep
-------------------------------------------------------------------------------------------
#powerbi #dataanalysis #datavisualization #dataengineer #microsoftfabric #microsoft #datapipeline #etl
zhlédnutí: 175
Video
8 Microsoft Fabric : Lakehouse to Notebook with SparkR | #microsoftfabric #powerbi #spark
zhlédnutí 80Před 2 měsíci
The primary objective of this video is to learn the following things How to 1. Create a Lakehouse 2. Load data from Files 3. Create Notebook 4. Using Notebook load, process, and transform data with SparkR 5. Visualize with ggplot2() You can download the data files from the below location. Data Files: github.com/arpitag1/Microsoft_Fabric_Material/tree/main/MovieFiles To find more details, click ...
7 Microsoft Fabric : Lakehouse to Notebook with SparkSQL | #microsoftfabric #powerbi
zhlédnutí 47Před 2 měsíci
The primary objective of this video is to learn the following things How to 1. Create a Lakehouse 2. Load data from Files 3. Create Notebook 4. Using Notebook load, process, and transform data with SparkSQL 5. Visualize with In-build chart options You can download the data files from the below location. Data Files: github.com/arpitag1/Microsoft_Fabric_Material/tree/main/MovieFiles To find more ...
6 Microsoft Fabric : Lakehouse to Notebook | PySpark, Matplotlib | #microsoftfabric #powerbi
zhlédnutí 103Před 2 měsíci
The primary objective of this video is to learn the following things How to 1. Create a Lakehouse 2. Load data from Files 3. Create First Notebook 4. Using Notebook load, process, and transform data with PySpark 5. Visualize with Matplotlib You can download the data files from the below location. Data Files: github.com/arpitag1/Microsoft_Fabric_Material/tree/main/MovieFiles To find more details...
5 Microsoft Fabric : Lakehouse to Report | Step by Step | #microsoftfabric #microsoft #powerbi
zhlédnutí 152Před 3 měsíci
The primary objective of this video is to learn the following things How to 1. Create a Lakehouse 2. Load data from Files 3. Convert Files to Delta Table 4. Append two Datasets into one table 5. Query Data in SQL Analytics Endpoint 6. Use Visual Query and transform the query into an aggregated format 7. Create a Report from the above aggregated visual query result. You can download the data fil...
4 Microsoft Fabric: Walk Through the Environment #microsoftfabric #microsoft #powerbi
zhlédnutí 78Před 3 měsíci
The primary objective of this video is to learn the following things 1. Login to Microsoft Fabric Environment 2. Explain different features/categories like Data Engineering, Data Warehouse, Data Science related tools To find more details, click the below link Office 356 License link: www.microsoft.com/en-gb/microsoft-365/enterprise/office365-plans-and-pricing?rtc=1 Fabric Tutorial link: learn.m...
3 What & Why Microsoft Fabric #microsoftfabric #microsoft #powerbi
zhlédnutí 84Před 3 měsíci
The primary objective of this video is to learn the following things 1. What is Microsoft Fabric? 2. Why Microsoft Fabric is useful? To find more details, click the below link Office 356 License link: www.microsoft.com/en-gb/microsoft-365/enterprise/office365-plans-and-pricing?rtc=1 Fabric Tutorial link: learn.microsoft.com/en-us/fabric/ Fabric Self-Placed Learning Path (Certification): learn.m...
What I followed to improve my English Communication Skills #podcast #communicationskills
zhlédnutí 55Před 3 měsíci
This is based on my 20 years of industry experience. #podcast #communicationskills #englishcommunication
How I improved my English Communication Skill #podcast #communicationskills #englishcommunication
zhlédnutí 304Před 3 měsíci
This is based on my 20 years of industry experience. #podcast #communicationskills #englishcommunication
2 Which Job Roles are relevant to Microsoft Fabric #microsoftfabric
zhlédnutí 165Před 3 měsíci
The primary objective of this video is to learn the following things 1. Explore different job roles which are relevant to Microsoft Fabric To find more details, click the below link Office 356 License link: www.microsoft.com/en-gb/microsoft-365/enterprise/office365-plans-and-pricing?rtc=1 Fabric Tutorial link: learn.microsoft.com/en-us/fabric/ Fabric Self-Placed Learning Path (Certification): l...
1 How I start my journey with Microsoft Fabric #microsoft #microsoftfabric
zhlédnutí 210Před 3 měsíci
The primary objective of this video is to learn the following things 1. How to get the first access to Microsoft Fabric 2. Primary Tutorials I am following 3. Self-placed learning paths 4. Fabric Community Help URL 5. Role Guidance To find more details, click the below link Office 356 License link: www.microsoft.com/en-gb/microsoft-365/enterprise/office365-plans-and-pricing?rtc=1 Fabric Tutoria...
Introduction to Powerops | Power BI External Plugin #powerbi #dataanalysis #datavisualization
zhlédnutí 189Před 3 měsíci
This video explains in detail how to add the "Powerops" tool to the Power BI desktop as an external plugin. The primary objective of this video is to learn the following things 1. From where you will get this tool 2. Which version to use 3. How to use initially 4. What are all the advantages Medium: arpita-ghosh.medium.com/ LinkedIn: www.linkedin.com/in/arpita19sep This channel is made for prep...
7 Charts to Show Part to Whole Relationships in Power BI #powerbi #datavisualization #chart
zhlédnutí 111Před 4 měsíci
Showing Part-to-Whole Relationships in Power BI: A Comprehensive Guide to Charts and Graphs Video Links: Pie & Donut Chart: czcams.com/video/9F_LTw1MxhQ/video.html Stacked Bar and Column Chart: czcams.com/video/dcm-mLwmNao/video.html&start=38&end=181 Treemap: czcams.com/video/oHi96ZWiCQo/video.html Funnel Chart: czcams.com/video/YYmbGs_AYS0/video.html Waterfall chart: czcams.com/video/uWgJVMRRt...
23 How to create ArcGIS Map in Power BI | Data Analysis in Power BI #powerbi #dataanalysis
zhlédnutí 305Před 4 měsíci
Chapter 23 of data analysis in Power BI is about how to create an ArcGIS Map This video has the following information How to create an ArcGIS Map. Points discussed: 1. How to create this visualization with detailed explanations. 2. Purpose of this visualization 3. Limitation of this viz. To find more materials on Power BI, please click on the below link GitHub (Data Analysis in Power BI - Chapt...
10 Steps to Profile, Clean and Model Data (Complete ETL Process) #powerbi #dataanalysis
zhlédnutí 620Před 7 měsíci
This video has the following information 1. Purpose of Data Profiling in Power BI 2. How to Identify Data Inconsistency in Power BI 3. How to Analyze Data Distribution in Power BI 4. How to Examine Data Statistics in Power BI 5. How to do Data Cleaning and Evaluation in Power BI 6. How to do Data Shaping (Pivot, Unpivot, Transpose and so on) in Power BI 7. How to do Data Combining (Merge, Appen...
How a Fresher received his first Data Analyst job offer | Step by Step process | #interview #podcast
zhlédnutí 634Před 7 měsíci
How a Fresher received his first Data Analyst job offer | Step by Step process | #interview #podcast
28 Statistical Functions in DAX with Examples #powerbi #dax #statistics
zhlédnutí 448Před 7 měsíci
28 Statistical Functions in DAX with Examples #powerbi #dax #statistics
9 Case Study - Price Analytics | Data Analysis with SQL #sql #postgresql
zhlédnutí 237Před 8 měsíci
9 Case Study - Price Analytics | Data Analysis with SQL #sql #postgresql
8 Aggregation with Having Clause | Data Analysis with SQL #sql #postgresql
zhlédnutí 64Před 8 měsíci
8 Aggregation with Having Clause | Data Analysis with SQL #sql #postgresql
2 Relational DB Vs. Graph DB: Which Is Better For Your Data? #knowledgegraph #graphdatabase
zhlédnutí 126Před 8 měsíci
2 Relational DB Vs. Graph DB: Which Is Better For Your Data? #knowledgegraph #graphdatabase
1 Introduction to Knowledge Graph #knowledgegraph #neo4j #graphdatabase
zhlédnutí 67Před 9 měsíci
1 Introduction to Knowledge Graph #knowledgegraph #neo4j #graphdatabase
7 Common Aggregation Functions, Group By, Order By | Data Analysis with SQL #sql #postgresql
zhlédnutí 94Před 9 měsíci
7 Common Aggregation Functions, Group By, Order By | Data Analysis with SQL #sql #postgresql
6 Know about Inner & Outer Join | Data Analysis with SQL #sql #postgresql
zhlédnutí 72Před 9 měsíci
6 Know about Inner & Outer Join | Data Analysis with SQL #sql #postgresql
5 Know about Primary & Foreign Keys | Data Analysis with SQL #sql #postgresql
zhlédnutí 121Před 9 měsíci
5 Know about Primary & Foreign Keys | Data Analysis with SQL #sql #postgresql
4 Basic SQL Statement Syntax | Data Analysis with SQL #sql #postgresql
zhlédnutí 70Před 9 měsíci
4 Basic SQL Statement Syntax | Data Analysis with SQL #sql #postgresql
3 Create Table & Import Data using PostgreSQL features | Data Analysis with SQL #sql #postgresql
zhlédnutí 130Před 9 měsíci
3 Create Table & Import Data using PostgreSQL features | Data Analysis with SQL #sql #postgresql
2 PostgreSQL Download & Install | Data Analysis with SQL #sql #postgresql
zhlédnutí 128Před 10 měsíci
2 PostgreSQL Download & Install | Data Analysis with SQL #sql #postgresql
1 Introduction to SQL | Data Analysis with SQL #sql #dataanalysis #dataanalytics #sqlforbeginners
zhlédnutí 208Před 10 měsíci
1 Introduction to SQL | Data Analysis with SQL #sql #dataanalysis #dataanalytics #sqlforbeginners
22 How to create Heatmap in Power BI | Data Analysis in Power BI #powerbi #dataanalysis
zhlédnutí 1,8KPřed rokem
22 How to create Heatmap in Power BI | Data Analysis in Power BI #powerbi #dataanalysis
1.2 Power BI Interview Questions and Answers | Power BI Interview #powerbi #interview
zhlédnutí 624Před rokem
1.2 Power BI Interview Questions and Answers | Power BI Interview #powerbi #interview
Finished watching
Finished watching
Finished watching
V gud explanation can u pls tell us how to remove null values in large dataset
Thank you. For any large data sets, it's better to do all cleaning activities at the database level. You can try in dataflow ( Power BI web) , but it's recommended to do this at databases level
Finished watching
Finished watching
finished WATCHING
Finished watching
finished watching
Please provide the dataset for practice .Thanks
Please check the description section. You will find the GitHub link. This is simple US superstore data and I am using it for all the videos.
@@ArpitasTechCorner Thanks
Finished watching
Thank you
I am unable to locate the dataset for practice
Please check the description section. You will find the GitHub location where you will get all the details
Finished watching
Thank you
Surprise with your performance
Thank you Baba 😄
Thanku So much for your great work
Thank you 🙏
Hi Mam, Is this end to end Fabric series? Or Just basics? Do we need to do anything else apart from this training?
No, this is not end. I am trying to capture one end to end journey in each video. Next video will have another end to end journey. Check the description section I have added some training material link.
Okay mam got it. I'm just checking if you are going to add more fabric topics in this series?? This will be organized videos or just random topics? Please guide
Organized based on my understanding.
Very informative. If possible could you please share the source files that you have used.
Thank you. Sure
github.com/arpitag1/Microsoft_Fabric_Material/tree/main/MovieFiles
Mind-blowing
Thank you
Hi Arpita mam, I created a report and set up a virtual machine (running 24/7) for scheduled refresh instead of connecting to a local PC. Now, I've made another report using a different dataset and want to schedule a refresh for it as well. Can I use the same virtual machine and gateway for this new report?
Ideally yes. I have used the same gateway server to run and refresh multiple datasets. The Admin team needs to create multiple connections for different data sources.
Hello, friends. Please help to calculate stdev.p/stdevx.p for different months. For example: i have 5 years observations and i need stdev for only January's separately, then for February's separately, then for March's and so on. Thank you 😢
Please post your problem in the LinkedIn Group or Microsoft Community forum.
Nice one Arpita ji
Thank you
Nice one Arpita ji
Thank you
Nice one
Thank you
Nice content please improve the video quality 😊
Thank you.
Good information
Thank you
I am feeling proud for such performance
Thank you 😊 Baba
👍
Thank you
hi Arpita, do you have any courses for biginer to Pro, for language learning, pleas help me to learn.
No I don't have any. I refer www.grammarly.com
Thank you ma'am, 🙏vary helpful for us too...
Thank you 😊
Sabash
Thank you 😊 Baba
REALLY USEFUL VIDEO CRISP AS WELL AS INFORMATIVE THANK YOU MAM, IT MAKES ME EXPLORE MORE ON THIS.
Thank you so much
Wonderful one thanku so much 😊
Thank you 😊
Thanks Arpita for this video. I subscribe to you and I was looking out on how to start preparing for fabric.
Thank you 😊
Good Content but poor audio!!
Thank you.
Thank you. You have explained in a very simple and systematic manner suitable for beginners.
Thank you 🙏
Thank you
Welcome 🙏
Does Data profiling a part of ETL process , if yes, which stage of ETL its done.
Data profiling is the whole process of understanding the data , cleaning, processing and ready for visualisation and modelling. In ETL , this is the 2nd stage, means after importing the data.
I am looking for exactly this explaination . fentastic explaination . thanks for good work :)
Thank you 😊
This helped a lot with clearing my doubts. Keep up the good work!
Thank you
Mam, I have one Question. If we want to create a dashboard for rewards, what do we have to do?
In this data set, don't have any reward points, but if we have reward related info, then we have some reports for example, Based on credit card expenditure how much reward points are adding , then there could have customer detail level reward points analysis. Based on reward points which products are available. I hope you get some idea from this.
Thank you for such great content 😇🤗
Thank you
Just wondering is it necessary to filter out the nulls?
Not applicable for every time. Sometimes we need to do it in a data sampling process, data profiling process. Based on our situation we have to decide. Also it depends how much data has null values.
Good explanation. Thank you.
Thank you
reference data model link is not open
Could you please explicitly mention which link is not opening?
Thanks alot but i need some data to use to practice , can you please help me with one data that you think i can make use of? Nice teaching
Thank you. You can check the GitHub link which I have mentioned in the description section. Superstore data set is available there. Using that you can start your journey. Also to get more data set you can check kaggle.com or data world
One most important thing is we have to cross chk these values in sql as well.
Yes definitely and that is part of the testing process. Unit , SIT testing.
Your videos have been very helpful. This channel is like a treasure that will certainly give learners with an edge. Thank you very much. Appreciate it!
Thank you 😊🙏
simply fantastic video mam
Thank you
mam the video quality is very low please improve the quality meanwhile nice topic
Thank you. I have merged some old existing videos, never got feedback earlier. However I have noted your points, and will keep in mind for the future.
Ma'am kindly provide some tips for Bengali Medium students who are facing huge problem in speaking English.
Sure .