Business Intelligence with Microsoft Power BI - with Material

Description

This course will take you through the key tools of Power BI. You will learn how to use them to clean and visualize data and create impressive reports and dashboards with ease.

Whether you want to prepare your data for visualization or create eye-catching reports and dashboards from datasets, Power BI is the answer. This course will teach you the necessary Power BI tools, and you will gain the skills and confidence to use them effectively in the real world. The course starts by introducing you to Power BI and takes you through the setup process of Power BI on your machines. Next, you will learn how to create charts, maps, tables, and matrix in Power BI. Moving along, you will learn to use cards, filters, slicers, and advanced charts. Next, you will learn to insert objects, such as images, texts, and shapes, in Power BI and discover what are bookmarks and actions. As you advanced, you will learn to create, publish, and export reports using the Power BI service and become familiar with the text, date, and number functions. Finally, you will learn how to append data, understand merge queries, and go through additional important topics of Power BI, such as group, transpose, and unpivot.
By the end of this course, you will have the Power BI skills needed for turning huge chunks of boring datasets into impressive reports and dashboards. The code files and all related files are uploaded on GitHub at https://github.com/PacktPublishing/Business-Intelligence-with-Microsoft-Power-BI---with-Material

Use Power Query to clean data
Create maps of different countries and regions in Power BI
Discover how to work with advanced cards and slicers
Append data from various sources in Power BI
Use Power View to visualize data
Design impressive reports and dashboards

Whether you are new to Power BI or an experienced data analyst, who is looking to learn Power BI to present the data in the form of stunning reports and dashboards, this course is for you. A basic understanding of Microsoft Excel will be beneficial but is not mandatory.

With the help of interesting examples and engaging activities, this course will show you how to use Power BI for transforming data into impressive reports and dashboards.

Gain a solid understanding of Power BI tools * Learn how to get insights of data quickly and easily * Get ready to design impressive reports and dashboards using the various tools of Power BI

https://github.com/PacktPublishing/Business-Intelligence-with-Microsoft-Power-BI---with-Material

Pavan Lalwani is a highly skilled and self-motivated trainer who has expertise in various business intelligence tools, such as Power BI, Tableau, and Microsoft Excel. He has 10 years of experience in training individuals in different industry sectors, such as banking, finance, healthcare, IT, automobile, manufacturing, and pharmaceutical. His major clients include Mercedes-Benz, Loreal, IBM, L&T, Wipro, Bajaj Finance, ITC, DHL, Deutsche Bank, Yes Bank, Mahindra, Morgan Stanley, and Deloitte, among others that are spread across the globe. He believes in providing end-to-end solutions through his training videos and is himself responsible for designing the course content, quizzes, online training, clarifying doubts, and any additional help required.

1. Introduction to Power BI

2. Basic Charts in Power BI

3. Maps in Power BI

4. Tables and Matrix In Power BI

5. Other Charts in Power BI

6. Cards and Filters in Power BI

7. Slicers in Power BI

8. Advanced Charts in Power BI

9. Power BI Objects, Bookmarks and Actions

10. Power BI Services

11. Text Functions in Power Query

12. Date Functions

13. Number Functions in Power Query

14. Append Data in Power BI

15. Introduction to Merge Queries

16. Introduction to Conditional Column and Column from Example

17. Important Topics in Power BI

18. M Language