An outline of an Enterprise DNA Membership
This training course gives a beginner to intermediate user of Power BI a complete overview of the various different parts of Power BI Desktop, Power BI online service and Power BI mobile applications. Reviewed are best practice techniques in how to develop reports in Power BI desktop and then how to use Power BI within your organisation by harnessing the online service features.
To learn more about this course click here - Power BI Super Users Workshop
This training will take you from a beginner to advanced user of Power BI by utilizing the powerful DAX language to the fullest. Covered in the course material are all the beginner theory that you must understand very well to harness the analytical power of DAX. Through real-world scenarios you will be taken through how to use DAX in practice to discover the insights you want to find in your data. Covered are every major DAX function and how to use these when completing calculations and in combination with each other. DAX is the most difficult part of Power BI to learn and put into practice well. This course covers all major tips and techniques that if practiced will have any Power BI user creating compelling Power BI reports and solutions.
To learn more about this course click here - Mastering DAX Calculations
This training is completely focused on how to use DAX formulas within Power BI to solve simple up to very advanced analytical problems. By utilising the power of DAX, combined with the Power BI data model you can almost effortlessly write DAX formula that can solve even the most complex questions being asked of your raw data. To do this effectively you need to firstly understand the core DAX concepts and formulas. From here you can branch out into a number of re-usable patterns that can be overlaid on a variety of datasets. This course teaches you how to do exactly this with comprehensive examples on a considerable amount of analytical scenarios that you will face everyday in the real-world
To learn more about this course click here - Solving Analytical Scenarios
In this training course you will learn how to transform raw data into compelling visualisations that showcase data in an intuitive way so consumers can extract the insights required to make quality decisions. Creating effective analytical models in only one small part of developing analytical solutions that will make a difference, making sure that your visualisations and reports can effeciently be consumed by your peers and managers is just as important. This course will take you through not only best practice design tips for your Power BI reports but also advanced techniques to really bring your analysis to life.
To learn more about this course click here - Dashboarding & Data Visualisation Intensive
This course covers in detail the query editor and how to develop effective Power BI data models. When starting out with Power BI you can sometimes overlook how important these two areas inside of Power BI are to developing an effective reporting solution. This course makes sure that you can see the immense value of doing work in these areas right can be. Covered are intermediate to advanced techniques that will enable you to optimize you raw data tables and then connect them into a functioning analytical model that you can ultimately overlay DAX formula to and get the correct results, that will answer you analytical questions.
To learn more about this course click here - Advanced Data Transformation & Data Modeling
This course showcases the analytical power you have available when implementing scenario analysis techniques inside your Power BI models. By first thinking analytical about what you want to achieve, then 'shocking' variables or factors in your data and finally overlaying many DAX techniques you can achieve incredible insights and literally predict outcomes that may occur into the future. This course is all about practical applications of Power BI and utilizing it's analytical potential to the max. This is a one of a kind course showcasing all key areas of Power BI models including the; query editor, data model, DAX and reporting visualizations. When bringing all these things together you can very quickly produce fantastic insights that can truly add value to any organization.
To learn more about this course click here - Scenario Analysis Deep Dive
This course showcases many advanced and unique analytical Power BI techniques either created, developed or improved upon by Enterprise DNA. Power BI is an immensely powerful analytical tool if you design and effectively utilize many of it's key features, especially the powerful DAX formula language. Throughout the examples and scenarios that are worked through in this course you will see how you can apply Power BI to solve great insights like; cross selling opportunities, fraud detection, understanding outliers or anomalies and many many more advanced analytical insights. This is a one of a kind course on Power BI that will enhance your abilities in Power BI immeasurably and will impress your consumers with the actionable insights you can produce.
To learn more about this course click here - Advanced Analytics in Power BI
The key to understanding how all components to Power BI development work is to practice, practice and practice some more. Through these comprehensive resources you will have the opportunity to explore how completed, best practice models are developed and then use a demo dataset of your choosing to replicate and practice these techniques to embed them in your mind. The Power BI model resources are a unique offering (there is nothing like this made available anywhere), but they are an essential part of understanding the full suite of development features and ultimately the analytical powers that are available to Power BI users. You will gain access to almost 18 months of development IP around Power BI model & reporting creation. This will place you in a fantastic position to leverage Power BI to its fullest with your own data.
To learn more about these extensive resources click here - Power BI Resources
Over 100 individual resources showcasing a range of tips and techniques around all areas of Power BI development and Power BI usage. Each resource is associated to an individual training video produced for the Enterprise DNA TV channel located on Youtube. Resources expected to reach over 125 by mid 2018.
To learn more about these resources click here - Enterprise DNA TV Resources
This module enables on-demand access to the large volume of virtual events held by Enterprise DNA. Most events also contain downloadable resources to use and review along with the virtual training session. During these event a wide range of topics are covered. Most revolve around develop a reporting solution based on a unique data scenario. This practical application and training in Power BI is essential to ultimately understanding how you can apply Power BI and DAX formula techniques in your own environments. Each session runs for between 40-60 mins and is packed with tips and techniques on many areas and features inside of Power BI. This module will continue to grow as more and more content and events are held and put on by Enterprise DNA.
To learn more about these resources click here - Webinar & Summit Series Resources
For a list of all courses available through Enterprise DNA view here
Sam very early on saw the immense opportunity of using Power BI to create analytical solutions. After years of developing some advanced analysis and tools in excel, he was amazed that he could re-create most of those things in about 10% of the time with Power BI.
He is the founder and CEO at Enterprise DNA, a business intelligence training & consultancy business primarily focused on driving better decision making within organisations by empowering individuals and teams to transform raw data into unmatched insights using Microsoft's Power BI suite of tools.
Sam has a strong history in Finance, previously working at ANZ, PIMCO, and Fonterra. He is also a CFA charterholder, achieving the designation in 2011.
He has a passion for building highly scalable analytical solutions within organisations, and wants to see others learn how to do the same.
Passionate about empowering users of Power BI
"My goal is to teach others that you have almost unlimited analytical power when harnessing all the features in Power BI.
Through training across a number of different mediums, I've reached over 10,000 Power BI users, showing them a range of tips and tricks in Power BI development.
I'm a true believer that Power BI is the future of analysis and know individuals with the right training can now create advanced analytics in a scalable way that can have a real impact in the way insights are found and consumed within organisations."
Sam McKay, CFA - Founder & CEO, Enterprise DNA