4 Weeks Microsoft Power BI Training in Manchester for Beginners-Business Intelligence training-Data Visualization Training-BI Training - Power BI Training bootcamp- Power BI Certification course, Power BI Desktop training, Power BI Service training

 This is a 4 weeks 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. 


Weekly Schedule

This is a week day course that will be held August 27 - September 19, 2019 US Pacific Time
The class sessions will be held-Monday, Wednesday every week
6:30-8:30 PM US Pacific time, each day.
Please check your local date and time for first session.

 

 
Detailed Weekly Schedule
This class will be held on Mondays and Wednesdays every week, starting August 27, 2019 at 6:30 PM US Pacific time. All sessions will follow the schedule below:

August 27, 2019 from 6:30-8:30 PM US Pacific Time
August 29, 2019 from 6:30-8:30 PM US Pacific Time
September 3, 2019 from 6:30-8:30 PM US Pacific Time
September 5, 2019 from 6:30-8:30 PM US Pacific Time
September 10, 2019 from 6:30-8:30 PM US Pacific Time
September 12, 2019 from 6:30-8:30 PM US Pacific Time
September 17, 2019 from 6:30-8:30 PM US Pacific Time
September 19, 2019 from 6:30-8:30 PM US Pacific Time



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

 

Join Tech Manchester

Register