Many have seen or heard of Microsoft Power BI, but not many are equipped with the essential skills to become an empowered data citizen. The craft of converting data into insight has a shiny new tool box in the form of Excel Power BI add-ins viz. Power Query, Power Pivot, Power View and Power Maps for Excel 2013 (Power Query and Power Pivot for Excel 2010). All you need are the skills to utilize this Excel Power BI tool box to rapidly turn data into business advantage. If an essential part of your role involves deriving insight from data, whether you are a BI professional or financial manager, then this course is for you. This course is hosted by e-magination InfoSolutions, a licensed/official provider of Osmosis training courses.
In this training course we build an end-to-end solution using Power Query and Power Pivot. The areas we cover are:
- What is Power BI and how it empowers the data organization
- Use Power Query to discover and shape data for analytical purposes
- Use Power Pivot and Data Analysis Expressions (DAX) to create rich analytical data models
By the end of the day we will have a complete solution and worked through many of the essential technical skills, as well as explore techniques for building personal BI solutions.
Workstations, samples and training guides will be provided.