Analysing and Visualising Data with Power BI
Power BI for Excel is a powerful tool which allows you to consolidate and mine data from multiple sources, investigate trends, create dashboards and make sense of your business data with just a few clicks in the familiar environment of Excel. Now it is possible to process millions of rows of data in Excel enabling deeper business insight and shorter decision making cycles.
If you are looking to boost your business or advance your career, then Power BI Training is for you. No previous experience required as we show you everything from the start but if you know a little about Excel formulas, one-to-many relationships in Access, SQL queries, VLOOKUP, PowerPivot Reports, you have a head start.
A very good knowledge of Excel, including a working knowledge of PivotTables.
At the end of the course, delegates will be able to use Power BI as a Self-Service BI tool. Users will learn Power Query for importing and transforming data from a multitude of data sources, building data models in Power Pivot and building Pivot Tables reading from multiple tables and finally creating interactive visualisations in Power BI Desktop or Power BI for o365.
Attending delegates will be presented with a Certificate of Attendance upon completion of training.
We believe that learning is most effective when presented in a relevant context so that the skills, strategy, and knowledge are meaningful to our delegates and can be applied directly in the training.
Each delegate will be given a digital courseware manual to refer to, both during and after the course.
Introduction to Business Intelligence (BI)
- The definition of BI
- Why is BI important?
- Preview a BI stack
Choosing the Right BI Tools
- Differentiate between business groups that consume BI
- Understand the typical progression of BI
- Determine the best BI tools for your needs
Using Power Query to gather data from various sources
- Importing data in excel from various data sources (online, web search, spreadsheets, various database sources, Facebook, Microsoft Exchange and others)
First Steps with PowerPivot
- Working with Classic Excel PivotTables
- Working with PivotTables in PowerPivot
- Importing, Querying Data and Creating a Data Model
- Creating PivotTables from multiple data sources
PowerPivot at Work
- Using the PivotTable to Produce Reports
- Formatting Numbers
- Adding Calculated Columns
- Adding Measures
- Adding More Tables
- Refreshing Data
- Using Slicers
- Extending the Data Model relationships using Excel, PowerPivot and DAX