Power BI eLearning Bundle Course



Course Details:

Length: 12 courses

Access Length: 6 months

Price: $1,075/person (USD)

Bulk Pricing: 10+ Contact Us

Course Features:

Instant Access After Purchase

Lecture by Recorded Video

Stop and Start as Needed

Certificate of Completion

Software Lab Included?: Yes

Delivery Method:

Self-Paced Online

Individuals and Groups
@ Your Location

 


Course Overview

Master the Power of Data Analysis with the Ultimate Microsoft Power BI Bundle!

Unleash actionable insights from your data with this comprehensive collection of Power BI courses, curated to empower you from beginner to dashboard designer. Whether you're new to data analysis or seeking to refine your skills, this bundle equips you with the knowledge and confidence to transform raw data into compelling visuals and impactful reports.

This bundle includes:

  • Microsoft 365 Power BI Desktop - Beginner: Master self-service business intelligence with Power BI Desktop.
  • Power BI Essentials: Create stunning reports and dashboards with real-time data.
  • Microsoft Power BI Skills: Become a Power BI pro, learning data connections, modeling, calculated measures, and building compelling reports and dashboards for informed decision-making.
  • Learning Microsoft Power BI: Craft interactive reports and dashboards from scratch based on real-world scenarios.
  • Learning Path: Microsoft Power BI Made Easy: Deep dive into advanced features like data sharing, Q&A, and troubleshooting.
  • Building Interactive Dashboards with Microsoft Power BI: Design professional dashboards that captivate your audience.
  • Microsoft 365 Power BI Desktop: Intermediate: Optimize data models, refine visuals, and take your Power BI skills to the next level.
  • Power BI: Analyze and Interactively Visualize Business Data: Conquer big data and create impactful visualizations for informed decision-making.

This bundle combines the strengths of several individual courses, offering:

  • Beginner-friendly foundation: Start with foundational concepts like navigating the Power BI interface, connecting to data, and creating basic visuals.
  • Intermediate-level mastery: Deepen your skills with data refresh optimization, column calculations, visual refinement, and advanced dashboard techniques.
  • Advanced insights: Explore topics like DAX measures, storytelling features, and data analysis from diverse sources like big data.

Here's what you'll gain:

  • Connect to any data source: Master importing data from files, online platforms, and Excel with Power Query.
  • Clean and transform your data: Learn crucial techniques for filtering, adding columns, and merging tables to ensure accuracy and reliability.
  • Build robust data models: Understand relationships between tables and configure column settings for practical analysis.
  • Craft stunning visualizations: Design engaging reports and dashboards using diverse chart types, formatting options, and visual cues.
  • Create interactive dashboards: Implement slicers, filters, and drill-down features to facilitate user exploration and deeper understanding.
  • Publish and share insights: Upload reports to Power BI.com, create app workspaces, and set up automated refresh cycles.
  • Apply your skills to real-world projects: Build functional reports and dashboards based on specific business requirements.

No matter your level or data analysis goals, this comprehensive bundle provides the perfect roadmap to success with Power BI.

Also Included - 4 Courses: An Essential Career Skills Pack with 4 courses in key areas for career management and growth, including Time Management, Digital Skills, Creativity and Soft Skills.

 


Course Notes

eLearning Training Delivery Method


How It Works

This self-paced online course lets you learn independently at your own pace through Certstaffix Training's easy-to-use platform.

  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screenshots
  • 6-month subscription length
  • Instant Access After Purchase

Have more than 10 students needing this course? Contact Us for bulk pricing.

Target Audience

Beginners:

  • Individuals with no prior data analysis experience who want to understand the basics of Power BI and learn how to visualize data effectively.
  • Business users and professionals who need to leverage basic reports and dashboards for making informed decisions.
  • Excel users seeking to expand their skillset beyond spreadsheets and explore a more robust data analysis tool.

Intermediate learners:

  • Individuals with some experience in Power BI who want to refine their skills and delve deeper into data modeling, reporting features, and dashboard interactivity.
  • Data analysts and business intelligence professionals looking to optimize data refresh processes, create advanced visualizations, and implement advanced dashboard techniques.

Advanced users:

  • Experienced data analysts and business intelligence professionals seeking to explore DAX measures, data storytelling techniques, and handling complex data sources like big data.
  • Anyone aiming to become a Power BI power user with comprehensive knowledge and hands-on experience building insightful reports and dashboards.
Learning Objectives:
  • Gain a comprehensive understanding of Power BI: Learn the fundamentals, components, and workflows for data analysis and visualization.
  • Master data acquisition, cleaning, and transformation: Connect to various data sources, prepare data for analysis, and create accurate datasets.
  • Develop proficiency in data modeling: Build effective data models with relationships, cardinalities, and security measures.
  • Craft stunning and informative visualizations: Utilize various chart types, formatting techniques, and interactive elements to tell data stories.
  • Design impactful dashboards and reports: Create insightful dashboards with KPIs, filters, and slicers for clear communication.
  • Extract valuable insights from large datasets: Learn efficient techniques for data retrieval, analysis, and visualization.
  • Communicate data effectively to diverse audiences: Present data in a clear, concise, and engaging manner.
  • Make data-driven decisions with confidence: Leverage data analysis to inform strategic choices and solve business problems.
  • Advance your career in data analysis or visualization: Gain the skills and knowledge sought after by employers in today's data-driven world.
  • Become a confident and proficient Power BI user: Unlock the full potential of this powerful tool to transform your data into actionable insights.
Key Features
  • Audio Narration
  • Video
  • Inline Activities
  • Exercises
  • Supplemental Resources
  • Post-Assessment
Languages
  • Audio/Video/Course Text: American English.
  • Subtitles (Closed Caption): Varies by course. Please refer to the individual course descriptions below for specific details.
Course Duration
  • Power BI Bundle: 27 hrs 53 min
  • Essential Career Skills Pack: 2 hrs 23 min

 


Course Topics

Microsoft 365 Power BI Desktop: Beginner

Course Duration - 2 hrs 48 min

Modern business reporting demands the ability to visualize data within an organization's business context. Power BI Desktop is Microsoft's premier tool for visualizing data and for creating highly interactive dashboards.

This course starts with the basics. Business Intelligence concepts are examined and explained. The process of grooming data for analysis is covered with demonstrations at each step.

Connecting to data sources is the first step, and this course covers several data sources as examples. Data may live in humble Excel workbooks, SQL databases, or the Power BI Service.

Once data sources have been created, data must often be prepared before visualizations can be created. Data must be cleansed, transformed, and shaped before analysis can begin. Power BI Desktop has tools to assist with all these tasks. Each feature is examined and demonstrated.

Many visualizations are created in this course. Each type is explained so that students understand why one visualization should be used instead of others. The lesser-used chart types are given extra attention because their value is usually not understood without examples.

Created in this course: Tables and Matrices, Text Based visuals, Column Charts, Line Charts, Interactive Legends, Waterfall Charts, Funnel Chars, Scatter Plot Charts complete with motion, Area, and Stacked Area Charts are all created. Gauges and KPIs are also created.

Finally, the Power BI Service is examined and used to create truly interactive dashboards that may be shared with other users within their organizations.

Course Objectives:
Course Objectives:
  • Grasp the fundamentals of self-service business intelligence (BI) and its role in modern business reporting.
  • Connect to various data sources like Excel workbooks, SQL databases, and the Power BI Service.
  • Clean, transform, and shape data for effective analysis using Power BI Desktop's data preparation tools.
  • Create and understand different data visualizations including tables, charts, and text-based visuals.
  • Utilize interactive elements like legends and motion in visualizations for deeper insights.
  • Construct specific visualizations like waterfall charts, funnel charts, and scatter plots with motion for tracking progress and trends.
  • Develop key performance indicators (KPIs) and gauges for clear and concise data representation.
  • Build interactive dashboards in the Power BI Service to share insights with organizational users.
  • Apply best practices for choosing appropriate visualizations based on data and context.
  • Gain a strong foundation in Power BI Desktop to continue learning and explore more advanced capabilities.
Additional Language Information:
Additional Language Information:
  • Subtitles (Closed Caption): American English, Arabic, Brazilian Portuguese, Canadian French, Chinese (Simplified), Chinese (Traditional), Dutch, French, German, Hindi, Indonesian, Italian, Japanese, Korean, Latin American Spanish, Russian, Spanish, Thai, Turkish, and Vietnamese.
Detailed Course Outline:
Detailed Course Outline:
Introduction

Understanding Self-Service BI

Connecting to Data
  • Understanding Data Connections
  • Data Import vs Live Connections
  • Connecting to Data
  • Saving Data
Preparing Data for Analysis
  • What is Data Prep?
  • Preparing for Data Analysis
  • Cleaning and Transforming Data
  • Shaping Data
Visualizing Data
  • Visualizing Data
  • Overview of the Environment
  • Data Basics
  • More Data Basics
Creating Text Based Visuals
  • Creating a Table and a Matrix
  • Creating Text Based Visuals
Creating Basic Visuals
  • Creating a Column Chart
  • Creating a Line Chart
  • Interactive Legends and Visuals
Creating Visuals to Track Progress and Movement
  • Creating a Waterfall Chart
  • Creating a Funnel Chart
  • Creating a Scatter Plot
  • Adding Motion to a Scatter Plot
Creating Area Charts
  • Creating an Area Chart
Creating BI Visuals
  • Creating BI Visuals - KPI
  • Creating BI Visuals - Gauge
Building Dashboards
  • Understanding the Power BI Service
  • Dashboard in Power BI Service
Conclusion


 

Power BI Essentials

Course Duration - 1 hr 25 min

Learn to create stunning reports with real-time data.

You can connect to existing data in Microsoft's Power BI to create modern data visualizations and reports. In this course, expert trainer Kathy Snizaski will teach you everything you need to know to design reports, charts, and dashboards and distribute them to your team.

First, you will learn to connect to data sources and create data relationships as the basis for your reports. Then Kat will walk you through creating a set of applied steps to clean and transform your data and create various engaging visualizations with your data. Lastly, publish your reports to the Power BI Web App and learn to create multiple customized dashboards from one report.

Course Objectives:
Course Objectives:
  • Describe how Power BI enables real-time data sharing and reports by connecting directly to external data sources, including Excel.
  • Manage data relationships within Power BI including create, modify, and delete
  • Create a set of applied steps to clean a data source, including changing data types, modifying field names, and splitting and merging columns.
  • Create and customize visualizations to display your data, including formatting, sorting, and filtering.
  • Format report pages, including text, shapes, and images
  • Create calculated columns using Data Analysis Expressions (DAX) for both strings and numbers.
  • Create explicit measures and add measures to visualizations.
  • Create interactive reports using real-time filters, hierarchies, and slicers.
Additional Language Information:
Additional Language Information:
  • Subtitles (Closed Caption): American English and Latin American Spanish.
Detailed Course Outline:
Detailed Course Outline:
Introduction

Using Power BI

Creating Data Connections

Modifying Data Relationships

Working with the Power Query Editor

Transforming Data

Creating Visualizations

Customizing Visualizations and Pages

Creating Calculations with DAX

Creating Calculated Measures

Filtering and Splicing Reports

Publishing Reports


 

Microsoft Power BI Skills

Course Duration - 6 hrs

Microsoft Power BI is a powerful business analytics tool that enables organizations to visualize and analyze data from various sources. The Microsoft Power BI Skills course is designed to provide learners with the knowledge and skills required to effectively use Power BI to create compelling visualizations and gain insights into their data.

The course begins with an introduction to Power BI, including its key features and benefits. Learners will then explore the various components of a Power BI environment, including data sources, data modeling, and report design.

Upon completing the Microsoft Power BI Skills course, learners will have the knowledge and skills required to effectively use Power BI to create compelling visualizations and gain insights into their data, ensuring data-driven decision-making in their organizations.

Course Objectives:
Course Objectives:
  • Gain an understanding of Microsoft Power BI's role and key features in business analytics.
  • Navigate confidently within the Power BI environment, identifying its components and functionalities.
  • Connect to various data sources using Power BI, including the Microsoft Dataverse and Data Flows.
  • Clean and prepare data effectively by identifying and resolving data issues, establishing appropriate keys for joins, and manipulating data within queries.
  • Develop calculated tables, columns, and measures using DAX formulas to enrich data analysis.
  • Design and create compelling reports in both Power BI Desktop and the Service, adapting them for mobile devices.
  • Construct interactive dashboards to efficiently communicate insights from data visualizations.
  • Utilize the "Analyze" feature in Power BI to gain a deeper understanding and identify trends within data.
  • Develop the foundational skills needed to continue learning and exploring more advanced Power BI capabilities.
  • Empower data-driven decision-making within organizations by effectively using Power BI for data visualization and analysis.
Additional Language Information:
Additional Language Information:
  • Subtitles (Closed Caption): American English.
Detailed Course Outline:
Detailed Course Outline:
ARCHITECTURE
  • Overview
  • Prerequisites
NAVIGATE
  • Get acquainted
HOW DO I?
  • Identify & Connect to a Data Source
  • Change Data Source Settings
  • Select a Storage Mode
  • Use the Microsoft Dataverse
  • Connect to a Data Flow
  • Resolve Data Issues
  • Identify & Create Appropriate Keys for Joins
  • Work with Data & Queries
  • Create Calculated Tables & Columns
  • Create Basic Measures by using DAX
  • Create Reports in Power BI Desktop
  • Create Reports in the Power BI Service
  • Create a Dashboard
  • Design Reports for Mobile Devices
  • Use the Analyze Feature in Power BI


 

Learning Microsoft Power BI

Course Duration - 4 hrs

Tell your data story with Power BI and reach millions of users with a single click on any device. Using Power BI, you can combine your data sources, create stunning visualizations, and embed your story on your website within seconds. This course aims to teach you how to use raw data, monitor it, and visualize it in a form that will provide rich insights with the help of dashboards. You will start with a set of business requirements for an example project from a client. Initially, you will connect to a data file. You will run through the process of connecting to your data, transform it, and then build the data model. This will help you understand and determine which DAX calculations are needed to meet the business requirements. Finally, you will build an interactive and functional report and a detailed dashboard and publish them on PowerBI.com. When it comes to learning Power BI, this course will ensure that you have the necessary tricks of the trade for practical insights and simplified visual analytics.

Course Objectives:
Course Objectives:
  • Connect to (almost) any data source: Master Power Query to import data from diverse sources like files, online platforms, and Excel.
  • Transform and clean data: Apply filtering, adding columns, and merging tables to create accurate and reliable datasets.
  • Build a robust data model: Understand relationships between tables and configure column settings for practical analysis.
  • Translate business requirements into DAX measures: Create custom calculations to answer specific questions and unlock advanced insights.
  • Craft compelling visualizations: Leverage different chart types, formatting, and visual cues to tell a clear and engaging data story.
  • Design interactive reports: Utilize matrix tables, running totals, and slicers to enable user exploration and deeper understanding.
  • Create insightful dashboards: Combine critical visualizations and metrics to deliver a comprehensive overview of your data.
  • Publish and share reports: Upload reports to Power BI.com, create app workspaces, and set up scheduled refreshes for automatic updates.
  • Apply lessons to a real-world project: Implement the acquired skills in building a functional report and dashboard based on a client's business requirements.
  • Gain confidence in visual analytics: Develop the necessary skills and tricks to extract valuable insights from raw data using Power BI.
Additional Language Information:
Additional Language Information:
  • Subtitles (Closed Caption): N/A.
Detailed Course Outline:
Detailed Course Outline:
Project Requirements and Getting Data
  • The Course Overview
  • What Is the Flow of Report Development for a Business Analyst?
  • Reviewing Project Requirements and Determining Data Sources
  • Connecting to (Almost) Any Data Source with Power Query
  • Importing Data and Power Query Fundamentals
  • Connecting to a Folder as a Data Source
  • Table Types and Relational Data Modeling
Common Data Transformations
  • Common Data Transformations with Power Query
  • Intelligent Data Filtering with Power Query
  • Adding New Columns with Power Query
  • Merging Tables with Power Query
Data Modeling and Relationships
  • Creating Table Relationships in Power BI
  • Understanding the Data View in Power BI
  • Column Settings and Hierarchies in Power BI
Data Analytics with Dax Measures
  • Translating Report Requirements into DAX Measures
  • Report View Walkthrough
  • DAX Concepts and Fundamentals
  • Creating Basic DAX Measures
  • Creating a DAX Measures Table
  • Referencing DAX Measures
Data Visualization and Modern Reporting
  • Visual Cues and Chart Types
  • Creating Visualizations - Matrix Table
  • Creating Visualizations - Running Total Chart
  • Creating Visualizations - Column and Line Chart (Year-Over-Year Profits %)
  • Creating Visualizations - Conditional Formatting and Waterfall Charts
  • Creating Visualizations - Card Visualizations and Title Section
  • Slicers and Filter Settings
  • Formatting and Report Design
Report Publishing and The Power BI Service
  • Publishing a Report to the Power BI Service
  • Creating an App Workspace
  • Creating a Dashboard
  • Setting Up Scheduled Refreshes
  • Learning Microsoft Power BI: Course Completed


 

Learning Path: Microsoft Power BI Made Easy

Course Duration - 4 hrs 7 min

Microsoft Power BI is a suite of tools to analyze your data and extract business insights from it through building interactive reports and dashboards. This Learning Path will be your guide to getting the most out of the Power BI Service, thus enabling you to solve business problems and improve operations. If you are a BI professional, IT manager, or a power user who wants to get insights from the business data using Microsoft Power BI, then go for this Learning Path. The highlights of this Learning Path include discovering and sharing new insights from your published reports and dashboards and moving ahead of the curve when it comes to transforming your data into valuable business insights using Microsoft Power BI.

First, you will learn how to develop dashboards from published reports and then continue to discover greater insight from your data with quick insights and the Q&A feature. Next, you will learn how to simplify data sharing and team collaboration in your organization, thereby harnessing these capabilities for improvement. Next, you will start with the basic installation and configuration of Power BI Desktop and go on to connect your data sources with it. You will learn how to transform and get your data ready for analysis and create effective data views using it. Then, you will see how to create stunning reports and dashboards in Power BI. Finally, the Learning Path provides some handy recipes for troubleshooting various issues in Power BI. By the end of this Learning Path, you will have all the tricks of the trade in mastering Power BI to get effective visual analytics.

Course Objectives:
Course Objectives:
  • Create dashboards from published reports.
  • Generate visuals and dashboards with Quick Insights.
  • Use natural language in the Q&A feature to quickly generate visuals for actionable insight.
  • Create relationships between tables in your data model.
  • Create calculated columns and measures using the DAX language.
  • Identify report layout and data visualization best practices.
  • Identify which charts/graphs to use depending on the question being answered or the story being told.
  • Incorporate custom visuals into your reports and dashboards.
Additional Language Information:
Additional Language Information:
  • Subtitles (Closed Caption): N/A.
Detailed Course Outline:
Detailed Course Outline:
Microsoft Power BI Online
  • The Course Overview
  • Creating a Dashboard from Existing Reports
  • Getting Quick Insights
  • Asking Questions of Your Data
  • Data Alert! Data Alert!
  • Be Kind and Share - With Whom and How?
  • Collaborating on Microsoft Teams
  • Overview and Staying Up to Date
Microsoft Power BI Recipes
  • The Course Overview
  • Desktop Layout, Features, and Views
  • Connecting to Common Data Sources
  • Query Editor Layout and Functionality
  • Creating Relationships in Your Data Model
  • Built-in Aggregations
  • Calculated Columns and Measures
  • A Visual Demonstration
  • Some Slightly Advanced Measures
  • Data Visualization Best Practices
  • Report and Dashboard Layout
  • Creating a Sales Analysis Report
  • Creating a Project Management Report
  • Telling the Story of Your Data
  • Thinking Outside the Visual Box
  • Theme-ing It Up
  • Capstone Project


 

Building Interactive Dashboards with Microsoft Power BI

Course Duration - 2 hrs 3 min

Do you get confused when you analyze data from various sources? If yes, this course will be your perfect guide and companion to analyze data easily. This course introduces Power BI's powerful dashboard design features and how to use them to your organization's advantage. You will begin the course by building a simple, functional, interactive dashboard. You will present linked charts and KPIs. You will develop dashboard examples suitable for publishing to analysts through managers and executives. At times, you need to walk users through the data, so we introduce some storytelling features of Power BI. Finally, we'll wrap up with some tips to style your dashboards for publishing.

At the end of this course, you will explore real-world examples, get started with Microsoft Power BI, and become comfortable with it so you can delve deeper.

Course Objectives:
Course Objectives:
  • Make exciting and creative visualizations based on your data with Power BI.
  • Build powerful, structured reports and KPIs with Power BI.
  • Use the analytical dashboard to explore detailed investigation history, trends, time series, and heat map charts.
  • Build several custom and geographic visuals to study the market with a strategic dashboard.
  • Publish your dashboard to the web to have powerful, tile-based, data fusion, and tailor-made data for the effective executive.
  • Utilize a narrative-oriented custom visual, Power BI's navigation capabilities, and a powerful storytelling feature.
  • Use Power BI's flexible formatting features.
Additional Language Information:
Additional Language Information:
  • Subtitles (Closed Caption): N/A.
Detailed Course Outline:
Detailed Course Outline:
Power BI Kick-Start
  • The Course Overview
  • The Visualization Palette, Reports, and Dashboards
  • Link Them Up - Enabling Visual Interactions
  • Key to Performance - Calculating Your KPIs
  • Helpful Hints - Adding Tooltips and Legends
Analytical Dashboards
  • Introducing the Analytical Dashboard Example
  • Time Matters - Time Series Chart
  • Some Like It Hot - Heat Map Charts
  • What-if - Using Parameters and Slicers to Filter and Explore
  • Detail-Oriented - Exporting Data from Visuals
Tactical Dashboards
  • Introducing the Tactical Dashboard Example
  • Point of Reference - Creating a Dot Plot
  • Statistics Never Lie - Box and Whisker Plots
  • Big Spenders - Building a Funnel Chart
  • Where It Is - Geographical Map Charts
Strategic Dashboards
  • Introducing the Strategic Dashboard Example
  • Are We There Yet? - Calculating Period-over-Period Changes
  • On Target - Visualizing Comparisons with Bullet Charts
  • Mash It Up - Pinning Visuals to Dashboards
  • Make It Pop - Adding Media Tiles to a Dashboard
Data Stories with Dashboards
  • Introducing the Data Stories Dashboard Example
  • Meet the Players - Presenting Data with the Card Browser Custom Visual
  • Space Travel - Linking Together Dashboards with Actions
  • Time Travel - Telling a Story with Bookmarks
  • Click for More - Embedded Links and Hyperlink Dashboard Tiles
Formatting Dashboards and Data
  • Formatting Concepts and Best Practices
  • Formatting Visuals and Reports
  • Creating Relevant Labels and Effective Number Formats
  • Formatting Dashboards
Course Conclusion


 

Microsoft 365 Power BI Desktop: Intermediate

Course Duration - 3 hrs 44 min

Modern reports and dashboards are highly interactive and use data from multiple sources. Managers want real-time information for analysis and decision-making. This course builds on the beginner course and enables dashboard creators to support these requirements.

Data is only as up-to-date as its latest refresh. The location of data has refresh implications, as does the feature used by Power BI Desktop to connect to that data. This course covers the issues that must be addressed to determine the freshness of an organization’s reporting data.

Data often comes from different sources. When all that data together must be used for visualizations and analysis, the data must be modeled. Data modeling includes the topics Table Relationships, Cardinality, Row-level Security, and Referential Integrity.

Sometimes, a data source does not have all the information that is required for reporting or forecasting. Calculated columns may be added to produce the data required for further analysis. Calculated columns are covered in this course.

Visualizations that are not covered in the beginner course are covered here. This course includes Donut Charts, Tree Maps, Line and Stacked Column charts, Line and Cluster Column charts, Maps, and Filled Maps. Perhaps most importantly, use cases that determine when each of these visuals is best to use are explained and demonstrated.

Filters are introduced as a technique for interactively analyzing data. Filters may be applied to single visualizations, pages, or entire reports. Each has its place. Special filters include Include / Excluded filters, Cross filters, Top N filters, and relative Date filters.

Slicers are visual filters that enhance interactivity, especially on dashboards. There are various types of slicers, and this course covers date slicers, time slicers, numeric range slicers, and others.

Even though dashboards are covered in the beginner course, so much can be done with them! In this course, dashboards are created to use the new visualizations, and they also incorporate filters and slicers!

Course Objectives:
Course Objectives:
  • Master data refresh strategies considering location, source, and Power BI Desktop features for timely reporting.
  • Design effective data models utilizing table relationships, cardinality, row-level security, and referential integrity.
  • Create calculated columns to address missing data requirements for enhanced analysis.
  • Expand visualization skills with donut charts, treemaps, line/stacked column charts, line/cluster column charts, maps, and filled maps.
  • Apply filters strategically to single visualizations, pages, or entire reports, including include/exclude, cross filters, top N filters, and relative date filters.
  • Enhance dashboard interactivity with various slicer types, including date, time, numeric range, and more.
  • Build advanced dashboards incorporating new visualizations, filters, and slicers for comprehensive data exploration.
  • Deepen understanding of table relationships and their impact on filter direction and visual outcomes.
  • Develop proficiency in conditional calculations within calculated columns for diverse data presentations.
  • Confidently select the most appropriate visualization type based on specific use cases and data characteristics.
Additional Language Information:
Additional Language Information:
  • Subtitles (Closed Caption): American English, Arabic, Brazilian Portuguese, Canadian French, Chinese (Simplified), Chinese (Traditional), Dutch, French, German, Hindi, Indonesian, Italian, Japanese, Korean, Latin American Spanish, Russian, Spanish, Thai, Turkish, and Vietnamese.
Detailed Course Outline:
Detailed Course Outline:
Introduction

Refreshing Data
  • Why Refreshing Data is Important
  • Implications for a Data Model
  • Introduction to Storage Modes
  • Overview of Refresh Types
Data Modeling
  • Refreshing Data Modeling
  • Table Relationships - Cardinality
  • Visuals from a Multi Table Model
  • Filter Direction
  • What is Row-Level Security?
  • Table Relationships - Active and Inactive Relationships
  • Table Relationships - Referential Integrity
  • Type Detection Options
Column Calculations
  • Understanding Calculated Columns
  • Date Calculations
  • Conditional Calculation One
  • Conditional Calculation Two
  • Order Status Visual
Visualizations
  • Introduction to New Visualizations
  • Donut Charts
  • TreeMaps
  • Line & Stacked Column Charts
  • Line & Cluster Column Charts
  • Maps
  • Filled Maps
Filters
  • Applying Filters
  • Page Filters and Report Filters
  • Types of Filters
  • Filters and Dashboards
Slicers
  • Defining Slicers
  • Applying Slicers
  • Slicer Scope
  • Controlling Slicers
Dashboards
  • Slicers, Filters, and Dashboards
Conclusion


 

Power BI: Analyze and Interactively Visualize Business Data

Course Duration - 3 hrs 46 min

In today's data processing of large and complex amounts of data, so-called big data, which can no longer be handled with conventional methods, are being processed more and more frequently. Power BI provides a solution to this challenge. With this Power BI training, you learn how to present meaningful data analysis in tables and graphs and create high-quality visualizations and interactive reports in addition to tools that allow you to share your reports with others effortlessly. Power BI is a powerful tool for analyzing data from various sources. With Power BI, you can analyze large amounts of data by extracting valuable information that can easily otherwise be lost.

Course Objectives:
Course Objectives:
  • Identify all the Power BI components and workflows you need to create meaningful reports and dashboards.
  • Determine how to make better decisions based on your data by creating meaningful reports and dashboards.
  • Retrieve, model, and visualize data.
  • Explain different types of diagrams, visualizations, the use of slicers and filters, and how to customize the design for mobile devices.
  • Explain more about the Power BI Service (the Online version of Power BI) and the components required to share your reports with others.
Additional Language Information:
Additional Language Information:
  • Subtitles (Closed Caption): American English.
Detailed Course Outline:
Detailed Course Outline:
Power Bi - Course Overview
  • Introduction - What is Power BI?
  • Handout - Table of Contents
  • Quiz 01 - What is Power BI?
Getting Started with Power BI Pro
  • Getting Started with Power BI Pro
  • Challenge - Create a first Power BI Report
  • Quiz 02 - Getting Started with Power BI Pro
Working With Various Data Sources in Power BI
  • Using Data from Excel Tables in Power BI
  • Challenge - Find the Mistake!
  • Using Data from Normalized Excel Spreadsheets in Power BI
  • Handout - Understanding "Normalization"
  • Update Data in Power BI
  • Import Data from Websites into Power BI
  • Import Data from a PDF File into Power BI
  • Import Data from a CSV File into Power BI
  • Import Data from Access Databases into Power BI
  • Action Plan - Data Sources Considerations
  • Quiz 03 - Working with Various Data Sources
Elaborate A Power BI Report to Enable Decision-Making
  • Elaborate a Power BI Report to Enable Decision Making
  • Improve a Power BI Report to Increase Informative Value
  • Do it Yourself - Start Your Own Power BI Project
  • Quiz 04 - Elaborate a Power BI Report to Enable Decision Making
Optimize Power BI Reports to Improve Readability
  • Edit Field Properties in Power BI to Improve Readability
  • Challenge - Edit Field Properties
  • Format Axes to Make Data Comparable
  • Visualize Benchmarks with Reference Lines
  • Challenge - Format Axes and Reference Lines
  • Add Annotations Using Text Boxes
  • Create YoY Comparisons Conveniently
  • Visualize Data on Maps to Valorize Reports
  • Challenge - Visualize Data on Maps
  • Enrich Visualizations with Radial Gauges - Speedometer and Thermometer
  • Enrich Visualizations with Conditional Formatting
  • Challenge - Conditional Formatting
  • Perform Advanced Data Analysis by Using Filters and Slicers
  • If Default Visualizations are not Enough: Add Custom Visuals
  • Customize the Design of a Report
  • Save Key Findings in Easy-to-Access Bookmarks
  • Challenge - Applying Filter, Slicer and Bookmarks
  • Optimize Reports for Mobile Devices
  • Access from Anywhere with Power BI Mobile
  • Quiz 05 - Optimize Power BI Reports to Improve Readability
Working With Data - Advanced Techniques
  • Improve Datasets by Extracting Data from Fields and Adding Fields
  • Create Calculated Columns if the Data Source is Insufficient
  • Take Advantage of Predefined Calculations Using Quick Measures
  • Create Virtual Columns Using Measures
  • Challenge - Mastering Calculated Columns
  • Quiz 06 - Working with Data - Advanced Techniques
Power BI Service - The Online Version of Power BI
  • Power BI Service - First Steps
  • Share Reports for Collaboration
  • Provide Reports in Microsoft Teams
  • Handout - Share Reports
  • Quiz 07 - Power BI Service
Publish Reports
  • Manage Roles and Assign Users
  • From Complex Reports to Clear Dashboards
  • Set Up Alerts for Target Values
  • Commenting on Reports and Dashboards
  • Use Data Gateways to Access Local Data Safely
  • Optimizing Power BI with Advanced Settings
  • Quiz 08 - Publish Reports
Appendix: The Various Power BI Components and How to Install Power BI
  • Installing Power BI Pro
  • Activate Power BI Service
  • Quiz 09 - The Various Power BI Components
Final Remarks

 


 


Essential Career Skills Pack


Productivity and Time Management

Course Duration - 30 min

It seems that there is never enough time in the day. But, since we all get the same 24 hours, why is it that some people achieve so much more with their time than others? This course will explain how to plan and prioritize tasks, so that we can make the most of the limited time we have. By using the time-management techniques in this course, you can improve your ability to function more effectively – even when time is tight and pressures are high. So, by the end of the course you will have the knowledge, skills and confidence to be an effective manager of your time.

Course Objectives:
Course Objectives:
  • Set your priorities to better manage your time
  • Improve your productivity by sharpening your focus and multitasking effectively
Detailed Course Outline:
Detailed Course Outline:
  • Productiity & Time Management
  • Prioritization
  • Getting Things Done
  • Procrastination
  • Multitasking & Focus
  • Summary


 

Basic Digital Skills

Course Duration - 13 min

With the rise of digital transformation and technology, having a basic digital literacy is essential for all types of jobs, regardless of the industry. To stay competitive and be successful in the workplace, enhancing your digital skills should be a top priority.

Course Objectives:
Course Objectives:
  • Recall the essential digital skills framework
  • Elaborate on the toolkit of essential digital skills
  • Identify how to develop or improve your digital skills
Detailed Course Outline:
Detailed Course Outline:
  • The Essential Digital Skills Framework
  • The Toolkit of Essential Digital Skills
  • Developing Digital Skills
  • Summary


 

4 Ways to Boost Creativity

Course Duration - 30 min

The digital economy is opening up ways for everyone to be creative. It doesn’t just mean being artistic – it’s more about ideas, solutions, alternatives, incremental improvements. Peter Quarry and Eve Ash discuss ways that mental capacity can be developed, perspectives changed, group power leveraged and making things actually happen.

Course Objectives:
Course Objectives:
  • Define creativity
  • Think outside the box
  • Develop the right mental attitude
  • Leverage the power of groups
  • Ensure managers make it happen
Detailed Course Outline:
Detailed Course Outline:
  • What is Creativity at Work?
  • Learn to Think Outside the box
  • Develop the Right Mental Capacity
  • Laverage the Power of Groups
  • Ensure Managers Make It Happen
  • Summary


 

The 11 Essential Career Soft Skills

Course Duration - 1 hr 10 min

Soft Skills are the traits, characteristics, habits, and skills needed to survive and thrive in the modern work world. Soft skills aren't usually taught in school, but you will learn them all here in this course. Are you someone that other people in your organization and industry like to work with, collaborate with and partner with? Are you seen as a valuable asset to any new project that comes along?

This soft skills training course will teach you how to develop the skills that can make the difference between a lackluster career that tops out at middle management versus one that lands you in the executive suite. Or to wherever you define career success. So many soft skills seem like common sense at first glance, but they are not commonly applied by most workers. This soft skills training course will give you an edge over your competitors. It will also make your job, your career and your life more rewarding and enjoyable.

Course Objectives:
Course Objectives:
  • Understand how to be a great communicator
  • Become a stronger listene
  • Appear professional to co-workers and bosses of all ages
  • Avoid common career blunders that often end careers
  • Manage expectations for bosses and colleagues
  • Position yourself for promotions
  • Make technology your asset, even if you are afraid of technology
  • Avoid the Not My Job Syndrome
  • Develop EQ to Match Your IQ
  • Develop leadership qualities
Detailed Course Outline:
Detailed Course Outline:
  • Introduction
  • The Soft Tech Savvy Way to Always Be Essential
  • Not My Job, And I Am Happy to Do It
  • You Can Become a Master Communicator
  • Feedback Video for The 11 Essential Career Soft Skills
  • Become a Leader Without the Title or Formal Authority
  • Your EQ Will Beat a Higher IQ
  • Building Your Winning Team
  • Make Every One of Your Seconds Count
  • Unleash Your Inner Anthony Robbins
  • Avoid Being Uncool
  • Clothes Can Still Make or Break Your Career
  • Conclusion The 11 Essential Career Soft Skills
  • Extra: Developing Your Career Secret Sauce

 



 


Related Power BI Information:

How Much Does Power BI Training Cost?

Public Power BI instructor led training course prices start at $620 per student. Group training discounts are available to reduce the Power BI course fee per student.

Self-Paced Power BI eLearning courses cost $725 at the starting point per student. Group purchase discounts are available.

How Do Tableau and Power BI Compare?

A: Both Tableau and Power BI can take large sets of your business's data and help you visualize and analyze them, but their strengths are in slightly different approaches to this analysis. Tableau can provide intricate visualizations to help you take action on current business proceedings, while Power BI uses data modeling to help decision-makers envision the future. Generally, Tableau is considered more intuitive to use, but Power BI has more advanced features. Training for both programs is typically required for beginners.

More Information on How Tableau and Power BI Compare

What Power BI Skills Should I Learn?

A: If you are wondering what Power BI skills are important to learn, we've written a Power BI Skills and Learning Guide that maps out Power BI skills that are key to master and which of our courses teaches each skill.

Read Our Power BI Skills and Learning Guide

What is the best Power BI course?

A: There are many different courses available to learn Power BI, depending on your learning style and needs. For those who prefer to learn online, Certstaffix Training offers both online live and eLearning classes that can be taken at your own pace. For groups, we offer onsite training face-to-face which can be customized to meet your specific needs. No matter what route you choose, our experienced instructors will ensure that you gain the skills and knowledge you need to confidently use Power BI.

How long will it take to learn Power BI?

A: There is no one-size-fits-all answer to this question, as the amount of time it takes to learn Power BI will vary depending on your prior experience and level of expertise. However, we can say that our Power BI training classes are designed to help you gain a comprehensive understanding of the software in a relatively short amount of time - a few days. The key after completing our training or other online resources like tutorials or videos, is to keep practicing to maintain and grow your Power BI skills.

Whether you choose to take our online or group onsite Power BI classes, you can be confident that you will receive the quality instruction needed to become a proficient Power BI user.

Is Power BI difficult to learn?

A: No, Power BI is not difficult to learn. Certstaffix Training provides classes online and onsite for corporate groups that can help you get started with Power BI quickly and easily. Our experienced instructors will guide you through the process of creating powerful data visualizations, so you can make better decisions for your business.

There are other ways to learn Microsoft Power BI than attending classes. You can watch video tutorials, read manuals, and attend webinars. If you prefer to learn on your own, these are great options. However, if you want more hands-on help or want to learn with others, consider attending a Power BI class. Certstaffix Training offers online and team onsite classes that are taught by experienced instructors who will help you get up and running with Power BI quickly. Sign up today and see how easy it is to get started with this powerful data visualization tool.

Is coding required for Power BI?

A: No, coding is not required for Power BI. Knowledge of SQL querying is helpful, but not required for basic tasks. Certstaffix Training provides classes online and onsite that can help you get started with this business intelligence tool. Power BI training classes can provide you with the skills you need to create reports and visualizations to help you make better decisions for your business. Contact Certstaffix Training today to learn more about our Power BI training options.

What are options to learn Power BI?

Are you looking to enhance your data analytics skills? Look no further than Power BI training! Our comprehensive program offers a range of options. You can take a Powerbi class (Power BI) or a Power BI seminar, to help you become an expert in data visualization and analysis.

With the increasing demand for professionals skilled in data analytics, enrolling in a Power BI class near me is the perfect opportunity to stay ahead of the competition. These Powerbi classes (Power BI) provide hands-on experience with the latest tools and techniques used in data analysis, making them ideal for both beginners and experienced individuals.

In addition to providing valuable skills for your career growth, some Power BI training also offers Power BI certification near me, giving you a recognized credential to showcase your expertise in the field. This certification is highly regarded by employers and can greatly enhance your job prospects.

Aside from traditional classroom-based learning, there are also options for PBI training through online courses or self-paced learning modules. These allow you to tailor your learning experience according to your schedule and preferred method of instruction.

When searching for Power BI classroom training near me, it's important to choose a reputable training provider with experienced instructors and relevant course content. This will ensure you receive high-quality education that translates into real-world skills.

Don't miss out on the opportunity to improve your data analytics skills through Power BI seminar. These seminars offer a condensed version of the training, perfect for busy professionals who want to quickly grasp the fundamentals of Power BI.

Investing in Power BI training is a smart move for anyone looking to advance their career in data analytics. Certstaffix Training offers 3 options to learn Power BI: 1) Live Online instructor-led, 2) In Person for Corporate Groups - Instructor-led at Offices and 3) Self-paced eLearning.

So why wait? Enroll in a Power BI training today and take your data analytics skills to the next level! So, if you are searching for bi near me, look no further than Certstaffix training. With our comprehensive curriculum and experienced instructors, you can be confident in your decision to enroll in one of our training courses. Don't hesitate any longer - take the first step towards becoming a data analytics expert by enrolling in Power BI training today!

What are the top Power BI skills?

A: The top Power BI skills include the ability to collect and analyze data, create visualizations and reports, and effectively communicate findings. In addition, Power BI users should have a strong understanding of statistical methods and be able to apply them to real-world scenarios. Furthermore, it is important for Power BI users to be able to work with complex data sets and be able to understand the relationships between different data points. Finally, Power BI users should have the ability to effectively communicate their findings to others.

Top Power BI Skills

1. Data modeling

2. Data visualization

3. DAX (Data Analysis Expressions)

4. Query editing

5. Report authoring

6. Custom visualization

7. Collaboration and sharing

8. Support and maintenance

9. Training and documentation

10. Project management

These are just some of the skills that are necessary to use Power BI effectively. If you want to be a power user, it is recommended that you master all of them.

Where Can I Learn More About Power BI?

Power BI Blogs

Power BI User Groups

Power BI Online Forums

Explore Power BI Training Classes Near Me:

Certstaffix Training provides Power BI classes near me or online, depending on the number of students involved. We offer online courses for individual learners, as well as in person classes at your office for corporate groups. Our trainers are highly experienced professionals with the expertise necessary to help you gain a thorough understanding of Power BI concepts and tools. With our courses available online for individuals or in person for corporate groups, it's easy to develop your Power BI skills. Start learning today and see how Certstaffix Training can help you reach your goals.







Registration:

Have a Group?
Request Private Training


Online Class

Self-Paced eLearning

Start your training today!