Data Analysis & Visualization with Power BI

Chapter 1: Power BI Desktop

  • Installing Power BI Desktop
  • Exploring the Power BI Desktop Interface
  • Examining Data Sources
  • Discussing Data Refresh
  • Understanding Data Types

Chapter 2: Working With CSV, TXT and Excel Worksheets

  • Importing, Transforming, and Loading Data from offline and online file
  • Appending Operations
  • Working with Folders and Files
  • Using Pivot Tables

Chapter 3: Connecting to Databases

  • Importing data from database (Access, Mysql, Oracle, Sql Server)
  • Working with Relational Data
  • Understanding Relationships
  • Relationships

Chapter 4: Merging, Grouping, Summarizing, And Calculating Data

  • Understanding the Issues with Merges
  • Performing Merges
  • Grouping Options
  • Summarizing
  • Calculating

Chapter 5: Data Analysis Expression DAX

  • Basic functions that we use in excel
  • SUM ()
  • SUMX ()
  • AVERAGE ()
  • AVERAGEX()
  • MIN ()
  • MAX()
  • CALCULATE ()
  • Filter ()
  • ALL
  • MINX () / MAXX ()

Chapter 6: Visualization & Reporting

  • Creating Reports
  • Bar Chart
  • Column Chart
  • Line Chart
  • Area Chart
  • Ribbon Chart
  • Pie Chart
  • Combo Chart
  • Bubble Chart
  • Scatter Chart
  • Donut Chart
  • Gauge Chart
  • Funnel Chart
  • Waterfall Chart
  • Single Number Chart
  • Multi row Chart
  • KPI Chart
  • Table Chart
  • Matrix Chart
  • Map
  • Filled Map
  • Tree Map
  • Slicer
  • Image

Chapter 7: Power BI Online

  • Introduction to Power BI Online
  • Importing Data
  • Creating Reports
  • Configuring Dashboards
  • Sharing Reports and Dashboards
  • Exploring Power BI Mobile