Use Energy Question, Energy Pivot, DAX, & Excel’s information visualization instruments to construct highly effective Business Intelligence options

Description

The very first thing it’s good to learn about this course, is that that is NOT your granddad’s Excel.

As a substitute of the identical previous spreadsheet stuff, we’ll do a deep dive on a actually revolutionary set of instruments that empower you to do industrial-strength Business Intelligence: the artwork and science of remodeling information – often huge quantities of it – into significant, actionable insights.

Prior to now, doing “actual” BI meant utilizing costly enterprise software program that solely a choose few individuals would have entry to anyway. However with what you’ll be taught on this course, you’ll be constructing strong Business Intelligence options very quickly, utilizing nothing greater than an Excel spreadsheet in your desktop.

Prior to now, doing “actual” BI meant utilizing costly enterprise software program that solely a choose few individuals would have entry to anyway. However with what you’ll be taught on this course, you’ll be constructing strong Business Intelligence options very quickly, utilizing nothing greater than an Excel spreadsheet in your desktop.

However simply as importantly, I’ve packed the course with TONS of workouts – starting from simple to difficult – that can allow you to retain, and even construct on , what you’ve realized.

Who this course is for:

  • First up, we’ll dive into Energy Question, a feature-packed but simple to make use of instrument for extracting, remodeling, and loading (ETL for brief) information from nearly any supply you may think about into Excel. From textual content recordsdata to databases, wherever the info you wish to analyze may be saved, you should use Energy Question to tug it into Excel, after which remodel it nevertheless it’s good to help your evaluation.
  • Subsequent, there’s an non-obligatory part on Pivot Tables, simply in case you’re not already aware of them. Whereas Pivot Tables is probably not a revolutionary new function in and of themselves, they nonetheless play a essential position within the Excel Business Intelligence panorama.
  • We’ll then be taught to show these Pivot Tables into “Energy” Pivot Tables, by connecting them to the Excel Data Mannequin…which is mainly a relational database that lives proper inside your Excel spreadsheet! It will permit us to mash up and analyze a number of datasets in a single Pivot Desk…no VLOOKUPS required! And keep in mind how Excel often begins to sputter out when you attempt to mess around with greater than a pair hundred thousand rows of knowledge? No extra! Energy Pivot let’s you’re employed with as much as a whole bunch of thousands and thousands of data in a single Excel file.
  • Then, so we will get absolutely the most out of our Data Mannequin (and into our Energy Pivot Tables), we’ll be taught DAX, an extremely highly effective system language for creating complicated calculations you can drop proper into your Pivots. Because the fundamentals of DAX syntax are simple to choose up should you’re already aware of Excel formulation, we’ll enterprise into superior subjects like Time Intelligence, Iterator Features, and Variables; and with workouts after nearly each video, you’ll have loads of alternatives to grasp what you’ve realized, proper after you be taught it.
  • Leave a comment

    Your email address will not be published. Required fields are marked *