A comprehensive guide on how to master Power BI Desktop and Power BI Online. Featuring a Formula One course project.
What you'll learn
Develop a business intelligence solution end to end
Create interactive and visually rich Reports
Understand how Power BI Service enables collaboration
Work with a range of data sources and become an expert at Loading and Transforming data from multiple sources
Understand Data Modelling in Power BI
Understand Reporting Best Practice
Create multiple visualizations
How to master Power BI for your real world projects!

Requirements
Windows Operating System
Some experience of Excel is a plus (but not essential)

Description
Learn one of the most in demand business intelligence tools around and master the most important concepts in the Power BI Ecosystem.This course is hands-on and you will LEARN BY DOING!COURSE PROJECTWe will be using a Formula One Dataset to create an interactive report with some amazing visualizations.Connect to various data sources including csv, excel, JSON and more.Perform extensive data transformations to make our data ready for reporting.Use relationships and data modelling methodologies to create an effective data model.Explore all kinds of visualisations from Column Charts, Scatter Charts, Maps, Tooltips and more.Use visual elements like action icons and buttons to navigate between pages in your report.Explore the capabilities of Power BI Pro and how it can enable you to collaborate within your OrganizationLeverage Data Analysis Expressions to add insight and analysis to our Power BI ReportBy the end of the Formula One Analysis Project you will gain extensive skills and have experience of developing a business intelligence solution end to end.You should gain more than enough experience to add value to your real world projects!CURRICULUMThis course can be split into 5 key areas:Loading and Transforming DataConnecting to data sources in Power BIUnderstanding Data TypesTransforming Columns in your QueryAdding Columns to your QuerySorting and FilteringDuplicating vs Referencing your QueryTransposing your dataGrouping and summarising your dataPivoting and Unpivoting your dataData ModellingTable RelationshipsOne to Many, One to One and Many to Many CardinalityAutodetect"Active" vs "Inactive" RelationshipsSTAR and SNOWFLAKE Modelling ApproachesDimensions and Fact TablesJoining Tables with the Merge OperationVisualizations and ChartsVisualization and Report BasicsTables and Pivot TablesMatrix VisualsBar and Column ChartsLine and Area ChartsCombo ChartsScatter ChartsTreemap ChartsCardsData Categories and Geographical ChartsTooltipsInteractions between VisualsFilters and SlicersAdding small multiplesVisual ElementsReport Design Best PracticeAdding Interactivity to your ReportPower BI ServicePower BI Pro vs Premium OverviewPower BI Pro Interface TourPublishing Reports to Power BI ProPersonal WorkspacesDashboardsAppsCollabortation WorkspacesData Analysis Expressions (DAX)Overview of the Langauges used in Power BI (M and DAX)DAX Syntax BasicsAggregation FunctionsFilter FunctionsOther FunctionsDAX DocumentationThe course is packed with lectures, code-along videos, assignment questions and detailed walkthroughs.There should be more than enough to keep you engaged and learning! As an added plus you will also have lifetime access to all the lectures.

Who this course is for
Anyone looking to learn Power BI with a project based approach
Anyone interested in building a business intelligence solution end to end
Anyone looking to pursue a career in data analysis or business intelligence

Homepage