4 WEEKS MICROSOFT POWER BI TRAINING IS A COMPREHENSIVE PRACTICAL
HANDS-on POWER BI TRAINING WITH A TOTAL OF 16 HOURS OF INSTRUCTOR LED
TRAINING THAT COVERS THE MOST IMPORTANT POWER BI FUNDAMENTALS AND
CONCEPTS INCLUDING DATA VISUALIZATION, POWER BI DESKTOP, POWER BI
SERVICE.
* Published Ticket Prices are in US Dollars
* This class will be taught in English language
4 Weeks Microsoft Power BI Training Weekly Schedule
* 4 Weeks | Monday, Wednesday US Pacific Time Every Week
(Before US Daylight Savings Time Begins on March 8, 2020)
* February 24 - March 7, 2020 US Pacific time
* 5:30 PM - 7:30 PM US Pacific time each day
* Please check your local date and time for the 1st session
[https://www.timeanddate.com/worldclock/converter.html?iso=20200225T013000&p1=234]
(After US Daylight Savings Time Begins on March 8, 2020)
* March 8 - March 18, 2020 US Pacific time
* 6:30 PM - 8:30 PM US Pacific time each day
* Please check your local date and time for the 5th Session
[https://www.timeanddate.com/worldclock/converter.html?iso=20200310T013000&p1=234]
Features and Benefits
* 4 weeks, 8 sessions, 16 hours of total Instructor-led LIVE
training
* Training material, instructor handouts and access to useful
resources on the cloud provided
* Practical Hands-on Lab exercises provided
* Actual code and scripts provided
* Real-life Scenarios
Course Overview
The course provides an in-depth and comprehensive practical hands-on
training of Microsoft Power BI including data visualization, Power BI
Desktop, Power BI Dashboard, how to connect to data using Power BI
Desktop, Modelling, working with Microsoft Excel, DAX and more.
Who can take this training
Our Microsoft Power BI Training is ideal for working professional who
have to work with data and also those in finance and accounting,
Business analysts, project managers and other IT professionals.
Prerequisites
You will get more out of this course if you have an understanding of
how data works, what is business intelligence, general data and BI
concepts, basic working experience with Microsoft Excel
Course Outline
1. Introduction to Microsoft Power BI and Getting Started with Power
BI
2. Getting Data for Power BI including Power BI Desktop, Connecting to
data sources
* Overview of Power BI Desktop
* Getting started with 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
3. Data Modeling including data relationships, calculated columns,
optimizing data models for better visuals
* Introduction to modeling your data
* How to manage your data relationships
* Create calculated columns
* Optimizing data models
* Create calculated measures
* Create calculated tables
* Explore your time-based data
4. Data Visualizations
* Introduction to visuals in Power BI
* Create and customize simple visualizations
* Combination charts
* Slicers
* Map visualizations
* Matrixes and tables
* Scatter charts
* Waterfall and funnel charts
* Gauges and single-number cards
* Modify colors in charts and visuals
* Shapes, text boxes, and images
* Page layout and formatting
* Group interactions among visualizations
* Duplicate a report page
* Show categories with no data
* Summarization and category options
* Z-order
* Visual hierarchies and drill-down
* R integration in Power BI Desktop
5. Exploring Data
* Introduction to the Power BI service
* Quick insights in Power BI
* 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 and add widgets
* Get more space on your dashboard
* Install and configure a personal gateway
6. Power BI and Excel
* Introduction to using Excel data in Power BI
* Upload Excel data to Power BI
* Import Power View and Power Pivot to Power BI
* Connect OneDrive for Business to Power BI
* Excel in Power BI - summary
7. Publishing and Sharing
* Introduction to content packs, security, and groups
* Publish Power BI Desktop reports
* Print and export dashboards and reports
* Manually republish and refresh your data
* Introducing Power BI Mobile
* Create groups in Power BI
* Build Apps
* Use Apps
* Update Apps
* Integrate OneDrive for Business with Power BI
* Publish to web
* Completion of Power BI Guided Learning
8. Introduction to DAX
* DAX calculation types
* DAX functions
* Using variables in DAX expressions
* Table relationships and DAX
* DAX tables and filtering
culture
3285
Views
19/03/2020 Last update