Delivery Methods: Classroom, Virtual Training
Duration: 2 days
Level: Begginer
Languages: English, Spanish other languages on request.
Course information
- Power BI Overview
- Introducing the Power BI Platform (Service, Desktop, Mobile)
- Overview of the various types of data that can be imported into Power BI
- Loading Data (from Different Sources and explain the difference between Direct Query and importing data)
- Power BI Desktop Introduction
- Visualizations in 7 minutes (Report, Data and Model views, Visualizations panel, etc)
- Transform Data
- Use Power Query to clean, transform and filter data: remove rows, find and replace, split data into separate columns
- Profile data with Query Editor: (ex: Check for unique values)
- Resolve data quality issues
- Apply friendly names to Queries, tables and columns
- Import data from an Excel formatted report
- Append, merge and reference queriesControlling Sales Processes
- Data Modeling 101
- Create relationships between the different data sources
- Understand Cardinality and Cross Filtering
- Defining Sales Document Types
- Editing, renaming and deleting the applied steps
- Calculated Columns and DAX Measures (COUNTX and COUNTROWS,CALCULATE with USERELATIONSHIP,)
- Create a Date Table
- Visualizing Data
- Choosing the right visualizations
- Applying company theme
- adding text boxes, shapes, a company logo and a background
- Working with Filters (including slicers, field filters, Top N, page filters v report filters)
- Creating drill through pages
- Using the selection pane effectively
- Turning interactions (cross high lighting) on or off
- Formatting table and matrix visualisations including applying conditional formatting
- Adding Custom Visualizations
- Report Sharing
- Workspace : Premium vs Non Premium
- Create an APP
- Publish your Report
- Build Attached Reports
- PDF, PPT & Analyze in Excel
- Understand the BPI basic features
- Gain the knowledge to star working with BPI
- Application Consultant
- Business Process Architect
- Business Process Owner / Team Lead / Power User
- Program/Project Manager
- User
- None
- This course is meant only for companies not for individuals ! **
- Max 15 attendees