Analysing and Visualising Data with Power BI
Course Description
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.
Course Structure
The following topics will be tackled:
Using Power Query
- Get 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
- Create row-level-security (RLS)
Power BI Service
- Publish report to Power BI Service
- Print to PDF
- Export data to Excel
- Show workspaces
- Create Dashboards in Power BI Service
- Set scheduled refresh
- Manage Dataset permissions
- Share reports
- Assign RLS to user
Should Attend
The course is ideal for anyone who has a good knowledge of Excel and would like to learn Power BI.
Prerequisites
A very good knowledge of Excel, including a working knowledge of PivotTables.
Assessment
There is no final assessment. Students will be guided during the course.
Key-Features
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.
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.
Attending delegates will be presented with a Certificate of Attendance upon completion of training.
Course Structure
The following topics will be tackled:
Using Power Query
- Get 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
- Create row-level-security (RLS)
Power BI Service
- Publish report to Power BI Service
- Print to PDF
- Export data to Excel
- Show workspaces
- Create Dashboards in Power BI Service
- Set scheduled refresh
- Manage Dataset permissions
- Share reports
- Assign RLS to user
Should Attend
The course is ideal for anyone who has a good knowledge of Excel and would like to learn Power BI.
Prerequisites
A very good knowledge of Excel, including a working knowledge of PivotTables.
Assessment
There is no final assessment. Students will be guided during the course.
Key-Features
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.
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.
Attending delegates will be presented with a Certificate of Attendance upon completion of training.
Register Your Interest: