Power BI

Curriculum

• Power BI Overview Free

  3 Lessons 7 Min

  Power Bi is a business analytics solution that helps you visualize your data, share insights across your organization or embed them in your app or website. In this section, you will get more information about the Power BI software and how it functions. We will see what the differences between the Power BI versions are and which one suits our needs best.

  Introduction to Power BI Free Power BI Desktop vs Power BI Pro Free Power BI data sources Free
• Power BI Setup Free

  3 Lessons 16 Min

  In the second section, we will set up our Power BI in Windows. We will show alternative options for Mac users and how they can use Power BI completely free of charge for the next 12 months.

  Power BI for MAC Free Power BI for Mac Part 2 Free How to Install Power BI Free
• Connecting to data sources Free

  12 Lessons 63 Min

  In this section, we are going to investigate the query editor. We will discuss the differences between Import Mode and Direct Query. We’ll learn how to import data from an Excel file, launch Power Query, and how to use it for data transformations. Here, you’ll have the opportunity to build your first data model and examine the relationships available in Power BI. We’ll talk about Active vs Inactive relationships, and how to enter data inside Power BI using DAX code or the native Power BI interface. In addition, we’ll touch base on Role Level Security. We are going to see how data refreshes in Power Bi, whether it’s an SQL server, live connection or an import mode. We’ll explore hierarchies. And, finally, we’ll investigate Q&A inside Power BI by demonstrating how you can ask questions to your data to get some real answers in the form of lines and charts.

  Introduction to Data Sources Free The Query Editor Free Import vs DirectQuery Free Importing Data from Excel Files Free Importing Data from Excel Files - Continued Free First Data Model Free Active vs Inactive Relationships Free Entering Data Manually Free Roles Free Refreshing Data Free Hierarchies Free Ask a Question Free
• Task three

  2 Lessons 18 Min

  This is our first mini project. In this task, you’ll be asked to create a model inside Power BI and create the following visuals: Sales Amount by Currency, Sales Amount by Month, and a Matrix table which will show us the Sales Amount per Email Address by Currency.

  Task Three, Part 1 Task Three, Part 2
• Data Modelling

  18 Lessons 104 Min

  This section will introduce DAX, the language Power BI uses for creating Measures and Calculated columns. We are going to learn the foundations, and then drill into some more sophisticated functions such as time-intelligence, iterators, CALCULATE, FILTERS, data-modelling and more. By the end of this section, you’ll feel confident using DAX language, and you will be able to transfer this knowledge into your own projects.

  Introduction to Data Modeling DAX Calculated Columns Measures Star Schema Snowflake Schema Investigating Filter Flow Related vs Relatedtable Bi-directional Cross-filtering Calculate Time Intelligence, Part 1 Time Intelligence, Part 2 ALL FILTER Iterators Logical Operators Switch Text Functions
• Task Four

  3 Lessons 26 Min

  This is our second mini project! Here, we will emphasize using some of the DAX functions that we’ve learned earlier in section 4. Our goals will be to find the total sales for the USA as a number in percentage, to create a button that will switch between values, to change the countries’ order, and build a dynamic text box that changes based on the user’s selection.

  Task Four, Part 1 Task Four, Part 2 Task Four, Part 3
• Creating Our First Data Visualization Report

  14 Lessons 98 Min

  In this section, you will learn how to format charts in Power BI. We’re going to explore some of the most popular visualizations and show you how to give your reports the wow factor! This is the section that will take your report designing skills to the next level. We are going to kick things off with the report viewer, moving on to pie charts, tables, card visuals slicers, gauges, filters, maps, conditional formatting, and more! The section wraps up with a mini quiz and a task that will allow you to put your new knowledge into practice.

  Introduction Report View Slicers Bar Chart Bookmarks Conditional Formatting Field Formatting Gauge Chart Card Visuals, Part 1 Card Visuals, Part 2 Drillthrough Filters Map Visuals Custom Colors
• Task Five

  4 Lessons 20 Min

  In this task, you will practice designing a dashboard that is both functional and aesthetically pleasing. The dashboard will contain: Header, Slicer with Colors to be placed inside, Measures table (using DAX), and other visuals.

  Task Five, Part 1 Task Five, Part 2 Task Five, Part 3 Task Five, Part 4
• Task Six Final Project

  14 Lessons 99 Min

  In our final project, you will implement all the knowledge you’ve gained in this course by building a dashboard for our sales team from scratch. The idea behind this dashboard is to create an overview where the user can get a better understanding of their sales, see the month-on-month performance, select a single currency, and see how this currency is performing compared to the others. Users will get to slice and dice between the following sections: Users, Currency and Sales Territory.

  Final Project, Part 1 Final Project, Part 2 Final Project, Part 3 Final Project, Part 4 Final Project, Part 5 Final Project, Part 6 Final Project, Part 7 Final Project, Part 8 Final Project, Part 9 Final Project, Part 10 Final Project, Part 11 Final Project, Part 12 Final Project, Part 13 Final Project, Part 14
• Bonus - Power BI Service

  3 Lessons 13 Min

  In the bonus lecture, you’ll have the opportunity to see how to sign up for the Power Bi service and how to use it for free for the next 60 days. We’ll dive into the features of the service, check out its workspaces, and see how we can use them.

  Announcement Power BI Service Workspaces