AICPA ENGAGE 2018


PST1824 - Excel Data Model and Power BI Fundamentals


Jun 12, 2018 5:10pm ‐ Jun 12, 2018 6:00pm

Standard: $49.00

Description

Microsoft recently added a new tool called the Excel Data Model, which allows sophisticated database tools like the creation of tables, joining multiple tables together, data analysis expressions, and office data connections. These tools can be combined with Excel PivotTables/PivotCharts or Microsoft Power BI to create real time business information. We will also briefly discuss the use of Power Query to extract, transform, and integrate data into the Excel data model, as well as using Office Data Connections (ODC) files to enable ad hoc analysis of data stored in the cloud.

Upon completion of the session, the participant should be able to:
• Define an Excel table, what is means to join two tables together, and a data analysis expression (DAX),
• Explain how these tools are used with the Excel data model
• Explain why using Power BI content packs and Office Data Connections (ODC) may simplify the process of getting data out of cloud systems

Speaker(s):

  • Brian Tankersley, CPA, CGMA, CITP, Director, Strategic Relationships, K2 Enterprises
Tags: PST

You must be logged in and own this session in order to post comments.

Print Certificate
Review Answers
Print Transcript
Completed on: token-completed_on
Review Answers
Please select the appropriate credit type:
/
test_id: 
credits: 
completed on: 
rendered in: 
* - Indicates answer is required.
token-content
token-speaker-name image
token-speaker-name
token-index
token-content
token-index
token-content
token-index
token-content
token-index
token-content
token-index
token-content
token-index
token-content
/
/
token-index
token-content