Maven Crash Course - Learn Power Query, Power Pivot & DAX in 15 Minutes

In the Maven Crash Course "Learn Power Query, Power Pivot & DAX in 15 Minutes", Chris Dutton walks through a hypothetical business case while showcasing the power of modern Excel tools like Power Query, Power Pivot and DAX.

Power Query is used to extract, transform, and load data from external sources like SQL databases, PDF and CSV files.

A relational model is created to join the tables without writing a single formula. Exploratory analysis is done using Power Pivot and Data Analysis Expressions (DAX).

Data Analysis Expressions is the language that we can use to define new calculated columns and measures to enhance our Data Model instead of the traditional cell formulas that we'd typically use if our data was stored in worksheets.

Pivot Charts and slicers are used to design a simple interactive report that the sales managers can use to analyze revenue trends and product performance.

Comments

Post a Comment

Popular posts from this blog

"Data Prep & Exploratory Data Analysis" course by Maven Analytics

Image
The Maven Analytics course on " Data Prep & Exploratory Data Analysis " by Alice Zhao is a beginner-friendly introduction to machine learning with Python. It covers the key steps of the data science workflow, including: Gathering Data Scoping a Project Modeling Data Sharing Insights Cleaning Data Exploring Data Modeling Data  Sharing Insights The presentation deck which is available as a download crisply summarizes the essential details and is a great reference to keep going back to. The course is well-suited for aspiring data scientists looking to get hands-on experience with the data prep and EDA stages of the machine learning workflow using Python and Jupyter Notebook. 
Read more

Workshop Highlights - Build AI Apps using Google AI Studio & Gemini AI

Image
Harsh Dattani's ~60-minute walkthrough of Google AI Studio during the workshop " Build AI Apps using Google AI Studio & Gemini AI " provides all the essentials you need to get started. Topics covered: Google AI Studio -browser-based IDE for prototyping with generative models Gemini AI - lets you access the latest generative models from Google API key - prerequisite for building apps with Gemini AI Prompt engineering Prompt Gallery  - examples of what's possible with Gemini models Fine tuning  - provides a mechanism for curating output when you have a small dataset of input/output examples System Instructions - for developers to manage prompts  idx.dev - cloud-based IDE for building Web, Android apps Focus of the workshop is on the inner loop of software development Google AI Studio provides several interfaces for prompts that are designed for different use cases Google AI Studio is a good starting point for beginners and small-scale projects, while Vertex AI St
Read more

AI - Reflections & Perspectives

Image
Image generated by AI * "AI is comparable in scale to the Industrial Revolution or electricity, or even the wheel". - Geoffrey Hinton, Godfather of Deep Learning * "The hottest new programming language is English" -  Andrej Karpathy * "Treat AI assistants as a slightly-drunk knowledgeable friend" - Richard Seroter * "No matter how valuable your skills are in the market today, they may or may not be highly valued by the market over the course of your lifetime. With artificial intelligence (AI) threatening to devalue entire categories of human work, we need to be more purposeful in recognizing a key distinction: the market value of a set of skills is not the same as its human value.  ...the US has become a service economy.  Many people still don’t recognize caregiving, for example — whether for the very young or very old — as a particularly skilled profession. This is mistaken. Anyone who has ever had a teacher who changed the course of their life simpl
Read more