Power BI Desktop£300
About this course
For Versions: Latest Desktop Version Download Required (Office365 Power BI Licence required for online systems)
Prerequisites: Attendees must be familiar with working with large data sets, either in Excel or other database programs (SQL, Access etc.)
Getting Started with Power BI Desktop
Explore the Power BI Application Import Data from Excel Importing Data from Online Services Refresh Data from a Data Source Creating the Data Model Linking Tables and Data
Organize and Format Tables Creating DAX Formulas Create Calculated Columns/Measures Sort and Filter PowerPivot Data Create and Manage Table Relationships
Creating Simple Reports
Create a Pivot Table Using Multiple Fields from different tables Using Slicers
Using Power Query
Importing Data direct from the Internet Removing unwanted data from the import Appending data to tables or data sets Shaping Data to analyse Merging and Appending Queries Saving and Loading Queries
Working with Power View
What is Power View? Using the Power View Window Adding Data to a Report Page Applying Filters/Slicers Adding extra Report Pages
Week 1 0/5
Tools for Professional Approach: It’s not just about learning, it’s about having the confidence to use English in real life and upgrade your business communication skills.
Week 2 0/4
Tools for Professional Approach - Step 2: It’s not just about learning, it’s about having the confidence to use English in real life and upgrade your business communication skills.
Lorem Ipsn gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auci elit consequat ipsutis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus a sit amet mauris. Morbi accumsan ipsum velit. Nam nec tellus a odio tincidunt auctor a ornare odio. Sed non mauris vitae erat consequat auctor eu in elit.