Microsoft Power Bi For Beginners: Get Started With Power Bi

Learn to analyze data and create beautiful dashboards with this Microsoft Power BI beginners course

What you'll learn
How to create stunning, interactive dashboards with Power BI
How to share your analysis and dashboards using Power Bi Online
To import CSV and Excel files into Power BI Desktop
All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions
All about using the card visual to create summary information
How to create amazing visuals, such as clustered column charts, maps, and trend graphs
How to use Slicers to filter your reports
How to edit the interactions between your visualizations and filter at visualization, page, and report level
Requirements
A good knowledge of MS Excel is advised but not necessary
Power BI Desktop installed on your machine is required to take the practice exercises
Description
**This course includes practice exercise files and LIFETIME access**Learn Microsoft Power BI with this brilliant beginner course from Microsoft experts Simon Sez IT.Power BI is an incredibly powerful, self-service Business Intelligence (BI) solution from Microsoft. It is the perfect Business Intelligence tool for people with limited technical experience.In this Power BI course, we start by looking at Power Query, and how to use this tool to organize and clean our data. We then show you how to build a Data Model and relate separate tables. After that, we teach you all about the data analysis language DAX in Power BI. Finally, we look at how to present this data using the charts and graphs available.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 create relationships between the different tables of the data model.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 themes to format your reports quickly and consistently.How to edit the interactions between your visualizations and filter at visualization, page, and report level.***Exercise and demo files included***This course includes:4+ hours of video tutorials45 individual video lecturesExercise files to practice what you learnedCertificate of completionHere’s what our students are saying…"Brilliant course. I'm quite new to the world of POWER and this course has shown me what it can do in a way that a newbie can understand.  Recommended. I will be looking for other courses by them."- Andrew"Very detailed course, really enjoyed the Power BI course. Simon has done a really good job explaining each process step. Looking forward to completing additional Power BI courses for advanced techniques."- Martin"I would highly recommend. The course was informative and easy to follow."- Thomas"Great match! Learning so much and I love the quick step by step videos."- Vikki

Overview

Section 1: Introduction

Lecture 1 Welcome and Overview

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Demo Files (Section 2-4)

Lecture 4 DOWNLOAD ME: Course Demo Files (Section 5-8)

Lecture 5 DOWNLOAD ME: Course Exercise File

Lecture 6 DOWNLOAD ME: Course Transcript

Lecture 7 What is Power BI?

Lecture 8 Install Power BI Desktop

Lecture 9 A Tour of BI Desktop

Lecture 10 Explore Commonly Used Power BI Options

Section 2: Getting and Transforming Data

Lecture 11 Import Files from a Folder into Power BI Desktop

Lecture 12 Get Data from Excel and Text Files

Lecture 13 Changing Query Source

Lecture 14 Reference Queries to Create Additional Lookup Tables

Lecture 15 Merge Queries in Power Query

Lecture 16 Prevent Queries from Loading into Power BI Desktop

Lecture 17 Practise Exercise

Section 3: Data Modelling

Lecture 18 Create Relationships Between Tables

Lecture 19 Create a Dynamic List of Dates

Lecture 20 Create Additional Date Columns for Analysis

Lecture 21 Sort the Month and Weekday Names Correctly

Lecture 22 Mark the Table as a Date Table

Lecture 23 Hide Unnecessary Fields from Report View

Lecture 24 Practise Exercise

Section 4: Introduction to DAX Measures

Lecture 25 Calculate the Total Revenue

Lecture 26 Count the Total Rows of a Table

Lecture 27 Use the CALCULATE Function

Lecture 28 Calculate the Total Revenue Last Year

Lecture 29 Difference Compared to Last Year

Lecture 30 Practise Exercise

Section 5: Adding Visualizations to your Report

Lecture 31 Show Summary Information with Cards

Lecture 32 Columns Charts to Compare Values

Lecture 33 Map Visual to Plot Geographic Data

Lecture 34 Slicers to Filter your Reports

Lecture 35 KPI Card to Measure Performance Against a Goal

Lecture 36 Line Graphs to Visualise Trend

Lecture 37 Show Detail with the Matrix

Lecture 38 Top N Lists with the Table Visualisation

Lecture 39 Practise Exercise

Section 6: Report Design

Lecture 40 Adding Text Boxes and Shapes

Lecture 41 Use Themes

Lecture 42 Conditional Formatting

Lecture 43 Practise Exercise

Section 7: Editing Interactions and Filters

Lecture 44 Edit the Interactions between your Visualisations

Lecture 45 The Filter Pane to Filter at Any Level

Lecture 46 Drill Through to More Detail

Lecture 47 Practise Exercise

Section 8: Power BI Service

Lecture 48 Publish Your Report to the Power BI Service

Lecture 49 Different Ways to Share your Power BI Report

Lecture 50 Practise Exercise

Section 9: Closing

Lecture 51 Wrap Up

Advanced Excel users