NEW TUTORIAL: Take your Excel game to the next level!

NEW TUTORIAL: Take your Excel game to the next level!

Did you catch the BRAND NEW tutorial from Chris Dutton earlier this week?

Because it's one you don't want to miss!


Picture it:

You’ve just been hired as a Data Analyst for Maven Electronics, a global electronics retailer.

It’s 4:00 pm on a Friday when you receive an urgent email from the VP of Sales, asking you to build a brand new Excel report for regional sales managers. To make matters worse, the data is over the place – SQL servers, CSV files, even static PDFs – and she needs it first thing Monday morning.

Yikes! ??

In this hands-on demo, Chris walks through this business case while showcasing the power of modern Excel tools like Power Query, Power Pivot and DAX.

  1. You’ll start by using Power Query to extract, transform, and load data from external sources like SQL databases and CSV files.
  2. Next, you’ll build a relational model to join the tables without writing a single formula, conduct some exploratory analysis using Power Pivot, and define calculated measures with Data Analysis Expressions (DAX).
  3. Finally, you’ll use Pivot Charts and slicers to design a simple interactive report that the sales managers can use to analyze revenue trends and product performance.

All in a matter of minutes! ??

Microsoft Excel is an incredibly powerful data analytics platform, yet less than 1% of users know how to leverage its most powerful business intelligence tools.

These skills will not only allow you to work smarter and faster in Excel, but also help you build foundational database and ETL skills that can easily be applied to tools like SQL or Power BI.


>> Watch the demo and download the project files here! <<

Mark Chappell - DCOM DCD

Data Centre Operations - Audit, Advice, and Guidance services

10 个月

Great tutorial from which I learned several new "tricks", Love the calendar creation and the Data Model explanations. Many thanks for sharing this knowledge.

Christopher Sabiti PMI?

Country Product Manager | Data & Product Analytics | Power BI & Data Visualization | Digital Product Growth | UX & Data Strategy

10 个月

Thanks, Chris Dutton, always insightful

Antonio Nunnally

Data Analyst | Healthcare and E-commerce | Data Visualization | Excel ? SQL ?Power BI ?Tableau ?Python

10 个月
Alain L.

Data Analyst & Digital Publishing Specialist for IT Software, Finance, Education and Nonprofits | I post about #DataAnalytics and #DigitalPublishing

10 个月

Great walkthrough!

要查看或添加评论,请登录

Maven Analytics的更多文章

社区洞察

其他会员也浏览了