Your Cart Is Empty
Home > Desktop Applications > > Microsoft Power BI Boot Camp
Make better decisions and provide strategic information to the entire organization with the solutions you build.
This three-day instructor-led course will teach how to use the entire Power BI and Power BI Desktop toolset as your business intelligence platform. You'll learn how to implement solutions using Power BI, Power BI Desktop, and Power Query. This Power BI training course is packed with hands-on labs to reinforce class topics and provide you with the skills to successfully create impressive dashboards, reports, and other business intelligence solutions. You'll learn best practices for implementing Power BI solutions and practical ideas for implementing the solutions within your organization. Companies today generate enormous amounts of valuable information, but often have poor reporting capabilities – inhibiting the sharing of key information. This course will teach you how to provide executives, managers, and your entire staff with insights into your data through state-of-the-art business intelligence solutions built on the Microsoft Power BI and 365 platform. BI has never been more accessible and capable before! This course teaches you everything you need to know to implement BI solutions using, Power BI, and Power Query. ** NOTE: This class also available as a Microsoft Official Course ** While this course is designed for average end users needing to learn essential Power BI skills, we also offer a more in-depth 4-day course titled DA-100 Analyzing Data with Power BI. It is for IT professionals and power users who want a deeper dive into the material and/or who are preparing to pass the related Microsoft certification exam. To view that course go to: DA-100 Analyzing Data with Power BI.
Category
ID
Duration
Level
Price
Excel
13858
3 Day(s)
Foundation
$1,895.00
Objectives
• Utilize the entire Microsoft BI stack • Connect on-premise data sources to the cloud • Build an enterprise Data Catalog to share queries • Implement scorecards, dashboards, and KPIs • Analyze data with PowerPivot • Integrate data from many different external data sources • Implement effective, high-performing BI solutions • Provide intuitive ad-hoc reporting for business users by implementing Power View
Part 1: What is BI 1. Business Intelligence Overview 2. Evolution of Business Intelligence 3. Common Challenges 4. Benefits of Power BI Part 2: Getting Started with Power BI 1. Overview & Pricing/Licensing 2. Components of Power BI 1. Power BI Desktop 2. Power BI Mobile 3. Power BI Embedded 4. Power BI Gateway 3. Building Blocks of Power BI 1. Datasets 2. Visualization 3. Reports 4. Tiles 5. Dashboards 4. Power BI Workflows 5. Resources for Inspiration Demo: Quick Tour of Power BI Service Lab Exercise: Quick Tour of Power BI Service Part 3: Getting Data 1. Navigating Power BI Desktop 2. Connect to Data Sources in Power BI Desktop 1. File Data Sources 2. Database Data Sources 3. Azure Data Sources 4. Online Service Data Sources 5. Miscellaneous Data Sources 3. Clean and Transform your Data 4. Advanced Data Sources 1. Advanced Editor 2. Shaping Data 3. Applied Steps 5. Transformations 6. Cleaning Irregularly Formatted Data 7. Data Types 8. Combining Data 9. AI Analytics 1. Text Analytics 2. Vision 3. Azure Machine Learning 4. Invoking the Shared Models 5. Considerations and Limitations Demo: Quick Tour of Power Query Editor Lab Exercise: Import Data and Create Queries with Power BI Desktop Lab Exercise: Transform Data Lab Exercise: Combining Data Lab Exercise: Create a Report using Power BI Desktop Lab Exercise: Publish a PBIX File to the Power BI Service Part 4: Power BI and Excel 1. Excel Integration 1. Import an Excel Table into Power BI 2. Use Excel as a Dataset 3. Import Excel Files with Data Models 4. Connect, Manage and View Excel in Power BI 2. Publishing and Sharing Part 5: Modeling Data 1. Overview 2. How to Manage Your Data Relationships 3. Create Calculated Columns 4. Optimizing Data Models for Better Visuals 5. Create Measures and Work with Time-Based Functions 6. Create Calculated Tables 7. Explore Time-Based Data 8. Grouping 9. Binning 10. Hierarchies Demo: Modeling Relationships Column by Example Conditional Columns, Groups, Hierarchies Part 6: Visualizations 1. Overview 2. Create and Customize Simple Visualization 1. Numerical Fields 2. Text Fields 3. Geographic Fields 3. Modify Colors Insert Static Objects, and Set Page Properties 4. Styling with Shapes, Text Boxes, and Images 5. Page Layout and Formatting 6. Z-Order of Report Elements 7. Customize Visuals with Summarizations 8. How to: 1. Use Combination Charts 2. Manage Slicers and Sync Slicer 3. Use Map Visualizations 4. Implement Tables and Matrixes 5. Apply Conditional Formatting 6. Interpret Scatter Charts 7. Work with Water & Funnel Chart 8. Use Gauges and Single Number Cards 9. Creating Complex Interactions Between Visuals 10. Advance Concepts and New Features 1. Decomposition Tree 2. Key Influencers 3. Insights 4. Visual Hierarchies and drill-down behavior 5. Custom Visualizations 6. Drillthrough 7. Analytics Pane 8. Forecasting 9. Tooltips 10. Chiclet Slicer 11. Hierarchy Slicer 12. Synoptic Panel 11. Other Powerful Custom Visualizes 1. Pivot Slicer 2. Smart Filter 3. Hierarchy Filter 4. Card Browser 5. Visio Visual 6. Infographic Designer 7. D3JS Visualizer Demo: Visualizations, Slicers, and Advanced Interactions Part 7: Publishing and Sharing 1. Print and Export Power BI dashboards 2. Creating Content Packs 3. Publishing to Web 4. Embed in SharePoint 5. Export to PowerPoint 6. Power BI Mobile 7. Creating Workspaces in Power BI Part 8: Exploring Data 1. Overview 2. Use Quick Insights 3. Create and Configure a Dashboard 4. Shared Dashboards with your Organization 5. Display Visuals and Tiles Full-Screen 6. Edit Tile Details 7. Get More Space on Your Dashboard 8. Ask Questions of your Data with Natural Language 1. Custom Q&A suggestions 2. Adding Q&A to a Report 3. Adding a Q&A to a Report 4. Q&A Tooling 5. Review Questions 6. Teach Q&A 7. Manage Terms 8. Data Sources for Q&A 9. Bulk Synonyms 10. Q&A Best Practices 9. Bookmarks 10. Themes Demo: Quick sights Demo: Q&A in Dashboards and Reports Demo: Bookmarks Part 9: Administration & Security 1. Securing Content in Power BI 1. My workspace 2. Sharing a Dashboard 3. Sharing to Web 4. Admin Access 2. Row-level Security 3. Permissions 4. Defining and Creating toles within Power BI Desktop 5. Row-Level Security 6. Managing Data Capacity 7. Subscriptions 8. Resources Part 10: Introduction to DAX 1. DAX Calculation Types 1. Calculated Columns 2. Calculated Measures 2. DAX Functions 1. Aggregation Functions 2. Counting Functions 3. Logical Functions 4. Information Functions 5. Text Functions 6. Date Functions 3. Using Variables in DAX Expressions 4. Table Relationships in DAX 5. DAX Tables and Filtering 6. Quick Measures 7. What-if Parameters 8. Dynamic Labeling 9. Resources Demo: Quick Measures Demo: What-if Demo: Dynamic Labeling Hands-on Lab Exercises: · Retail Sales Exercise · Retail Analysis – Overview · Retail Analysis – District Monthly Sales · Retail Analysis – New Stores · Customer Profitability Exercise · Customer Profitability – Team Scorecard · Customer Profitability – Industry Margin Analysis · Customer Profitability – Executive Scorecard · Opportunity Analysis: Exercise · Opportunity Analysis – Opportunity Count · Opportunity Analysis – Revenue Overview · Opportunity Analysis – Upcoming Opportunities · Opportunity Analysis – Region Stage Counts · Opportunity Analysis Data Model
Questions?
Professionals who may benefit from this Microsoft Power BI training include: · Analysts · Database Administrators · Project Managers · Senior Business Intelligence Architects and Consultants · Senior Business Analysts · Digital Marketers · IT Specialists · IT Managers/IT Directors · Anyone responsible for implementing BI
Microsoft Power BI Boot Camp
Class Schedule
Live Online
Course Overview
Training Delivery Methods
With Productivity Point, you will have a spectrum of delivery methods to choose from... when where and how you like it. Whether it's in a classroom or online, we have a delivery option to meets your needs.
Classroom Live
Classroom Virtual
Private Group
On Demand
Classroom Live Training
Get in-person, hands-on instruction with live lab exercises taught by subject matter experts who deliver authorized and industry-leading content.
With classrooms in almost every major U.S. city, Productivity Point has something for users of every level, so you can earn the most popular industry certifications. You get hands-on learning experience with live lab exercises taught by experienced instructors. We proudly advocate our learning services to be hosted by the best-qualified trainers in terms of technical knowledge and teaching skills.
Classroom Virtual Training
Prefer to have a dedicated classroom for your virtual experience? Attend live, hands- on training via remote instructor from one of Productivity Point’s multiple locations.
Enjoy a focused and professional training environment, including all technical equipment provided along with administrative and technical support at your fingertips. With over 150 locations to choose from, review our course catalog or contact your personal Productivity Point Account Manager to see if the course you have in mind is delivered at one of our dedicated virtual classrooms in your area.
Live Online Training
Blend the best from traditional face-to-face instructor-led training with the latest in conferencing technology.
Private Group Training
Your private group classroom experience will not only take place in the location of your choice (including any of our training centers), but you will enjoy the following amenities:
On-Demand Learning
On-Demand is an IT training solution designed around your schedule, budget, and learning needs. Combining high-quality video, reading, and knowledge checks in a self-paced format, On-Demand helps you build skills as your schedule allows—all at once or five minutes at a time.
With On-Demand, you learn at your own pace and in the convenience of your own space.
With Learn at your own pace…
Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.
Productivity Point Headquarters 1580 Sawgrass Corporate Parkway Suite 205 Sunrise, Florida 33323 United States
Contact T 1-844-238-8607 P 1-954-425-6141 F 1-954-928-9057 E info@productivitypointls.com