Deep-Dive Into Microsoft Power BI (advanced)

Days: 1
  • Dynamics GP Business Users
  • Finance Managers
  • Business Analysts
  • Controllers
  • IT Professionals

Course Description

Power BI is a suite of business analytics tools to analyze data and share insights. This deep dive into Power BI will take you beyond the basics and show you the true power that this tool can bring to your business.
During this course, students will cover the following topics:
  • Power BI Advanced
    • Using Power Pivot to model data
    • Data sources and data discovery
    • Power Query fundamentals
    • Working with query editor window
    • Combining queries
    • Import data using SQL tables
    • Import data using SQL views
    • Import data from other sources
    • Data modeling
    • Creating calculated columns
    • Integrating lookup tables
    • Creating measures
  • Dashboard Designing & Publishing
    • Download 3rd party/custom visulations
    • Dashboards
    • Designing animated dashboards
    • Natural language queries and the Q&A search box
    • Deploying dashboards using content packs
  • Managing Power BI Gateways & On-Premise Data
    • Deciding when to use DirectQuery mode
    • Understanding Power BI gateways
    • Installing and configuring a personal gateway
    • Installing and configuring an enterprise gateway
    • Configuring a dataset with an auto refresh schedule


Location: Training is held at our corporate head office located at 6 Antares Drive, Phase 1, Suite 200 (corner of Hunt Club Rd and Antares Dr).
Cost: $600 for 1st company registrant. $550 for each additional registrant.
Vouchers: 2/person

Upcoming Live Sessions:

There are currently no live training sessions scheduled. Contact us for live one-on-one-training options.

To register for this event, or to inquire into this course, please email

CRGroup Academy: Local Training in Microsoft® Business Solutions

Organizations make a significant investment in the business technologies you use every day. Corporate Renaissance Group has developed a training curriculum, offered through CRGroup Academy, to help employees make the most out of that investment.

At CRGroup Academy, you will:

  • Participate in classroom training, led by a subject matter expert
  • Be provided with training computers/workstations
  • Receive comprehensive course materials in soft-copy format
  • Obtain a course completion certificate that may be used towards Continuing Education Credits
  • Enjoy complimentary refreshments (lunch is also included with full-day courses)

Goal: Our team of experts will give you the knowledge and tools you need in order to maximize your organization’s technology investment.

Custom Training Solutions to Suit Your Needs

At CRGroup, we are committed to delivering world-class training to Microsoft solutions users. We can deliver custom training programs and courses to suit your needs. Please send us an email to inquire further about our custom training solutions.