Microsoft Power BI Business Analytics
Contact us for dates, pricing and how we can customise courses to your requirements: contact us
Power BI Business Analytics Introduction
Duration: 2 days
This practical two-day course is designed for those who need to create business analytics using Microsoft Power BI. Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.
With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets, you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published. This course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports.
This course does not cover MS Power BI Pro (M20778), Power BI accessed via Office 365 or SharePoint Services. Please note that this course is not suitable for new Excel or database users • An understanding of basic data concepts • Ability to create, format chart outputs • Be able to create formulas using standard aggregate functions
Getting Started with Power BI Desktop
- Power BI Concepts and Overview
- Introduction to Main Features
- Imports
- Visualizations
- Filters and Queries
- Reports
Connecting to Data Sources with Power BI Desktop
- Data Sources Power BI Desktop will connect to
- Data Types and Properties in Power BI Desktop
- Import and Enter Data
- Get Data and Query Editor
- Introducing the Query Editor
- Using the Query Editor to Connect to Data
- Combining Data Sources as a Mash Up
- Working with Relationships in Data
Reports and Output Options
- Report Elements and Options
- Working with Pages
- Adding Graphics
- Visual and Filter Settings
- Export Power BI Data to CSV
- Create a Power BI Template
Data Visualizations
- Overview of Data Visualizations
- Tables and Matrix Views
- Applying Conditional Formats
- Charts
- Interactive Data and Date Slicers
- Drill Visualizations to see underlying data
- Create Reusable Field Hierarchies
- Record Grouping and Binning in Visualizations
- Drill Visualizations with using Dates
- Clustering
- Analytics and Forecast Lines in Visualizations
- Creating Role Based Views
- Data Categories, Geo-Data and Maps
- Querying and Shaping the Data
- Common Activities using Query Editor
- Filters
- Transforms
- Pivot and Group By
- Creating Custom Calculated Columns
- Adding Conditional Columns
- Introduction to DAX Expressions Histograms
Power BI Business Analytics Advanced
Duration: 2 days
Following on from the 2 day Introduction course, this course has an advanced focus on using Power BI, teaching how to build models that extend the capabilities of source data for more advanced and personalized business intelligence solutions.
Getting Started with Power BI Desktop
- Power BI Concepts and Overview
- Introduction to Main Features
- Imports
- Visualizations
- Filters and Queries
- Reports
Review
Get information
- From folder
- Power bi service
Power query
- Combine query
- Append query
- Add columns
- Fill in data
- De-energize
- Split columns
- Replace values
- Transpose
- Formats
- Extract
- Add prefixes and suffixes
Create related calendar table
- Year, Quarter, Month Day Day of week,
- Week of the year
- Dax operators
Create smart tags Roles Power BI service
- Reports dashboards and data sets to share
Dax functions
- Date and time functions
- Financial Functions
- Filter functions
- Functions Information
- Logical Functions
- Mathematical functions
- Relationship functions
- Text functions
- Table manipulation functions
- Relationship functions
- Time intelligence functions
Create calculated columns
Create calculated measures
Features to highlight
- Calculate
- Filter
- All
- Allselected
- Allexcept
- Keepfilters
- Lookvalue
- Selectedvalue
- Hasonfilter
- Hasonvalue
- Switch
- If and or
- Related
- Relatedtable
- Sumx
- Averagex
- Datesbeetween
- Firstdate
- Lastdate
- Parallelperiod
- Sameperiodlastyear
- Totalmtd
- totalytd
- Dateadd
- TopN
- Union