What you'll learn

  • Extract & Transform

    Get data from various sources such as websites, SharePoint, Excel files and CSV. Transform this data ready for visualisation.

  • Model & Visualise

    Learn how to create calculations and measures using DAX. Visualise them using interactive charts and visuals.

  • Distribute

    Learn how to use the Power BI Service to distribute your insights across your teams and organisation.

Course curriculum

    1. What is Power BI?

      FREE PREVIEW

    2. An Example

      FREE PREVIEW

    3. Typical Workflow

      FREE PREVIEW

    1. Power BI Desktop

    2. Power BI Service Account

    3. Power BI Licenses

    4. Downloadable Lab Files

    1. Introduction to Power BI Desktop

    2. Getting Data from Excel

    3. Getting Data from a SharePoint Online Folder

    4. Getting Data from Databases

    5. Getting Data from Websites

    6. Combining Files in Folder

    7. Enter your Own Data

    8. Refreshing your Data

    9. Storage Modes

    10. Best Practices

    11. QUIZ - Get Your Data

    12. TEST your Knowledge - Get Your Data

    1. Introduction to Power Query

    2. Basic Transformations

    3. Creating Columns

    4. Merging and Appending Tables

    5. Pivoting and Unpivoting

    6. Groupings and Aggregations

    7. Working with Queries

    8. QUIZ - Transforming your Data

    9. TEST your Knowledge - Transforming your Data

    10. SOLUTION - Transforming your Data

    11. Power Query Best Practices

    1. Introduction to Data Modelling

    2. Setting Up Relationships

    3. Star and Snowflake Schemas

    4. Using a Date Table

    5. Introduction to DAX

    6. Logical Functions

    7. Text Functions

    8. Math Functions

    9. Date and Time Functions

    10. Aggregation Functions

    11. Measures VS Calculated Columns

    12. CALCULATE Function

    13. Time Intelligence Functions

    14. Filter Functions

    15. Row Context and Filter Context

    16. Data Modelling Best Practices

    17. QUIZ - Preparing Your Model

    18. TEST your Knowledge - Preparing Your Model

    19. SOLUTION - Preparing Your Model

    1. Introduction to Power BI Visuals

    2. Using Visuals

    3. Filtering and Cross Filtering

    4. Basic Shapes, Images and Texts

    5. Basic Charts

    6. Cards and KPIs

    7. Maps

    8. Gauges, Funnels and Waterfall

    9. Tables and Matrix

    10. Slicers

    11. Adding Buttons

    12. Importing Custom Visuals

    13. Drillthrough Pages

    14. Editing Interactions

    15. Selection Pane

    16. Bookmarks

    17. Structuring Your Reports

    18. Create Mobile-Friendly Layouts

    19. Data Visualisation Best Practices

    20. QUIZ - Visualising your Data

    21. TEST your Knowledge - Visualising your Data

About this course

  • £99.00
  • Guided lessons
  • Test your knowledge
  • Practical activities

Your Instructor

Power BI Specialist Fernan Espejo

Hi, my name is Fernan and thank you for considering me to help you with your Power BI journey.

On my YouTube Channel, I share weekly Power BI tips, tricks and best practices based on my experience and requests from the community.

I’m a Microsoft Certified Data Analyst Associate, as well as MCSA Certified in BI Reporting awarded in 2020. I have over 6 years experience in the analytics field, implementing data solutions for various organisations within the UK.

My background is: BSc Software Engineering, Data Scientist, Programmer and Consultant. My passion is teaching and solving difficult problems in Power BI and DAX. I’m also addicted to learning and enjoy watching other professionals with their own tips and tricks.

I founded Solutions Abroad in 2018, with the aim of helping people have the tools and confidence they need to be efficient at work, solve problems and get more done.

Let’s start now.