The profile of CA Rajat and their contact details have been verified by our experts
CA Rajat
- Rate TSh 41,370
- Response 5h
-
Students1
Number of students CA Rajat has accompanied since arriving at Superprof
Number of students CA Rajat has accompanied since arriving at Superprof
TSh 41,370/hr
Do you spend a lot of time getting data, cleaning it up, and creating reports? Then Start Learning Power Bi Dashboard to automate your tasks and analyze through Visual Dashboard
Lesson location
- Online
About CA Rajat
EDUCATIONAL PROFILE
Chartered Accountant. (CA)
Bachelor of Commerce (BCOM)
Diploma in Information Systems Audit (DISA)
Certification on Forensic Accounting & Fraud Detection (FAFD)
Certification on Concurrent Audit of Bank (CAB)
PROFESSIONAL PROFILE
Practicing CA in Chhattisgarh in the field of Audit, Income Tax & GST.
Faculty of Information Systems Audit- DISA ( Mentored Thousands of CA Members through video lectures )
Expert in Data Analytics with experience on IDEA Software, Excel- Power Query & Power BI.
Handled various automation projects and development MIS Dashboard.
Expert in Google Ads with experience on optimizing ad budgets for startups.
Expert in web development & SEO with experience on many WordPress projects.
Trainer and panelist for Various programs of ICAI.
CA Rajat is a passionate speaker and Business Consultant, with the mission to empower Chartered Accountants to achieve Financial Freedom through technological Advancement.
See more
About the lesson
- All Levels
- English
All languages in which the lesson is available :
English
What you'll learn
Understand what is good and bad data. Good data allows you to analyze it without wasting time in clean-up.
Identify incoming data as good or bad and clean it up very fast. (unimaginably fast)
Understand how to detect inefficiency while working and how to find the most efficient approach.
Combine transnational data with master data without using VLOOKUP
Import millions of rows of data and analyze it quickly
Learn which type of visualization to use depending upon business reuqirements
Create interactive and easy to understand dashboards using Power BI tools
Use Power BI capabilities to find out interesting but usually unseen insights about data using “Quick Insights”
Share the dashboards and reports with others in a secure manner
Objectives
1. Help you learn Power BI faster using the Excel knowledge you already have
2. Understand how to gather and clean data
3. Make you self-sufficient in applying this knowledge to your work
4. How to use Power BI and Excel to your advantage
Preparation
If you use Excel, you are good to go.
No special preparation is required.
Just dive into the course and start learning.
No Power BI license required.
Use Power BI Desktop – which is completely free.
No knowledge of any programming language or database is necessary.
Who should take this course
Anyone who is using Excel will benefit from this course.
If you want to learn Power BI directly, that is also fine. Because the concepts are common.
Even if you are an expert, you will find new concepts and ideas which will amplify your impact
This course will enhance your Excel skills as well because Power Query and Data Model are also available in Excel
Difficulty Level
The entire Power BI life-cycle is covered.
1. Power BI – the concepts
2. Importing data from various sources
3. Cleaning up data for Analysis in Power BI
4. Consolidating data across sheets and files
5. Creating a cohesive database (data model)
6. Creating visuals and interactive reports
7. Natural language Question and Answer
8. Introduction to DAX functions
9. Power BI within Excel
10. How to learn and next steps
See more
Rates
Rate
- TSh 41,370
Pack prices
- 5h: TSh 206,849
- 10h: TSh 413,699
online
- TSh41,370/h
CA Rajat's Video
Similar teachers in Rajnandgaon
MBIKIYE
& Online
- TSh 10,000/hr
- 1st lesson free
Edith
Dar es Salaam & Online
- TSh 30,000/hr
- 1st lesson free
Ibrahim
Dar es Salaam & Online
- TSh 30,000/hr
- 1st lesson free
Lucas
Mwanza
- TSh 40,000/hr
- 1st lesson free
Omary
Dar es Salaam & Online
- TSh 30,000/hr
- 1st lesson free
Mwanahawa
Arusha & Online
- TSh 15,000/hr
- 1st lesson free
Alphonce
Dar es Salaam & Online
- TSh 30,000/hr
- 1st lesson free
Michael Agustino
Dar es Salaam & Online
- TSh 20,000/hr
- 1st lesson free
Julius
Dar es Salaam & Online
- TSh 25,000/hr
- 1st lesson free
Muharram
Dar es Salaam & Online
- TSh 25,000/hr
- 1st lesson free
Shikha
Dar es Salaam
- TSh 15,000/hr
- 1st lesson free
Hoda
Dar es Salaam & Online
- TSh 20,000/hr
- 1st lesson free
Ester
Dodoma & Online
- TSh 3,000/hr
- 1st lesson free
Nuhu
Dodoma & Online
- TSh 40,000/hr
- 1st lesson free
Gippy
Songambele & Online
- TSh 20,000/hr
- 1st lesson free
Sarah
Dar es Salaam & Online
- TSh 120,000/hr
- 1st lesson free
Nart Murat
Dearing, United States & Online
- TSh 157,681/hr
- 1st lesson free
Fuad
Toronto, Canada & Online
- TSh 138,721/hr
- 1st lesson free
Al Hamza
Brooklyn, United States & Online
- TSh 91,981/hr
- 1st lesson free
Ryan
Toronto, Canada & Online
- TSh 138,721/hr
- 1st lesson free
-
See tutors
