What is Users are Users the skill familiar with understand level of Excel how to the VLookup and create users? HLookup functions. relationships between tables, and they understand DAX. How Small to Many much medium data millions of data is sets (from records. hundreds of being analyzed? records to just over 1 million records). Is the Yes. Yes. data To To coming incorporate incorporate from data from data from multiple multiple multiple data sources, you sources, you import it into import it into sources? and PowerPivot then tables and integrate then create one column relationships or row at a between the time using tables. VLookup or HLookup functions.
What is the skill level of the users? Users are familiar with Excel VLookup and HLookup functions. Users understand how to create relationships between tables, and they understand DAX. How much data is being analyzed? Small to medium data sets (from hundreds of records to just over 1 million records). Many millions of records. Is the data coming from multiple data sources? Yes. To incorporate data from multiple sources, you import it into and then integrate one column or row at a time using VLookup or HLookup functions. Yes. To incorporate data from multiple sources, you import it into PowerPivot tables and then create relationships between the tables.
MicrosoftReportingToolChoices%2020120327%201643E3.docx