-
Get and query data
9 Lessons-
StartActivity and Workbooks
-
StartIntroduction to the Query Editor Section
-
PreviewConnect and transform data from an Excel Workbook
-
StartConnect and transform folders of Data
-
StartUnpivot Data
-
StartSetting up a date (Calendar) table using query
-
StartConnect to a .TXT file
-
StartConnect to data on the Web
-
StartActivity
-
-
DAX
19 Lessons-
StartWorkbook
-
PreviewDAX introduction
-
StartRelationships
-
StartActivity
-
StartCalculated columns
-
PreviewMeasures
-
StartActivity
-
StartThe X-functions
-
StartActivity
-
StartRelated and Related Table Expressions
-
StartThe Filter Expressions
-
StartActivity
-
StartCalculate Function
-
StartActivity
-
StartOther DAX Functions
-
StartMore on DAX
-
StartMore on Calculated Columns and Measures
-
StartTime Intelligence Functions
-
StartActivity
-
Power BI Desktop - Data Analytics for Everyone
Learn how to Get, Sort, Transform, Model and Visualize data from any source with Microsoft Power BI application
Course Summary
Power BI
Power BI Desktop is a combination of Excels Power Features (Power Pivot, Power Query and Power View) all in a standalone package. Using Power BI, you can find, get, transform, analyse and Combine data from disparate databases, files, and web services with visual tools that help you understand and fix data quality and formatting issues automatically. Combined with BI Service, these data queries reports and dashboard can be shared and viewed on the go.This self-service business intelligence systems brings data analytics to the ordinary company.
COURSE SUMMARY
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 Analyst's, 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.• 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’s included?
Instruction by an expert12 months access 24/7
Certificate of completion
How long will it take ?
Completion Time 5 hoursCourse Curriculum
Paula Guilfoyle
After over 10 years in Accounting and Operations Paula turned her career to subject matter expert, consultant, content creation and online education. In 2010 Paula began teaching online and can now boast over 250K students in 186 different countries. In 2016 Paula began her learning journey around Blockchain and Cryptocurrency. By 2022 Paula pivoted her consultancy, content creation and online education to focus on Blockchain, Web3 and Digital Assets.
