If you need to analyse data then this is the course for you.
Many people use Excel to analyse data, and this works well for simple data sets that can be represented by a single table with less than a million rows. Even then Excel doesn't make it easy to produce good looking and easily shareable reports and dashboards.
Whether the data source is spreadsheet, database or involves pulling data from several different files or systems, then Power BI will make your life easier. Building reports and dashboards from this data and subsequently sharing the results is exactly what it's designed to do.
Getting Started with Power BI Desktop
- Power BI Concepts and Overview
- Introduction to Main Features
- Imports
- Visualizations
- Filters and Queries
- Reports
Connecting to Data Sources with Power BI Desktop
- Data Sources Power BI Desktop will connect to
- Data Types and Properties in Power BI Desktop
- Import and Enter Data
- Get Data and Query Editor
- Introducing the Query Editor
- Using the Query Editor to Connect to Data
- Combining Data Sources as a Mash Up
- Working with Relationships in Data
Data Visualizations
- Overview of Data Visualizations
- Tables and Matrix Views
- Applying Conditional Formats
- Charts
- Interactive Data and Date Slicers
- Drill Visualizations to see underlying data
- Create Reusable Field Hierarchies
- Record Grouping and Binning in Visualizations
- Drill Visualizations with using Dates
- Clustering
- Analytics and Forecast Lines in Visualizations
- Creating Role Based Views
- Data Categories, Geo-Data and Maps
Querying and Shaping the Data
- Common Activities using Query Editor
- Filters
- Transforms
- Pivot and Group By
- Creating Custom Calculated Columns
- Adding Conditional Columns
- Introduction to DAX Expressions
- Histograms
Reports and Output Options
- Report Elements and Options
- Working with Pages
- Adding Graphics
- Visual and Filter Settings
- Export Power BI Data to CSV
- Create a Power BI Template
The course runs from 9:30am through to 4:30pm. Refreshments are available from 9am.
We provide:
- Full course material
- Certificate of attendance
- Note pad and pen
- Polos!
Also includes:
Our Norwich on-site parking (NR3 1UB) is free and situated 5 minutes walk along the river to our training centre at St James Mill. If you arrive by train it is about 20 minutes on the Riverside walk or a short taxi ride to get to us. View full directions for Norwich and all our other venues.
You will learn in a relaxed environment with a small group of people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.
