Business Intelligence

Online Advertising   |   Business Intelligence   |   Digital Analytics

Our preferred tool for data analysis, exploration, reporting, and visualization is Microsoft Power BI’s set of self-service business intelligence tools:

  • Power Query provides extract, transform, and load functionality
  • Powerpivot provides a platform for building data models
  • Power View and Power Maps allow rapid exploration and visualization of data

One of the greatest benefits of working with Microsoft Power BI is that almost every business has access to Microsoft Excel 2013, which includes most or all of these tools for free–which makes insights easy to share with everyone in the office! To learn more about Powerpivot, Power Query, and Microsoft’s other data analysis tools, visit the site below or search out some of the books below–each from my personal collection.

Microsoft Power BI (Self-service BI for small and medium businesses)



Books on Data Analysis & ETL

Power Query for Power BI and Excel (Chris Webb)

Powerpivot Alchemy: patterns and Techniques for Excel (Bill Jellen, Rob Collie)

Dashboarding and Reporting with PowerPivot and Excel: How to Design and Create a Financial Dashboard with PowerPivot — End to End (Kasper de Jonge)

Microsoft Business Intelligence Tools for Excel Analysts (Alexander, Decker, Wehbe)

DAX Formulas for PowerPivot: A Simple Guide to the Excel Revolution (Rob Collie)

Microsoft Excel 2013: Data Analysis and Business Modeling (Wayne L. Winston)

Microsoft Excel 2013: Building Data Models with PowerPivot (Ferrari, Russo)


Books on Statistics and Econometrics

Statistical Analysis: Microsoft Excel 2013 (Conrad Carlberg)

Decision Analytics: Microsoft Excel (Conrad Carlberg)

Predictive Analytics (Conrad Carlberg)