Visual Analytics

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. In this course, you will learn how to connect, explore, and visualize data with Power BI. Power BI Desktop provides a free-form canvas for drag-and-drop data exploration as well as an extensive library of interactive visualizations, simple report creation, and fast publishing to the Power BI service.

Topics:

  1. Introduction to Business Intelligence and Data Analysis and Visualization
  2. Introduction to Power BI
  3. Connection to different data storages
  4. Data Modelling in Power BI
    a) Relationships in Power BI
    b) Quick Measures and Calculated Measures in Power BI
    c) Calculated Tables and Calculated Columns
    d) Time Intelligence
  5. Visuals in Power BI
    a) Create and Format Visualization
    b) Analytics Pane
    c) Clustering Data
    d) Slicers
    e) Map Visualization
    f) Tables and Matrixes
    g) Waterfall Chart, Funnel chart, and Scatter Chart
    h) Gauge, cards, and KPIs
    i) Visual Interactions
    j) Positioning, aligning, and sorting visuals
  6. Dashboard and Power Bi Services