Index
A
Access databases
Analysis Services database
SeeSQL Server Analysis Services (SSAS) database
Appending data
contents adding (query/query)
dialog window
meaning
multiple queries
source data
Application programming interface (API)
B
Blob Storage
account key
data connection
source data steps
C
Comma-separated values (CSV) files
access databases
close/load button
contents
data discovery process
dialog window
excel files
import Data
navigator dialog
processing queries dialog
steps
working process
file data connectors
fixed-width text file
loading excel data
loading text/CSV files
data type detection
delimiter
origin file
potential options
table/range
text-based files
text file handling
transform data button
XML file
Count rows function
D
Database connections
connect dialog (unable)
credential types
ODBC/OLE DB
database source
Dataset shaping
BaseData query
choose columns dialog
merge columns
dialog window
move (Go to) column dialog
output result
separators
working process
move button options
removing columns
renaming columns
reordering columns
Data transformation
column contents
adding prefix/suffix
format menu
leading and trailing spaces
nonprinting characters
steps
text operation
column headers
context menus
data processes
data type changing
approaches
column/group columns
column type alert
context menu
data types
detecting data
icons
indicators
locale
modification
numeric values
SeeNumeric transformations
restructuring data
search-and-replace operation
advanced replace options
data cleansing operation
dialog window
techniques
techniques
viewing full record
Data transformations
column creation
conditional columns
duplicate column button
extract function
filling down empty cells
blank cells
data table
matrix data table
index column
merging columns
splitting column
surrogate key
Data warehouses
refreshing data
SSAS database
synapse analytics
tabular databases
transformation techniques
Date transformations
Documenting queries
Duplicating queries
Duration transformations
Dynamics 365
E
Extract, Transform, and Load (ETL) tool
Excel toolkit
data load process
get data popup menu
import data dialog
loading data
navigator dialog
source data table
discover and load data
keywords
Power Query
SeePower Query Editor
sample files
Extensible Markup Language (XML)
approaches
column information
CSV files
expand icon
query editor window
table column
Extract transformations
advanced options
between delimiters
dialog window
technique working process
text before and after delimiter
F
File-based sources
CSV file
SeeComma-separated values (CSV) files
data source
JSON files
Filtering techniques
advanced options
approaches
date/time options
elements
numeric data
ordering filters
text ranges options
value selection
G, H
Generic data sources
access data stores
lowest common denominator approach
OData feeds
ODBC drivers
SeeOpen Database Connectivity (ODBC)
OLE DB
refreshing data
Grouping queries
adding query
creation
dialog window
queries pane
rename
Grouping records
aggregation operations
complex data groupings
dataset
group By dialog
output
roll up records
row options
I
IBM DB2 database
J, K
JavaScript Object Notation (JSON)
approaches
column/list conversion
complex files
data elements
expand icon
nested elements
nodes
opening window
parsing
record tools
source file
structure viewing
converted/table
copying data
data expanded
dataset
initial import
parsing
reusing data sources
elements
pinning data
recent sources button
To Table dialog
JSON files
L
Load data process
data modification
data preview pane
dataset search
display options
data previews
item selection
navigator options
key elements
navigator dialog
refresh
source data table
Load destinations
data model
default load option
destination options
Excel worksheet
existing connection
limitations
peek window options
popup menu
Power Pivot
VLOOKUP() functions
Loading data
capabilities
complex XML files
display/filtering file attributes
List Tools Transform ribbon
loading and parsing JSON file
multiple files
paring XML data
parsing JSON
removing header rows
sources folder
contents
dialog window
Excel files
files dialog
filtering source files
identical files
imported data
loading multiple files
steps
structured files
M
Massively parallel processing (MPP)
Merge operation
aggregating data
merged dataset
multiple linked records
options
popup menu
queries
existing queries
adding linked data
column/expand icon
joined query
output window
popup menu
join queries
join types
column name (prefix)
columns do not map
correct and incorrect
datasets
data table
description
massive table/duplicate records
multiple columns
search columns
merging queries
M language
advanced editor
connection modification
database connection
expressions
fundamental reasons
let statements
syntax checking
concepts and functions
data types
date functions
derived/calculated columns
durations
elementary categories
functional language
lists
accessing values
advanced editor
creation
functions
generation
positional references
technical information
meaning
multiline comments
number functions
Power Query Editor
BaseData query
code modification
data load and transformation process
error message
Excel Macro development
expression
formula bar
step and subsequent data
primitive values
queries
advanced editor
lists
steps
records
tabular data
single-line comments
structural concepts
text function
text functions
URLs
user-defined functions
values
fundamentals
user variables
whirlwind introduction
MySQL database
N
Numeric transformations
buttons/sequences
calculation
dates
duration
rounding options
time values
O
Object Linking and Embedding, Database (OLB DB)
advantages
API sources data
connection properties
coworker
data link properties
dialog window
drivers/provider
process
test connection alert
valid string data
OData feeds
advanced options
credentials dialog
dialog window
generic method
navigator
Open Database Connectivity (ODBC)
compliant data source
configuration assistant
confirmation dialog
database specification
data source administrator
driver configuration
Excel From dialog
FileMaker Pro
installation process
key elements
localhost option
naming option
security dialog
System DSN tab
Oracle databases
dialog window
installation
meaning
Power Query
sample databases
security dialog
Organizing queries
P
Parameterizing queries
current value modification
database data sources
data source step
dialog window
filtering records
filtering subsequent datasets
meaning
modification
queries list
query icons
server and database
SQL query
structure modification
subset value creation
techniques
two-step process
Pivoting data
Platform as a service (PaaS)
PostgreSQL database
Power Query Editor
adding data model
data process
data sources
definition
delete connect(see Load data process)
load destinations
SeeLoad destinations
MI/BI tool
M language
queries/connections pane
query properties
restructuring data
source data properties
source data steps
transformation techniques
applied steps list
context menus
discard modifications
key elements
macro recorder
ribbons
saving option
uses of
view ribbon options
Q
Queries & Connections pane
data ingestion processes
display/hide
key information
peek window
worksheet
Query management
adding column
discard changes
add step
approaches
dialog window
error records
modification
process step sequencing
documentation
duplicate option
grouping
organization
queries/connections pane
referencing process
transformation steps
delete/series step
Excel source file
key process
modification
renaming steps
tools
R
Referencing queries
Refreshing data
Excel in-memory model
options
queries/connections pane
Relational databases
connection details
database source
database sources
drivers/providers
generic connectors
missing driver alert
Oracle
SQL Server
SeeSQL Server databases
Removing records
approaches
duplicate records
keeping rows
approach
blank (empty) rows
dialog window
range dialog window
removing rows
Restructuring data
appending data
contents adding (query/query)
multiple queries
data preparation
data structures
categories
pivoting data
transposing rows and columns
unpivoting tables
errors/anomalies
displaying errors
queries/connections pane
remove option
viewing errors
loading data (Query Editor)
merge operation
SeeMerge operation
pivoting and unpivoting data
queries
transformation options
transposing data
view ribbon
Ribbons
add column ribbon
fundamentals
home options
transform options
view ribbon
S
Salesforce
data accessing
loading data
access dialog
Excel spreadsheet
identity dialog
login dialog
navigator
objects dialog
sign-in dialog
report data
SAP HANA in-memory database
Software as a service (SaaS)
SeeSalesforce
Sorting data
context menu
multiple columns
reverse rows button
Splitting column
advanced options
data source column
delimiter
description
number of characters
results of
SQL Server Analysis Services (SSAS) database
attributes and measures
attributes and measures selection
credentials dialog
cubes
database server dialog
file and finish dialog
import data dialog
multidimensional database
office data connection
output (Excel worksheet)
table dialog selection
tabular data warehouse
working process steps
SQL Server databases
database connection
navigator dialog
options
search database
server service
data load progress
dialog window
navigator dialog
steps
tables
database data selection
navigator
security
SELECT statement
statements
steps
stored procedure
web and cloud services
credentials dialog
database connection
Excel spreadsheet
platform as a service
processes
SQL Server on-premises database
Sybase database
Synapse Analytics
T
Teradata database
Time transformations
Transformation techniques
categories
count rows function
dataset shaping
SeeDataset shaping
extending queries
context menu
corporate data sources
data before loading
editing data
initial data load
queries
filtering data
SeeFiltering techniques
grouping records
pivoting and unpivoting data
Power Query Editor
query/load
removing records
sorting data
Transform ribbon
U
Unpivoting tables
dataset
options
pivoted dataset
V
Virtual machines (VMs)
database dialog window
dialog window
SQL Server connection
W, X, Y, Z
Web and cloud services
Azure sources
blob storage
data sources
Dynamics 365
ever-increasing range
online services
platforms
salesforce
SeeSalesforce
security
sources types
SQL Database
synapse analytics
virtual machines
web pages
advanced options
navigator dialog
source web page
steps
web dialog
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.