Gayatri Nagar, Nagpur, India - 440022.
Verified 
3
Details verified of Rohit Motghare✕
Identity
Education
Know how UrbanPro verifies Tutor details
Identity is verified based on matching the details uploaded by the Tutor with government databases.
Marathi
English
Hindi
Rashtrasant Tukdoji Maharaj Nagpur University 2023
Bachelor of Engineering (B.E.)
TCS iON 2021
TCS iON Career Edge - Young Professional
The Tools, Nagpur 2022
Microsoft Power BI Training
Gayatri Nagar, Nagpur, India - 440022
ID Verified
Education Verified
Phone Verified
Email Verified
Report this Profile
Is this listing inaccurate or duplicate? Any other problem?
Please tell us about the problem and we will fix it.
+15 more
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Teaching Experience in detail in Microsoft Power BI classes
I have strong knowledge of Business Intelligence and Data Analytics using Microsoft Power BI. I can conduct sessions to share my knowledge which can be most helpful to find various career opportunities in the industry.
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Microsoft Excel Training classes
3
Teaches following Excel features
Advanced Excel
Teaching Experience in detail in Microsoft Excel Training classes
I have 3+ years of practical experience using Microsoft Excel in real-time Data Analytics and Business Reporting projects. I have extensively worked on data cleaning, data analysis, financial reporting, MIS reporting, and dashboard creation using Excel. My expertise includes advanced formulas (VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS), Pivot Tables, Pivot Charts, conditional formatting, data validation, Power Query basics, and automation using Excel functions. I focus on helping students understand both fundamental and advanced concepts with real-world business scenarios. In my teaching approach, I emphasize hands-on practice, live examples, and industry-oriented assignments. I also provide interview preparation guidance and practical problem-solving techniques. My goal is to make students confident in handling Excel efficiently for jobs, business reporting, and career growth.
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in SQL Programming Training
3
Teaching Experience in detail in SQL Programming Training
I have 3+ years of industry experience using SQL in real-time Data Analytics and Business Intelligence projects. I have worked extensively with SQL Server and Azure SQL Database, handling large datasets, writing complex queries, joins, subqueries, CTEs, window functions, stored procedures, and optimizing queries for performance. I have built financial reports such as P&L, revenue, and billing dashboards using SQL. In my teaching, I focus on strong fundamentals, practical hands-on practice, real-world scenarios, and interview preparation. I help students develop logical thinking and problem-solving skills so they can confidently crack interviews and work on real industry projects.
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Tableau Training
3
Teaching Experience in detail in Tableau Training
I have 3+ years of hands-on experience working with Tableau in real-time Data Analytics and Business Intelligence projects. I have designed interactive dashboards, KPI reports, financial dashboards (P&L, revenue, billing), and performance tracking reports for business stakeholders. My expertise includes data modeling, calculated fields, LOD expressions, parameters, filters, dashboard actions, blending, and performance optimization. I have worked with multiple data sources including SQL databases, Excel, and cloud platforms. In my teaching approach, I focus on strong fundamentals, practical dashboard building, real-world business scenarios, and interview-oriented preparation. Students learn not just visualization, but storytelling with data, dashboard best practices, and how to handle real industry projects confidently. My goal is to make students job-ready and capable of building professional, impactful dashboards independently.
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Azure Data Factory Training
3
Teaching Experience in detail in Azure Data Factory Training
I have 3+ years of hands-on experience working with Azure Data Factory in real-time Data Engineering and Data Analytics projects. I have designed and implemented end-to-end ETL/ELT pipelines for data integration, transformation, and migration across multiple data sources. My expertise includes building pipelines, linked services, datasets, data flows, triggers, parameterization, incremental loading, error handling, and monitoring. I have worked with Azure SQL Database, Blob Storage, Data Lake, and on-premise sources using Integration Runtime. In my teaching approach, I focus on strong fundamentals, architecture understanding, and practical pipeline development with real-world scenarios. Students gain hands-on experience in building, debugging, and optimizing data workflows. My goal is to make students industry-ready for Data Engineer and Cloud Data roles with confidence in handling real-time Azure projects.
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Python Training classes
3
Course Duration provided
1-3 months
Seeker background catered to
Individual, Corporate company, Educational Institution
Certification provided
No
Python applications taught
Data Analysis with Python , Data Visualization with Python
Teaching Experience in detail in Python Training classes
I have 3+ years of hands-on experience using Python in Data Analytics and automation projects. I have worked extensively with Python for data manipulation, analysis, reporting, and building practical business solutions. My expertise includes core Python concepts, data structures, functions, OOP, file handling, exception handling, and working with libraries such as Pandas, NumPy, and Matplotlib for data analysis and visualization. I also guide students in writing clean, efficient, and optimized code with proper logic-building techniques. In my teaching approach, I focus on strong fundamentals, practical coding exercises, real-world datasets, and interview-oriented preparation. Students get hands-on experience through assignments and mini-projects. My goal is to make students confident programmers who can apply Python effectively in real industry scenarios.
Upcoming Live Classes
5 out of 5 3 reviews
Sahadevi Ramesh kannake
"I attended a free demo session for Power BI from Rohit Sir, it was so informative and beneficial for me. Teaching style of sir is awesome and projects assigned on Power BI help me a lot to hands on skills thoroughly. Overall best learning experience with rohit sir. "
Pratiksha Ashok meshram
"I attended a free demo session for Power BI from Rohit Sir, it was so informative and beneficial for me. Teaching style of sir is awesome and projects assigned on Power BI help me a lot to hands on skills thoroughly. Overall best learning experience with rohit sir. "
Renu Bhaskar karhade
"I learned Power BI from Rohit Sir. It was a great experience of learning with hands-on project work. It help me lot to understand real time industry scenarios and importance of business intelligence in the industry. "
Reply by Rohit
Thank you Renu for your kind feedback. and all the best for your bright career.
1. Which classes do you teach?
I teach Azure Data Factory Training, Data Analytics, Microsoft Excel Training, Microsoft Power BI, Python Training, SQL Programming and Tableau Classes.
2. Do you provide a demo class?
Yes, I provide a free demo class.
3. How many years of experience do you have?
I have been teaching for less than a year.
Answered on 29/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
To compute factorial using VBA in Excel, you can utilize this function. First, access the VBA editor by pressing Alt + F11, insert a new module via Insert > Module, and paste the provided code. The function Factorial(num) takes a number as input and returns its factorial value. Simply input =Factorial(number) into an Excel cell, replacing number with the desired value for which you want to compute the factorial. This VBA code employs a straightforward iterative loop to calculate the factorial of the given number.
Answered on 29/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
To incorporate Solver in Excel, first enable the Solver Add-In by navigating to "File" > "Options" > "Add-Ins" > "Excel Add-ins," and check the "Solver Add-in" box before clicking "OK." Once activated, access Solver in the "Data" tab. Click on the "Solver" icon to open the Solver Parameters dialog box. Here, define the objective cell, set constraints for variables, select the solving method, and adjust Solver options. Clicking "Solve" initiates Solver to find a solution that aligns with your specified criteria. Upon completion, review the results to keep the solution or revert to the initial values based on Solver's findings. Solver proves effective for optimizing scenarios such as financial planning, resource allocation, and scheduling by dynamically adjusting variables to meet defined conditions and objectives within Excel.
Answered on 29/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
To automatically update one Excel worksheet from another, you can use various methods:
Formulas/Cell References: Utilize cell references or formulas like =SheetName!A1 in the target sheet to link and display data from another worksheet. Any changes made in the original worksheet will automatically update the linked cells in the target sheet, ensuring real-time synchronization of data.
VBA Macros: Employ VBA macros to automate data transfer between sheets. With VBA, you can create scripts to copy specific ranges or entire datasets from one worksheet to another, allowing for more complex data manipulation or custom updating processes based on your requirements.
Data Connections or Power Query: Establish data connections or use Power Query to pull in data dynamically from another worksheet. By setting up connections or using Power Query transformations, you can link sheets and update data in one worksheet based on changes in the source, offering a more automated and structured approach to data updates.
Select the method that aligns best with your workflow and data updating needs within Excel.
Answered on 29/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
To modify only the last three digits of a serial number string in Excel VBA, extract the last three characters, convert them to a number, add your desired value while ensuring it stays within a three-digit range, then update the original string with the modified digits. Here's a concise code snippet:
Sub IncreaseLastThreeDigits()
Dim serialNumber As String
serialNumber = "ABC123456" ' Replace with your serial number
Dim lastDigits As Long
lastDigits = (CLng(Right(serialNumber, 3)) + 100) Mod 1000 ' Increase by 100 (for example)
serialNumber = Left(serialNumber, Len(serialNumber) - 3) & Format(lastDigits, "000") ' Update serial number
MsgBox "Updated Serial Number: " & serialNumber ' Display updated serial number
End Sub
Replace "ABC123456" with your actual serial number string and adjust the + 100 part to increase the last three digits by your desired value. Execute this code in Excel VBA to view the updated serial number in a message box.
Answered on 28/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Teaching Experience in detail in Microsoft Power BI classes
I have strong knowledge of Business Intelligence and Data Analytics using Microsoft Power BI. I can conduct sessions to share my knowledge which can be most helpful to find various career opportunities in the industry.
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Microsoft Excel Training classes
3
Teaches following Excel features
Advanced Excel
Teaching Experience in detail in Microsoft Excel Training classes
I have 3+ years of practical experience using Microsoft Excel in real-time Data Analytics and Business Reporting projects. I have extensively worked on data cleaning, data analysis, financial reporting, MIS reporting, and dashboard creation using Excel. My expertise includes advanced formulas (VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS), Pivot Tables, Pivot Charts, conditional formatting, data validation, Power Query basics, and automation using Excel functions. I focus on helping students understand both fundamental and advanced concepts with real-world business scenarios. In my teaching approach, I emphasize hands-on practice, live examples, and industry-oriented assignments. I also provide interview preparation guidance and practical problem-solving techniques. My goal is to make students confident in handling Excel efficiently for jobs, business reporting, and career growth.
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in SQL Programming Training
3
Teaching Experience in detail in SQL Programming Training
I have 3+ years of industry experience using SQL in real-time Data Analytics and Business Intelligence projects. I have worked extensively with SQL Server and Azure SQL Database, handling large datasets, writing complex queries, joins, subqueries, CTEs, window functions, stored procedures, and optimizing queries for performance. I have built financial reports such as P&L, revenue, and billing dashboards using SQL. In my teaching, I focus on strong fundamentals, practical hands-on practice, real-world scenarios, and interview preparation. I help students develop logical thinking and problem-solving skills so they can confidently crack interviews and work on real industry projects.
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Tableau Training
3
Teaching Experience in detail in Tableau Training
I have 3+ years of hands-on experience working with Tableau in real-time Data Analytics and Business Intelligence projects. I have designed interactive dashboards, KPI reports, financial dashboards (P&L, revenue, billing), and performance tracking reports for business stakeholders. My expertise includes data modeling, calculated fields, LOD expressions, parameters, filters, dashboard actions, blending, and performance optimization. I have worked with multiple data sources including SQL databases, Excel, and cloud platforms. In my teaching approach, I focus on strong fundamentals, practical dashboard building, real-world business scenarios, and interview-oriented preparation. Students learn not just visualization, but storytelling with data, dashboard best practices, and how to handle real industry projects confidently. My goal is to make students job-ready and capable of building professional, impactful dashboards independently.
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Azure Data Factory Training
3
Teaching Experience in detail in Azure Data Factory Training
I have 3+ years of hands-on experience working with Azure Data Factory in real-time Data Engineering and Data Analytics projects. I have designed and implemented end-to-end ETL/ELT pipelines for data integration, transformation, and migration across multiple data sources. My expertise includes building pipelines, linked services, datasets, data flows, triggers, parameterization, incremental loading, error handling, and monitoring. I have worked with Azure SQL Database, Blob Storage, Data Lake, and on-premise sources using Integration Runtime. In my teaching approach, I focus on strong fundamentals, architecture understanding, and practical pipeline development with real-world scenarios. Students gain hands-on experience in building, debugging, and optimizing data workflows. My goal is to make students industry-ready for Data Engineer and Cloud Data roles with confidence in handling real-time Azure projects.
Class Location
Online class via Zoom
Student's Home
Tutor's Home
Years of Experience in Python Training classes
3
Course Duration provided
1-3 months
Seeker background catered to
Individual, Corporate company, Educational Institution
Certification provided
No
Python applications taught
Data Analysis with Python , Data Visualization with Python
Teaching Experience in detail in Python Training classes
I have 3+ years of hands-on experience using Python in Data Analytics and automation projects. I have worked extensively with Python for data manipulation, analysis, reporting, and building practical business solutions. My expertise includes core Python concepts, data structures, functions, OOP, file handling, exception handling, and working with libraries such as Pandas, NumPy, and Matplotlib for data analysis and visualization. I also guide students in writing clean, efficient, and optimized code with proper logic-building techniques. In my teaching approach, I focus on strong fundamentals, practical coding exercises, real-world datasets, and interview-oriented preparation. Students get hands-on experience through assignments and mini-projects. My goal is to make students confident programmers who can apply Python effectively in real industry scenarios.
5 out of 5 3 reviews
Sahadevi Ramesh kannake
"I attended a free demo session for Power BI from Rohit Sir, it was so informative and beneficial for me. Teaching style of sir is awesome and projects assigned on Power BI help me a lot to hands on skills thoroughly. Overall best learning experience with rohit sir. "
Pratiksha Ashok meshram
"I attended a free demo session for Power BI from Rohit Sir, it was so informative and beneficial for me. Teaching style of sir is awesome and projects assigned on Power BI help me a lot to hands on skills thoroughly. Overall best learning experience with rohit sir. "
Renu Bhaskar karhade
"I learned Power BI from Rohit Sir. It was a great experience of learning with hands-on project work. It help me lot to understand real time industry scenarios and importance of business intelligence in the industry. "
Reply by Rohit
Thank you Renu for your kind feedback. and all the best for your bright career.
Answered on 29/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
To compute factorial using VBA in Excel, you can utilize this function. First, access the VBA editor by pressing Alt + F11, insert a new module via Insert > Module, and paste the provided code. The function Factorial(num) takes a number as input and returns its factorial value. Simply input =Factorial(number) into an Excel cell, replacing number with the desired value for which you want to compute the factorial. This VBA code employs a straightforward iterative loop to calculate the factorial of the given number.
Answered on 29/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
To incorporate Solver in Excel, first enable the Solver Add-In by navigating to "File" > "Options" > "Add-Ins" > "Excel Add-ins," and check the "Solver Add-in" box before clicking "OK." Once activated, access Solver in the "Data" tab. Click on the "Solver" icon to open the Solver Parameters dialog box. Here, define the objective cell, set constraints for variables, select the solving method, and adjust Solver options. Clicking "Solve" initiates Solver to find a solution that aligns with your specified criteria. Upon completion, review the results to keep the solution or revert to the initial values based on Solver's findings. Solver proves effective for optimizing scenarios such as financial planning, resource allocation, and scheduling by dynamically adjusting variables to meet defined conditions and objectives within Excel.
Answered on 29/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
To automatically update one Excel worksheet from another, you can use various methods:
Formulas/Cell References: Utilize cell references or formulas like =SheetName!A1 in the target sheet to link and display data from another worksheet. Any changes made in the original worksheet will automatically update the linked cells in the target sheet, ensuring real-time synchronization of data.
VBA Macros: Employ VBA macros to automate data transfer between sheets. With VBA, you can create scripts to copy specific ranges or entire datasets from one worksheet to another, allowing for more complex data manipulation or custom updating processes based on your requirements.
Data Connections or Power Query: Establish data connections or use Power Query to pull in data dynamically from another worksheet. By setting up connections or using Power Query transformations, you can link sheets and update data in one worksheet based on changes in the source, offering a more automated and structured approach to data updates.
Select the method that aligns best with your workflow and data updating needs within Excel.
Answered on 29/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
To modify only the last three digits of a serial number string in Excel VBA, extract the last three characters, convert them to a number, add your desired value while ensuring it stays within a three-digit range, then update the original string with the modified digits. Here's a concise code snippet:
Sub IncreaseLastThreeDigits()
Dim serialNumber As String
serialNumber = "ABC123456" ' Replace with your serial number
Dim lastDigits As Long
lastDigits = (CLng(Right(serialNumber, 3)) + 100) Mod 1000 ' Increase by 100 (for example)
serialNumber = Left(serialNumber, Len(serialNumber) - 3) & Format(lastDigits, "000") ' Update serial number
MsgBox "Updated Serial Number: " & serialNumber ' Display updated serial number
End Sub
Replace "ABC123456" with your actual serial number string and adjust the + 100 part to increase the last three digits by your desired value. Execute this code in Excel VBA to view the updated serial number in a message box.
Answered on 28/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
Want to learn from Rohit?
Share this Profile
Reply to 's review
Enter your reply*
Your reply has been successfully submitted.
Certified
The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.
