- 49
- 171 771
Vikas Munjal Ellarr
India
เข้าร่วมเมื่อ 9 มิ.ย. 2015
Welcome to Ellarr.com Official TH-cam Channel
Owner has more than 16 Years of rich experience. Currently working as a Corporate Trainer for SQL Server and Business Intelligence. Also worked as a SQL Developer. Lives in Delhi, India.
Microsoft Certifications:
Microsoft Certified Solution Expert Data Platform
Microsoft Certified Solution Expert Business Intelligence
Microsoft Certified Solution Expert Data Management and Analytics
Microsoft Certified Solution Associate SQL Server
Microsoft Certified Professional
Owner has more than 16 Years of rich experience. Currently working as a Corporate Trainer for SQL Server and Business Intelligence. Also worked as a SQL Developer. Lives in Delhi, India.
Microsoft Certifications:
Microsoft Certified Solution Expert Data Platform
Microsoft Certified Solution Expert Business Intelligence
Microsoft Certified Solution Expert Data Management and Analytics
Microsoft Certified Solution Associate SQL Server
Microsoft Certified Professional
Key Lookup , RowID Lookup & Nested Loop Operator in Microsoft SQL Server Execution Plan
To enroll in the execution plan course please check the following link:
www.udemy.com/course/understanding-execution-plans-indexes-sql-server/?referralCode=7F75CBC9C83858505533
This course is designed for advanced users and is not suitable for beginners. A solid understanding of T-SQL command writing is required. Despite this, the online video training starts with the basics and provides a detailed, step-by-step guide on reading, understanding, and analyzing execution plans.
Initially, the learning material covers:
There are two types of Execution Plans: Estimated and Actual Execution Plans. Both types are thoroughly discussed. The Estimated Execution Plan predicts how a T-SQL query will be executed, while the Actual Execution Plan shows how a SQL command was executed. Detailed step-by-step descriptions are provided.
This course will enhance your skills in Performance Tuning and query optimization using Execution Plans, specifically for Microsoft SQL Server Developers.
Additional Related Courses:
Beginning T-SQL for SQL Server Developer, Data Analyst & DBA
www.udemy.com/course/online-t-sql-developer-video-training/?referralCode=857BE29382C3B0B6A577
T-SQL Training with Real World Scenarios:Tricks of the Trade
www.udemy.com/course/t-sql-training/?referralCode=CF5CAAB9EC593BD54F15
Transaction, Isolation Levels and In-Memory OLTP in T-SQL
www.udemy.com/course/transaction-isolation-levels-in-memory-oltp-t-sql/?referralCode=838D6A1B3E602EFA6F9B
www.udemy.com/course/understanding-execution-plans-indexes-sql-server/?referralCode=7F75CBC9C83858505533
This course is designed for advanced users and is not suitable for beginners. A solid understanding of T-SQL command writing is required. Despite this, the online video training starts with the basics and provides a detailed, step-by-step guide on reading, understanding, and analyzing execution plans.
Initially, the learning material covers:
There are two types of Execution Plans: Estimated and Actual Execution Plans. Both types are thoroughly discussed. The Estimated Execution Plan predicts how a T-SQL query will be executed, while the Actual Execution Plan shows how a SQL command was executed. Detailed step-by-step descriptions are provided.
This course will enhance your skills in Performance Tuning and query optimization using Execution Plans, specifically for Microsoft SQL Server Developers.
Additional Related Courses:
Beginning T-SQL for SQL Server Developer, Data Analyst & DBA
www.udemy.com/course/online-t-sql-developer-video-training/?referralCode=857BE29382C3B0B6A577
T-SQL Training with Real World Scenarios:Tricks of the Trade
www.udemy.com/course/t-sql-training/?referralCode=CF5CAAB9EC593BD54F15
Transaction, Isolation Levels and In-Memory OLTP in T-SQL
www.udemy.com/course/transaction-isolation-levels-in-memory-oltp-t-sql/?referralCode=838D6A1B3E602EFA6F9B
มุมมอง: 117
วีดีโอ
Power BI Data Flow: Multiple Tables & Relationships Explained
มุมมอง 32หลายเดือนก่อน
When you have a relationship between two tables, how does the data flow from one table to another in Power BI? In short, how does the data flow across relationships between two tables? Before explaining multiple tables, I used the same data in a single table and performed the Sum() function on the Sales column. As you know, Power BI generates a summary report; I used Matrix visualization to sho...
Power BI Ribbon Charts Explained: Rank Analysis & Comparison with Waterfall Charts
มุมมอง 9หลายเดือนก่อน
Ribbon Chart or Visualization in Power BI The Ribbon Chart displays the ranking factor of the data, indicating which product ranks highest during a specific time period. While the Ribbon Chart displays the final value over a certain period, the Waterfall Chart illustrates the reasons why and how the final value is reached. The Ribbon Chart has X-Axis, Y-Axis, and Legend options. For the X-Axis,...
Waterfall Charts in Power BI: Analyze Sales Trends & Influential Factors
มุมมอง 17หลายเดือนก่อน
The waterfall visualization in Power BI is explained through an example. By examining a specific time period, you can determine whether your sales or profit are rising or falling. This allows you to identify the most influential products driving these changes in sales or profit. This chart has Category, Breakdown, and Y-Axis sections. The output will be in the form of bar charts. In this exampl...
Power BI Card & Multi-Row Card Visuals: Display & Format Metrics
มุมมอง 41หลายเดือนก่อน
Card and Multi-Row Card Visuals in Power BI Card: A Card visual displays a single value, whereas a Multi-Row Card displays multiple values in different rows. Cards are frequently used in dashboards to represent overall metrics such as sales, profit, profit percentage, number of orders, etc. Field Section: In the Card visual, you can drag and drop a measure or numeric value. Formatting: You can ...
Drill down the Matrix Visual in Power BI | Customization & Features Explained
มุมมอง 45หลายเดือนก่อน
Matrix Visual in Power BI In a Matrix report, the number of columns is dynamic, whereas in a Table report, the number of columns is fixed. Additionally, a Table report can be summarized or detailed, whereas a Matrix report is summarized only. These are two key differences between Table and Matrix visualizations in Power BI. The Matrix visual consists of Rows, Columns, and Values sections. In th...
Power Query | Pivot Unpivot | Group By | Remove Transform Columns using Date | Disable Load
มุมมอง 70หลายเดือนก่อน
The following topics are covered using Power BI technology: Query Settings Removing Columns Transforming Columns using Dates Pivoting & Unpivoting Columns Grouping Data Based on Multiple Columns Disabling Load This video provides a basic, step-by-step explanation of Power Query in Power BI using Power Query Editor. Don't forget to watch the previous video, as this one continues from there.
Power Query in Power BI | Remove Merge Append Rename Split Merge Custom Columns Rows Header
มุมมอง 55หลายเดือนก่อน
In this video, the following topics of Power Query using Power Query Editor are covered. This video provides a step-by-step description of Power Query basics in simple language. Excel users can also benefit from this video because Power Query Editor is similar in both Power BI and Excel: 1) Use First Row as Headers 2) Remove Rows 3) Keep Rows 4) Add Custom Columns 5) Append Queries 6) Rename Co...
PART 3 - How to Install Power BI Desktop
มุมมอง 34หลายเดือนก่อน
In this video, I will guide you through the step-by-step process to install Power BI Desktop, which is used to develop reports. To begin, you need to Google search "Download Power BI Desktop" to find the Microsoft URL where you can download the setup file. Once downloaded, you can proceed with the installation.
PART 2 - What is Power BI Architecture | By Vikas Munjal
มุมมอง 53หลายเดือนก่อน
This video discusses Power BI architecture in simple language, covering: Power BI Desktop: Used to connect to various data sources and perform ETL (Extract, Transform, Load) operations. Power BI Service: Accessible via PowerBI.com, where you can publish your developed reports and share them with end-users. Data Gateway: A topic discussed for data refresh.
PART 1 - What is Power BI Technology | By Vikas Munjal
มุมมอง 54หลายเดือนก่อน
In Power BI technology, three major topics are covered: Visualization Tools: Includes charts, graphs, filters, drilldown, etc. Power Query: Enables Extract Transform Load (ETL) operations. XVelocity In-Memory Engine: A fast engine that accelerates data processing.
Learn Execution Plan in SQL Server Step by Step : Promotional Video
มุมมอง 1926 หลายเดือนก่อน
To enroll in the execution plan course please check the following link: www.udemy.com/course/understanding-execution-plans-indexes-sql-server/?referralCode=7F75CBC9C83858505533 This course is not for beginners and it is advanced T-SQL course.You should have good knowledge of writing T-SQL Commands. But this online video training course starts from basics and has step by step description to read...
Install SQL Server 2022 ,SSMS, SSIS , SSRS , SSAS (MultiDimensional and Tabular) Step by Step
มุมมอง 1.8K9 หลายเดือนก่อน
For Online One to One Training and Job Support , Please check out the following link www.ellarr.com How to perform the Installation SQL Server 2022 , SSIS, SSRS , SSAS MultiDimensional Mode , SSAS Tabular Mode and also it includes SQL Server Management Studio Installation with Mixed Mode Authentication means Window Authentication and SQL Server Authentication
How to install MSBI ( SSAS, SSIS, SSRS ) projects extensions using Visual Studio
มุมมอง 3329 หลายเดือนก่อน
For Online One to One T-SQL and Microsoft Business Intelligence Training , please visit the courses link of the following website www.ellarr.com The courses include T-SQL, SSIS , SSAS, , MDX , SSRS Trainings Installing Visual Studio ,SQL Server Integration Services Extensions ,Microsoft Reporting Services Projects Extensions ,Microsoft Analysis Services Projects Extensions, Microsoft Business I...
SSRS and SSIS Online Training Session Feedback |Jackie from USA | Vikas Munjal | ELLARR.COM INDIA
มุมมอง 2473 ปีที่แล้ว
Name:Jackie Country: USA Course : SSIS and SSRS Session Attended Virtually or Online Sessions were delivered By Vikas Munjal It was Live Instructor Led Training Jackie has shared her feedback for his SQL Server Integration Service and Reporting Service Course which she attended Here are the links to the course SSRS Course ellarr.com/training-courses/online-training-ssrs/ SSIS Course ellarr.com/...
SQL Server T-SQL Query Virtual Training Feedback | Chandan from Melbourne | Vikas Munjal Ellarr.Com
มุมมอง 1653 ปีที่แล้ว
SQL Server T-SQL Query Virtual Training Feedback | Chandan from Melbourne | Vikas Munjal Ellarr.Com
SSIS Online Training Session Feedback | Vikas Munjal | ELLARR.COM
มุมมอง 2723 ปีที่แล้ว
SSIS Online Training Session Feedback | Vikas Munjal | ELLARR.COM
Introduction of Vikas Munjal , SQL Server , ellarr.com
มุมมอง 1624 ปีที่แล้ว
Introduction of Vikas Munjal , SQL Server , ellarr.com
Developing quick IT technology Project Summer Industrial Training CSE/CS/IT/MCA/BCA/B.Tech/B.Sc(CS)
มุมมอง 2214 ปีที่แล้ว
Developing quick IT technology Project Summer Industrial Training CSE/CS/IT/MCA/BCA/B.Tech/B.Sc(CS)
Dropping multiple tables in one go having a fixed pattern in SQL Server
มุมมอง 1.7K5 ปีที่แล้ว
Dropping multiple tables in one go having a fixed pattern in SQL Server
Why to create Black and White Coloured Report in SSRS
มุมมอง 545 ปีที่แล้ว
Why to create Black and White Coloured Report in SSRS
SSRS Grouping multiple columns and SubTotals in Tablix Report
มุมมอง 6K5 ปีที่แล้ว
SSRS Grouping multiple columns and SubTotals in Tablix Report
Displaying a Tablular Report after clicking on a Chart using Drillthrough option in SSRS
มุมมอง 635 ปีที่แล้ว
Displaying a Tablular Report after clicking on a Chart using Drillthrough option in SSRS
Create Tabular Report by using Report Wizard in SSRS
มุมมอง 535 ปีที่แล้ว
Create Tabular Report by using Report Wizard in SSRS
T-SQL Online Training Session Feedback by Ram Sridhar (Data Analyst in Australia )
มุมมอง 1475 ปีที่แล้ว
T-SQL Online Training Session Feedback by Ram Sridhar (Data Analyst in Australia )
How to create time intelligence in ssas
มุมมอง 1.3K6 ปีที่แล้ว
How to create time intelligence in ssas
How to add Fact and Dimensions into SSAS Cube - Modify Cube Structure
มุมมอง 4.1K6 ปีที่แล้ว
How to add Fact and Dimensions into SSAS Cube - Modify Cube Structure
Op video
SAAS does not use only MDX, it uses also DAX
however at the end, you did not really explain how the cubes where created
@@inesdhaker2476 SSAS Tabular Model uses DAX . Here i am talking about SSAS Multidimensional Model. Also i have prerecorded courses on Udemy on SSAS and MDX where i explained How the cubes are created in detail. Name of the courses are MDX Training PArt 1 , 2 and SSAS Training MultiDimensional Model - Part 3. If you want discounted coupons of those courses you can whatsapp me. My phone number is available in www.ellarr.com website
very well explained
Ssrs and ssas are working but SSIS is not.
thank you, very helpful
Hi, I currently work in IT using SSIS technology. I need to talk to you. How can I contact you?
you can send me whatsapp mentioned in my website www.ellarr.com
Can we install msbi new version in window 10 pro
yes
Thank you sir😊
Great explanation sir
Thanks bro
I am looking for SSIS training please share your contact info ASAP
Please share your contact number i will connect you using whatsapp first or you can send me whatsapp mentioned in my website www.ellarr.com
Thanks so much for this tutorial. Greatly appreciated.
I had been fighting with that issue for an hour, thank you very much!!
Do you take classes of ssis sql??
Yes, pls visit my website www.ellarr.com and you may contact me through whatsapp. My contact number is available in the website.
thanks bro
Very nice.Thanks
Thanks. Explained well
v. nice explanation 👍👍
DATA WARE HOUSE IS ANALYTICAL PLATFORM, THEN HOW DAILY SALES DATA GET STORED IN IT???
Very clear
Thank you very much Mr. Munjal for this great video. It really helps me to understand what I have been looking for. GBU
very informative video and very well explained! Thank you! 😊
You are great
Very informative video and very well explained! Thank you! 😊
Awesome!
Great video
Very straight to the points which are not many on TH-cam
Good description👍
U taught in a very nice manner sir.. thank you 😊
awosome , my all doughts have been cleared thanks
Good Job! Keep it going and spread knowlegde.
Good job! You explained everything really well! Keep on going!
This literally saved my life from struggling hours for nothing, thank u !!!!!!!
🥰
thank you!
Perfect explanation, thank you!
Thanks
Thank you for the video
Great simple introductory overview that ties it all together. Thank you. The OLAP/OLTP concept at the end was rushed. All in all good intro
How do I take the training
Please whatsapp me , my number is available on the website
This was helpful vikas , keep doing the good work your are doing
I got more clarification after watching your video, please make more video like this thanks
It was very helpful!
This was very helpful, thank you so much!
Thanks for this awesome video..
U did not explain SSRS
for more details, you can refer here- www.udemy.com/course/ssrs-online-training-video-tutorial-course/?referralCode=79A01CE5E432370931AD
Thank you! Very good overview!
please provide the contact details of Delhi office sir thank you 👍
Less time,more information..very well explained.Thank you