Self -paced Course

Runs from August 5th - October 1st, 2019

  • 00Days
  • 00Hours
  • 00Minutes
  • 00Seconds
Enroll Now

Use your organisation's data to tell compelling stories

  • Do you want to create your own reports and dashboards?
  • Unable to access data needed to measure indicators?
  • Unable to monitor project results in real-time?
  • Having difficulty sharing your dashboards?
  • Is it difficult to report on your project's activities and impacts?


What you will learn

This course will show you how to analyze data from single or multiple sources, create individual datasets based on these sources, and transform results into beautiful and easy-to-make visualizations. Power BI offers you a comprehensive set of Business Intelligence tools for your data analysis goals. Learn how to quickly structure your data, easily add calculations to it, and create and publish nice-looking charts in just a few minutes. You will learn about different tools in the Power BI universe, understand Power BI Desktop and its components, and a lot more.

  • Understand Power BI Desktop and its components

  • Learn about the different views of the Data Model

  • Create calculated columns and measures

  • Learn how to build relationships between different tables

  • How to create a report with different interactive visualization types

  • Learn how to use Power BI Service to create dashboards and to share and publish your results

  • How to access your results from multiple devices using Power BI Mobile

  • How to create custom visuals using TypeScript and the Power BI Developer tools

Course description

Why learn Power BI?



Pricing

Why Wait? Get Started Now

Features

  • Activities

    Hands-on activities enabling learners to practice what is learned in the course.

  • Live Instructor-Led

    Expert-led live labs providing learners with hands-on instruction.

  • Support

    Our team will help resolve any issues that occur during and after the course.

Your course includes

  • 18 hours of self-paced content

  • Access to 2 hours of live data labs

  • Quizzes

  • Practical Activities

  • Certificate of Achievement

  • Suggested readings for each topic

  • Lifetime access to self-paced learning

Learn to create compelling visualizations

This course teaches the techniques needed to create stunning reports and dashboards

Course curriculum

  • 1

    Files

    • Files
  • 2

    Section 1: Getting Started

    • Understanding the Power BI Tools
    • Initial Project 1/3: Installing Power BI Desktop and Connecting to Data
    • Initial Project 2/3: Working in the Query Editor
    • Initial Project 3/3: Working in the Data Model and Creating a Visualization
    • Course Outline
    • How to use the Attached Project Files
    • Quiz
  • 3

    Section 2: An Introduction to Power BI Desktop

    • An Overview of the Workflow in Power BI Desktop
    • Introducing the Different Views of the Data Model
    • Taking a Closer Look at the Query Editor Interface
    • Before we Dive Deeper: Recommended Settings
    • Quiz
  • 4

    Section 3: An Introduction to the Query Editor

    • Just to be sure: What is the Query Editor?
    • Connecting Power BI Desktop to our Data Sources
    • Editing Rows
    • Understanding Append Queries
    • Editing Columns
    • Replacing Values
    • Formatting Data
    • Pivoting and Unpivoting Columns
    • Splitting Columns
    • Creating a New Group for our Queries
    • What we Achieved until Now and How to Continue
    • Introducing the Star Schema
    • Duplicating and Referencing Queries
    • Creating the DIM Region Table
    • Entering Data Manually
    • Merging Queries
    • Finishing the DIM Region Table
    • Introducing the DIM AgeGroup Table
    • Creating an Index Column
    • Duplicating Columns and Extracting Information
    • Creating Conditional Columns
    • Creating the FACT Population Table
    • Performing Basic Mathematical Operations
    • Improving Performance and Loading Data into the Data Model
    • Module Summary
  • 5

    Section 4: Working on our Data Model: Data & Relationship View

    • Module Introduction
    • Query Editor vs. Data Model
    • Introducing and Understanding Relationships
    • Editing Relationships
    • Understanding Cardinality
    • Cross Filter Selection and Many-To-Many Relationships
    • Active Properties
    • Understanding the differences between the M-Language and DAX
    • M vs. DAX applied: Calculated Columns
    • M vs. DAX: Conclusion
    • DAX - Basic information
    • DAX and Calculated Columns
    • Calculated Columns vs. Measures
    • Introducing DAX-Measures
    • DAX-Measures Continued
    • Categorizing Data
    • Module Summary
    • Quiz
  • 6

    Section 5: Working in the Report View to Visualize our Results

    • Module Introduction
    • Understanding the Interface of the Report View
    • Creating our First Visualizations
    • Editing Interactions and Adding Tooltips
    • Adding Color Saturation
    • Understanding Hierarchies and Adding Drill-Down
    • Formatting Charts and Sorting
    • Introducing Slicers
    • Adding Treemaps and Tables
    • Applying different Filter Types
    • Creating (Multi-Row) Cards
    • Understanding Combined Visualizations and Waterfalls
    • Module Summary
  • 7

    Section 6: Power BI Service & Power BI Mobile - How to Continue?

    • Module Introduction
    • Continuing our Work and why we need Power BI Service
    • Comparing Power BI Free, Pro and Premium
    • Logging in to Power BI Service
    • Understanding the Interface
    • Importing our Data from Power BI Desktop to Power BI Service
    • Understanding the Dataset Menu
    • Working on Reports
    • Introducing Dashboards
    • Exploring our Workspace
    • Understanding Gateways
    • Comparing Personal and On-Premise Gateway and Installing a Gateway
    • Working alone or Collaborating with Colleagues
    • Collaborating in App Workspaces
    • Sharing the Results
    • Publishing the App
    • Content Packs from Online Services
    • Power BI Mobile: Installing and Understanding the Mobile App
    • One Last Thing: Excluding Datasets from Sharing
    • Module Summary
  • 8

    Section 7: Other Data Sources

    • Module Introduction
    • Importing JSON Data
    • Importing Data from REST APIs
    • Preparation: Setting up a MySQL Server
    • Importing Data from a MySQL Server (and other SQL Servers)
    • Wrap Up
  • 9

    Section 8: Creating Custom Visuals (Power BI for Developers)

    • Module Introduction
    • How do Custom Visuals Work?
    • Using Data Driven Documents (D3)
    • Creating and Using a Visual
    • Installing an IDE (Code Editor)
    • Understanding the visuals.ts File
    • Understanding the Project Structure
    • Installing d3.js (Data Driven Documents)
    • Adding a First Shape
    • Connecting Shapes to Data
    • Scaling Shapes
    • Managing Visual Capabilities to Allow Data Input
    • Starting the Data Extraction
    • Limiting the Data Input
    • Extracting Data
    • Displaying the User Data
    • Optimizing the Code
    • Adding Dynamic Coloring
    • Making Bars Selectable (Cross-Visual)
    • Adding X-Axis Labels
    • Adding Custom Visuals Settings
    • Extracting the Visual Configuration
    • Informing Power BI About the Custom Configuration
    • Next Steps
    • Packaging the Custom Visual
    • Wrap Up
  • 10

    Course Roundup

    • Congratulations

FAQ

  • What if I have questions after I complete the course?

    We will address queries during and after the course.

  • How soon after enrolling will I get access to the content?

    The LMS access will be available instantly, and you will be able to access the all of the course information, activities, and lesson labs.

  • Is the course material accessible to the students even after the course training is over?

    You will have lifetime access to the course material.

  • What are the payment options?

    Payments can be made using any major credit card and a receipt will be issued to you automatically via email.