• Training Products

    Adding Error Checking to Excel BI Solutions 

    by
    Rebekah
    Published on 2017-07-25 11:21 PM

    Adding Error Checking to Excel BI Solutions



    COURSE DESCRIPTION
    How confident are you that your Excel spreadsheet is calculating correctly, and isn't hiding any errors? You may be confident today, but will you still feel the same way when picking up your model again after taking a 30, 60 or 90-day break?

    This course is all about adding error checking sections into ...
    Read More Read More

    Master Your Data for Power BI 

    by
    Rebekah
    Published on 2017-06-28 10:34 PM

    Course Description

    The sad reality is that not all data we need for our reports is stored in nicely curated databases. While some of the data may be, the reality is that we also need to piece together data provided in text files, Excel files, web pages and even the body of emails in order to build the complete business intelligence solutions we need. Until now this has been a ...
    Read More Read More 1 Comment

    "Data to Dashboards" 3-Day Power BI Boot Camp 

    by
    Rebekah
    Published on 2016-12-01 01:00 PM


    Course Description

    For years, Excel has been the business intelligence tool of choice for accountants and business analysts around the world. In July 2015, however, Microsoft released a free software package that has become the hottest software commodity in the business intelligence landscape: Power BI Desktop.

    Join us for an intensive three-day, hands-on boot camp that will allow you to hit the ground running with Power BI. Geared specifically towards Excel users who have never used Power BI, this course takes you from opening the Power BI Desktop for the first time to publishing live, ...
    Read More Read More

    Learn to Write DAX 

    by
    Rebekah
    Published on 2016-10-17 10:08 PM     Number of Views: 1244 

    Learn to Write DAX:
    A Practical guide to learning Power Pivot for Excel and Power BI

    Add to Cart

    Power Pivot has been called “the best thing to happen to Excel in 20 years.” It is a revolutionary piece of software that brings everything that is good about enterprise-strength business intelligence (BI) tools directly to you right inside Excel, and without the negative time and cost impacts you would normally expect from big-scale BI projects. Analyses that you would never have considered viable in the past are now easily doable tasks within the current business cycle.

    But to unleash the enormous power of Power Pivot, you will need to learn how to write DAX. Power Pivot is very learnable, but it also very different from Excel so you need some structured learning if you want to use the tool effectively. This book is written specifically with the Excel user in mind, geared towards the way Excel ...
    Read More Read More

    Power Pivot And Power BI 

    by
    Rebekah
    Published on 2016-10-17 08:32 PM     Number of Views: 1123 

    Power Pivot & Power BI:
    The Excel User's Guide to DAX, Power Query, Power BI and Power Pivot in Excel 2010-2016

    ​Add to Cart

    Excel pros are used to working with unstructured data. This ability is what has made Excel so successful, but it’s also this freedom that makes learning Power Pivot challenging. Why? Because Power Pivot requires structured data, something we’re just not used to.

    It’s for this reason that we HIGHLY recommend Power Pivot and Power BI as an essential part of the learning journey. In fact, had it not been for the material in this book, Ken says he wouldn’t be equipped to teach courses on Power Pivot.

    Learning how tools work is great, but if you can’t figure out how to apply it to your own work, it doesn’t help. And that, right there, is why this book is so essential. Not only does it teach you the concepts of how to build your DAX measures, this book clearly works through how DAX ...
    Read More Read More

    M is for (Data) Monkey 

    by
    Ken Puls
    Published on 2015-10-22 06:42 PM     Number of Views: 24541 

    M is for (Data) Monkey:
    The Excel Pro's Definitive Guide to Power Query
    ​
    Add to Cart

    It may have a funny title, but this will be one of the most important Excel books you ever buy in your career.

    The Excel book that will change YOUR life...
    Written BY Excel pros FOR Excel pros, this book has been designed to guide you through learning how to master the new "Get and Transform" data experience in Excel. Released as a free add-in from Microsoft for Excel 2010 and 2013, Power Query technology is now built in to Excel 2016 and the Power BI Desktop application. This technology is a game changer, and will revolutionize the way you work with your data forever.

    Way back when this book was nothing more than a concept, we knew that it needed to be approached in a specific way. It had to speak to Excel users, the problems that they face on a daily basis, and ways to solve those problems both effectively and efficiently. It had to be written to keep you engaged, and to take you on a guided journey, learning from someone who understands you as an Excel pro, how you work, and what you face on a daily basis.

    We're proud to say that we believe that we've delivered on that goal, starting with common ...
    Read More Read More 21 Comments

    Master Your Excel Data 

    by
    Ken Puls

    Course Description

    In this hands-on course we are going to look at the most important Excel features that will turn you into a quick and efficient data master in Excel.

    Most users missed the implementation of the Excel Tables feature that happened in Excel 2007. It stealthily slid its way into the product with very little fanfare, yet it is one of the most important architectural features that you can implement to enforce data integrity in your solutions. It’s with that feature we’ll start, showing you how and why this little feature should form the foundation of every solution you build.

    ...
    Read More Read More

    The Magic Of PivotTables 

    by
    Ken Puls
    Published on 2012-04-23 08:10 AM     Number of Views: 40078 

    The Magic of PivotTables
    Add to Cart

    Excel PivotTables: It’s a polarizing term. People who use PivotTables absolutely love them. For those who don’t, the term is mysterious and encourages the fear of powerful features that are the domain of geeks and Excel junkies, and out of reach to the common man. But nothing could be further from the truth.

    Why You Should Take This Course:

    If you’ve never created, or don’t regularly use PivotTables in your work, let me show you that you are missing out on one of the most useful, impressive and easy-to-use tools in Microsoft Excel.

    Excel PivotTables are an amazingly powerful feature that can be used to very quickly summarize and slice and dice data with ease. And contrary to many users’ fears, they are actually VERY easy to use once you’ve been shown how.

    So why don’t you let me do just that? In this one hour video training course, I will teach you how to build your first PivotTables. You’ll see first hand just how easy they are to create, how fast they work, and how easy it is to change them to display your data the way you want to see it.
    ...
    Read More Read More 1 Comment
Gravatar by 1e2.it