Date / Heure
Date(s) - 17/07/2019
3h30 - 5h30
Emplacement
Entirety Technologies
Catégories
Schedule
This class will be held on Mondays and Wednesdays every week, starting July 16, 2019 at 6:30 PM US Pacific time. All sessions will follow the schedule below:
July 16, 2019 from 6:30-8:30 PM US Pacific Time
July 18, 2019 from 6:30-8:30 PM US Pacific Time
July 23, 2019 from 6:30-8:30 PM US Pacific Time
July 25, 2019 from 6:30-8:30 PM US Pacific Time
July 30, 2019 from 6:30-8:30 PM US Pacific Time
August 1, 2019 from 6:30-8:30 PM US Pacific Time
August 6, 2019 from 6:30-8:30 PM US Pacific Time
August 8, 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
Refund Policy
100% refund can be applied if request is initiated 24 before the 1st course session
If a class is rescheduled/cancelled by the organizer, registered students will be offered a credit towards any future course or a 100% refund.
https://www.eventbrite.com/e/microsoft-power-bi-training-in-paris-for-beginners-business-intelligence-training-data-tickets-63461204170?aff=ebdssbdestsearch