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.
Microsoft has a decade-spanning stable of pedigree platforms that have fueled and serviced the exponential growth and thirst for enterprise data storage, processing and reporting solutions.
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 business intelligence isn't just a nice idea now - it 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
"I have no background in programming but learned a lot of very useful information in the course. The expertise and patience of the instructor was clear."
Python Training Course
TW, Data Scientist
Stat Core
"Great introduction to Scala and Functional Programming – well paced and really hit the spot!"
Scala Training Course
AF, Developer
Department of Work and Pensions
"Many thanks. I got a lot a value from the sessions. Having one-to-one personalised training was definitely much better for me tha being part of a larger group."
.NET Programming with C# Training Course
PG, Software Engineer
Millenium Capital Partners
"The instructor command of the subject was very high. Some subjects (like Testing and Mocking) was completely new to me but I now believe have acquired a good command of the subject and intend to apply it in practice soon."
Advanced C# Programming Training Course
CA, Senior Developer
Sayula
