Our Power BI training course will give you hands-on experience with Microsoft's heavy hitting Business Intelligence platform. Open up more highly-extensible reporting and analysis capabilities than you would have thought possible.
The latest suite of Power BI tools are the culmination of a raft of integration, business logic, visualisation and deployment technologies presented in such a way that self-service "pick-your-own" business intelligence now brings genuinely powerful control and takes away a lot of the complexity these functions would previously have required.
Power BI has the capability to pull in and process data from hundreds of other platforms - not just Microsoft's own (such as Dynamics, Sharepoint, SQL Server, Excel...) but pretty much anything with a decent API, whether on-premise or in the cloud - and squirt out interactive dashboards to browsers and desktop / mobile apps.
If you have a specific use case, project requirement or skills gap, please get in touch to find out how we can tailor a Power BI training workshop for you and / or your team's needs.
By the end of this course, you will have learnt about:
- Business Intelligence fundamentals
- An overview of the Power BI suite
- Connecting to various data sources
- Data Modelling
- Data Analysis Expressions (DAX) language
- Data Visualisation
- Publishing your solution (web / mobile apps)
Who should attend
Data analysts, business analysts, software developers and other business stakeholders who want to create and publish cross-platform Business Intelligence dashboards solutions
Prerequisites
Delegates should have intermediate to advanced Microsoft Excel skills (or with an equivalent package such as Crystal Reports, Business Objects). Some experience of Excel Macros / scripting would be useful but is not mandatory.
On-site
If you are looking for a tailored Power BI course which takes into account your existing technical skills, project requirements and timeframes, and specific topics of interest, please get in touch.
We can focus on the most relevant topics and even incorporate hands-on exercises based on your own data sources (we're happy to sign an NDA to facilitate this).
Give us a call on 020 3137 3920 or get in touch to talk to us about your learning goals and project requirements.
Business Intelligence fundamentals
- Defining BI and what it means to you
An overview of the Power BI suite
- Power BI Desktop
- Power BI Mobile
- Power BI Service
Connecting to data sources & Transforming Data
- Power Query & Query Editor
- Cleaning, Filtering and Normalising data
- Transformation GUI
Data Modelling & DAX
- xVelocity engine
- Relationships
- Hierarchies
- Formatting
- Sorting
- Data Analysis Expressions (DAX) language
- Calculations
- Normalising data
Data Visualisation & Publishing
- Charts, charts, charts
- Drill Down and Drill Up
- Filters
- Slicers
- More charts
- KPIs
- Building Dashboards
- Sharing visualisations
- Additional BI Service functions
"
The Jupyter notebooks were really handy, and I liked the group work using the breakout room feature of Zoom. Although the participants were from different backgrounds, Marco handled this very well by constantly checking if anyone has questions, adding explanations and making sure that the pace is right for the group.
"
Data Science with Python Training Course
FSK, Data Analyst [Remote online course]
ActiveVIam
"
It was very good. In particular the separated chat rooms used for some of the exercises worked very well.
"
Data Science with Python Training Course
JHO, Data Analyst [Remote online course]
ActiveViam
"Well paced, good overview of the material as required. Good balance of hands-on and talk/theory."
Apache Spark Training Course
JB, Lead Developer
Orange
