Excel Power Query, Power Pivot, Power Map & DAX Masterclass 4.3 (801 ratings) Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
What you’ll learn
- Learn in depth Power Query, PowerPivot, Power View and Power Map tools
- 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 Power View powerful add-in
- Analyze huge amounts of data fast and accurate
- 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
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 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 2019 but it’s compatible with older versions of Excel.
This course introduces Microsoft Excel’s powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis