- Видео 621
- Просмотров 1 533 607
Mukesh Singh
США
Добавлен 23 окт 2010
This channel contains all the tutorial demo for Microsoft Business Intelligence with (SQL Server, SSRS, SSIS and SSAS).
* Programming Language: Python, R, Spark, PySpark and C#
* PL/SQL, T-SQL, ETLs with SQL Server 2012, 2014 and 2016 onward
* Tools: MS Visio, Microsoft Azure Explorer Tools, Azure Data Lake tools, Amazon Glue, Pentaho, Talend, Teradata SQL Assistant and dB Visualizer
* Microsoft SQL Server, AWS, Azure SQL server, Teradata, Hadoop, Tableau, Power BI, Micro-strategy and Reporting Services, NoSQL MongoDB
* Airflow, GCP, Amazon WMS APIs
Apart from this, we are here to support the natural things such as birds, animals, trees, mountain, water-falls, space and funny moments also.
* Programming Language: Python, R, Spark, PySpark and C#
* PL/SQL, T-SQL, ETLs with SQL Server 2012, 2014 and 2016 onward
* Tools: MS Visio, Microsoft Azure Explorer Tools, Azure Data Lake tools, Amazon Glue, Pentaho, Talend, Teradata SQL Assistant and dB Visualizer
* Microsoft SQL Server, AWS, Azure SQL server, Teradata, Hadoop, Tableau, Power BI, Micro-strategy and Reporting Services, NoSQL MongoDB
* Airflow, GCP, Amazon WMS APIs
Apart from this, we are here to support the natural things such as birds, animals, trees, mountain, water-falls, space and funny moments also.
Alteryx Tool - A Basic Tutorial for Beginners || Learn Alteryx in 2 Hours || Quick Guide for Alteryx
Alteryx is a powerful data analytics platform designed to simplify data preparation, blending, and analysis, making it accessible to users of varying skill levels. In this tutorial, you will learn "Learn Basic tools of Alteryx in 2 hours".
With an intuitive, drag-and-drop workflow interface, Alteryx allows users to connect to a wide range of data sources, process data, and generate insights without needing advanced coding skills. It is especially popular for data preparation tasks, automating repetitive processes, and creating data pipelines.
🛠️This tutorial contains the following outline:
📌0:00-3:48 Connect with an Excel File OR Import Excel by Input Data Tool
📌3:49-8:47 Extract patterns f...
With an intuitive, drag-and-drop workflow interface, Alteryx allows users to connect to a wide range of data sources, process data, and generate insights without needing advanced coding skills. It is especially popular for data preparation tasks, automating repetitive processes, and creating data pipelines.
🛠️This tutorial contains the following outline:
📌0:00-3:48 Connect with an Excel File OR Import Excel by Input Data Tool
📌3:49-8:47 Extract patterns f...
Просмотров: 338
Видео
SQL - Basic Understanding of Date Functions | Get Month Name | Previous Date |Last Date of the Month
Просмотров 643 месяца назад
In this tutorial, you will learn "How to use various Date Function to get Month Name, Year, Quarter, Previous Date, Next Date and Differences between two dates" in SQL. This tip explains How to use various Date Function to get Month Name, Year, Quarter, Previous Date, Next Date and Differences between two dates in SQL. You will learn - 🚀How can get Last and Next date of a given date 🚀How to get...
SSIS - Load Multisheet Excel File into SQL Server Database || Read Excel with different Schema
Просмотров 624 месяца назад
In this tutorial, you will learn "How to read data from multiple Excel worksheets having different schema with SQL Server Integration Services" This tip explains how we can load data from multiple Excel sheets and load it into a SQL Server destination tables by using SSIS. You will learn - 🚀How can you configure your Excel File Connection with Multisheet 🚀How to configure your Local Variables i...
Free Time with Full Masti in Rain🌧️||🌧️ Awesome Childhood 😶🌫️ Raining Weather
Просмотров 285 месяцев назад
Raining Season #trending #jeenu #love #kids #cuteanimal #free
Magnet Challenge: Mini And Jeenu || Who will win 500 bucks?||💯Entertainment
Просмотров 505 месяцев назад
In this video, Jeenu and Mini challenge each other in a magnet game where there are going to put their magnet inside a thread circle. Who is going to put their magnet inside the circle with attract other magnet and finish their all magnets then he/her will be the winner of the game. So guys, let have a fun. Cartoons for kids, Kids songs, Educational videos for kids, Nursery rhymes, Minecraft ga...
Top 5 Interview Questions for SQL Data Warehousing
Просмотров 586 месяцев назад
Top 5 Interview Questions for SQL Data Warehousing
SQL - How to use PIVOT Tables Operator to Convert Rows into Columns
Просмотров 736 месяцев назад
SQL - How to use PIVOT Tables Operator to Convert Rows into Columns
SQL - How to Use Rollup Operator to Calculate SubTotal and GrandTotal at hierarchal Level
Просмотров 536 месяцев назад
SQL - How to Use Rollup Operator to Calculate SubTotal and GrandTotal at hierarchal Level
SQL Interview Questions - High Cardinality Vs Low Cardinality
Просмотров 1767 месяцев назад
SQL Interview Questions - High Cardinality Vs Low Cardinality
SQL Interview Questions - Row_Number() vs Rank() vs Dense_Rank()
Просмотров 357 месяцев назад
SQL Interview Questions - Row_Number() vs Rank() vs Dense_Rank()
Databricks - What are Materialized Views || Speed up your Lakeview dashboards
Просмотров 4537 месяцев назад
Databricks - What are Materialized Views || Speed up your Lakeview dashboards
SQL - What are the Key Differences Between Primary Key and Foreign Key
Просмотров 2347 месяцев назад
SQL - What are the Key Differences Between Primary Key and Foreign Key
PySpark - Replace Accented letters with their Non-Accented letters
Просмотров 1347 месяцев назад
PySpark - Replace Accented letters with their Non-Accented letters
Orchestration- Databricks Workflow VS Azure Data Factory
Просмотров 3287 месяцев назад
Orchestration- Databricks Workflow VS Azure Data Factory
DataBricks- Delta Lake Saves Your Money in many ways
Просмотров 267 месяцев назад
DataBricks- Delta Lake Saves Your Money in many ways
DataBricks - How to load CSV Or JSON files from AWS S3 to dataframe by using PySpark
Просмотров 6607 месяцев назад
DataBricks - How to load CSV Or JSON files from AWS S3 to dataframe by using PySpark
Alteryx - How to Use RegEx Tool and Formula Tool
Просмотров 2747 месяцев назад
Alteryx - How to Use RegEx Tool and Formula Tool
RedShift - How to Import CSV/JSON Files into RedShift Serverless
Просмотров 2957 месяцев назад
RedShift - How to Import CSV/JSON Files into RedShift Serverless
DataBricks - Retrieve matched rows from two Dataframes or Files by Using PySpark
Просмотров 788 месяцев назад
DataBricks - Retrieve matched rows from two Dataframes or Files by Using PySpark
DataBricks - How to Find out Returning Customers within 7 days in PySpark
Просмотров 418 месяцев назад
DataBricks - How to Find out Returning Customers within 7 days in PySpark
DataBricks - How to apply Data Cleansing in Dataframe By Using PySpark
Просмотров 2048 месяцев назад
DataBricks - How to apply Data Cleansing in Dataframe By Using PySpark
DataBricks - How to Sum Up Multiple Columns in Dataframe By Using PySpark
Просмотров 918 месяцев назад
DataBricks - How to Sum Up Multiple Columns in Dataframe By Using PySpark
DataBricks - Transpose OR Pivot OR Rows to Columns in Dataframe By Using PySpark
Просмотров 3408 месяцев назад
DataBricks - Transpose OR Pivot OR Rows to Columns in Dataframe By Using PySpark
PySpark - How to Add Or Update Multiple Columns in Dataframe
Просмотров 1758 месяцев назад
PySpark - How to Add Or Update Multiple Columns in Dataframe
Python - How to Update Multiple Columns in Dataframe
Просмотров 1218 месяцев назад
Python - How to Update Multiple Columns in Dataframe
Python - How to Add Multiple Columns in DataFrame
Просмотров 1418 месяцев назад
Python - How to Add Multiple Columns in DataFrame
AWS - Write Event-Driven Lambda Function To Read CSV Files from S3 | Easy to Go Example
Просмотров 2808 месяцев назад
AWS - Write Event-Driven Lambda Function To Read CSV Files from S3 | Easy to Go Example
AWS - How to Write Your First AWS Lambda Function | Easy to Go Example
Просмотров 838 месяцев назад
AWS - How to Write Your First AWS Lambda Function | Easy to Go Example
AWS - Introduction of Lambda Function and Key Features
Просмотров 288 месяцев назад
AWS - Introduction of Lambda Function and Key Features
SSRS - How to use LookUp, LookupSet and MultiloopUp functions
Просмотров 3888 месяцев назад
SSRS - How to use LookUp, LookupSet and MultiloopUp functions
Excellent👍
Sir, I want to know how to do fuzzy matching in lookup, or what method can be used to achieve similar effects with fuzzy matching. Because the data source A is bound to the table, when rendering A, you need to take the filed of A to fuzzy query the title in B to find all the data and join the string.
will this append all the data in a bucket if new files are added?
My file was contains 16900 rows.when I mapped file to table.i want each file 1000 rows.how to achieve this can u tell me??
Getting the below error Exception in component tAzureStorageList_1 (AzureMFTBlob) java.lang.IllegalArgumentException: The String is not a valid Base64-encoded string. Could you please help
Sure, let me check this.
very clear explaination.
Very informative...
Thanks Mukesh! I was just working on this process. You are very helpful.
Glad it was helpful!
Hi sir, little bit disturbence is there. Pls could you give notes sir, thank you sir.
Sorry for that
Greetings from Venezuela, you are the master. You are the best.
This is very useful information. Thank you So much But somehow it is not working for me.I am trying to rename tab with group name like suggested in the video and it is not doing the same for me.Any more details to check and fix are appreciated
Please send your settings... I will check your group details.
Great tutorial! Thanks!
Glad it was helpful!
good , thanks
Thank you too
I don't have such database mail option in my sql server. I'm using sql server management studio 2022. what can i do? please reply
You have to check, which version are you using?
This saved the day. I had an SSIS package that was doing this with 70 different data flows and this replaced that in 30 minutes. You are the best!
no audio
Thanks for your time I am watching from Adelaide - Australia
Thanks for watching!
Thanks for the insight. Mukesh
Thank you so much. I was really having hardwire deploying successfully
Thank you for this video. Is it possible to ask questions about setbacks or errors?
Yes...
𝕯𝖏 𝖉𝖍𝖆𝖉𝖐𝖆𝖓
Apna bhai king Sarzan dj ❤❤❤❤
Ok..🛕
Amar❤❤❤dj
❤❤❤❤❤❤❤❤❤❤❤❤❤❤🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Jayy Mahadev
short and sweet
good
Har har mahadev
🚩🙏HAR HAR MAHADEV 🙏🚩
Har har Mahakal
❤❤
🇮🇳💖🇮🇳🚩🕉️🔱🎎HAR 🌺 HAR 🌺 MAHADEV 🎎🌺💐🙏🙏🇮🇳🚩🚩
Har har Mahadev
🙏🏻🙏🏻🙏🏻🙏🏻
How you have installed the libraries and dependencies. Please guide us
You can easily install them through a notebook as well.
Super example
How do I validate fixed width flat file using total row length in ssis using script task or script component
Please can you explain your task in more detail...
@@Sql-datatools actually if u have a fixed width flat file and want to capture invalid length characters from valid length characters in the fixed width flat file, how do you do it in ssis script task or script component?
Great video! Thanks!
Glad you liked it!
Thank you for this, exactly what I needed.
Glad it was helpful! ☺️
How to add date when report created and page numbers
You can add date and page numbers in the report header as well as in the report footer.
Can you give a Pyspark code for : Removing all special characters from the column names and dealing with the duplicate column names. For example : if after transforming 2 cols : Col A and Col (A) as : Col_A and Col_A we want to keep both but somehow maintain the code to do it?
Sure, we will create a video for this as well.
Thank you.
Hi, how to find a parent node path in collection of mongodb?
Thank you so much. this video is really so helpfull😍
Hawa Hawai... Ghaziabad ❤
where to get the components?
❤
can you do one for colab?
Yes
Looks like I am not a boy according to the admin.. 😂😂 gender revealed.. Wow..