- Important Concepts
- Introduction to Power BI
- Power BI Set up
- Importing Data into Power BI Desktop
- Data Import Practice
- Where is the data stored?
Online
₹ 3,199
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
Power BI enhances Excel's capacity to empower non-programming professionals in the data-driven era. Excel and Power BI are compatible. This enables the combined use of the two platforms for a variety of business operations and BI practices. Power BI for Excel Users - The work Smarter, Grow Faster certification course is created by Dr. Nitin Paranjape who is an Adoption and Change Management Consultant, and is offered by Udemy.
Power BI for Excel Users - The work Smarter, Grow Faster online course is a comprehensive programme that includes 3 hours of learning resources and 26 articles with lifetime access for the participants who want to learn how to advance in power BI. Power BI for Excel Users - Work Smarter, Grow Faster online training includes, bringing together information from several places, preparing Power BI Analysis data and spreadsheets, developing a data model, and recognizing which sort of visualization to employ based on business requirements, charts, graphs, and more.
The highlights
- Certificate of completion
- Self-paced course
- 3 hours of pre-recorded video content
- 26 articles + resources
- Learning resources
Program offerings
- Online course
- Learning resources
- 30-day money-back guarantee
- Unlimited access
- Accessible on mobile devices and tv
Course and certificate fees
Fees information
certificate availability
certificate providing authority
What you will learn
After completing the Power BI for Excel Users - Work Smarter, Grow Faster online certification, participants will acquire a solid understanding of the concepts involved with good and bad data, learn how to identify inefficiencies, and Import millions of data rows to generate interactive dashboards. Applicants can master transnational data by utilizing master data and determining which sort of visualization to employ based on business needs and Quick Insights"
The syllabus
Introduction to Power BI Desktop
Cleaning up the data
- The Eleven Commandments of Good Data
- How to clean up cross-tab data
- How to clean up multiple cross-tab data
- Combine Multiple cross tabs in Power Query
- Combining Data from multiple Sheets or Files
- Import data from PDF
- Power BI Data
Creating a Cohesive Database
- Eliminating VLOOKUP using Relationships
- Adding Calculated Columns
Working with Dates
- Working with Dates Overview
- Creating a custom Date Table
Creating Reports in Power BI Desktop
- Creating reports
- Filtering Reports
- Publishing Reports to Power BI Portal
- Keeping the Reports updated
- Viewing the Data behind the Visualization
- Quiz Time
Working with DAX
- Calculated Columns
- Text Grouping and RELATEDTABLE
- Bin Analysis
- New Measure or New Column - Which one to use when?
- Time Intelligence - Comparing current data with the past
- Dax Quiz
Practical Scenarios
- Comparing Budget vs Actuals
- Use AI to understand rise and fall of business parameters
Powerful Features of Power BI
- Facebook Analytics
- Natural language Q&A: Just type a question and create a report
- Row Level Security - Controlling who can see what in Power BI
- Power BI Process Quiz
Putting it all together
- Excel and Power BI Integration
- Putting it all together