Power BI: Beginner Microsoft Power BI 2.96

https://www.skillsoft.com/channel/power-bi-b086cc41-2a94-11e7-9149-6dad704035be?expertiselevel=3586781&technologyandversion=3586782 https://www.skillsoft.com/channel/power-bi-b086cc41-2a94-11e7-9149-6dad704035be?expertiselevel=3586781&technologyandversion=3586784 https://www.skillsoft.com/channel/power-bi-b086cc41-2a94-11e7-9149-6dad704035be?expertiselevel=3586781&technologyandversion=7012381 https://www.skillsoft.com/channel/power-bi-b086cc41-2a94-11e7-9149-6dad704035be?expertiselevel=3586783&technologyandversion=3586782 https://www.skillsoft.com/channel/power-bi-b086cc41-2a94-11e7-9149-6dad704035be?expertiselevel=3586783&technologyandversion=3586784 https://www.skillsoft.com/channel/power-bi-b086cc41-2a94-11e7-9149-6dad704035be?expertiselevel=3586783&technologyandversion=7012381
  • 44 Courses | 35h 40m
  • 6 Books | 35h
  • Includes Lab
  • 3 Courses | 2h 52m 45s
  • 10 Books | 55h 24m
  • 5 Courses | 7h 18m 59s
  • 16 Courses | 12h 26m
  • 3 Books | 17h 54m
  • 1 Course | 47m 49s
  • 8 Books | 37h 26m
  • 3 Courses | 4h 20m 22s
Likes 631 Likes 631
 
Look at data in a whole new way with Power BI, Microsoft's data visualization solution.

GETTING STARTED

Business Reporting: Visualizing & Merging Data in Power BI

  • Playable
    1. 
    Course Overview
    2m 46s
    NOW PLAYING
  • Playable
    2. 
    Creating Calculated Columns in Power Query
    9m 28s
    UP NEXT

GETTING STARTED

Power BI Data Model Design: An Overview of Data Modeling

  • Playable
    1. 
    Course Overview
    2m 59s
    NOW PLAYING
  • Playable
    2. 
    Data Models in Power BI
    13m 14s
    UP NEXT

GETTING STARTED

Business Reporting: Getting Started with Power BI Desktop for Data Analysis

  • Playable
    1. 
    Course Overview
    2m 33s
    NOW PLAYING
  • Playable
    2. 
    Installing Power BI and Importing Data to It
    11m 12s
    UP NEXT

GETTING STARTED

Data Preparation and Processing: Using Power BI for Data Analysis

  • Playable
    1. 
    Course Overview
    3m 7s
    NOW PLAYING
  • Playable
    2. 
    The DA-100 Power BI Certification
    5m 8s
    UP NEXT

COURSES INCLUDED

Business Reporting: Visualizing & Merging Data in Power BI
Power BI and Power Query can be used in combination to facilitate both basic and advanced operations. In this course, you'll learn how to use Power Query to create the two types of calculated columns, custom and conditional. Next, you'll use Power BI to import and clean data and create stacked line charts (area charts) to visualize data. You'll filter the unique categorical values of the visualized series using various filtering techniques. You'll then combine data between tables using a foreign key relationship and create a bar chart with line markers using the analytics card. You'll move on to import a large number of files residing in the same folder. Lastly, you'll use Power BI's UI and Advanced Editor to perform basic data cleaning operations and Power Query to perform various advanced operations.
10 videos | 1h 28m has Assessment available Badge
Business Reporting: Creating & Formatting Matrix Visualizations in Power BI
Some of Power BI's advanced capabilities include mapping relationships among tables and customizing the look and functionality of matrix visualizations. You'll start this course using E-R (entity-relationship) diagrams to create, edit, and delete relationships among columns in different tables. You'll then move on to creating matrix visualizations and setting up a matrix control. You'll use the matrix control to visualize parent and child columns via a drill-down feature. You'll then create a column from a formula (known as a measure in Power BI) and perform various formatting operations to your matrix visualization, such as adding a title and row subtotals, editing text size and alignment, and turning on vertical and horizontal gridlines. Lastly, you'll implement conditional formatting on your matrix visualization.
13 videos | 2h 1m has Assessment available Badge
Business Reporting: Leveraging Treemaps, Matrices, & Slicers in Power BI
Treemaps are an impressive hierarchical data visualization feature of Power BI. Add in tooltips, matrices, slicers, and mobile readiness, and your reports will be highly interactive and engaging. You'll start this course by creating and configuring a treemap in Power BI. You'll then set up a treemap tooltip and configure it to use a chart on another Power BI page. Next, you'll create a Power BI report that automatically links the treemap to a matrix visualization. You'll then optimize this report for mobile device viewing. You'll move on to use slicers and add them to a page in your Power BI report. Lastly, you'll work with different slicer settings for numeric and string (categorical) fields and implement horizontal and vertical slicer layouts.
8 videos | 1h 10m has Assessment available Badge
Power BI Bootcamp: Session 1 Replay
This is a recorded Replay of the Power BI Live session that ran on July 19th at 11 AM ET. In this session Bobby Lansing introduces Power BI, shows you how to build your first report, and builds a report with formatting.
3 videos | 2h 39m available Badge
Power BI Bootcamp: Session 2 Replay
This is a recorded Replay of the Power BI Live session that ran on July 20th at 11 AM ET. In this session Bobby Lansing discusses creating interactive visuals.
2 videos | 2h 53m available Badge
Power BI Bootcamp: Session 3 Replay
This is a recorded Replay of the Power BI Live session that ran on July 21st at 11 AM ET. In this session Bobby Lansing discusses using the ETL Layer and Power BI Web Services.
2 videos | 2h 47m available Badge
Power BI Bootcamp: Session 4 Replay
This is a recorded Replay of the Power BI Live session that ran on July 22nd at 11 AM ET. In this session Bobby Lansing discusses implementing data storytelling frameworks and programming in Power BI using Dax.
2 videos | 2h 43m available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Power BI Data Model Design: An Overview of Data Modeling
Data as a form of currency is an analogy that's been around since the early 2000s. However, data itself is worthless. The real value is in the insights you gain from it; this is where data analysis comes in. Data modeling is a crucial part of data analysis, helping turn raw data into accurate insights and meaningful reports. Use this course to learn how to design and optimize data models through Power BI Desktop. Examine the star and snowflake schemas. Learn about the DAX formula language. Then, conduct a range of tasks, including combining tables, defining calculated columns, creating measures, and counting values. Upon course completion, you'll know how to use data modeling to transform raw data into powerful visuals and reports. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
12 videos | 1h 49m available Badge
Power BI Data Model Design: Applying the DAX Formula Language
Power BI does the heavy lifting when it comes to analyzing data. One way it does this is through the DAX formula language. By learning how to use this language, you can vastly improve the insights you get from data. Use this course to learn how to conduct several data analysis operations using the DAX formula language. Begin by performing aggregation operations, such as sum and average. Learn how to generate and work with blank data in DAX. Explore a variety of counting functions, ranging from simple counts of values to conditional counts based on filters. Lastly, practice using the IF and SWITCH functions. Upon course completion, you'll know how to use DAX to calculate values and reference table data in Power BI. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
10 videos | 1h 16m available Badge
Power BI Data Model Design: Working with Filters
The more you master DAX in Power BI, the better the insights and reports you'll get from data. The filter context is a need-to-know DAX concept. Use this course to get hands-on experience working with this aspect of Power BI. Start by exploring the relationships between tables in Power BI. Move on to using the CALCULATE function. Then, see how a filter context can be defined so that it only points to a subset of the overall data and how you can continue to perform operations within this filter context. Moving on, examine a breadth of options for ignoring the filter context for specific use cases, including how to bypass filters using various DAX functions. When you're done, you'll be able to use DAX functions to perform operations on a subset of data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
10 videos | 1h 22m available Badge
Power BI Data Model Design: Using Time Intelligence
A big part of data analysis is evaluating how data behaves over time. Power BI's DAX language includes time intelligence functions that enable you to aggregate, compare, and manipulate data using time periods. Use this course to learn how to model data using time-based analysis. Begin by creating a date table. Then use DAX time intelligence functions to extract values from a date. Also, learn how to define dates as a hierarchy, which can then be applied in visualizations. Moving along, practice operating on a range of dates that are shifted from the range in the current context by a specified interval. Finally, perform year-to-date and month-to-date computations from the date in the current context. When you're done, you'll be able to apply a variety of time functions to your data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
7 videos | 54m available Badge
Power BI Data Model Design: Advanced Modeling Technique
A well-designed data model eliminates irrelevant and uninterpretable analyses and ensures insightful and well-performing reports. Use this course to step up your data analysis using Power BI's advanced data modeling features. Begin by loading a sales dataset containing a large fact table and multiple dimension tables and modeling it into a snowflake schema. See how Power BI automatically detects relationships. Then, learn how to apply detailed configurations of relationships, from setting the right cardinality to applying bi-directional cross-filtering. Next, explicitly define a hierarchy in your data to model a set of geographical values. Learn further detailed configurations, such as setting a default aggregation operation on fields and hiding specific ones from the reports view. Lastly, learn how to implement row-level security. When you're done, you'll be able to use Power BI's advanced data modeling capabilities. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
15 videos | 1h 56m available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Business Reporting: Getting Started with Power BI Desktop for Data Analysis
Power BI is one of the most commonly-used tools for building data reports from various source data. In this course, you'll start by installing Power BI Desktop and importing data to it from several sources, including the relational databases, MySQL and PostgreSQL, cloud data warehouses, and Excel, CSV, JSON, and XML files. You'll then use Power BI to perform simple operations, such as changing data types, renaming columns, and using uppercase text. You'll also open and run the Power Query app. Moving on, you'll use Power BI to create and format simple data visualizations, such as bar charts, line charts, and stacked bar charts. Finally, you'll practice aggregating numeric data and string (categorical) data in charts, working with the correct aggregation operators for their respective fields.
11 videos | 1h 35m has Assessment available Badge

COURSES INCLUDED

Data Preparation and Processing: Using Power BI for Data Analysis
Most businesses have an enormous amount of data in their possession. But this data is only as valuable as the quality of the processes used to understand it. So how do you gather seemingly disparate data from multiple sources and turn it into digestible insights for all to use? One way to do this is to use Power BI, Microsoft's business analytics service. Use this course to comprehend exactly what's involved in data analysis, including specific tasks and job roles. Examine how Power BI's suite of features can facilitate these tasks efficiently and effectively. Furthermore, see the steps involved in taking the DA-100 certification exam, which tests the learner's ability to analyze data using Power BI. Upon completion, you'll have a theoretical understanding of how Power BI is used to carry out data analysis.
9 videos | 1h 9m has Assessment available Badge
Data Preparation and Processing: Loading & Transforming Data in Power BI
Using Power BI for data analysis means you can pull data from multiple places into one location and turn that combined data into meaningful insights. Use this course to learn how to connect different data sources to Power BI and the types of transformations that can be applied to this data. Install Power BI desktop. Load data from CSV, XML, and JSON files as well as from SQL Server. Use Power Query within Power BI to apply transformations. Then, explore transformations crucial to building meaningful, responsive, and informative visualizations, such as trimming out unnecessary data and merging columns containing related information. Upon completion, you'll be able to load data into Power BI and transform it for analysis.
10 videos | 1h 20m has Assessment available Badge
Data Preparation and Processing: Preparing Data for Visualizations in Power BI
A vital step between gathering data and creating a report or visualization from it is transforming it into a cohesive form. Use this course to gain hands-on experience in transforming raw data for visualizations. Practice combining related data into a single table. While doing so, perform a preliminary analysis of the data so you can imagine what visualizations can be created from it. Next, combine data from several files into a single table and conduct several transformations, from aggregating data to filtering out unnecessary rows. Finally, build a simple column chart visual from the contents of a Power BI table. While doing so, identify the different storage modes in Power BI and how they affect your visuals. Upon completion, you'll be able to prepare data for visualization using a variety of transformations.
12 videos | 1h 51m has Assessment available Badge

EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

BOOKS INCLUDED

Book

Data Analysis with Microsoft Power BI
Including hands-on exercises based on real-life business scenarios, this book teaches you the skills you need to interact with, author, and maintain robust visualizations and custom data models.
Book Duration 6h 12m Book Authors By Brian Larson

Book

Pro Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions
Providing detailed examples and explaining the different methods available, this book will help you understand the many options and choose the best combination for hosting, developing, sharing, and deploying a Power BI solution within your organization.
Book Duration 4h 14m Book Authors By Reza Rad

Book

Pro Power BI Desktop, Second Edition
Helping you to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop, this book shows you how to choose from a wide range of built-in and third-party visualization types so that your message is always enhanced.
Book Duration 10h 36m Book Authors By Adam Aspin

Book

Introduction to Microsoft Power BI: Student Study Guide
Including an introduction to the Power BI web app, this book will show you how to link and model data in Power BI and create visual reports that reveal data insights.
Book Duration 1h 6m Book Authors By Velsoft Training Materials, Inc.

Book

Supercharge Power Bi: Power Bi is Better When You Learn to Write Dax
Including numerous worked-through examples and practice exercises, this book clearly explains the necessary concepts while at the same time giving hands-on practice to engage the reader and help new knowledge stick.
Book Duration 3h 26m Book Authors By Matt Allington

Book

Pro Power BI Desktop: Self-Service Analytics and Data Visualization for the Power User, Third Edition
Deliver eye-catching and insightful business intelligence with Microsoft Power BI Desktop. This new edition has been updated to cover all the latest features of Microsoft’s continually evolving visualization product.
Book Duration 9h 26m Book Authors By Adam Aspin
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Beginning Power BI with Excel 2013: Self-Service Business Intelligence Using Power Pivot, Power View, Power Query, and Power Map
Taking you through each tool in turn, using hands-on activities to consolidate what you’ve learned in each chapter, this step-by-step resource is your practical guide to getting maximum insight from your data, and presenting it with impact.
Book Duration 2h 52m Book Authors By Dan Clark

Book

High Impact Data Visualization with Power View, Power Map, and Power BI
Helping you master this suite of powerful tools from Microsoft, this insightful guide helps you take business intelligence delivery to a new level that is interactive, engaging, even fun, all while driving commercial success through sound decision-making.
Book Duration 7h 54m Book Authors By Adam Aspin

Book

Power Pivot and Power BI: The Excel User's Guide to DAX Power Query, Power BI & Power Pivot in Excel 2010-2016, 2nd Edition
Introducing the concepts in a simple, step-by-step manner tailored to the learning style of Excel users everywhere, this easy-to-follow guide presents techniques that allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce.
Book Duration 5h 11m Book Authors By Avi Singh, Rob Collie

Book

Pro Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions
Providing detailed examples and explaining the different methods available, this book will help you understand the many options and choose the best combination for hosting, developing, sharing, and deploying a Power BI solution within your organization.
Book Duration 4h 14m Book Authors By Reza Rad

Book

Power Query for Power BI and Excel
Going well beyond the surface of what Power Query can do, this concise, practical book provides a complete guide to Power Query and how to use it to solve all of your Excel data-loading problems.
Book Duration 3h 29m Book Authors By Chris Webb

Book

Beginning Big Data with Power BI and Excel 2013
Through instruction, insight, advice, and case studies, this book shows how the self-service analytics available in Excel with Power BI - which you already know how to use - can perform many of the same functions as the higher-end Apache tools many people believe are required to carry out in Big Data projects.
Book Duration 1h 50m Book Authors By Neil Dunlop

Book

Pro Power BI Desktop: Free Interactive Data Analysis with Microsoft Power BI
Showing you how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop, this book will enable you to take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention.
Book Duration 7h 22m Book Authors By Adam Aspin

Book

High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI, Second Edition
Covering new features and added support for visualization in Excel 2016, this essential book helps in harnessing the power of Microsoft’s flagship, self-service business intelligence suite to deliver compelling and interactive insight with remarkable ease.
Book Duration 9h 5m Book Authors By Adam Aspin

Book

Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop, Second Edition
Using step-by-step activities and plenty of screen shots, this book will teach you how to build scalable and robust data models to work from, clean and combine different data sources effectively, and create compelling visualizations and share them with your colleagues.
Book Duration 2h 51m Book Authors By Dan Clark

Book

Pro Power BI Desktop, Second Edition
Helping you to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop, this book shows you how to choose from a wide range of built-in and third-party visualization types so that your message is always enhanced.
Book Duration 10h 36m Book Authors By Adam Aspin

BOOKS INCLUDED

Book

Data Analysis with Microsoft Power BI
Including hands-on exercises based on real-life business scenarios, this book teaches you the skills you need to interact with, author, and maintain robust visualizations and custom data models.
Book Duration 6h 12m Book Authors By Brian Larson

Book

Introduction to Microsoft Power BI: Student Study Guide
Including an introduction to the Power BI web app, this book will show you how to link and model data in Power BI and create visual reports that reveal data insights.
Book Duration 1h 6m Book Authors By Velsoft Training Materials, Inc.

Book

Pro Power BI Desktop, Second Edition
Helping you to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop, this book shows you how to choose from a wide range of built-in and third-party visualization types so that your message is always enhanced.
Book Duration 10h 36m Book Authors By Adam Aspin

BOOKS INCLUDED

Book

High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI, Second Edition
Covering new features and added support for visualization in Excel 2016, this essential book helps in harnessing the power of Microsoft’s flagship, self-service business intelligence suite to deliver compelling and interactive insight with remarkable ease.
Book Duration 9h 5m Book Authors By Adam Aspin

Book

Beginning Big Data with Power BI and Excel 2013
Through instruction, insight, advice, and case studies, this book shows how the self-service analytics available in Excel with Power BI - which you already know how to use - can perform many of the same functions as the higher-end Apache tools many people believe are required to carry out in Big Data projects.
Book Duration 1h 50m Book Authors By Neil Dunlop

Book

Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop, Second Edition
Using step-by-step activities and plenty of screen shots, this book will teach you how to build scalable and robust data models to work from, clean and combine different data sources effectively, and create compelling visualizations and share them with your colleagues.
Book Duration 2h 51m Book Authors By Dan Clark

Book

Pro Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions
Providing detailed examples and explaining the different methods available, this book will help you understand the many options and choose the best combination for hosting, developing, sharing, and deploying a Power BI solution within your organization.
Book Duration 4h 14m Book Authors By Reza Rad

Book

High Impact Data Visualization with Power View, Power Map, and Power BI
Helping you master this suite of powerful tools from Microsoft, this insightful guide helps you take business intelligence delivery to a new level that is interactive, engaging, even fun, all while driving commercial success through sound decision-making.
Book Duration 7h 54m Book Authors By Adam Aspin

Book

Power Pivot and Power BI: The Excel User's Guide to DAX Power Query, Power BI & Power Pivot in Excel 2010-2016, 2nd Edition
Introducing the concepts in a simple, step-by-step manner tailored to the learning style of Excel users everywhere, this easy-to-follow guide presents techniques that allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce.
Book Duration 5h 11m Book Authors By Avi Singh, Rob Collie

Book

Power Query for Power BI and Excel
Going well beyond the surface of what Power Query can do, this concise, practical book provides a complete guide to Power Query and how to use it to solve all of your Excel data-loading problems.
Book Duration 3h 29m Book Authors By Chris Webb

Book

Beginning Power BI with Excel 2013: Self-Service Business Intelligence Using Power Pivot, Power View, Power Query, and Power Map
Taking you through each tool in turn, using hands-on activities to consolidate what you’ve learned in each chapter, this step-by-step resource is your practical guide to getting maximum insight from your data, and presenting it with impact.
Book Duration 2h 52m Book Authors By Dan Clark

YOU MIGHT ALSO LIKE