Course Code: powerbibespoke
Duration: 21 hours
Course Outline:
  • Introducing Power BI
    • Introducing Requirements
    • Power BI Key Ideas
    • Datasets, Data Models, and Data Files
    • Signing up for the Power BI Service
    • Uploading a PBIX File to the Power BI Service
    • Using Quick Insights
    • Viewing Reports 
    • Dashboard Features
    • Exploring a Dashboard
    • Choosing a Development Tool
    • Power BI Desktop Workflow 
    • Getting Familiar with Power BI Desktop
    • Using Excel for Power BI Development
  • Getting Data
    • Supported Data Sources
    • Accessing Data Sources
    • Globomantics Data Sources
    • Getting Data from Databases
    • Getting Data from Individual Files
    • Getting Data from a Group of Files
    • Getting Data from Individual Files in Power Query Editor
    • Getting Data from the Web and Manual Entry
    • Loading the Data Model
    • Getting Data into the Excel Data Model
  • Transforming Data
    • Renaming Queries
    • Appending Queries
    • Grouping Queries
    • Promoting Header
    • Fixing Column Metadata
    • Filtering Rows
    • Eliminating Columns
    • Merging Queries
    • Adding Columns by Splitting Text
    • Adding Columns by Splitting XML
    • Adding Columns for Sorting
    • Disabling the Data Load for Selected Queries
    • Transforming Data in Excel
  • Modeling Data for Analysis
    • Reviewing Missing Relationships
    • Creating a Relationship
    • Creating More Relationships
    • Defining New Columns
    • Concatenating Columns
    • Performing a Lookup to a Related Table
    • Translating a Value
    • Using the If Function
    • Adding a Date Table
    • Modeling Data in Excel
  • Enhancing Data Models
    • Defining Hierarchies
    • Configuring Properties
    • Hiding Objects and Configuring the Sort by Columns
    • Configuring Data Categories, Formatting, and Default Summarization
    • Creating Measures
    • Defining the Customer Count Measure
    • Defining the Percent of Total Customers Measure
    • Defining the Total Sales Measure
    • Defining the Previous Year Sales Measure
    • Enhancing the Excel Data Model
  • Visualizing Data
    • Globomantics Requirements
    • Creating a Table
    • Creating a Clustered Column Chart
    • Creating a Bar Chart
    • Creating a Map
    • Creating a Card
    • Creating a Matrix
    • Creating and Adjusting a Clustered Column Chart
    • Creating a Filled Map
    • Creating a KPI
    • Filtering
    • Slicer Filtering
    • Highlighting
    • Setting Properties
    • Drilling within a Hierarchy
    • Visualizing Data in Excel Part 1
    • Visualizing Data in Excel Part 2
  • Refreshing Data
    • Publishing to Power BI
    • Power BI Gateway
    • Rules for Refreshing Data 
  • Preparing Data for Power BI
    • Importing Data 
    • Importing Your Data Source
    • Transforming Data: Common Tasks
    • Eliminating Columns in a Query
    • Filtering Rows in a Query
    • Fixing Metadata
    • Transforming Data: More Options
    • Duplicating a Query
    • Splitting by Delimiter
    • Using the Unpivot Transformation
    • Cleansing Data
    • Replacing Values
  • Creating Data Models in Power BI
    • Introducing the Power BI Data Model
    • Defining Table Relationships
    • Configuring Model Properties
    • Reviewing and Changing the Demonstration Model's Properties
    • Adding Calculations
    • Creating a Calculated Column
  • Creating Reports
    • Report Development Workflow
    • Report Elements
    • Adding Visualizations to a Report
    • Adding Static Elements to a Report
    • Customization Options
    • Customizing Visualizations
    • Conditional Formatting and Web URLs
    • Formatting a Page and Designing the Mobile Layout
    • Report Publication
    • Publishing a Report and Creating a Dashboard