Learn Data Visualization and Analysis Using Power BI from the basic to advanced level
Converting raw data to insightful diagrams and charts to make informative decisions is a crucial analytical skill in data science. You will in this course how to create powerful charts and perform data analysis. First, you will understand data visualization, and why data visualization. After that you will understand Power BI services and the use of each of them. After you became familiar with these services and their usage you will learn how to install and navigate in Power BI Desktop. After that, you will learn how to use advanced functions for data preparation and cleaning. You will learn to append and merge several datasets in one dataset to create thorough analytical charts. After that you will learn to convert your datasets to insightful charts using many useful functions. You will learn how to filter your data according to your business requirements. You will learn how to create measures and calculated columns for your own data analysis. You will have an introduction to DAX language where you can learn how to create new tables and columns based on your needs. After that you will learn publish your project to Power BI Pro in the Cloud where you can share your work with other users. You will learn how use Power BI Pro interface to create, edit and share reports. After completing this course, you will be confidently able to add Power BI to the list of your analytical skills in your resume.
What you’ll learn
- Install and use Power BI Desktop.
- Understand Data Visualization.
- Create different types of diagrams and charts.
- Learn datasets merge and append and use them in diagrams.
- Create calculated fields using DAX Language.
- Learn data preparation and cleaning such as converting data types, split columns, pivot and unpivot and more.
Course Content
- Introduction –> 6 lectures • 16min.
- Data Cleaning and Preparation –> 27 lectures • 1hr 25min.
- Data Visualization –> 26 lectures • 1hr 8min.
- Work on Projects in the Cloud with Power BI Pro –> 9 lectures • 25min.
Requirements
Converting raw data to insightful diagrams and charts to make informative decisions is a crucial analytical skill in data science. You will in this course how to create powerful charts and perform data analysis. First, you will understand data visualization, and why data visualization. After that you will understand Power BI services and the use of each of them. After you became familiar with these services and their usage you will learn how to install and navigate in Power BI Desktop. After that, you will learn how to use advanced functions for data preparation and cleaning. You will learn to append and merge several datasets in one dataset to create thorough analytical charts. After that you will learn to convert your datasets to insightful charts using many useful functions. You will learn how to filter your data according to your business requirements. You will learn how to create measures and calculated columns for your own data analysis. You will have an introduction to DAX language where you can learn how to create new tables and columns based on your needs. After that you will learn publish your project to Power BI Pro in the Cloud where you can share your work with other users. You will learn how use Power BI Pro interface to create, edit and share reports. After completing this course, you will be confidently able to add Power BI to the list of your analytical skills in your resume.