About This Course
Who this course is for:
- This course is meant for those involved in the Analysis of Data, Finance & Accounting and Reporting roles.
- This course is for you if you are looking to learn Power BI Self Service functions.
- This course is not for you if you are new to Excel.
What you’ll learn:
- Learn to gather data
- Transform data and model data
- Explain the data and share valuable insights with your organisation
- No prior knowledge is required to take this course
Power BI brings the world of data analytics to the ordinary business, by connecting to data from multiple sources and transforming or modelling that data, you can view and share insights to your business like never before. Being a self-service system, means you don’t need the help of and IT department to transform or model the data.
LEARN TO GATHER DATA, TRANSFORM DATA AND MODEL DATA BEFORE YOU CREATE VISUALIZATIONS TO EXPLAIN THE DATA AND SHARE VALUABLE INSIGHTS WITH YOUR ORGANISATION.
CONTENTS AND OVERVIEW
Section 1 of this course is an Introduction section where you will learn how to install PowerBI and you will be given a guided tour.
In section 2 of this course we will look at getting data from multiple sources, both internal and external. Connecting to different types of files of data, Folders or data and online data. Setting up data queries and transforming the data into a format that can be used.
In section 3 of this course we will look at Data modelling, setting up relationships, creating calculated columns and measures using DAX, using calculated tables and creating hierarchy. In addition to this we will also look at some time intelligence functions.
In section 4 of this course we will look at Data visualization. We will go through the use of different charts, trend lines, slicer’s maps and other visualizations
Who Should Attend?
This course is suited to those with an interest in Excel, Data Analysts, Data Mining, BI and Reporting This course is well suited for Accountants, Auditors, Internal Auditors, Business Analysts, Finance staff, Banking staff, Management and those involved with Compliance and Risk assessment and BI.
Our Promise to You
By the end of this course, you will have learned BI for data analytics.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about BI for data analytics.
|Section 1 - Power BI Desktop Introduction|
|Download PowerBI Desktop||00:00:00|
|Lets Take A Tour Around The Desktop Application||00:00:00|
|How To Take This Course||00:00:00|
|Section 2 - Get And Query Data|
|Activity And Workbooks||00:00:00|
|Introduction To The Query Editor Section||00:00:00|
|Connect And Transform Data From An Excel Workbook||00:00:00|
|Connect And Transform Folders Of Data||00:00:00|
|Setting Up A Date (Calendar) Table Using Query||00:00:00|
|Connect To A .Txt File||00:00:00|
|Connect To Data On The Web||00:00:00|
|Section 3 - DAX|
|Related And Related Table Expressions||00:00:00|
|The Filter Expressions||00:00:00|
|Other DAX Functions||00:00:00|
|More On DAX||00:00:00|
|More On Calculated Columns And Measures||00:00:00|
|Time Intelligence Functions||00:00:00|
|Downloadable Materials : DAX And Data Files||00:00:00|
|Section 4 - Visualizations|
|Introduction To Visulaizations||00:00:00|
|The Canvas And Your First Visualization||00:00:00|
|Line Charts And Hierarchy||00:00:00|
|Gauges, KPI’s And Cards||00:00:00|