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 |
Requirements
| You must know how to use Excel. You must also know how to use Pivot Tables. |
| If you do not know Pivot Tables well, you can check my “Pivot Tables: Second Honeymoon” course. |
Description
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 |
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. |
