US $19.97

Power BI

——   Created by Simon Sez IT

Share this course:

NEW
Course
45
Lessons
4h 0m
Lesson time
beginner
Skill level

More about this course

Power BI is an incredibly powerful, self-service Business Intelligence (BI) solution from Microsoft. Power BI is user friendly and perfect for people with a limited technical or programming background.

 

In this Power BI course, we start by looking at Power Query, and how to use this tool to organize and clean our data. If you’ve used Power Query in Excel, then you’ll find it simple moving to Power BI. We then show you how to build a Data Model and relate separate tables - this allows us to start to combine and analyze millions of rows of data. After that, we teach you all about the powerful data analysis language DAX. Finally, we look at how to present this data using the plethora of charts and graphs available.

 

Power BI allows anyone to create beautiful looking charts and graphs that generate business insight and fuels decision making.

 

Start creating your reports using Power BI Desktop and then share them as interactive dashboards using Power BI Online in no time at all.

 

This course also includes practice exercises and follow-along files so you can build your data models as we go.

 

In this course you will learn:

 

●     What is Power BI and why you should be using it.

●     To import CSV and Excel files into Power BI Desktop.

●     How to use Merge Queries to fetch data from other queries.

●     How to prevent some queries from loading to the model.

●     How to create relationships between the different tables of the data model.

●     To create a dynamic list of dates using DAX.

●     All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.

●     All about using the card visual to create summary information.

●     How to use other visuals such as clustered column charts, maps, and trend graphs.

●     How to use Slicers to filter your reports.

●     How to use the Matrix visualization.

●     How to use themes to format your reports quickly and consistently.

●     About using Conditional Formatting to highlight key information.

●     How to edit the interactions between your visualizations and filter at visualization, page, and report level.

●     How to drill down from one report to another in Power BI.

45 Lessons

Module 1: Introduction
3 mins
Welcome and Overview
free preview
5 mins
What is Power BI?
free preview
3 mins
Install Power BI Desktop
7 mins
A Tour of BI Desktop
6 mins
Explore Commonly Used Power BI Options
13 mins
Import Files from a Folder into Power BI Desktop
Module 2: Getting and Transforming Data
8 mins
Get Data from Excel and Text Files
7 mins
Reference Queries to Create Additional Lookup Tables
7 mins
Merge Queries in Power Query
4 mins
Prevent Queries from Loading into Power BI Desktop
1 min
Practise Exercise
7 mins
Create Relationships Between tables
Module 3: Data Modelling
View more lessons +

About the instructor

Simon Sez IT
Simon Sez IT
  • 34 courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon …

Read more
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today. ☝️

Class benefits

  • Certificate of Completion
  • 30 day satisfaction guarantee
  • 24/7 streaming access
  • Direct teacher access
  • 4h 0m of on-demand video
  • 2 downloadable files
  • Have a coupon?
  • Checkout