Description
If you're a data professional or aspiring analyst looking to learn the top business intelligence platform on the market, you've come to the right place. You want to analyze data from single or multiple sources? You want to create your individual datasets based on these sources and transform your results into beautiful and easy-to-make visualizations? You also want to share your results with colleagues or collaborate on your projects? Finally, you want to be able to access your data from multiple devices?Then the Power BI tools are the tools to choose for you! POWER BI SKILLS ARE IN HIGH DEMANDAs companies worldwide implement Power BI solutions, there's a big gap in the job market for skilled professionals. People who learn Power BI today, will be first in line for the best jobs tomorrow. Get access to our best-selling Power BI course now and become a highly sought-after Power BI professional. In this course you will learn why Power BI offers you a comprehensive set of Business Intelligence tools for your data analysis goals and how to use these tools to fulfill all of the above tasks - and more. Imagine to quickly structure your data, to easily add calculations to it and to create and publish nice-looking charts in just a few minutes. This is what you will learn: Get to know the different tools of the Power BI universe and learn how to use themUnderstand Power BI Desktop and its componentsLearn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two stepsLearn how to filter and format data, how pivoting and unpivoting worksHow to work in the different views of the Data ModelHow to create calculated columns and measuresHow to build relationships between different tablesHow to create a report with different interactive visualization typesLearn how to use Power BI Pro to create dashboards and to share and publish your resultsHow to access your results from multiple devices using Power BI MobileAnd more! Power Query is an ETL tool created by Microsoft for data extraction, loading and transformation, and is used to retrieve data from sources, process it, and load them into one or more target systems. PQ 1 - What is Power QueryPQ 2 - Data TypesPQ 3 - Fixing Dates & Date Locale SettingPQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATESPQ 5 - Split ColumnsPQ 6 - MergePQ 7 - Filtering RowsPQ 8 - Removing Duplicates and ErrorsPQ 9 - SortingPQ 10 - Appending Data from Multiple Excel WorksheetsPQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet NamesPQ 13 - Replace and FillPQ 14 - Formatting Numbers and DatesPQ 15 - Adding Custom Calculated ColumnsPQ 16 - GroupByPQ 17 - UnpivotPQ 18 - 6 Types of JoinsPQ 19 - Create Calendar in PQ vs. DAX
