Course Description
Do you struggle creating dashboards in Excel?
Do you want to master business modeling and analysis techniques with Excel 2013 and create effective dashboards?
Do you want to learn how to use PowerPivot and Power View tools to create mind blowing charts and graphics?
This
course is a guide with simple step by step instructions walk you
through creating business intelligence reports and dashboards quickly
and efficiently.
-----------------------------------------------------------------------------------------------------------
Excel
Dashboards are a powerful tool 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's free PowerPivot and Power View tools 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!
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.
Curriculum
What are KPI’s and how to create them?
Add key metrics and create our first Powerpivot pivot table
An alternative way to create a lookup relationship
Calculated columns
Calculated fields
Complete the dashboard worksheet using slicers and timeline
Create calculated fields using DAX formula language
Create filtered calculations
Create pivot charts
Dashboard design principles
Design your Dashboard with link buttons
Download the Excel project files first
How to create an amazing sales map and other useful charts
How to import data from Powerpivot tab
If you need more help for DAX formula language
Install the Power Pivot and power views add-ins
Link a table in Excel and add into Powerpivot data model
Preconditions and features of Power View
Section 1: Welcome to Excel Dashboards course
Section 2: Get started with Powerpivot and Powerview
Section 3: Calculated fields and columns - DAX formula language
Section 4: KPI, key metrics and design your Excel Dashboard - part:1
Section 5: Design your Excel Dashboard - part:2
Section 6: Create an amazing sales map with Powerview
Section 7: Thank you!
Thank you!
The diagram view and the relations between data
Using Matrices, Cards and Tiles to visualize Power View Data
What are Excel powerpivot and powerview add-ins?
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
