Tune in as Ed Fritts trains o n Power Query (Uses M language), Power Pivot uses Data Analytics Expression (DAX functions), Data Model, and OnLine Analytical Processing (OLAP) Pivot Table. All four all linked in one Excel Workbook. We’ll show you the secret of changing the default of drilling down to 1,000 to increase up to 1,048,576 rows using the OLAP Pivot Table. Further, you’ll learn just how easy it is to maneuver between all the above Business Intelligence tools. Please click HERE to view the full synopsis.
Ed Fritts graciously created additional videos going over each topic from the session, including step-by-step videos of the individual topics. You may download them for free below. Once the .zip folder has downloaded, click “extract” and you will easily be able to see the content of the folder. The videos are in the “video” folder.
To help support Crosswinds’ and learn more about their efforts to raise awareness about mental, emotional, and moral trauma associated with military service, please click HERE.