Böcker av Jeff Hutchinson

In this workbook/guide, we will cover many behind-the-scenes capabilities of Power BI. We will use the Power BI Desktop tool to get data, the Power Query Editor to filter the data source, and use the DAX programming language to adjust the results.******** Obtain Your PDF Copy and Recorded Videos ********This workbook includes PDF Download and Video Clip of each practice exercise. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt. To see an example clip: www.elearnlogic.com Get Data - The first step is to use the Get Data command in order to extract records from many different data sources such as Excel, Access, SQL, etc. Once you Get Data, you will then choose a specifically desired table or sheet. Then, you can Load all data or Transform data to clean up any undesired records. Query Editor - Databases are becoming very large and now contain more records than what is necessary to build Reports. When you choose to Transform, it will open the Query Editor interface which is used to filter records, correct many database glitches, clean up data, fix anomalies, and transform, or shape data source information. It can also be used to fix misspellings, clarify labels or columns containing wrong data types, automatically merge two data sources into a single table, adjust columns(fields), adjust rows (records), split columns, combine columns, replace information, transpose an entire table, and sort columns. DAX Programming - In these chapters, you will learn the DAX (Dynamic Analysis Expressions) program language for business intelligence data modeling and analysis techniques. It will explain how to change the behavior of records and Reports based on the DAX function and allow you to create new columns that are not already contained in a database. DAX contains most of the Excel functions, but it also has a built-in record-filtering capability to pull data based on specific criteria. Also, if a user applies a filter in Power BI, it might skew the results. However, DAX will allow you to extract records and ignore any locally applied filter. The workbook explains DAX formula terms, basic structure, and common development techniques. Also included, is how to create New Columns in a table, custom calculations known as Measures, as well as how to create New Tables. Chapter Concepts Covered: Chapter 1 - Get DataThis will extract a data source from a database such as Excel, Access, etc, The sections covered include Power BI Interface, Field List More Options, Report View / Home Ribbon Tab, Report View / Insert Ribbon Tab, Report View / Modeling Ribbon Tab, and Connection Techniques. Chapter 2 - Query EditorThis will allow us to review extracted data and filter or remove specific records prior to saving them to the Power BI file. The sections covered include Query Editor Interface, Query Editor / Home Ribbon Tab, Query Editor / Transform Ribbon Tab, Query Editor / Add Column Ribbon Tab, and Query Editor/View Ribbon Tab. Chapter 3 - DAX Formula OverviewThis chapter will provide an overview of the most important DAX formulas, functions, and capabilities. First, we will review common settings to better create formulas; then, we will review New Column, New Measure, New Table, and Quick Measure. Chapter 4 - DAX Reference GuideIn this chapter, we will document many common functions and provide practice exercises to demonstrate DAX capabilities. The sections covered include Math And Statistical Functions, Formatting Functions, Specialized DAX Functions, and Date And Time DAX Functions.

This class teaches some of the creative aspects of Photoshop. readers will learn image adjustment techniques such as how to brighten photos, change contrast, balance colors, change exposure, highlight colors, and create photo filters. We will use tools to fix problems on an image such as healing, correction, or clone stamping. We will discover techniques to mask objects, warp text, and other special effects. Using a combination of commands, we will generate new possibilities and help readers develop new skills. Obtain Your PDF Copy and Video CourseThis workbook includes an Online Recorded Video course and PDF Download. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt. The following are the details contained in each chapter: Quick Review - Photoshop Environment, Zooming, Panels, Basic Drawing Tools, Resolution type, Selection, Layers, Filter Effects, Layer Effects, Saving Techniques, and Color Picker.General Drawing Tools - Brush defaults, Brush Tool, Pencil, Eye Dropper, Color Sampler Tool, Eraser, Paint Bucket, Rectangle, Rounded Rectangle, Ellipse, Polygon, Line, and Custom Shape.Drawing Patterns and Color - Gradient Tool, Pattern Stamp Tool, Create Custom Patterns, Swatches, History Brush, and Art History Brush.Touch Up Images - Free Transform and Crop, Spot Healing Brush, Healing Brush Tool, Patch Tool, Content-Aware Move, Redeye, Clone Stamp Tool, Blur Tool, Sharpen Tool, Smudge Tool, Dodge Tool, and Burn Tool.Image Adjustments - Auto Tone, Auto Contrast, Auto Color, Brightness/Contrast, Levels, Curves, Exposure, Vibrance, Hue/Saturation, Color Balance, Black and White, Photo Filter, Channel Mixer, Color Lookup, Invert, Posterize, Threshold, Gradient Map, Selective Color, Shadows/Highlights, HDR Toning, Desaturate, Match Color, Replace Color, and Equalize.Layer Mask and Clipping Masks - Quick Mask Painting, Quick Mask Background Color, Quick Mask mode to Feather selection, Reveal Selection, Hide Selection, and Clipping Mask.Text Layer Effects - Pin, Freeform, Add Anchor Point, Delete Anchor Point, Convert Point, Warp Text, Wrap Text on a Path, Layer Comps, and Vanishing Point.Advanced Features - Artificial Intelligence (AI) capabilities, Actions, Batch, Video Files, Export Video Files, and 3-dimensional functionality. Note: The documentation supports both Adobe Suite CS6 (Version 11) and Adobe Suite CC (Version 12.) What's in the workbook? Click on the left side of the screen: Look Inside!Enter one of the following keywords: Shading, Healing, Correction, Clone Stamping, Layers Panel, Smart Object, Image Adjustment, etc. How the Workbook is DesignedThis Workbook contains over 70+ step-by-step practice exercises to help you get up to speed quickly and understand each concept. The following link is a Video Clip explaining how the Workbook has been designed and how to use it most effectively. www.elearnlogic.com/media/workbook.mp4

Excel Visual Basic is a programming tool used to enhance the capability of Excel and requires advanced skills to use it effectively. Visual Basic will help to automate repeating operations and redundant tasks. Once you understand how to use Excel VBA, you'll be able to apply your VBA programming knowledge to other MS Office products, including Microsoft Word and Access.Obtain Your PDF Copy and Video CourseThis workbook includes an Online Recorded Video course and PDF Download. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt. This Workbook supports Excel 2010, 2013, and 2016 because the VBA commands are very similar. However, some commands function differently between Excel versions, and many of these will be noted in the courseware. Also, you will be able to create VB code and run routines that are not possible using standard Excel commands. This Workbook will employ the Visual Basic Application (VBA) programming language that is built into Excel. Students will begin by starting the command Recorder, performing a series of commands or operations in Excel, stopping the recorder, and then running the recording to see if it operates. These Macros are stored in the Visual Basic Editor and can be edited to troubleshoot problems. The Visual Basic programming commands are included in the Macro recording, but there are hundreds of other coding commands that can accomplish fantastic results, as well. Code can also be written to open display message boxes to status the end of a routine; Input Boxes can allow you to prompt for information needed, and there are Worksheet and Workbook commands to create and manipulate information automatically. Visual Basic is designed to go beyond the capabilities of Excel and can replace a long process, completing a task in minutes.The following are the major topics to be covered: Excel Macros - These can be recorded, stored, and run to automate many tasks.Visual Basic Editor - Here, we will cover the editing, debugging, and storage locations of VB code.Cell Manipulation - Excel is made up of many cells and here we will review cell manipulation capabilities. This is an extremely important chapter because these commands are very often used.Formatting Techniques - Although Recording Macros would be the best approach to Format Cells, there are many additional Visual Basic formatting tools to understand.Variables - These are great methods to help remember specific items for use at a later time."If" Logic - This will be covered to help automate decisions and provide the logic necessary to make adjustments.Message and Input Boxes - These tools are methods to provide Input Boxes in a popup window with results being stored in a cell.Loops - This will provide the logic to repeat steps in multiple cells.Worksheet and Workbook - This will allow access to data from multiple worksheets. The use of these functions will automate the overall efficiency of a project.Functions - There are many more advanced programming techniques that can create more efficient code.What's in the Workbook? Click on the left side of the screen: Look Inside!Enter one of the following keywords: VB, Programming, VBA, Variables, Forms, etc.