Power BI: Beginner

Course Outline PBI001IW.pdf
PowerPoint Slides Intro.pptx
DayModulesSharing
1
  • A history of Business Intelligence
  • The development of Self Service Business Intelligence
  • Introducing Power BI
  • Introducing the three main tools
  • Understanding your data
  • Fact and dimension tables
  • Creating tables for Power BI to connect to
  • Getting started
  • Connecting to data
  • Using Power Query Editor
  • Data types
  • Renaming columns and queries
  • Navigating the main Power BI
  • Desktop window
  • The data model
  • Create and delete relationships
  • Modify data formats
  • Normalising a dataset
  • Overview of visualisations
  • Create a column or bar chart
  • Basic formatting of visualisations
  • Focus mode
  • Create a line chart
  • Create a card visualisation
  • Create a gauge visualisation
  • Create a table visualisation
  • Create a matrix visualisation
  • Adding and naming report pages
  • Re-using visualisations
  • Text boxes and other visual element
  • Create a treemap visualisation
  • Create pie or donut chart visualisations
  • Introducing Visual Interaction
  • Turning Interaction On or Off
  • Interacting by Filtering, Highlighting or None
Lab Exercises:
References:
2
  • Slicers
  • Slicers and the data model
  • The Filters pane
  • Visual filters
  • Creating a Top N filter
  • Filter an entire page
  • Filter an entire report
  • Create a map visualisation
  • Create a filled map visualisation
  • Analyse data in a visual
  • AppSource Power BI visuals
  • Chiclet slicer
  • Import chiclet slicer
  • Use images on the chiclet slicer
  • Play axis dynamic slicer
  • Power BI Service layout
  • Create a new report
  • Reports to dashboards
  • Create a new dashboard
  • Pin visualisations from other pages and reports
  • Pin an entire report page
  • Quick Insights
  • Related Insights
  • Other tiles
  • Add an image to a dashboard
  • Add web content to a dashboard
  • Add video to a dashboard
  • Add a text box to a dashboard
  • Renaming dashboards
  • Favourite dashboards
  • Dashboard actions
  • Duplicate a dashboard
  • Print dashboard
  • Refresh dashboard tiles
  • Performance inspector
  • Settings
  • Dashboard themes
  • Arrange a dashboard for mobile use
  • Generating alerts from cards and KPIs
  • Refreshing data in Power BI Desktop
  • Refreshing local data from Power BI Service
  • Refreshing data from the cloud from Power BI Service
  • Sharing reports
  • Sharing dashboards
  • QR codes
  • Official Microsoft sources
  • Other sources
  • Axes
  • Data labels
  • Titles
  • Sizing and alignment
  • Data colours, backgrounds, borders and shadows
  • Installing the Power BI mobile apps
  • Interacting with reports and dashboards on a mobile
  • Favourite dashboards
  • Interacting with reports
  • Annotating reports
  • Sharing a dashboard
  • QR Scanner
  • Viewing data samples
  • Working through the Retail
  • Analysis Sample Pack
Lab Exercises:
References:

Recommanded Books
TitleTeach Yourself Visually Power BI
ISBN978-1-119-90377-2
AuthorAlexander Loth
Year2023
Publisher Visual
TitleData Cleaning with Power BI: The definitive guide to transforming dirty data into actionable insights
ISBN978-1-805-12640-9
AuthorGus Frazer
Year2024
Publisher Packt Publishing
TitleThe Complete Power BI Interview Guide: A modern approach to acing the data analyst interview and landing your dream job
ISBN978-1-805-12067-4
AuthorSandielly Ortega Polanco, Gogula Aryalingam and Abu Bakar Nisar Alvi
Year2024
Publisher Packt Publishing Pvt Ltd
TitlePro Power BI Theme Creation: JSON Stylesheets for Automated Dashboard Formatting
ISBN978-1-484-29632-5
AuthorAdam Aspin
Year2023
Publisher Apress
TitleBeginning Power BI for Business Users: Learning to Turn Data into Insights
ISBN978-1-394-19029-4
AuthorPaul D. Fuller
Year2023
Publisher Wiley
TitleMastering Microsoft Power BI: Expert techniques to create interactive insights for effective data analytics and business intelligence, 2nd Edition
ISBN978-1-801-81148-4
AuthorGreg Deckler, Brett Powell
Year2022
Publisher Packt Publishing
TitlePro Data Mashup for Power BI: Powering Up with Power Query and the M Language to Find, Load, and Transform Data
ISBN978-1-484-28577-0
AuthorAdam Aspin
Year2022
Publisher Apress
TitlePower BI for the Excel Analyst: Your Essential Guide to Power BI
ISBN978-1-615-47076-1
AuthorWyn Hopkins
Year2022
Publisher Holy Macro! Books
TitlePower BI for Jobseekers: Learn how to create interactive dashboards and reports, and gain insights from the data
ISBN978-9-355-51814-9
AuthorAlan Murray
Year2023
Publisher BPB Publications
TitleLearning Microsoft Power BI: Transforming Data into Insights
ISBN978-1-098-11284-4
AuthorJeremey Arnold
Year2023
Publisher O'Reilly Media
TitleApplied Microsoft Power BI: Bring your data to life!
ISBN978-1-733-04613-8
AuthorTeo Lachev,Edward Price,Maya Lachev,Martin Lachev
Year2022
Publisher Prologika
TitleMicrosoft Power BI For Dummies
ISBN978-1-119-82487-9
AuthorJack A. Hyman
Year2022
Publisher For Dummies
TitleLearn Power BI: A comprehensive, step-by-step guide for beginners to learn real-world business intelligence, 2nd Edition
ISBN978-1-801-81195-8
AuthorGreg Deckler
Year2022
Publisher Packt Publishing
TitlePro Power BI Desktop: Self-service Analytics and Data Visualization for the Power User
ISBN978-1-48425-762-3
AuthorAdam Aspin
Year2020
Publisher Apress
TitleMicrosoft Power BI Quick Start Guide - Second Edition: Bring your data to life through data modeling, visualization, digital storytelling, and more
ISBN978-1-800-56157-1
AuthorDevin Knight, Bradley Schacht, Mitchell Pearson, Erin Ostrowsky
Year2020
Publisher Packt
TitleAnalyzing Data with Power BI and Power Pivot for Excel
ISBN978-1-509-30276-5
AuthorAlberto Ferrari, Marco Russo
Year2017
Publisher Microsoft Press