Power BI

Power BI is an incredibly powerful, self-service Business Intelligence (BI) solution from Microsoft. Power BI is user friendly and perfect for people with a limited technical or programming background.

In this Power BI training course, we start by looking at Power Query, and how to use this tool to organize and clean our data. If you’ve used Power Query in Excel, then you’ll find it simple moving to Power BI. We then showy ou how to build a Data Model and relate separate tables – this allows us to start to combine and analyze millions of rows of data. After that, we teach you all about the powerful data analysis language DAX. Finally, we look at how to present this data using the plethora of charts and graphs available. 

Power BI allows anyone to create beautiful looking charts and graphs that generate business insight and fuels decision making.

Start creating your reports using Power BI Desktop and then share them as interactive dashboards using Power BI Online in no time at all.

This course also includes practice exercises and follow-along files so you can build your data models as we go.

In this Power BI training course you will learn:

• What is Power BI and why you should be using it.
• To import CSV and Excel files into Power BI Desktop.
• How to use Merge Queries to fetch data from other queries.
• How to prevent some queries from loading to the model.
• How to create relationships between the different tables of the data model.
• To create a dynamic list of dates using DAX.
• All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.
• All about using the card visual to create summary information.
• How to use other visuals such as clustered column charts, maps, and trend graphs.
• How to use Slicers to filter your reports.
• How to use the Matrix visualization.
• How to use themes to format your reports quickly and consistently.
• About using Conditional Formatting to highlight key information.
• How to edit the interactions between your visualizations and filter at visualization, page, and report level.

Course Format

This is a video-led, Advanced Microsoft Excel training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is designed for PC users and does require a working knowledge of Microsoft Excel.

This course is also suitable for Office 365 users.

30-Day Guarantee

We offer an unconditional, 30-day, full money-back guarantee, no questions asked. It’s our way of ensuring you have complete confidence in your membership to Simon Sez IT. With 30 days of risk-free membership, you can test-drive all of our courses and feel entirely sure you’re getting just what you need. If you don’t learn, you don’t pay.

Why Trust Us?

Simon Sez IT has been in business for 10+ years and has taught over 500,000 students. We’ve created over 100 software training courses, 5,900+ video tutorials, and we’ve helped thousands of people around the world learn how to use Microsoft Office and developed multiple Microsoft Word training courses.

How Do I Start?

Simon Sez IT makes complicated software simple at a fantastic price. To access this course and over 90 others, select a membership option on the right-hand side >>>

All Simon Sez IT memberships are entirely flexible (cancel anytime), and all include our no questions asked 30-day money-back guarantee.