Module 1: Data Analysis in ExcelModule 2: The Excel Data Model
Module 2: The Excel Data Model
“The Excel Data Model … Basic DAX … Explore an Excel Data Model”
(Source URL)
Module 3: Importing Data from a CSV File
Module 3: Importing Data from a CSV File
“Importing Data from a CSV File … Importing Data from a CSV File”
(Source URL)
Module 4: Importing Data from Databases
Module 4: Importing Data from Databases
“Importing Data from Databases … Importing Data from Multiple Files … Creating Mash-ups of Data from Multiple Sources”
(Source URL)
Module 6: Importing Data from a Formatted Excel Report
Module 6: Importing Data from a Formatted Excel Report
“Module 6: Importing Data from a Formatted Excel Report … Advanced Text Query”
(Source URL)
Continue reading “Module 6: Importing Data from a Formatted Excel Report”
Module 7: Visualizing Data in Excel
Module 7: Visualizing Data in Excel
“Visualizing Data in Excel … Data Visualizations in Excel”
(Source URL)
Module 8: Using Excel with Power BI
Module 5: Creating and Formatting Measures
Module 5: Creating and Formatting Measures
“Creating and Formatting Measures … Using Advanced DAX Functions … Creating Measures using Advanced DAX Functions”
(Source URL)
Continue reading “Module 5: Creating and Formatting Measures”
Microsoft: DAT206x Analyzing and Visualizing Data with Excel
Microsoft: DAT206x Analyzing and Visualizing Data with Excel
(Source URL)
Continue reading “Microsoft: DAT206x Analyzing and Visualizing Data with Excel”