DATA ANALYSIS WITH POWER BI

Introduction 

• A history of Business Intelligence 
• The development of SelfService 
• Business Intelligence 
• Introducing PowerBI 
• How does Power BI fitin? 
• Introducing the three main tools – Power BI Service, Power BI desktop & Power BIMobile 
• When to use Power BIDesktop 
• Free versus Pro Signing up to the Power BI onlineservice 
• Which sources of Data can I use in Power BIDesktop? 

• Introducing Power BI Desktop 

• Which version – 32 or 64bit 
• Starting Power BIDesktop 
• Desktopinterface 
• Ribbon andQAT 
• Sign-in and collapse ribbon Navigation 
• Getting Data and availablesources 
  
  The BI Process 

• The Business Intelligenceprocess 
• How Power BI relates to the standard BIprocesses. 
  
  Data Source and loading 

• Introduction to the data source used in thiscourse 
• Creating Tables ofData 
• Import data fromExcel 
• Import data fromWeb 
• Renaming Queries 
• Grouping Queries 
• Including and Excluding Queries in reportrefresh 
• Enabling or disabling Queryloading 
• Applying Queries 
• Viewing Querydependencies 
• Append Queries 
• MergeQueries 
• Merge QueryTypes 
• Cleaning the resultingquery 
  
  Using Data from an Excel Workbook 

• Understanding yourdata 
• Importing data from an Excelworksheet 
• Excel Tables 
• Importing table data from the Excelfile 
• Saving in Power BIDesktop 
  
   Visualisations 
  

• Overview ofVisualizations 
• Creating and working withVisualizations 
• Creating a Bar ChartVisualization 
• Creating a Column ChartVisualization 
• Creating a Line ChartVisualization 
• Some basic formatting ofVisualizations 
• Focus Mode 
• Creating a Card Visualization 
• Giving Cards someimpact 
• Creating a TableVisualization 
• Creating a MatrixVisualization 
• Creating a Bubble Map Visualization 
• Creating a Filled MapVisualization 
• Creating A GaugeVisualization 
• Creating a TreemapVisualization 
• Choosing the rightVisualizations 
• Card Visuals andFilters 
• Create variancemeasures 
• Using variance measures in a Waterfall chart 

• Create drill down time serieschart 
• Drill down chartinteraction 
• Create drill down barchart 
• Creating What ifParameters 
• Using What if parameters in achart 
• Enabling Q & A in Power BIDesktop 
• Create a visual with Q &A 
• Using Bookmarks in Power BIDesktop 
• Bookmarks to filterdata 
• Bookmarks to changevisuals 
• Add buttons to accessbookmarks 
  
  Working with Formats & Visualisations 

• Axes 
• Data Labels and titles  
• Sizing & Alignment 
• Data colours, backgrounds, and Borders 

From Visualizations to Reports 

• Adding Pages to yourReports 
• Renaming Pages 
• Re-usingVisualizations 
• Building a Narrative in yourreport 
• Editing & ReadingModes 
• Pie Chart Visualizations 

TextB Text boxesShapes 

• Introducing VisualInteraction 
• Turning Interaction On orOff 
• Interacting by Filtering, Highlighting orNone 
  
  Working with Filters 

• Creating aSlicer 
• Filtering in the Visualizationpane 
• Creating a Visual Fieldfilter 
• Creating a Top NFilter 
• Adding a page levelFilter 
• Creating pages from page levelfilters 
• Add a report levelFilter 
  
  Working with Desktops Files  

• Introduction to PBIXfiles 
• Credentials 

• Save a Desktop file as pbix 
• Power BITemplates 
• Refresh data from atemplate 
• Generate a data sourceerror 
  
  Q & A 

• Making Visualizations with natural languagequeries 
• Enabling Q&A in Power BIDesktop 
• Create a Visual usingQ&A 
• Add categories to the Q&Aexpression 
• Add conditions toQ&A 
• Add grouping to theQ&A 
• Specify a visualtype 
  
  Refreshing your Data 

• Refreshing your Datasets 
• Contents of a Power BI pbixfile 
• Contents of a templatefile 
• User profilecontent 

Power Query (Query Editor) 

• Connecting to adatabase 
• Building a DataModel 
• Using Query Editor Formatting and Properties of Data types and theiruses 
• Loading IndividualTables 
• CreatingRelationships 
• DeletingRelationships 
  
  Using Custom Visuals 

• Custom VisualizationsGallery 
• Installing a CustomVisualization 
• Word Cloud 
• Chiclet Slicer 
• World FlagSlicer 
• Count Down Timer Cards withStates 
• Scroller 
• Enlighten Aquarium 
  
  Access Database & Power BI 

• Importing an AccessDatabase 
• DataRelationships 
• Stacked ColumnChart 
• Sorting an ExistingVisualisation 
• Adding Depth to yourReport 
• Focusing on Key Points ofInterest 
• Calculated Columns 
• Adding a CalculatedColumn 
• Displaying calculated columns in avisualization 
• Using a Calculated column in acalculation 
  
  Synchronise Slicers 

• Introduction toSlice 
• Sychronisation 
• The Sync Slicerspane 
• Slicers Group 
  
  Report Themes 

• Introduction toThemes 
• ThemeGallery 
• Do it yourselfthemes 
• Colourcodes 
• JSONfile 
• Themegenerators 

Data Model & Transformation 

• The Power Queryprocess 
• Data transformationprinciples 
• Manual data clean-upexample 
• Removing rows fromTables 
• Using first row asheaders 
• Filteringdata 
• Detect and change datatype 
• Filling Null areas withvalues 
• Trimming text 
• Replacing values 
• AdemonstrationofhowPowerQueryhelpswithefficientuseofdata query 
• Dimension and FactTables 
• Data Model considerations 
• Common Data Models 

Date Transformations 

• Disabling AutoDate/Time 
• Extracting year 

• Extractingquarter 
• Extracting month 
• Extractingdate 
• Filterdates 

Power Query UI 

• Queries Area 
• Datasection 
• The TransformationsRibbons 
• Query SettingsArea 
• M LanguageArea