From Excel to Power BI
Description
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
-
Help you learn Power BIÂ faster using the Excel knowledge you already have
-
Make you self-sufficient in applying this knowledge to your work
Preparation
If you use Excel, you are good to go.
No special preparation is required.
Just dive into the course and start learning.
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 be surprised at the simplicity and effectiveness of Dr. Nitin’s approach.
No knowledge of any programming language or database is necessary.
Difficulty Level
200
Topics covered:
The entire Power BIÂ life-cycle is covered.
– Power BI – the concepts
– Importing data from various sources
– Preparing data for Analysis in Power BI
– Creating a cohesive database
– Working with dates
– Creating reports
– Working with DAX
– Natural language Q&A
– Facebook AnalyticsÂ
– Power BIÂ within Excel
Â
Who this course is for:
- Do you spend lot of time in getting data, cleaning it up and creating reports? Then this course is for you.
- This course is NOT for developers or SQL / Database programmers.
Course content
- Introduction to Power BI Desktop
- Cleaning up the data
- Creating a Cohesive Database
- Working with Dates
- Creating Reports in Power BI Desktop
- Working with DAX
- Practical Scenarios
- Powerful Features of Power BI
- Putting it all together
Price
: 49.99 EUR
Brand
Dr. Nitin Paranjape
12 reviews for From Excel to Power BI Dr. Nitin Paranjape, Sale
There are no reviews yet.