Microsoft Power BI is the industry’s leading Business Intelligence application. If you’re an excel user and want to take your reporting and dashboarding skills to a next level or you’re a small to medium sized company and cannot afford to pay hefty license fees to use BI Tools then Microsoft Power BI is the answer.
Power BI is a business analytics service that gives you a single view of your business data, with the ability to monitor the health of your business using live dashboards, create rich interactive reports and access your data on the go, from your mobile devices
The goal of this hands-on session is to help you understand how to analyse your data in a rich and compelling way. Whether you are evaluating its ability to meet organizational requirements around data visualization and analysis or are looking to learn how Power BI can help you be more efficient and make a greater impact on the work you do every day, this is the training for you.
This session is highly interactive where participants will have an opportunity to widen their Power BI knowledge and capabilities. In this one-day training session, you will get a full coverage of Power BI desktop and its interaction with Power BI Service.
We also encourage you to bring your own data in a CSV or Excel format, to the workshop. The last 2 hours are dedicated to enabling you to build reports and dashboards on your own data with the support of your instructor.
At the end of the day, attendees will better understand how to:
- Connect to, import, and combine data from a variety of sources
- Clean and transform transactions data inside the Query Editor.
- Data modelling techniques and best practices
- What DAX is and how to make sense of its different evaluation contexts
- Visualisation techniques and how to turn your dashboard into a piece of art.
- Sharing and collaborations in Power BI across your entire organisation.
- Exploring the Power BI Service and how it interacts with Power BI Desktop
- Monitor critical KPI by setting alarms to receive notification on your mobile app.
Featuring Our Speakers
Director / Founder
JNT Excel Consulting Pty Ltd
John is the director and founder of JNT Excel Consulting, a management consulting firm that helps individuals and organisations to improve their data analytics capabilities and become more productive in getting value out of their data. John is supported by over 15+ years of experience in using data to deliver business value. He is specialised in Power BI, Power Query, Power Pivot and Excel.
John has a bachelor degree in Finance/commerce, which helped him shaping his analytical path. Working in top level multinational organisations, John has developed a strong business and commercial acumen, which sits him apart when it comes to applying analytics techniques to solve real business problems.
John has a unique teaching style that will not just teach you how to do it but more importantly explains the logic behind every element, so you can understand what going behind the surface when working with Power BI.
With the revolution in the business intelligence space, Power BI comes with a unique set of capabilities that almost eliminate the need for any other data tools to dive in an ocean of data and find deep insights quick and easy.
John has started working with Power BI since its official release in July 2015. Since then, he developed so many business solutions that solved unique needs for specific business units and for organisations as a whole. Right from the start, John has monitored closely the rapid improvement in Power BI since the time where Microsoft used to ship updates to the tool on a weekly basis, sometimes that could be a challenge to keep up with all the huge improvements in the tool over the last 4+ years but John, will be able to transfer his wide knowledge and expertise with you to help you start your own Power BI journey that will immensely help you creating your future career path.
Who should attend?
- Anyone who loves data
- Excel users wishing to upgrade their reporting capabilities
- Data analysts
- Business analysts
- Information analysts
- DB administrators
- Project managers
- Financial analysts
- Introduction to Power BI
- Understanding Data Sources in Power BI Desktop
- Shaping and Combining Data
- Data Modelling
- Interactive Data Visualisations