Foundations of Power BI – Data to Dashboard Online Training

Matt Allington has been delivering live Power BI in Australia since 2014 and he has taught literally thousands of people with these live training courses and books.  Now you can get the live training experience by watching this recorded live training course.

In this training, you will understand the Power BI Desktop features and learn how to create different types of reports. You will also learn how to share your reports, create Dashboards on Power, use the Power BI features such as Q&A, Quick Insights, Analyze in Excel, etc. You will also get an introduction on Power Query and Data Modelling in Power BI. Power BI is easy to learn, and you can supercharge your learning experience with this Online Training course specifically targeted to you.

Why Should I Purchase?

  • It has been designed and created Matt Allington (Microsoft MVP).
  • Matt is a true Power BI/Power Pivot/Power Query professional who understands business users AND the technology that can solve these problems. i.e. he understands you and your problems.
  • The training is all “example based” using relevant real time scenarios to teach you the tricks.
  • You can download the slides used in the training.
  • You will have access to the online videos for 36 months, so if you want to come back and watch them again then that is fine.
  • You can purchase the course and start-off on the course at any time, and you will get access to the lessons (videos) immediately.
  • It is great value at US$99 for 36 months access to the online materials (videos).
  • You can claim 8 CPD hours.
  • Certificate available on request after completion of the course.
  • Buy this and any other Online Training at the same time and automatically get 10% off the price of those products!

Course Content

This course is a screen recording of one of Matt’s live public training courses. It is not a theatre production quality movie but rather a live recording of the step by step training and instructions from a live session. The audio quality in the recording does vary as Matt moves closer and further from the microphone, but it is clearly audible at all times.

Course Duration – 4 Hrs.

Module 1: Power BI Desktop - Building Your First Report - 59 minutes
Lesson Key Topics Covered
An Introduction to Building Power BI Reports3 minutes Placing a logo in the reportResizing the logoAdding a title to the reportFormatting the title of the report
Building Power BI Reports – Map Visual11 minutes Creating a map visualResizing the mapFields list of the visualImporting report themeRenaming a field in the visualUsing colour saturation
Building Power BI Reports – Column Chart Visual15 minutes Creating a visual using Q&A featureChanging the sort order in a visualCross-filteringData labels in a visualReset cross-filteringCreating an ad-hoc hierarchy in a visualDrill up and down in the visualFocus mode (Full-screen mode)Show DataDrill Down and Drill UpData hierarchy in a tableDeleting a data hierarchy
Building Power BI Reports – Bar Chart Visual3 minutes Creating a visual with copy-paste of an existing visualRepurposing a visual switching it to bar chartCross-filtering among the visualsCross-filtering by selecting fields on different visuals
Building Power BI Reports – Slicer Visual6 minutes Adding a Slicer visual to the reportFiltering using SlicerSignificant difference between Slicer and Cross-filteringEraser; List; DropdownSelection in a Slicer redraws the entire chartsControlling cross-filtering using Edit interactions
Building Power BI Reports – Card Visual2 minutes Adding a Card visual to the reportFormatting Card visual
Building Power BI Reports – Line Chart Visual10 minutes Adding line chart visual to the reportDate hierarchyDrilldown the date hierarchyAnalytics featuresForecastDocumentation on Forecasting in Power BISharp increase in the line chartAnalyze – Explain the increaseAdding the analysis chart as a visual to the report page
Building Power BI Reports – Bookmarks9 minutes Bookmarks pane and Selection paneAdding a BookmarkCreating another view and adding a BookmarkToggling between BookmarksNavigating through different views as in PowerPoint presentation modeAdding Buttons to ReportGiving labels to the ButtonsAssigning actions to the ButtonsUsing the Buttons to trigger the assigned actions
Module 2: Power BI Desktop - Other Reports - 33 minutes
Lesson Key Topics Covered
Building Power BI Reports – Top Customers Report9 minutes Adding a new page to the reportCopying and pasting the Logo and Title from previous pageEditing the TitleTable and Matrix visualsAdding a Table to the reportAdding fields (columns) to the TableFiltering the Table to display Top 20 CustomersSorting the Table by selecting a columnFormatting a columnConditional Formatting on the columns of the Table
Building Power BI Reports – Customer Detail Report9 minutes Creating a Table with all transactionsAdding DRILLTHROUGH filterAdding a Card with Customer NameDrillthrough to the Customer Detail ReportInteractive Drillthrough Report
Building Power BI Reports – Tool Tip Report15 minutes Adding Fields to TooltipsBuilding a Custom TooltipCreating a Blank Page named ToolTipFormatting Page as Tooltip PageChanging Page Size to TooltipChanging Page View to Actual SizeAdding Tooltip field to TOOLTIPBuilding the Tooltip ReportViewing the Custom Tooltip
Module 3: Sharing Reports in Power - 33 minutes
Lesson Key Topics Covered
Publishing Reports to Power BI.com15 minutes Signing in to Power BI.comPower Key AreasCreating an App WorkspaceAssigning Access to App WokspacePublishing a Report from Power BI DesktopPublished Report as Dataset in Power BI.comReports in Power and Power BI DesktopWorkbooks in Power
Creating Dashboards7 minutes Dashboards in Power BI.comPinning Visuals on to DashboardResizing Dashboard TilesPinning a Range from a WorkbookAdding Tiles from other SourcesPinning entire Report Page on to DashboardFully Interactive Report on DashboardQ&A in Power BI.comMobile Phone View of Dashboard
Power – Other Topics11 minutes Sharing MethodsSharing WorkspaceSharing DashboardsSharing ReportsPublish to WebCreating and Sharing an App WorkspaceQuick InsightsPinning an Insight to DashboardAnalyze in ExcelThin WorkbookSharing Thin Worbooks
Module 4: Power Query - An Introduction - 74 minutes
Lesson Key Topics Covered
Power Query – An Introduction24 minutes Getting data from a web pagePower QuerySteps to show how Power Query worksRemove RowsContext menu buttonUse First Row as Headers (Promote the first row as column headers)APPLIED STEPSCog of a step – step wizardRemove ColumnsCleaning and tidyingChanging Data typeReplace ValuesRenaming TableShape of the tableUnpivot Other ColumnsTransform and Add ColumnLoading data
Power Query – 2 More Power Query Techniques17 minutes Edit QueriesCreating Country-State hierarchyCombining State and Country into a columnAdd Column – Column From ExamplesData viewBuilding geographical hierarchyUsing the State Country combined columnSetting Data CategoryUsing Colour Saturation in Map visualCopying a query from Power BI to ExcelCopying query code to a text editor
File Consolidation with Power Query21 minutes Get Data from FolderCombine & EditSample File queryConsolidation queryEditing Sample File queryFixing the Consolidation queryRefreshing the Consolidation query
Power Query Audit12 minutes Data used for the exampleCreate connection without loadCreate a new queryMerge Queries as NewProfilingAdding Variance columnReplace ValuesAdding Status column
Module 5: Data Modelling in Power BI - An Introduction - 29 minutes
Lesson Key Topics Covered
Data Modelling in Power BI – An Introduction29 minutes Concept of modellingConcept of Data ModellingWhat is business logicStar SchemaLoading data from ExcelLoad & Edit buttonsData ViewData tables vs. Lookup tablesRelationships viewLaying tablesCreating relationshipsCreating calculated columnProblem with created columnsCreating measuresAdvantages of using measuresInellisense

Additional Goodies

  • Copy of Slides used in the training.
  • Self-paced training with timestamps provided for all the topics in every lesson to go through any specific section anytime.
  • CONTACT COURSE TEACHER button enables you to send a message to Matt Allington directly for any query on the course.
  • Certificate available on request after completion of the course.

Ready to purchase? You can purchase online from my shop here and start learning immediately.

The price of the course is US$99 (AU$129).

Buy this and the Super Charge Power BI Online Training (Data Modelling in Power BI) and/or  the Power Query Online Training at the same time and automatically get 10% off the price of the selected products.