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
"Very stimulating course - plenty of hands-on time. Instructor was able to communicate his enthusiasm and knowledge to the group!"
Advanced Scala Training Course
DC, Senior Developer
BBC
"The instructor went into great detail of the language (Python) and his amazing understanding of other languages made for great contrasting examples which made it easy to understand."
Python Training Course
Anonymous, Senior Test Analyst
BBC
"Some really useful things to think on - real life examples really helped put the content in context."
Secure Web App Development Training Course
KC, Lead Software Developer
UK consultancy (risk, pensions, investment and insurance) - name withheld
"Probably the best training course I've had the pleasure to go on. Toby was extremely articulate and delivered the course in a clear and precise manner. Toby's knowledge of Angular/JavaScript was very impressive. I've recommended Toby and Framework Training to the rest of my colleagues. "
Angular Training Course
RD, Senior Developer
Spirax Sarco
"The format was very well laid out, the instructors depth of knowledge surrounding core concepts was very impressive and useful! Examples/explanations were clear and concise and supplemented the training material well. Overall it was a great learning experience."
Advanced Angular Training Course
CH, Developer
1 x 2 Network
"I, along with three colleagues, came on the Agile course. The training was fantastic. I have limited Agile knowledge and this helped answer all the questions I had, in an impartial and helpful way. I learned more about Scrum than I have done in the past and heard of different frameworks that I didn’t know existed and much of this was down to the instructor: his approach, style and knowledge. Please pass on my thanks and I cannot recommend Framework highly enough based on this session."
Agile Project Management Training Course
DS, Programme Manager
Technophobia
