ABOUT POWER BI TRAINING

Power BI is Microsoft’s latest business intelligence (BI) and data visualisation tool that enables you to quickly develop stunning interactive dashboards that bring your data to life, and enable you to monitor your business on every device.

The free Power BI Desktop tool can get and model data from almost anywhere using the same Power Query and Power Pivot tools many Excel users will be familiar with. Then quickly create impressive interactive reports using the sophisticated charting and visualisation gallery.

You can even embed Excel charts, tables, PivotTables and dashboards in your Power BI dashboards using the free Power BI Publisher add-in for Excel.

Why Power BI?
  • Power BI is a vast program with lots of functionality which makes it an awesome tool, but it also means there is a lot to learn.
  • Power BI is easy to use for the most part but there are some fundamental things you must get.
  • Having Power BI, Power Query and Power Pivot skills is going to set your way above the Excel crowd and into the Data Analyst sphere with the potential to earn a higher salary.
  • Power BI Dashboards will enable your users to interact and drill down on the data. They can even create their own reports and views, which will increase interest in the data and reduce your workload.
  • No need to be familiar with databases or existing BI tools to learn and use Power BI.

Power bi Course Content

overview of Power BI
  • Guided Learning for Power BI
  • Using Power BI
  • Building Blocks of Power BI
  • A quick look at the Power BI service
  • Review this first section of Guided Learning
Getting Data
  • Data Preparation
  • Introduction to Power BI Desktop
  • Connect to Data Sources in Power BI Desktop
  • Clean and Transform Your Data With the Query Editor
  • More Advanced Data Sources and Transformation
  • Cleaning Irregularly Formatted Data
Modeling
  • Modeling
  • How to Manage Your Data Relationships
  • Create Calculated Columns
  • Optimizing Data Models for Better Visuals
  • Create measures and work with time-based functions
  • Create Calculated Tables
  • Explore Time-Based Data
Visualizations
  • Using Visualization objects
  • Create and Customize Simple Visualizations
  • How to Use Combination Charts
  • Create and format slicers
  • Map Visualizations
  • Tables and Matrixes
  • Scatter Charts
  • Waterfall and Funnel Charts
  • How to Use Gauges and Single Number Cards
  • How to modify colors in charts and visuals
  • Style Your Reports With Shapes, Text Boxes, and Images
  • Style Your Reports With page layout and formatting
  • Create Complex Interactions Between Visualizations
  • Duplicate a Report Page
  • Show Categories With No Data
  • Customize Visuals with Summarization and Category Options
  • Arrange the Z-order of Report Elements
  • Visual hierarchies and drill-down behavior
  • R Visuals in Power BI
Exploring Data
  • Exploring Data
  • Use Quick Insights in the Power BI service
  • Create and Configure A Dashboard
  • Ask Questions of Your Data With Natural Language
  • Create Custom Q&A Suggestions
  • Share Dashboards with your organization
  • Display Visuals and Tiles Full-Screen
  • Edit Tile Details
  • Get More Space on Your Dashboard
  • Install and Configure a Personal Gateway
Power BI and Excel
  • Power BI and Excel
  • Import an Excel table into Power BI
  • Import Excel with data models and Power View sheets
  • Connect OneDrive for Business to Power BI
  • Excel data in Power BI summary
Publishing and Sharing
  • Publishing and Sharing
  • Publish Reports to Power BI Service
  • Print and export Power BI dashboards
  • Manually Republish and Refresh Your Data
  • Introducing Power BI Mobile
  • Create a group in Power BI
  • Create a content pack in Power BI
  • Connect to content pack from group
  • Edit a content pack in Power BI
  • Integrate OneDrive for Business with Power BI
  • Publish a report to the web from Power BI
  • Congratulations – and what’s next for you
Introduction to DAX
  • Introduction to DAX
  • DAX Calculation types
  • DAX Functions
  • Using variables in DAX expressions
  • Table Relationships and DAX
  • DAX Tables and Filtering