Data Analysis And Business Intelligence With Microsoft Excel

Description

The very first thing it’s essential 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 reworking information – often large quantities of it – into significant, actionable insights.

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

• First up, we’ll dive into Energy Question, a feature-packed but simple to make use of software 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 could be saved, you should utilize Energy Question to tug it into Excel, after which remodel it nevertheless it’s essential to help your evaluation.

• Subsequent, there’s an non-compulsory part on Pivot Tables, simply in case you’re not already accustomed to them. Whereas Pivot Tables will not be a revolutionary new characteristic in and of themselves, they nonetheless play a essential position within the Excel Business Intelligence panorama.

• We’ll then study to show these Pivot Tables into “Energy” Pivot Tables, by connecting them to the Excel Data Mannequin…which is principally 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 bear in mind how Excel often begins to sputter out when you attempt to mess around with greater than a pair hundred thousand rows of information? No extra! Energy Pivot let’s you’re employed with as much as a whole lot of hundreds of thousands of information 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 study DAX, an extremely highly effective formulation language for creating complicated calculations which you could drop proper into your Pivots.

  Because the fundamentals of DAX syntax are simple to choose up in the event you’re already accustomed to Excel formulation, we’ll enterprise into superior matters like Time Intelligence, Iterator Capabilities, and Variables; and with workouts after nearly each video, you’ll have loads of alternatives to grasp what you’ve realized, proper after you study it.

• In fact, all that quantity crunching does not assist a lot if we won’t current these numbers in an intuitive, simply digestible means. That is why I shut the course out with a collection of highly effective visualization methods – from conditional formatting to Pivot Charts – that can remodel your calculations into insights that can be utilized to make real-world choices.

  We’ll even discover methods for constructing dynamic dashboards in Excel, utilizing Slicers and Timelines to not solely filter our charts, however really change the metrics we show in them. And all supported by the Data Mannequin’s capability for juggling a whole lot of hundreds of thousands of rows of information in a single spreadsheet.

And in every part, I take advantage of hands-on demos, sensible examples, and intuitive, common sense explanations to show you these ideas in a means that can provide help to see the connection between your new expertise and the issues you’re making an attempt to unravel on the job.

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

So if you wish to grasp these game-changing instruments and construct professional-grade Business Intelligence options proper in your desktop, all you want is Microsoft Excel – and this course – to do it. I sit up for seeing you there!