Excel Power Query, Power Pivot, Power Map & DAX Masterclass

Training

Online

up to £ 100

Description

  • Type

    Training

  • Methodology

    Online

  • Class hours

    5h

  • Start date

    Different dates available

"Learn Power Query, PowerPivot, DAX and Power Business Intelligence Tools that are rarely found on Excel users and transform to an Excel Star!These days almost any job requires data analysis & presentation of results. While anyone can put a list of values in Excel & sum them up, not everyone can do advanced analysis, create interactive charts, summarize data intelligently using PowerPivot and PowerBI tools, and finally present output in stunning Dashboards.Content and OverviewThis course is a guide with simple step by step instructions to walk you through creating business intelligence reports and dashboards in Excel, quickly and efficiently. The course has been created with the version of Microsoft Excel 2019 but it's compatible with older versions of Excel.Excel Dashboards are powerful if you want to present and report data. However building a Dashboard is a complex process. In this course I'll walk you through the most effective ways and tools to build Excel Dashboards that will wow management both visually and substantively. We'll use Microsoft Excel free Power Query, Power Pivot, Power View tools and DAX Formula Language to analyze huge amounts of business data fast and transform data into bottom-line results – no programming required!You'll have lifetime access to watch the videos whenever you like. If you're not 100% satisfied there is a 30 day money back guarantee! Plus you will get fast and responsive support within 24 hours.Free downloadable Excel working files are included to allow you to follow along using the same material I use throughout the lectures. You can download all of them.What are you waiting for? Enroll now and make your Excel Dashboards look amazing!This course assumes that you have a basic knowledge of Excel . You don't need to be a master of Excel. Only basic prior experience in Excel or Spreadsheets is required to get the most out of this Excel course. "

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

"Learn in depth Power Query, PowerPivot, Power View and Power Map toolsCreate business intelligence reports and dashboardsQuickly turn mass quantities of data into meaningful information using Excel PowerPivot add-inMake amazing interactive sales maps using Excel Power View powerful add-inAnalyze huge amounts of data fast and accurateImprove general Excel knowledgeFollow along with included Excel project filesLearn the most current version of Microsoft ExcelCourse updated regularlyLearn from an instructor with over 16 years of experience, teaching thousands of students in his own computer learning schoolAn instructor ready to answer your questions in less than 24 hoursWatch high-quality video lectures with lifetime accessCertificate of completion"

"Everyone who wants to master Excel DashboardsBusiness analystsData analystsStudentsEntrepreneurs"

"To have Excel 2010 or later version installed, so you can open the workbooks and practice what you learnPowerPivot is not available in Office Standard 2013Willingness for learning"

"-100% online -Access to the course for life -30 days warranty money back -Available from desktop or mobile app -Can begin and finish the course any time -Can repeat the course any times"

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2020

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 3 years

Subjects

  • Excel
  • Microsoft Excel
  • Business Intelligence
  • Microsoft excel training
  • MS Excel
  • Power Query
  • Power Pivot
  • Power View
  • Power Map
  • Analysis
  • Charts
  • Data
  • DAX
  • DAX Functions
  • Dashboards
  • Data analysis
  • Excel project
  • MAPS
  • Sales Maps
  • Access

Course programme

"Introduction
Introduction
DOWNLOAD: Project Files & Course Study Tracker & Important Notes for New Student
Versions, Compatibility and Install Power Pivot
HOMEWORK-1
GET STARTED WITH POWER QUERY
What is PowerBI?
Install Power Query for Excel
Getting to Know Power Query and Power Query Editor
Exploring Power Query Editor
Power Query Editor: Cleaning and Flattening the Data Table
Powerful Data Table Transformations
DEMO: Transform APPLE stock data with Power Query
Append, Duplicate and Merge Queries
Grouping, Aggregating and inserting Calculated Columns
GET STARTED WITH POWER PIVOT
The Excel Data Model
The Powerpivot Interface
Making a User-Friendly Model
Importing Excel data into power pivot
Cleanup the Data Model
Importing Access Data & Create Pivot Table
Creating Table Relations and Hierarchies
Example of Table Relations
HOMEWORK:3 - Loading Data into Power Pivot
DAX FUNCTIONS
Introduction to DAX Formula Language
DAX Basic Calculations
Using DAX RELATED() Function
Using DAX Text Functions
Using DAX IF & Date Functions
Using DAX COUNTX & FILTER Functions
Using Dax CALCULATE() Function
DEMO: Using DAX COUNTROWS Function, Slicers & Timeline
HOMEWORK:4 - Creating Calculated Columns into Power Pivot
CREATING MEASURES WITH DAX (or CALCULATED FIELDS)
Introduction to DAX Measures
Basic Measures with DAX
DEMO: Create Measures (Calculated fields) with DAX
Using DAX TOTALMTD() and TOTALYTD()
Using DAX ALL() Function
What are KPI’s and how to create them?
GET STARTED WITH POWER MAP
Power Map Basics
Power Map Format
Power Map Category
Power Map Scene
Power Map Annotation & Text Box
Power Map 2D Chart
Power Map Time Feature
Power Map Capture Screen & Video
DESIGN YOUR DASHBOARD
Design your Dashboard with link buttons
Add key metrics and create our first Powerpivot pivot table
Create pivot charts
Complete the dashboard using slicers and timeline
GET STARTED WITH POWER VIEW & PIVOT CHARTS
Preconditions and features of Power View
Using Matrices, Cards and Tiles to visualize Power View Data
How to create an amazing sales map and other useful charts
Completing Dashboards with Pivot Charts
CHEAT SHEET ~ Create an amazing sales map with Powerview
BONUS SECTION
Excel 2019 Tutorial for Beginners
Top 20 Excel Tips and Tricks
Excel 2019 Useful Keyboard Shortcuts and Tips
My Final Thoughts & Thank you!
Amazing discount for my other courses!"

Excel Power Query, Power Pivot, Power Map & DAX Masterclass

up to £ 100