Excel Power Pivot , DAX & Business Intelligence Masterclass (Udemy.com)
Learn Excel Power Pivot DAX Power Map & Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013
Created by: Andreas Exadaktylos
Produced in 2021
What you will learn
- Create business intelligence reports and dashboards
- Quickly turn mass quantities of data into meaningful information using Excel PowerPivot add-in
- Make amazing interactive sales maps using Excel 2013 Power View powerful add-in
- Analyze huge amounts of data fast and accurate
- Learn in depth PowerPivot and Power View tools
- Improve general Excel knowledge
- Follow along with included Excel project files
- Learn the most current version of Microsoft Excel
- Course updated regularly
- Learn from an instructor with over 16 years of experience, teaching thousands of students in his own computer learning school
- An instructor ready to answer your questions in less than 24 hours
- Watch high-quality video lectures with lifetime access
- Certificate of completion
Quality Score
Overall Score : 88 / 100
Course Description
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 Overview
This 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 2013
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 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!
Note: Power View is a new interactive tool available only in Excel 2013 (PowerPivot is available in both versions - Excel 2010 and Excel 2013)
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!
What you'll learn:
- Dashboard design principles, tips and tricks
- Understand and install the Excel Power Pivot and Power View add-ins
- Import data from spreadsheets, Access, SQL, text files and other sources
- Add calculated fields and columns with Data Analysis Expressions (DAX) formula language
- Create complex reporting systems
- Design your Excel Dashboard with link buttons
- What are KPI's and add key metrics
- Create mind blowing Excel Pivot Charts from PowerPivot
- Create powerful reports using Slicers and Timeline
- Make an amazing interactive sales map using Excel 2013 Power View powerful add-in
- Summarize data with Matrices, Cards and Tiles
- Perform simple-to-sophisticated calculations like Month to date and Year to date
- Analyze multiple tables together without the need to ever write VLOOKUP formulas again
100% risk free 30 day money back guarantee! - Lifetime access
Who is this course for?
This course assumes that you have a basic knowledge of Excel 2010 or Excel 2013. 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.
This course is also ideal for data analysts, MIS professionals, business analysts, managers, dashboard makers, business intelligence professionals and students.
At the end of this Excel class you will be given a Certificate of Completion.
STUDENT REVIEWS:
"I highly recommend this course. It was exactly what I needed to jump start my career. I learned far more than I expected. The instructor is excellent !!!!!!!!" - Troy Newman
===================================================================
"A thorough tutorial on using charts, pivot tables, etc to create dashboard reporting. Very well presented and explain complex issues in a simple way. It is clear and easy to understand and has helped me develop reporting dashboards. Excellent!" - Albert Loomer
===================================================================
"Knowing how to create charts and how to create charts USEFULLY are different skills. Andreas helps the viewer use Excel skills to produce truly useful dashboards. Highly recommend for those looking to learn data presentation." - David Anderson
===================================================================
Enrol now and enjoy!Who this course is for:
- Everyone who wants to master Excel Dashboards
- Business analysts
- Data analysts
- Students
- Entrepreneurs
Instructor Details
- 4.4 Rating
95 Reviews
Andreas Exadaktylos
Hi, I am Andreas and I'm a teacher. I really love learning and teaching whenever I can.
I have over 16 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school.
I have a Master's Degree in Computer Science and a Degree in Electronic Engineering.
I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well.
I have a passion for software products that make people's lives easier. I teach Python Programming, Microsoft Excel and all Microsoft software products for over 17 years. I am a professional Forex Trader for over 5 years.
I love to create websites and optimize them with Search Engine Optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife.
I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family and my two kids. Travel, forex trading, and reading books are my favorite hobbies.
Students also recommend
-
Microsoft Excel - Online Tutorial for Beginners (2010)
-
0.0 (0 Reviews)
-
Provider: Chandoo.org
Time: 1h 30m
Free
More courses by Andreas Exadaktylos
Excel Macros & Excel VBA Programming for Beginners (2021)
4.6 (307 Reviews)
- Provider: Udemy
- Time: 2h
$11.99
Microsoft Excel Charts, Graphs and Data Visualization (2021)
4.6 (209 Reviews)
- Provider: Udemy
- Time: 4h
$11.99
Excel Pro Hacks & Tips with Excel 2016 - Top 100+ Excel Tips (2021)
4.7 (100 Reviews)
- Provider: Udemy
- Time: 3h
$11.99
Python for Beginners: Learn Python in One Day (2021)
4.5 (99 Reviews)
- Provider: Udemy
- Time: 2.5h
$11.99
Excel Dashboards and Data Analysis Masterclass (2021)
4.6 (95 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Reviews
- Video Duration:
2h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English, English [Auto-generated] - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
