Business Intelligence and data are here to stay. Now with Power BI by Microsoft, costs and skills are no longer a barrier to entry.
Power BI is a self service business intelligence system, and best of all, it is free for all to use.
The aim of this course Power BI - The Ultimate Orientation is to give you a solid orientation of Power BI. First you will learn how to download and install power bi desktop. We will have a look around the user interface and then we will start to work with some data.
Using an example data set, we will connect to both excel and cvs files and you will get an introduction of the Query editor as we do some transformation on the data. Then we will move on to a few calculations and you will be introduced to the concept of relationships and dax. Finally in powerbi desktop we will look at the visualisations side.
After we look at visualisations in Power Bi Desktop we will move on to power Bi services. Its in services that you will get insights, have the ability to share reports, build dashboards and connect to data packs that contains prebuilt dashboards and reports.
We will not be looking at any of this in detail as, this course is an orientation course, designed to get you familiar and comfortable with the Power BI user interface. The aim of the course is to get you up and running. To show you that Power BI offers a real solution, and give you ideas of how it can be used.
This is an Introduction to Power BI and this course Power BI - the Ultimate Orientation
In this section we will discuss Power BI desktop and section 1 in general.
By the end of this section you will
Learn how to download and install Power BI Desktop
Learn how to connect to Excel and CSV files
be familiar with the idea of data transformation in the query editor
be familiar with the idea of DAX calculations
be able to insert visualizations
In this lesson you will learn how to download and install Power BI Desktop to your laptop or computer
In this lesson we will connect to an Excel file and a CSV file. You will also be introduced to the Query Editor in Power BI. The query editor is how you transform data that you connect to into a form that you can analyse
In this lesson you will be shown the relationships view and you will be introduced to relationships in Power BI. We will look at the data view and we will also look at the visualizations view
In this lesson we will introduce you to DAX and measures and we will look at more visualizations
Carry out the following activities in Power BI Desktop
A quick chat on Power BI Services and an overview of this section. learn how to publish reports from Desktop to Services, see insights, set up dashboards, connect to data sources, use content packs and much much more
A quick overview on signing up and an orientation of Power BI services user interface
In this lesson you will be shown how to publish a report from desktop to services. You will also get a quick introduction to Power BI Insights
In this lesson we will look at connecting to files on your computer to PowerBI Services. we will also look at insights again
In this lesson we will look at dashboards and the features they have to offer. We will look a tiles and how you can move tiles around the dashboard
Learn how you can share your Power BI report by embedding it to a website
In this lesson you will learn how to set up a personal gateway between PowerBI services and your data
In this lesson we will look at connecting to Power BI services content packs for both Google Analytics and Mail Chimp. These content packs contain pre built dashboards for you to use
a quick wrap up on this orientation course
Grab your bonus today
Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management,Process improvement, Internal Audit, Group accountant, Operations management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has Udemy courses for those wishing to up skill, especially in the area of Spreadsheets, Bookkeeping and Accounting.
Now an E-learning Educator 5+ years, Paula also has a focus on E-learning and online teaching. Drawn from her online teaching experience,Paula has a number of courses available to online teachers to help bridge the skills gap for those that teach or wish to teach online.