mndatasolutions
Turbodata: faster, easier reporting through data compression and sql reduction. In this channel we discuss about SQL-from a datawarehousing perspective, ETL. We have taken many instances from an easily available Indian ERP and developed datawarehouse for the same.
Ask queries regarding Turbodata: lead-0c4eff.zapier.app/
Whom is the channel for?
a.) Mobile app developers
b.) Freshers looking for datawarehousing jobs in sql and powerbi
c.) Recruiters looking for personnel in a quick fashion
Website link:sites.google.com/turbodatatool.com/turbodatatool/h…
Follow the turbodata channel on WhatsApp: whatsapp.com/channel/0029VaKzXFk4tRrnNEBi3d1n
Posts
mndatasolutions
https://youtu.be/roCllHyGOis?si=h80-z... Do send your sample spreadsheets for automation. contact Apoorv Chaturvedi:+91-8802466356,email:support@mndatasolutions.com;support@turbodatatool.com;youtube channel:youtube.com/@mndatasolutions2042;website:https://w… - https://www.youtube.com/watch?v=roCll....Rohit Prajapati: best in class sql, powerbi developer with extensive Python knowledge.https://drive.google.com/drive/folders/16_XFRkDJ0SqpXQaYFKtuuJRT1xfj3j9f?usp=sharing
15 hours ago | [YT] | 0
View 0 replies
mndatasolutions
Inserting data from json into sql server: Do send your sample spreadsheets for automation. contact Apoorv Chaturvedi:+91-8802466356,email:support@mndatasolutions.com;support@turbodatatool.com;youtube channel:youtube.com/@mndatasolutions2042;website:https://w… - https://www.youtube.com/watch?v=_e6xO....Rohan: a good python Developer available for immediate hire.https://drive.google.com/drive/folders/1aeZj2Y3MxRRrxLJEQvMKAYEA8QCMIdCF?usp=sharing
16 hours ago | [YT] | 0
View 0 replies
mndatasolutions
Insert, updates and deletes in sql datawarehouse. Use of merge transform. Do send your sample spreadsheets for automation. contact Apoorv Chaturvedi:+91-8802466356,email:support@mndatasolutions.com;support@turbodatatool.com;youtube channel:youtube.com/@mndatasolutions2042;website:https://w… - https://www.youtube.com/watch?v=B-odS....Rohit Prajapati: best in class sql, powerbi developer with extensive Python knowledge.https://drive.google.com/drive/folders/16_XFRkDJ0SqpXQaYFKtuuJRT1xfj3j9f?usp=sharing
16 hours ago | [YT] | 0
View 0 replies
mndatasolutions
IN THIS VIDEO WE LOOK AT TYPICAL INTERVIEW QUESTIONS INVOLVING THE FOLLOWING:A.) Converting columns to rowsb.) Number of rows in joins Do send your sample spreadsheets for automation. contact Apoorv Chaturvedi:+91-8802466356,email:support@mndatasolutions.com;support@turbodatatool.com;youtube channel:youtube.com/@mndatasolutions2042;website:https://w… - https://www.youtube.com/watch?v=jbLs1....Rohit Prajapati: best in class sql, powerbi developer with extensive Python knowledge.https://drive.google.com/drive/folders/16_XFRkDJ0SqpXQaYFKtuuJRT1xfj3j9f?usp=sharing
16 hours ago | [YT] | 0
View 0 replies
mndatasolutions
In this video we explain with an example how to convert an user defined scalar function to DAX using Calculate. Whom is this video for ?a.) SQL resources looking for Powerbi skillsb.) SQL developers seeking to convert their sql code to PowerbiFor more details look into the channel:Powerbi : • Using slicer, RankX and summarize to ... SQL: • SQL_D: Handling merge transform in sql Mutual funds: • Mutual fund analysis Purchase planning: • Part 2-inventory valuation on the las... Do send your sample spreadsheets for automation. contact Apoorv Chaturvedi:+91-8802466356,email:support@mndatasolutions.com;support@turbodatatool.com;youtube channel:youtube.com/@mndatasolutions2042;website:https://w… - https://www.youtube.com/watch?v=7tReS....Rohit Prajapati: best in class sql, powerbi developer with extensive Python knowledge.https://drive.google.com/drive/folders/16_XFRkDJ0SqpXQaYFKtuuJRT1xfj3j9f?usp=sharing
16 hours ago | [YT] | 0
View 0 replies
mndatasolutions
In this set of videos we discuss how to reduce the long running query execution times by using the Datawarehouse methodology. As a first step we create the staging layer using SQL wherein we extract the required columns into a staging layer tables (using truncate concept). How to deduce a staging layer from a complex query is given in this video.Whom is this video for?a.) Students looking for employment in data warehousingb.) SQL developers facing long query running times.c.) Mobile app developers Do send your sample spreadsheets for automation. contact Apoorv Chaturvedi:+91-8802466356,email:support@mndatasolutions.com;support@turbodatatool.com;youtube channel:youtube.com/@mndatasolutions2042;website:https://w… - https://www.youtube.com/watch?v=m8Lg6....Pranavi: a good SQL Developer with over 2 years of experience. The resource has knowledge of SSIS.Please indicate if resource required in Chennai.https://drive.google.com/drive/folders/1xLAxqGHiWKzppecPigBFTbULJyIcnas8?usp=sharing
16 hours ago | [YT] | 0
View 0 replies
mndatasolutions
In this second part of the video, the first been • Using slicer, RankX and summarize to ... , we continue our analysis for generating the dashboards using the KPIs set by the client. We have worked with sample data. and have used summarized table for our analysis. Do send your sample spreadsheets for automation. contact Apoorv Chaturvedi:+91-8802466356,email:support@mndatasolutions.com;support@turbodatatool.com;youtube channel:youtube.com/@mndatasolutions2042;website:https://w… - https://www.youtube.com/watch?v=zi86X....Rohit Prajapati: best in class sql, powerbi developer with extensive Python knowledge.https://drive.google.com/drive/folders/16_XFRkDJ0SqpXQaYFKtuuJRT1xfj3j9f?usp=sharing
16 hours ago | [YT] | 0
View 0 replies
mndatasolutions
In this particular case we have looked at detailed working of how the Tally API integration can work. We have only looked at the token and the posting of the data. We have not gone into the merits of the report.The initial and incremental logic can be easily done at the database level.Please contact the following for a demo or API requirements. Most TDL developers or companies shall be able to do the API integration with this video and sample code from the site. Do send your sample spreadsheets for automation. contact Apoorv Chaturvedi:+91-8802466356,email:support@mndatasolutions.com;support@turbodatatool.com;youtube channel:youtube.com/@mndatasolutions2042;website:https://w… - https://www.youtube.com/watch?v=4feo-...
16 hours ago | [YT] | 0
View 0 replies
mndatasolutions
In this particular case we have looked at detailed working of how the Tally API integration can work. We have only looked at the token and the posting of the data. We have not gone into the merits of the report.The initial and incremental logic can be easily done at the database level. Do send your sample spreadsheets for automation. contact Apoorv Chaturvedi:+91-8802466356,email:support@mndatasolutions.com;support@turbodatatool.com;youtube channel:youtube.com/@mndatasolutions2042;website:https://w… - https://www.youtube.com/watch?v=4feo-...
16 hours ago | [YT] | 0
View 0 replies
mndatasolutions
In this live session we will look at analysis of mutual funds and financial instruments using Powerbi.One of our customers has a large set of investments in mutual funds. He is using Powerbi. We have hidden the customer, financial advisor name. Whom is this session for?\a.) Freshers looking for Powerbi jobsb.) Mutual fund investors looking to shift from Excel to Powerbi for analyticsFreshers can use this direct download from Value Reasearch to develop sample projects for thee finance industry. This module should be useful to gain entry into banks Do send your sample spreadsheets for automation. contact Apoorv Chaturvedi:+91-8802466356,email:support@mndatasolutions.com;support@turbodatatool.com;youtube channel:youtube.com/@mndatasolutions2042;website:https://w… - https://www.youtube.com/watch?v=8i343....Rohit Prajapati: best in class sql, powerbi developer with extensive Python knowledge.https://drive.google.com/drive/folders/16_XFRkDJ0SqpXQaYFKtuuJRT1xfj3j9f?usp=sharing
16 hours ago | [YT] | 0
View 0 replies
Load more